MemberDTO

public class MemberDTO {

private String userid;

private String passwd;

private String name;

private String email;

private Date join_date;

}

public interface MemberDAO {

public boolean loginCheck(MemberDTO dto);

public MemberDTO viewMember(String userid);

}

public interface MemberService {

public boolean loginCheck(MemberDTO dto, HttpSession session);

public void logout(HttpSession session);

public MemberDTO viewMember(String userid); 

}

create table cart (

cart_id number not null primary key,

userid varchar2(50) not null,

product_id number not null,

amount number default 0

);

alter table cart add constraint cart_userid_fk

foreign key(userid) references member(userid);

alter table cart add constraint cart_productid_fk

foreign key(product_id) references product(product_id);

public class CartDTO {

private int cart_id;

private String userid;

private String name;

private int product_id;

private String product_name;

private int price;

private int money;

private int amount;

}

public interface CartDAO {

public List<CartDTO> cartMoney();

public void insert(CartDTO dto);

public List<CartDTO> listCart(String userid);

public void delete(int cart_id);

public void deleteAll(String userid);

public void update(int cart_id);

public int sumMoney(String userid);

// 장바구니에 이미 상품이 담겼는지 확인

public int countCart(String userid, int product_id);

// 장바구니 수량 변경

public void updateCart(CartDTO dto);

public void modifyCart(CartDTO dto);

}

select cart_id, m.userid, m.name, p.product_id, product_name, amount, price*amount money

from member m, cart c, product product_id

where m.userid=c.userid and p.product_id=c.product_id

and m.userid = #{userid}