public void remove(String CategoryId) {
		try {

			Connection connection = DataSourceUtils.getConnection(dataSource);

			PreparedStatement statement = connection
					.prepareStatement("DELETE FROM Category WHERE genre = ?");
			statement.setString(1, CategoryId);

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