avalys

public Reservation[] getReserves(String query) throws SQLException {		Statement stmt = dbCon.createStatement();		System.out.println(query);		ResultSet rs = stmt.executeQuery(query);		List resp = new Vector();		String currentUser = "none_valys";		String currentE = "Alex Valys";		String currentDate = "yesterday";		String periods = "";		Reservation r = null;		// This is so horribly, horribly executed.  I was tired.		while(rs.next()) {			String theUser = rs.getString("username");			String theDate = formatDate(rs.getString("date"));			String theE = rs.getString("name");			if (!currentDate.equals(theDate) || !currentUser.equals(theUser) || !currentE.equals(theE)) {				if (r != null) {					r.periods = periods;					resp.add(r);				}				r = new Reservation();				currentUser = theUser;				currentDate = theDate;				currentE = theE;				r.user = theUser;				r.date = theDate;				r.equipment = theE;				r.room = rs.getString("room");				r.eID = rs.getString("eid");				periods = "";			}			periods = periods+rs.getString("short")+" ";		}		if (r != null) {			r.periods = periods;			resp.add(r);		}		return (Reservation[]) resp.toArray(new Reservation[resp.size()]);	}