"WHERE c.imageid=? ORDER BY c.date DESC");
stmt.setInt(1,imageid);
ResultSet result=stmt.executeQuery();
while (result.next()) {
CommentBean temp=new CommentBean();
temp.setContent(GlobalHelpers.nl2br(result.getString(1)));
temp.setDate(result.getTimestamp(2));
temp.getUserBean().setName(result.getString(3));
temp.setUserid(result.getInt(4));
list.add(temp);
}
result.close();