서블릿 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 로 변환하기 위한 클래스