因本人记性不好,所以在此做个记录,以便日后查找。呵呵
执行本地Sql不要直接创建session.createSQLQuery();而是应当
this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
//在这里调用,如下面方法所示
}
this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
String sql = "update JY_GOODS set SORT_CODE=? where COMPANY_ID=?";
int num = session.createSQLQuery(sql).setString(0, dto.getSort().getSortCode())
.setString(1, dto.getCompanyId())
.executeUpdate();
return num;
}
});
执行本地Sql不要直接创建session.createSQLQuery();而是应当
this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
//在这里调用,如下面方法所示
}
this.getHibernateTemplate().execute(new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
String sql = "update JY_GOODS set SORT_CODE=? where COMPANY_ID=?";
int num = session.createSQLQuery(sql).setString(0, dto.getSort().getSortCode())
.setString(1, dto.getCompanyId())
.executeUpdate();
return num;
}
});