Package javax.persistence

Examples of javax.persistence.Query.executeUpdate()

393
394
395
396
397
398
399
400
401
402
403
    query = em.createQuery("select c from Customer21 c where c.age = (select min(cust.age) from Customer21 cust)");
    assertEquals(2, query.getResultList().size());

    tx.begin();
    query = em.createQuery("update Customer21 c set c.firstName = 'TOO YOUNG' where c.age < 18");
    assertEquals(2, query.executeUpdate());
    tx.commit();

    tx.begin();
    query = em.createQuery("delete from Customer21 c where c.age < 18");
    assertEquals(2, query.executeUpdate());
View Full Code Here
398
399
400
401
402
403
404
405
406
407
408
    assertEquals(2, query.executeUpdate());
    tx.commit();

    tx.begin();
    query = em.createQuery("delete from Customer21 c where c.age < 18");
    assertEquals(2, query.executeUpdate());
    tx.commit();

    // Remove objects
    tx.begin();
    em.remove(customer01);
View Full Code Here
250
251
252
253
254
255
256
257
258
259
260
   
    sql = NamedQuery.getInstance().getQuery("category.item.language.create");
    Query query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.setParameter("siteProfileClass", defaultSiteProfileClass);
    query.executeUpdate();
 
    sql = NamedQuery.getInstance().getQuery("category.item.language.create1");
    query = em.createQuery(sql);
    query.setParameter("siteProfileClassId", siteProfileClass.getSiteProfileClassId());
    query.executeUpdate();
View Full Code Here
255
256
257
258
259
260
261
262
263
264
265
    query.executeUpdate();
 
    sql = NamedQuery.getInstance().getQuery("category.item.language.create1");
    query = em.createQuery(sql);
    query.setParameter("siteProfileClassId", siteProfileClass.getSiteProfileClassId());
    query.executeUpdate();
   
    sql = NamedQuery.getInstance().getQuery("category.content.language.create");
    query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.setParameter("siteProfileClass", defaultSiteProfileClass);
View Full Code Here
261
262
263
264
265
266
267
268
269
270
271
   
    sql = NamedQuery.getInstance().getQuery("category.content.language.create");
    query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.setParameter("siteProfileClass", defaultSiteProfileClass);
    query.executeUpdate();
 
    sql = NamedQuery.getInstance().getQuery("category.content.language.create1");
    query = em.createQuery(sql);
    query.setParameter("siteProfileClassId", siteProfileClass.getSiteProfileClassId());
    query.executeUpdate();
View Full Code Here
266
267
268
269
270
271
272
273
274
275
276
    query.executeUpdate();
 
    sql = NamedQuery.getInstance().getQuery("category.content.language.create1");
    query = em.createQuery(sql);
    query.setParameter("siteProfileClassId", siteProfileClass.getSiteProfileClassId());
    query.executeUpdate();
  }
 
  static public void removeSiteProfileClass(String siteId, SiteProfileClass siteProfileClass) throws Exception {
    EntityManager em = JpaConnection.getInstance().getCurrentEntityManager();
    String sql = NamedQuery.getInstance().getQuery("category.item.language.remove");
View Full Code Here
276
277
278
279
280
281
282
283
284
285
286
    String sql = NamedQuery.getInstance().getQuery("category.item.language.remove");
    Query query = em.createQuery(sql);
   
    query.setParameter("siteId", siteId);
    query.setParameter("siteProfileClass", siteProfileClass);
    query.executeUpdate();
   
    sql = NamedQuery.getInstance().getQuery("category.content.language.remove");
    query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.setParameter("siteProfileClass", siteProfileClass);
View Full Code Here
282
283
284
285
286
287
288
289
290
291
292
   
    sql = NamedQuery.getInstance().getQuery("category.content.language.remove");
    query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.setParameter("siteProfileClass", siteProfileClass);
    query.executeUpdate();
  }
 
  static public void createSiteCurrencyClass(SiteCurrencyClass defaultSiteCurrencyClass, SiteCurrencyClass siteCurrencyClass, String siteId, String userId) throws Exception {
    EntityManager em = JpaConnection.getInstance().getCurrentEntityManager();
    String sql = null;
View Full Code Here
294
295
296
297
298
299
300
301
302
303
304
   
    sql = NamedQuery.getInstance().getQuery("category.item.price.create4");
    query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.setParameter("siteCurrencyClassId", defaultSiteCurrencyClass.getSiteCurrencyClassId());
    query.executeUpdate();

    sql = NamedQuery.getInstance().getQuery("category.item.price.create5");
    query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.setParameter("siteCurrencyClassId1", defaultSiteCurrencyClass.getSiteCurrencyClassId());
View Full Code Here
300
301
302
303
304
305
306
307
308
309
310
    sql = NamedQuery.getInstance().getQuery("category.item.price.create5");
    query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.setParameter("siteCurrencyClassId1", defaultSiteCurrencyClass.getSiteCurrencyClassId());
    query.executeUpdate();

    sql = NamedQuery.getInstance().getQuery("category.item.price.create");
    query = em.createQuery(sql);
    query.setParameter("siteId", siteId);
    query.setParameter("siteCurrencyClassId1", defaultSiteCurrencyClass.getSiteCurrencyClassId());
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.