org.hibernate.SQLQuery.executeUpdate()方法的使用及代码示例

本文整理了Java中org.hibernate.SQLQuery.executeUpdate()方法的一些代码示例，展示了SQLQuery.executeUpdate()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。SQLQuery.executeUpdate()方法的具体详情如下：
包路径：org.hibernate.SQLQuery
类名称：SQLQuery
方法名：executeUpdate

SQLQuery.executeUpdate介绍

暂无

代码示例

代码示例来源：origin: gocd/gocd

public static int updateNaturalOrderForPipeline(Session session, Long pipelineId, double naturalOrder) {
String sql = "UPDATE pipelines SET naturalOrder = :naturalOrder WHERE id = :pipelineId";
SQLQuery query = session.createSQLQuery(sql);
query.setLong("pipelineId", pipelineId);
query.setDouble("naturalOrder", naturalOrder);
return query.executeUpdate();
}

代码示例来源：origin: citerus/dddsample-core

public void store(Cargo cargo) {
getSession().saveOrUpdate(cargo);
// Delete-orphan does not seem to work correctly when the parent is a component
getSession().createSQLQuery("delete from Leg where cargo_id = null").executeUpdate();
}

代码示例来源：origin: BroadleafCommerce/BroadleafCommerce

counter++;
response += query.executeUpdate();

代码示例来源：origin: BroadleafCommerce/BroadleafCommerce

counter++;
response += query.executeUpdate();

代码示例来源：origin: bill1012/AdminEAP

public int executeSql(String sql) {
SQLQuery sqlQuery = this.getCurrentSession().createSQLQuery(sql);
return sqlQuery.executeUpdate();
}

代码示例来源：origin: jtalks-org/jcommune

public static void createViewUnreadPostsInBranch() {
session.createSQLQuery("CREATE VIEW COUNT_POSTS_TOPICS_VIEW AS SELECT tp.TOPIC_ID, tp.BRANCH_ID," +
" MAX(POST_DATE) as LAST_POST_DATE FROM TOPIC tp join POST p ON p.TOPIC_ID=tp.TOPIC_ID group by tp.TOPIC_ID")
.executeUpdate();
}

代码示例来源：origin: stackoverflow.com

SQLQuery sqlQuery = session.createSQLQuery("ALTER SESSION SET NLS_COMP = 'BINARY'");
sqlQuery.addSynchronizedQuerySpace("");
/*
* Only the empty query space "" will be invalidated.
* So no cache will be invalidated, because no table with an empty name exists
*/
int updatedEntities = sqlQuery.executeUpdate();

代码示例来源：origin: bupt1987/JgFramework

@Override
public int execute(String queryString, Map where) {
int result = this.getQuery(queryString, where, false).executeUpdate();
return result;
}

代码示例来源：origin: jtalks-org/jcommune

/**
* Used in manual rollback
*/
public static void deleteViewUnreadPostsInBranch() {
session.createSQLQuery("DROP VIEW COUNT_POSTS_TOPICS_VIEW")
.executeUpdate();
}

代码示例来源：origin: stackoverflow.com

SQLQuery sqlQuery = session.createSQLQuery("ALTER SESSION SET NLS_COMP = 'BINARY'");
sqlQuery.addSynchronizedQuerySpace("");  
int updatedEntities = sqlQuery.executeUpdate();

代码示例来源：origin: com.impetus.client/kundera-rdbms

public void deleteByColumn(String schemaName, String tableName, String columnName, Object columnValue)
{
StringBuffer query = new StringBuffer();
query.append("DELETE FROM ").append(getFromClause(schemaName, tableName)).append(" WHERE ").append(columnName)
.append("=").append("'").append(columnValue).append("'");
s = getStatelessSession();
Transaction tx = s.beginTransaction();
s.createSQLQuery(query.toString()).executeUpdate();
tx.commit();
}

代码示例来源：origin: stackoverflow.com

Session s = factory.withOptions().openSession();
Transaction tx = s.beginTransaction();
SQLQuery query = s.createSQLQuery(sql);
int res = query.executeUpdate();
tx.commit();

代码示例来源：origin: needmorecode/carmelo

public int executeBySql(String sql) {
int result;
SQLQuery query = this.getSession().createSQLQuery(sql);
result = query.executeUpdate();
return result;
}

代码示例来源：origin: pl.edu.icm.sedno/sedno-tools

@Override
public void executeUpdateSql(String sql) {
getCurrentSession().createSQLQuery(sql).executeUpdate();
}
}

代码示例来源：origin: stackoverflow.com

public int updateSomeParameter(String tableName, String idColumnName, int id,
String parameterColumnName, Object newParameterValue) {
String sql = "UPDATE " + tableName + " SET " + parameterColumnName
+ " = :new_value WHERE " + idColumnName + " = :id";
SQLQuery query = session.createSQLQuery(sql);
query.setInteger("id", id);
query.setParameter("new_value", newParameterValue);
return query.executeUpdate();
}

代码示例来源：origin: stackoverflow.com

SQLQuery query = session.createSQLQuery(hql);
query.setParameter(0, "asd");
...
query.setParameter(26, "asd2");
Integer result = query.executeUpdate();

代码示例来源：origin: stackoverflow.com

SQLQuery query = session.createSQLQuery(sql);
query.setDate(1, acctPeriod);
query.setDate(2, geoScheme.getId());
recordCount = query.executeUpdate();

代码示例来源：origin: stackoverflow.com

Session session = (Session) getEm().getDelegate();
Transaction tx = session.beginTransaction();
String sql ="Delete from xyz where id=:id" ;
SQLQuery query = session.createSQLQuery(sql);
query.setParameter("id", "1");
int flg = query.executeUpdate();
tx.commit();

代码示例来源：origin: org.nakedobjects.examples/expenses-hibernate

private void createTable(final String createSQL) {
try {
HibernateUtil.startTransaction();
final SQLQuery sq = HibernateUtil.getCurrentSession().createSQLQuery(createSQL);
sq.executeUpdate();
HibernateUtil.commitTransaction();
} catch (final Exception e) {
HibernateUtil.rollbackTransaction();
}
}

代码示例来源：origin: org.nakedobjects.examples/expenses-hibernate

private void insertRole(final String role) {
try {
final int nextId = getNextId("role");
HibernateUtil.startTransaction();
final SQLQuery sq = HibernateUtil.getCurrentSession().createSQLQuery(SQL[INSERT_ROLE]);
sq.setInteger(0, nextId);
sq.setString(1, role);
sq.executeUpdate();
HibernateUtil.commitTransaction();
} catch (final Exception e) {
HibernateUtil.rollbackTransaction();
}
}