Package javax.persistence

Examples of javax.persistence.Query.executeUpdate()

307
308
309
310
311
312
313
314
315
316
317
    sql = NamedQuery.getInstance().getQuery("category.item.price.create");
    query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.setParameter("siteCurrencyClassId1", defaultSiteCurrencyClass.getSiteCurrencyClassId());
    query.setParameter("siteCurrencyClassId2", defaultSiteCurrencyClass.getSiteCurrencyClassId());
    query.executeUpdate();
 
    sql = NamedQuery.getInstance().getQuery("category.item.price.create2");
    query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.setParameter("siteCurrencyClassId1", defaultSiteCurrencyClass.getSiteCurrencyClassId());
View Full Code Here
314
315
316
317
318
319
320
321
322
323
324
    sql = NamedQuery.getInstance().getQuery("category.item.price.create2");
    query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.setParameter("siteCurrencyClassId1", defaultSiteCurrencyClass.getSiteCurrencyClassId());
    query.setParameter("siteCurrencyClassId2", defaultSiteCurrencyClass.getSiteCurrencyClassId());
    query.executeUpdate();

    sql = NamedQuery.getInstance().getQuery("category.item.price.create3");
    query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.setParameter("siteCurrencyClassId1", defaultSiteCurrencyClass.getSiteCurrencyClassId());
View Full Code Here
321
322
323
324
325
326
327
328
329
330
331
    sql = NamedQuery.getInstance().getQuery("category.item.price.create3");
    query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.setParameter("siteCurrencyClassId1", defaultSiteCurrencyClass.getSiteCurrencyClassId());
    query.setParameter("siteCurrencyClassId2", defaultSiteCurrencyClass.getSiteCurrencyClassId());
    query.executeUpdate();

    sql = NamedQuery.getInstance().getQuery("category.item.price.create6");
    query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.executeUpdate();
View Full Code Here
326
327
328
329
330
331
332
333
334
335
336
    query.executeUpdate();

    sql = NamedQuery.getInstance().getQuery("category.item.price.create6");
    query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.executeUpdate();

    sql = NamedQuery.getInstance().getQuery("category.item.price.create1");
    query = em.createQuery(sql);
    query.setParameter("siteCurrencyClassId", siteCurrencyClass.getSiteCurrencyClassId());
    query.executeUpdate();
View Full Code Here
331
332
333
334
335
336
337
338
339
340
341
    query.executeUpdate();

    sql = NamedQuery.getInstance().getQuery("category.item.price.create1");
    query = em.createQuery(sql);
    query.setParameter("siteCurrencyClassId", siteCurrencyClass.getSiteCurrencyClassId());
    query.executeUpdate();

  }
 
  static public void removeSiteCurrencyClass(String siteId, SiteCurrencyClass siteCurrencyClass) throws Exception {
    EntityManager em = JpaConnection.getInstance().getCurrentEntityManager();
View Full Code Here
341
342
343
344
345
346
347
348
349
350
351
    EntityManager em = JpaConnection.getInstance().getCurrentEntityManager();
    String sql = NamedQuery.getInstance().getQuery("category.item.price.remove");
    Query query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.setParameter("siteCurrencyClass", siteCurrencyClass);
    query.executeUpdate();
  }
 
  static Date addDay(Date input, int day) {
    Calendar calendar = Calendar.getInstance();
    calendar.setTime(input);
View Full Code Here
173
174
175
176
177
178
179
180
    query.setParameter("newRunTimeStamp", newRunTimeStamp);
    query.setParameter("newNextRunTimeStamp", newNextRunTimeStamp);
    query.setParameter("id", id);
    query.setParameter("oldRunTimeStamp", oldRunTimeStamp);
    query.setParameter("oldNextRunTimeStamp", oldNextRunTimeStamp);
    return query.executeUpdate() == 1;
  }
}
View Full Code Here
833
834
835
836
837
838
839
840
841
842
843
  public static int revokeOnHoldPermanently(EntityManager entityManager, String issuerDN) {
    final Query query = entityManager.createQuery("UPDATE CertificateData a SET a.status=:status1 WHERE a.issuerDN=:issuerDN AND a.status=:status2");
    query.setParameter("status1", SecConst.CERT_REVOKED);
    query.setParameter("issuerDN", issuerDN);
    query.setParameter("status2", SecConst.CERT_TEMP_REVOKED);
    return query.executeUpdate();
  }

  /** @return the number of certificates that had their status changed from On Hold to Revoked for this issuer. */
  public static int revokeAllNonRevokedCertificates(EntityManager entityManager, String issuerDN, int reason) {
    final Query query = entityManager.createQuery("UPDATE CertificateData SET status=:status1, revocationDate=:revocationDate, revocationReason=:revocationReason WHERE issuerDN=:issuerDN AND status <> :status2");
View Full Code Here
844
845
846
847
848
849
850
851
852
853
854
    query.setParameter("status1", SecConst.CERT_REVOKED);
    query.setParameter("revocationDate", new Date().getTime());
    query.setParameter("revocationReason", reason);
    query.setParameter("issuerDN", issuerDN);
    query.setParameter("status2", SecConst.CERT_REVOKED);
    return query.executeUpdate();
  }

  /** @return a List<Certificate> of SecConst.CERT_ACTIVE and CERT_NOTIFIEDABOUTEXPIRATION certs that have one of the specified types. */
  public static List<Certificate> findActiveCertificatesByType(EntityManager entityManager, String certificateTypes) {
        final List<Certificate> certificateList = new ArrayList<Certificate>();
View Full Code Here
913
914
915
916
917
918
919
920
  /** @return true if a row with the given fingerprint was updated */
  public static boolean updateStatus(EntityManager entityManager, String fingerprint, int status) {
    final Query query = entityManager.createQuery("UPDATE CertificateData a SET a.status=:status WHERE a.fingerprint=:fingerprint");
    query.setParameter("status", status);
    query.setParameter("fingerprint", fingerprint);
    return query.executeUpdate() == 1;
  }
}
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.