파이널 발표 : 20분

테이블 조인하여 출력

select m.name,c.idx,c.shopnum,s.sangpum,s.photo,s.price,c.cnt,s.price*cnt total,c.cartday
from cart c,shop s,member m
where c.shopnum=s.shopnum and c.num=m.num;

출력 메서드

해시맵 사용

// 장바구니 출력
	public List<HashMap<String, String>> getCartList(String id) {
		List<HashMap<String, String>> list = new ArrayList<>();

		Connection conn = db.getConnection();
		PreparedStatement pstmt = null;
		ResultSet rs = null;

		String sql = "select c.idx,c.shopnum,s.sangpum,s.photo,s.price,c.cnt,c.cartday\\r\\n"
				+ "from cart c,shop s,member m\\r\\n" + "where c.shopnum=s.shopnum and c.num=m.num and m.id=?";

		try {
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, id);

			rs = pstmt.executeQuery();
			while (rs.next()) {
				HashMap<String, String> map = new HashMap<>();

				map.put("idx", rs.getString("idx"));
				map.put("shopnum", rs.getString("shopnum"));
				map.put("sangpum", rs.getString("sangpum"));
				map.put("photo", rs.getString("photo"));
				map.put("price", rs.getString("price"));
				map.put("cnt", rs.getString("cnt"));
				map.put("cartday", rs.getString("cartday"));

				list.add(map);

			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return list;
}

담을 땐 put, 얻을 땐 get