hql update 语句 | 红颜丽人

String hql = “update Web w set w.littlewarm=? w.noticepic=? w.help=? where w.id =?”;
Query q = session.createQuery(hql);
q.setString(0,littlewarmValue);
q.setByte(1,noticepicValue);
q.setString(2,helpValue);
q.setInteger(3,idValue);
q.executeUpdate();
其中littlewarmValue，noticepicValue，helpValue，idValue可以通过参数传递过来。

只更新littlewarm的情况
String hql1 = “update Web w set w.littlewarm = ‘”+content+”‘ where w.id = ’1′” ;
session.createQuery(hql1).executeUpdate() ;
更新两个属性
String hql1 = “update Web w set w.littlewarm = ‘”+content+”‘,set w.xxx=’xxx’ where w.id = ’1′” ;
楼主发分吧~嘿嘿评论(1) | 3 4
2010-10-27 18:28 371906039 | 五级
类似于一般的SQL语句：update tableName set col1=val1,col2=cal2 where 1=1 ..

在MySQL中用hibernate测试update语句发现以下问题：

update语句竟然不去作用；

表机构如下：

create table student
(sid int primary key ,
sname varchar(45) not null,
ssex char(2) not null,
sdept varchar(10) not null,
sage int ,
saddress varchar(45)
);

update语句如下：

String[] params = new String[] { “20″, “成龙” };

HibernateUtil.executeUpdate(
“update Student s set s.sage=? where s.sname=?”,params);

复制代码
package com.huml.util;

import java.util.ArrayList;
import java.util.Arrays;

import org.hibernate.Transaction;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class HibernateUtil {
private static final SessionFactory sf;
private static ThreadLocal<Session> threadLocal = new ThreadLocal<Session>();
static {
sf = new Configuration().configure().buildSessionFactory();
}

private HibernateUtil() {

}

public static Session openSession() {
return sf.openSession();
}

public static Session getcurrentSession() {
Session session = threadLocal.get();

if (session == null) {
session = sf.openSession();
threadLocal.set(session);
}
return session;
}

public static void save(Object obj) {
Session session = openSession();
Transaction tx = null;

try {
tx = session.beginTransaction();
session.save(obj);
tx.commit();
} catch (Exception e) {
if (tx != null) {
tx.rollback();
}
throw new RuntimeException(e.getMessage());
} finally {
if (session != null && session.isOpen()) {
session.close();
}
}
}

@SuppressWarnings(“unchecked”)
public static ArrayList executeQuery(String hql, String… params) {
Session session = openSession();
Transaction tx = null;
ArrayList list = null;
try {
tx = session.beginTransaction();
Query query = session.createQuery(hql);

if (params != null && params.length > 0) {
for (int i = 0; i < params.length; i++) {
query.setParameter(i, params[i]);
}
}
list = (ArrayList) query.list();
tx.commit();
} catch (Exception e) {
if (tx != null)
tx.rollback();
throw new RuntimeException(e.getMessage());
} finally {
if (session != null && session.isOpen()) {
session.close();
}
}
return list;
}

public static void executeUpdate(String hql, String… params) {

Session session = openSession();
Transaction tx = null;

try {
tx = session.beginTransaction();
Query query = session.createQuery(hql);

if (params != null && params.length > 0) {
for (int i = 0; i < params.length; i++) {
query.setParameter(i, params[i]);
// System.out.println(“query influenced: “+params[i]);
}
}
System.out.println(“query influenced: ” + query.getQueryString());
int n = query.executeUpdate();
System.out.println(“query influence: ” + n);
tx.commit();
} catch (Exception e) {
if (tx != null)
tx.rollback();
throw new RuntimeException(e.getMessage());
} finally {
if (session != null && session.isOpen()) {
session.close();
}
}
}

}
复制代码
原因是MySQL中不能自动把String类型转换成Integer，在Oracle中可以修改代码如下：

Object[] params = new Object[] { 20, “成龙” };

HibernateUtil.executeUpdate(
“update Student s set s.sage=? where s.sname=?”,params);
复制代码
package com.huml.util;