public List getReseravtionsForPrint(int cowlab, java.util.Date date) throws SQLException { List ls = new ArrayList(); String query = "SELECT reservations.id as rid, reservations.userid as ruser, reservations.cowlab as cl, periods.fullname as per, reservations.room as rroom, reservations.date as rdate, periods.id as pid FROM reservations, periods WHERE date ='"+new Date(date.getTime())+"' and reservations.cowlab='"+cowlab+"' ORDER BY periods.shortname ASC;"; Statement st = dbcon.createStatement(); ResultSet rs = st.executeQuery(query); while(rs.next()){ String period = rs.getString("per"); ls.add(new Reservation(rs.getInt("rid"),rs.getInt("ruser"),rs.getInt("cl"),period,rs.getString("rroom"),rs.getDate("rdate"))); System.out.println(period); } return ls; }