@Override
	public List<Position> getAll() throws SQLException {
		List<Position> results = new ArrayList<Position>();
		Connection dbConnection = null;
		java.sql.Statement statement = null;
		String selectCourses = "SELECT id_position, name, sallary FROM position";
		try {
			dbConnection = PSQL.getConnection();
			statement = dbConnection.createStatement();
			ResultSet rs = statement.executeQuery(selectCourses);

			while (rs.next()) {
				Position position = new Position();
				int id = rs.getInt("id_position");
				String name = rs.getString("name");
				int sallary = rs.getInt("sallary");
				position.setId(id);
				position.setName(name);
				position.setSallary(sallary);
				results.add(position);
			}

		} catch (SQLException e) {

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

		} finally {

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

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

		}
		return results;

	}