Package org.hibernate

Examples of org.hibernate.Query.executeUpdate()

460
461
462
463
464
465
466
467
468
469
470
                    // Delete aggregated tables
                    deleteHql = "delete from "+ DataSourceTableEntry.class.getName() + " where datasource = :datasource";
                    deleteQuery = session.createQuery(deleteHql);
                    deleteQuery.setString("datasource", dsName);
                    deleteQuery.executeUpdate();

                    // Delete the data source.
                    dSource.delete();
                }}.execute();
            }
View Full Code Here
517
518
519
520
521
522
523
524
525
526
527
        HibernateTxFragment txFragment = new HibernateTxFragment() {
            protected void txFragment(Session session) throws Exception {
                String[] arrTableName=getSelectedTables().split(",");
                String deleteHql = "delete from "+DataSourceTableEntry.class.getName() + " where datasource = '"+getName()+"'";
                Query deleteQuery = session.createQuery(deleteHql);
                deleteQuery.executeUpdate();
                for(int i=0;i<arrTableName.length;i++){
                    DataSourceTableEntry tableEntry = new DataSourceTableEntry();
                    tableEntry.setDatasource(getName());
                    tableEntry.setName(arrTableName[i]);
                    tableEntry.setSelected("true");
View Full Code Here
528
529
530
531
532
533
534
535
536
537
538
                    session.saveOrUpdate(tableEntry);
                }

                deleteHql = "delete from " + DataSourceColumnEntry.class.getName() + " where datasource = '"+getName()+"'";
                deleteQuery = session.createQuery(deleteHql);
                deleteQuery.executeUpdate();
                for(int i=0;i<arrTableName.length;i++){
                    List tableColumns = getTableColumns(arrTableName[i]);
                    Iterator it = tableColumns.iterator();
                    while(it.hasNext()){
                        DataSourceColumnEntry columnEntry = (DataSourceColumnEntry) it.next();
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
    try {
      String stringQuery = "DELETE FROM PRACOWNIK "
                + "WHERE imie LIKE :param ";
      Query query = session.createSQLQuery(stringQuery);
      query.setString("param", param+"%");
      query.executeUpdate();
      commit(tx);
    } catch (HibernateException e) {
      rollback(tx);
      handleException(e);
    } finally {
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
  public void update(BasePO basePO, StringBuffer sbWhere) throws DataAccessException {
    String strUpdSql = "update " + basePO.getStrTableName() + " set "
        + basePO.getStrUpdValues() + " where " + sbWhere.toString();
    Query query = getSession().createQuery(strUpdSql);
    query.executeUpdate();
  }

  public void delete(BasePO basePO) throws DataAccessException {
    if (basePO.getStrKeyWhere().toString().equals("")) {
      return;
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
  public void delete(BasePO basePO, StringBuffer sbWhere) throws DataAccessException {
    String strUpdSql = "delete " + basePO.getStrTableName() + " "
        + " where " + sbWhere.toString();
    Query query = getSession().createQuery(strUpdSql);
    query.executeUpdate();
  }

  public BasePO selectSingle(BasePO basePO) throws DataAccessException {
    List listResult = getHibernateTemplate().find(
        " from " + basePO.getStrTableName() + " as "
View Full Code Here
151
152
153
154
155
156
157
158
159
160
161
    return calculate(basePO, strTemp, basePO.getStrExactWhere());
  }

  public void exeSql(StringBuffer sbSql) throws DataAccessException {
    Query query = getSession().createQuery(sbSql.toString());
    query.executeUpdate();
  }

  public HibernateDaoImpl getFromApplicationContext(ApplicationContext ctx) {
    return (HibernateDaoImpl) ctx.getBean("HibernateDaoImpl");
  }
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
      for(String key: params.keySet()){
        logger.debug("{}) [{}] : {}", new Object[]{i++, key, params.get(key)});
        query.setParameter(key, params.get(key));
      }
    }
    return query.executeUpdate();
  }
 
  public int batchUpdateByQuery(String queryString, Map<String, Object> params) {
    Session session = getSession();
    Query query = session.createQuery(queryString);
View Full Code Here
118
119
120
121
122
123
124
125
126
127
128
      for(String key: params.keySet()){
        logger.debug("{}) [{}] : {}", new Object[]{i++, key, params.get(key)});
        query.setParameter(key, params.get(key));
      }
    }
    return query.executeUpdate();
  }
 
  @SuppressWarnings("unchecked")
  private <T> List<T> findByQueryNative(Query query, Map<String,Object> params, int start, int pageSize){
    if(params != null && !params.keySet().isEmpty()){
View Full Code Here
454
455
456
457
458
459
460
461
462
463
464
                protected void txFragment(Session session) throws Exception {
                    // Delete aggregated table columns
                    String deleteHql = "delete from " + DataSourceColumnEntry.class.getName() + " where datasource = :datasource";
                    Query deleteQuery = session.createQuery(deleteHql);
                    deleteQuery.setString("datasource", dsName);
                    deleteQuery.executeUpdate();

                    // Delete aggregated tables
                    deleteHql = "delete from "+ DataSourceTableEntry.class.getName() + " where datasource = :datasource";
                    deleteQuery = session.createQuery(deleteHql);
                    deleteQuery.setString("datasource", dsName);
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.