public ResultPage<Patron> getPatronList(int offset) throws SQLException {
		openPatronsDatabase();
		
		PreparedStatement statement = patronsConnection.prepareStatement(
				"SELECT * FROM Patrons ORDER BY Name LIMIT 11 OFFSET ?");
		statement.setInt(1, offset * 10);
		
		ResultSet resultSet = statement.executeQuery();
		
		ArrayList<Patron> results = new ArrayList<Patron>(10);
		
		for (int book = 0; book < 10 && resultSet.next(); book++) {
			results.add(new Patron(resultSet.getInt(1),
					resultSet.getString(2)));
		}
		
		boolean isBeginning = false;
		boolean isEnd = false;
		
		if (offset == 0) {
			isBeginning = true;
		}
		if (!resultSet.next()) {
			isEnd = true;
		}
		
		resultSet.close();
		statement.close();
		closePatronsDatabase();
		
		return new ResultPage<Patron>(results, offset, isBeginning, isEnd);
	}