public List<MovieCategory> findMoviesByGendre(String genero)
			throws InstanceNotFoundException {
		List<MovieCategory> list = new ArrayList<MovieCategory>();
		// /doeslike = null;

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

			PreparedStatement statement = connection
					.prepareStatement("SELECT idp, genre FROM moviecategory WHERE genre=?");
			statement.setString(1, genero);

			ResultSet resultSet = statement.executeQuery();

			while (resultSet.next()) {

				list.add(new MovieCategory(resultSet.getInt(1), // idu
						resultSet.getString(2)) // name
				);

			}
			//connection.close();
		} catch (SQLException e) {
			throw new RuntimeException(e);
		}

		return list;
	}