Java tutorial
/* * Copyright 2001-2008 The Apache Software Foundation. * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. * */ package org.apache.juddi.query; import java.util.List; import javax.persistence.EntityManager; import javax.persistence.Query; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.apache.juddi.query.util.DynamicQuery; /** * * Returns the list of PublisherAssertions that contain the input businessKeys as their from or to key * * * @author <a href="mailto:jfaath@apache.org">Jeff Faath</a> */ public class DeletePublisherAssertionByBusinessQuery extends PublisherAssertionQuery { private static Log log = LogFactory.getLog(DeletePublisherAssertionByBusinessQuery.class); public static int delete(EntityManager em, List<?> businessKeys) { if ((businessKeys == null) || (businessKeys.size() == 0)) return 0; DynamicQuery dynamicQry = new DynamicQuery(deleteSQL); appendConditions(dynamicQry, businessKeys); log.debug(dynamicQry); Query qry = dynamicQry.buildJPAQuery(em); int result = qry.executeUpdate(); return result; } /* * Appends the conditions to the query based on the businessKey list. The keys can either be in the fromKey or toKey of the publisher assertion. */ public static void appendConditions(DynamicQuery qry, List<?> businessKeys) { qry.WHERE().pad().openParen().pad(); qry.appendInList(ENTITY_ALIAS + "." + FROM_KEY_NAME, businessKeys); qry.pad().OR().pad(); qry.appendInList(ENTITY_ALIAS + "." + TO_KEY_NAME, businessKeys); qry.closeParen().pad(); } }