public Category insert(Category category) {

		if (category == null)
			return null;

		try {

			Connection connection = DataSourceUtils.getConnection(dataSource);

			PreparedStatement statement = connection
					.prepareStatement("INSERT INTO Category (genre) "
							+ "VALUES (?)");// ,
											// Statement.RETURN_GENERATED_KEYS);

			statement.setString(1, category.getGenre());
			statement.executeUpdate();

			// ResultSet resultSet = statement.getGeneratedKeys();

			// if (resultSet != null && resultSet.next())
			// category.setGenero(resultSet.getString(1));
			//connection.close();
		} catch (SQLException e) {
			throw new RuntimeException(e);
		}

		return category;
	}