hql 字符串where语句_常用的HQL语句

1.hql更新

String hql = "update PhUser set realName=?";

int row=this.getSession().createQuery(hql).setString(0, "小李想").executeUpdate();

PhUser 类名

2.hql删除

String hql = "delete PhUser a where a.userId=2";

int row=this.getSession().createQuery(hql).executeUpdate();

还有个这种的格式:

final String hql = "delete PhRoleFunction as a where a.roleId = "

+ roleId;

this.getHibernateTemplate().execute(new HibernateCallback() {

public Object doInHibernate(Session session)

throws HibernateException, SQLException {

return session.createQuery(hql).executeUpdate();

}

});更新也可以写成这样的格式

3.hql单表查询

String hql = "from PhUser a where a.userId=" + userId;

List list = this.getHibernateTemplate().find(hql);

4.hql多表查询

(1)String hql = "select new map(a.CUId as CUId,a.unitName as unitName,b.CUFId as CUFId,b.UFName as UFName) from PhCorrelativeUnit a,PhCorrelativeUnitFunction b where a.CUId=b.CUId";

List list = this.getHibernateTemplate().find(hql);

多个表的字段放到map中,map的键值就是as后面的别名,如果没有as就是字段名

(2) String hql = "select new com.phantom.appeal.action.bean.DealPaper(a.id as id,a.billId as billId,a.state as state,a.creator as creator,a.createtime as createtime ,b.eventContent as eventContent ,c.realName as realName,b.billCode as billCode,b.citName as citName ) from PhDealBill a,PhAcceptBill b,PhUser c where a.departmentId="+ billid+ " and a.state=0 and a.billId=b.billId and a.creator =c.userId order by a.billId";

return this.getHibernateTemplate().find(hql);

另外就是写一个类,对应你要查询的字段,这里的类名是new com.phantom.appeal.action.bean.DealPaper,里面对应查询的字段名

5.得到记录数

String hql = "select count(*) from PhUser";

List list = this.getHibernateTemplate().find(hql);

return ((Long) list.get(0)).intValue();

分享到：

2008-08-28 00:34

浏览 6338

评论