public ArrayList<Project> getProjects(String query)
throws java.rmi.RemoteException, SQLException {
ResultSet result = connection.createStatement().executeQuery(query);
ArrayList<Project> projects = new ArrayList<Project>();
DateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm");
while (result.next()) {
try {
System.out.printf(result.getString(3));
Date projectDate = format.parse(result.getString(3));
Project p =
new Project(
result.getString(2),
projectDate,
result.getDouble(4),
result.getString(5),
result.getBoolean(6));
int projectId = result.getInt(1);
p.setId(projectId);
p.setPaths(this.getProjectPaths(projectId));
p.setMessages(this.getProjectMessages(projectId));
p.setRewards(this.getProjectRewards(projectId));
p.setExtras(this.getProjectExtraLevels(projectId));
projects.add(p);
} catch (ParseException e) {
e.printStackTrace();
}
}
return projects;
}
