stmt.setInt(1,userid);
ResultSet result=stmt.executeQuery();
//wrap the results into a list of beans
while (result.next()) {
MessageBean temp=new MessageBean();
temp.setId(result.getInt(1));
temp.setTitle(result.getString(2));
temp.setDate(result.getTimestamp(3));
temp.setRead(result.getBoolean(4));
temp.getSenderBean().setName(result.getString(5));
temp.getSenderBean().setId(result.getInt(6));
list.add(temp);
}
result.close();