hql语句总结-技术博客集

hql语句总结
编程技术 / houtizong 发布于 3年前 153

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 , 26. B.EVENTCONTENT AS EVENTCONTENT , C.REALNAME AS REALNAME, B.BILLCODE AS BILLCODE, 27. B.CITNAME AS CITNAME )
FROM PHDEALBILL A
      ,PHACCEPTBILL B
      ,PHUSER C 28.WHERE A.DEPARTMENTID="+ billid+ "
   AND A.STATE = 0
   AND A.BILLID = B.BILLID 29.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();

上一篇：检验文本框中输入的是否为空格

下一篇：检查URL是否ping通

请勿发布不友善或者负能量的内容。与人为善，比聪明更重要！

<div style="font-size: 14px;"> <div class="blog_content"> <ol> <li> 1.hql更新 &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;String&nbsp;hql&nbsp;=&nbsp;&quot;update&nbsp;PhUser&nbsp;set&nbsp;realName=?&quot;; &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;int&nbsp;row=this.getSession().createQuery(hql).setString(0,&nbsp;&quot;小李想&quot;).executeUpdate(); &nbsp;&nbsp; </li> <li>&nbsp;&nbsp;&nbsp;PhUser&nbsp;类名&nbsp; &nbsp;&nbsp;</li> <li> 2.hql删除 &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;String&nbsp;hql&nbsp;=&nbsp;&quot;delete&nbsp;PhUser&nbsp;a&nbsp;where&nbsp;a.userId=2&quot;; &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;int&nbsp;row=this.getSession().createQuery(hql).executeUpdate(); &nbsp;&nbsp; </li> <li>&nbsp;&nbsp;&nbsp;还有个这种的格式: &nbsp;&nbsp;</li> <li> &nbsp;&nbsp;&nbsp;final&nbsp;String&nbsp;hql&nbsp;=&nbsp;&quot;delete&nbsp;PhRoleFunction&nbsp;as&nbsp;a&nbsp;where&nbsp;a.roleId&nbsp;=&nbsp;&quot;&nbsp;&nbsp; </li> <li>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+&nbsp;roleId; &nbsp;&nbsp;</li> <li> &nbsp;&nbsp;&nbsp;this.getHibernateTemplate().execute(new&nbsp;HibernateCallback()&nbsp;{ &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;&nbsp;public&nbsp;Object&nbsp;doInHibernate(Session&nbsp;session) &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;throws&nbsp;HibernateException,&nbsp;SQLException&nbsp;{ &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;session.createQuery(hql).executeUpdate(); &nbsp;&nbsp; </li> <li>&nbsp;&nbsp;&nbsp;&nbsp;} &nbsp;&nbsp;</li> <li>&nbsp;&nbsp;&nbsp;});更新也可以写成这样的格式 &nbsp;&nbsp;</li> <li> 3.hql单表查询 &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;String&nbsp;hql&nbsp;=&nbsp;&quot;from&nbsp;PhUser&nbsp;a&nbsp;where&nbsp;a.userId=&quot;&nbsp;+&nbsp;userId; &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;List&nbsp;list&nbsp;=&nbsp;this.getHibernateTemplate().find(hql); &nbsp;&nbsp; </li> <li> 4.hql多表查询 &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;(1)String&nbsp;hql&nbsp;=&nbsp;&quot;select&nbsp;new&nbsp;map(a.CUId&nbsp;as&nbsp;CUId,a.unitName&nbsp;as&nbsp;unitName,b.CUFId&nbsp;as&nbsp;CUFId,b.UFName&nbsp;as&nbsp;UFName)&nbsp; </li> <li> &nbsp;&nbsp; from&nbsp;PhCorrelativeUnit&nbsp;a,PhCorrelativeUnitFunction&nbsp;b&nbsp;where&nbsp;a.CUId=b.CUId&quot;; &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;List&nbsp;list&nbsp;=&nbsp;this.getHibernateTemplate().find(hql); &nbsp;&nbsp; </li> <li>&nbsp;&nbsp;&nbsp;多个表的字段放到map中,map的键值就是as后面的别名,如果没有as就是字段名 &nbsp;&nbsp;</li> <li> &nbsp;&nbsp;&nbsp;(2)&nbsp;String&nbsp;hql&nbsp;=&nbsp;&quot;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 , 26. B.EVENTCONTENT AS EVENTCONTENT , C.REALNAME AS REALNAME, B.BILLCODE AS BILLCODE, 27. B.CITNAME AS CITNAME ) &nbsp; FROM PHDEALBILL A &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,PHACCEPTBILL B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,PHUSER C 28.WHERE A.DEPARTMENTID=&quot;+ billid+ &quot; &nbsp;&nbsp; AND A.STATE = 0 &nbsp;&nbsp; AND A.BILLID = B.BILLID 29.AND A.CREATOR = C.USERID &nbsp;ORDER BY A.BILLID </li> <li> &quot;; &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;this.getHibernateTemplate().find(hql); &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;另外就是写一个类,对应你要查询的字段,这里的类名是new&nbsp;com.phantom.appeal.action.bean.DealPaper,里面对应查询的字段名 &nbsp;&nbsp; </li> <li> 5.得到记录数 &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;String&nbsp;hql&nbsp;=&nbsp;&quot;select&nbsp;count(*)&nbsp;from&nbsp;PhUser&quot;; &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;List&nbsp;list&nbsp;=&nbsp;this.getHibernateTemplate().find(hql); &nbsp;&nbsp; </li> <li> &nbsp;&nbsp;&nbsp;return&nbsp;((Long)&nbsp;list.get(0)).intValue(); </li> </ol> </div>

留言需要登陆哦

技术博客集 - 网站简介：
前后端技术：
后端基于Hyperf2.1框架开发,前端使用Bootstrap可视化布局系统生成
网站主要作用：
1.编程技术分享及讨论交流，内置聊天系统;
2.测试交流框架问题，比如：Hyperf、Laravel、TP、beego;
3.本站数据是基于大数据采集等爬虫技术为基础助力分享知识，如有侵权请发邮件到站长邮箱，站长会尽快处理;
4.站长邮箱：[email protected];

文章归档

文章标签

友情链接

首页
关于我们

Auther ·HouTiZong: 侯体宗的博客