public Patron getPatron(int cardNumber) throws SQLException {
		openPatronsDatabase();
		
		PreparedStatement statement = patronsConnection.prepareStatement(
				"SELECT * FROM Patrons WHERE CardNumber = ?");
		statement.setInt(1, cardNumber);
		
		ResultSet resultSet = statement.executeQuery();
		
		Patron result;
		
		if (resultSet.next()) {
			result = new Patron(resultSet.getInt(1), resultSet.getString(2));
		} else {
			result = null;
		}
		
		resultSet.close();
		statement.close();
		closePatronsDatabase();
		
		return result;
	}