서블릿 JSP
JSP 조인한 테이블로 데이터 가져오기
짱코딩러
2022. 10. 2. 20:02
public List<Object> listReview() {
List<Object> reviewList = new ArrayList<Object>();
String sql = "select * from review R LEFT JOIN product P ON R.prodno = P.prodno WHERE best =2";
System.out.println(sql);
try {
conn = DBManager.getConnection();
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
while (rs.next()) { // rs의 레코드셋을 변수에 할당한다.
Map<String, String> br = new HashMap<>();
br.put("reviewno",Integer.toString(rs.getInt("reviewno")));
br.put("prodno",Integer.toString(rs.getInt("prodno")));
br.put("subject",rs.getString("subject"));
br.put("img",rs.getString("img"));
br.put("id",rs.getString("id"));
br.put("pwd",rs.getString("pwd"));
DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
String dateToStr = dateFormat.format(rs.getDate("indate"));
br.put("indate",dateToStr);
br.put("count",Integer.toString(rs.getInt("count")));
br.put("name_kr",rs.getString("name_kr"));
reviewList.add(br);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBManager.close(conn, pstmt, rs);
}
return reviewList;
}
*DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");*
Date -> String
String -> Date 로 변환하기 위한 클래스