hibernate 执行此条delete Lc_Admin where id in(?)只能删除第一个ID

[怀之若谷]

​public boolean runByHql(String hql, Object...params) {
try {
Query query = this.getHibernateTemplate().getSessionFactory().getCurrentSession().createQuery(hql);
if(params != null && params.length>0){
for(int i=0;i<params.length;i++){
query.setString(i, params[i].toString());
}
}
query.executeUpdate();
return true;
} catch (Exception e) {
e.printStackTrace();
return false;
}
}

​String hql = "delete Lc_Admin where id in(?)";

为什么执行此条hql语句时，能执行成功。但是删除多个id时[1,2,3],只能执行成功一个id的数据[1]!!!

[weixin_31313899]

sql执行语句只执行一遍，没有在循环里面

[gukuitian]

你的hql只有一个问号?

[oxcow]

给你个例子吧

 @Override
    public int updateExpirationData(String[] codes, Date date, String oper) {
        Session session = getSession();
        String hql = "update Coupon set expirationData = ?, status = ?, updateTime = ?, lastOper = ? where couponCode in (:codes)";
        Query query = session.createQuery(hql);
        query.setDate(0, date);
        query.setInteger(1, CouponStatus.UNUSED.ordinal());
        query.setDate(2, new Date());
        query.setString(3, oper);
        query.setParameterList("codes", codes);
        int affectRows = query.executeUpdate();
        releaseSession(session);
        return affectRows;
    }

[执笔记忆的空白]

打出你的sql语句看下，是in (1) 还是 in (1,2,3)