1,hibernate-select count(*) 返回类型
hibernate的hql执行以下这句是,返回的list里面的元素是Long类型结果
SELECT count(*) FROM Entity where type=?
2,hql in
public void changePass(String userIds, String pass){
if (userIds == null || "".equals(userIds))return;
String [] userIdArr = userIds.split(",");
Long [] uIdArr = new Long[userIdArr.length];
for (int i=0; i<userIdArr.length; i++){
uIdArr[i] = Long.parseLong(userIdArr[i]);
}
String hql = "update User set password=:pass where id in (:ids)" ;
Session session = userDao.getSession();
Query query = session.createQuery(hql);
query.setParameterList("pass",new Object[]{pass});
query.setParameterList("ids",uIdArr);
query.executeUpdate();
}
hibernate的hql执行以下这句是,返回的list里面的元素是Long类型结果
SELECT count(*) FROM Entity where type=?
2,hql in
public void changePass(String userIds, String pass){
if (userIds == null || "".equals(userIds))return;
String [] userIdArr = userIds.split(",");
Long [] uIdArr = new Long[userIdArr.length];
for (int i=0; i<userIdArr.length; i++){
uIdArr[i] = Long.parseLong(userIdArr[i]);
}
String hql = "update User set password=:pass where id in (:ids)" ;
Session session = userDao.getSession();
Query query = session.createQuery(hql);
query.setParameterList("pass",new Object[]{pass});
query.setParameterList("ids",uIdArr);
query.executeUpdate();
}