HQL更新字段示例-优快云博客

本文链接：https://blog.youkuaiyun.com/Attacked_code/article/details/79894113

Hql 更新部分字段有多种方式

我选择的是

Query query = dao.getCurrentSession().createQuery("update realestate.Supervice.sto.PayableBill p set p.paybill_BankName=?,p.paybill_BankStaff =?,p.paybill_Money =?,p.paybill_Date =?,p.paybill_Sequence =?,p.paybill_Code =?,p.paybill_Desc =?,p.paybill_Status =? where p.id=? ");

realestate.Supervice.sto.PayableBill：实体类

p：别名

如何进行赋值？

                query.setString(0,payableBill.getPaybill_BankName());
		query.setString(1,payableBill.getPaybill_BankStaff());
		query.setDouble(2,payableBill.getPaybill_Money());
		query.setDate(3,payableBill.getPaybill_Date());
		query.setString(4,payableBill.getPaybill_Sequence());
		query.setString(5,payableBill.getPaybill_Code());
		query.setString(6,payableBill.getPaybill_Desc());
		query.setString(7,"2000");
		query.setString(8,payableBill.getId());

query.setXXXX: xxx是你传入数值的属性 例如：anme String属性 就写做 query.setString(0,xxxx);

query.setString(0,xxxx); o:代表的是从第几位开始 一般跟数组一样都是从0 开始  xxxx:代表传入的参数

很不熟悉的Hql语句，更新部分字段还是得用它，没法，加油把