public List<ImageDTO> getAllImageDataByDateAndUser(String date, String username)
throws Exception {
Connection con = null;
List<ImageDTO> list = new ArrayList<ImageDTO>();
try {
con = new MyConnection().getConnection();
String query =
"select * from tbl_tracker_image where username=? and c_date=? order by c_time";
System.out.println("query : " + query + " : " + username + " : " + date);
PreparedStatement ps = con.prepareStatement(query);
ps.setString(1, username);
ps.setString(2, date);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
ImageDTO dto = new ImageDTO();
dto.setC_date(rs.getString("c_date"));
dto.setId(rs.getString("id"));
dto.setC_time(rs.getString("c_time"));
dto.setFpath(rs.getString("fpath"));
dto.setUsername(rs.getString("username"));
list.add(dto);
}
ps.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
if (con != null) {
con.close();
}
}
System.out.println(list.size());
return list;
}
