public void update(Category category, String categoryId) {

		try {

			Connection connection = DataSourceUtils.getConnection(dataSource);

			PreparedStatement statement = connection
					.prepareStatement("UPDATE Category SET genre = ? "
							+ "WHERE genero= ?");

			statement.setString(1, category.getGenre());
			statement.setString(2, categoryId);
			statement.executeUpdate();
			//connection.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}