@Override
	public void deletePosition(Position position) throws SQLException {
		Connection dbConnection = null;
		PreparedStatement preparedStatement = null;

		String deletePosition = "DELETE FROM position WHERE id_position = '"
				+ position.getId() + "'";
		try {
			dbConnection = PSQL.getConnection();
			preparedStatement = dbConnection.prepareStatement(deletePosition);

			// execute delete SQL stetement
			preparedStatement.executeUpdate();

		} catch (SQLException e) {

			System.out.println(e.getMessage());

		} finally {

			if (preparedStatement != null) {
				preparedStatement.close();
			}

			if (dbConnection != null) {
				dbConnection.close();
			}

		}

	}