@Override
	public void updatePerson(Person person) throws SQLException {
		Connection dbConnection = null;
		java.sql.Statement statement = null;
		try {
			
			dbConnection = PSQL.getConnection();
			statement = dbConnection.createStatement();
			String positionUpdate = "UPDATE person SET phone_number = "+ person.getPhoneNr() +" , pin = "+ person.getPin() +" , date_of_birth = "+ person.getDateOfBirth() +" , position_id = "+ person.getPositionId() +" WHERE surname = "+ person.getSurname() +" AND name = "+ person.getName();
			statement.executeUpdate(positionUpdate); 
 
		} catch (SQLException e) {
 
			System.out.println(e.getMessage());
 
		} finally {
 
			if (statement != null) {
				statement.close();
			}
 
			if (dbConnection != null) {
				dbConnection.close();
			}
 
		}
				
		
	}