Question

hibernate中我该如何把数组放到hql中啊？

Answer 1

你是要将数组中的值写到hql中吗？

可以用循环拼接字符串和占位符插入进去

Object[] parameter = null;
    StringBuffer hql1=new StringBuffer();
    hql1.append("from BlogCategory ");
    if(CId!=null){
        length=CId.size();
        parameter=new Object[length];
        for(int a=0;a<length;a++){
            if(CId.get(a)!=null){
                if(a==0){
                    hql1.append("where CId in(?,");
                    parameter[a]=CId.get(a);
                }
                hql1.append("?,");
                parameter[a]=CId.get(a);
                if(a==length-1){
                    hql1.append("?)");
                    parameter[a]=CId.get(a);
                }
            }
        }
    }
    String hql = hql1.toString();
    return blogCategory_h.blogCategoryList(hql,parameter);

Session session = sessionFactory.openSession();
Query query = session.createQuery(hql);
if (parameter != null) {
    for (int a = 0; a < parameter.length; a++) {
        if (parameter[a] != null) {
            query.setParameter(a, parameter[a]);
        }
    }
}
@SuppressWarnings("unchecked")
List<BlogCategory> blogCategoryList = query.list();
session.close();
return blogCategoryList;

Answer 2

数组
hql支持list和map，数据倒是没有见过。

Answer 3

你是想批量操作吗？