方法1
@Override
public void paySuccess(Long orderNo) {
getCurrentSession().createQuery(sql).setDate("payTime", new Date()).setLong("orderNo", orderNo).executeUpdate();*/
String sql = "update Order set status =1 , payTime =? where orderNo =? ";
getCurrentSession().createQuery(sql).setTimestamp(0 ,new Date()).setLong(1, orderNo).executeUpdate();
}
方法2
走sql
@Override
public Integer updateStatusDiscard(List<Long> rids) {
if (CollectionUtils.isEmpty(rids)) {
return 0;
}
String sql = "UPDATE requirement r SET r.status=0,r.updateTime=NOW() WHERE r.id IN (:rids)";
return getCurrentSession().createSQLQuery(sql).setParameterList("rids", rids).executeUpdate();
}