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语句,更新部分字段还是得用它,没法,加油把