ResultSet
반응형
ResultSet.getInt(), .getString() 등 메서드
Dao객체에서 가져온 예제 public ArrayList selectOseqOrderIng(String id) { ArrayList list = new ArrayList(); String sql = "select distinct oseq from order_view where id=? and result='1' " + " order by oseq desc"; con = Dbman.getConnection(); try { pstmt = con.prepareStatement(sql); pstmt.setString(1, id); rs = pstmt.executeQuery(); while(rs.next()) { list.add(rs.getInt(1)); } } catch (SQLException e) { e.p..
반응형