public List<Movie> findMovieByDirector(String director) {
		List<Movie> list = new ArrayList<Movie>();

		try {
			Connection connection = DataSourceUtils.getConnection(dataSource);

			PreparedStatement statement = connection
					.prepareStatement("SELECT id, name, year, description, director FROM movie WHERE director = ?");
			statement.setString(1, director);

			ResultSet resultSet = statement.executeQuery();

			while (resultSet.next()) {

				list.add(new Movie(resultSet.getInt(1), // id
						resultSet.getString(2), // name
						resultSet.getInt(3), // year
						resultSet.getString(4), // description
						resultSet.getString(5) // director

				));

			}

		} catch (SQLException e) {
			throw new RuntimeException(e);
		}

		return list;

	}