public List<Project> getAll() throws ServerException, SQLException {
		ArrayList<Project> projectList = new ArrayList<Project>();
		PreparedStatement stmt = null;
    ResultSet rs = null;
    try {
    	String sql = "SELECT * FROM projects";
    	stmt = db.getConnection().prepareStatement(sql);
    	
    	rs = stmt.executeQuery();
    	while (rs.next()) {
    		int id = rs.getInt(1);
    		String title = rs.getString(2);
    		int recordsPerImage = rs.getInt(3);
    		int firstYCoord = rs.getInt(4);
    		int recordHeight = rs.getInt(5);
    		Project project = new Project(id, title, recordsPerImage, firstYCoord, recordHeight);
    		projectList.add(project);
    	}
    } catch (SQLException e) {
    	
    } finally {
    	if (rs != null) rs.close();
    	if (stmt != null) stmt.close();
    }
		return projectList;
	}