JAVA技巧(hibernateHQL语句的参数设置)
以hql为列表:更多搜索帮助
/使用List作为参数作为条件结果
List lst = new ArrayList();
lst . add(14);
lst . add(15);
lst . add(17);
String hql = " from Students where s . SId in(:lst)";
Query q = session . create Query(hql);
q.setParameterList("lst ",lst);
//取一个真实类作为参数条件
hql = " from students where s . class =:class ";
q.setEntity("class ",session.get(Class.class,1));
//根据给定的参数匹配Type hiberntae中对应的类
hql = " from students where s . sid =?还是s.SName=?”;
Query q = session . create Query(hql);
q . set parameters(new Object[]{ 14," update" },new Type [] { new IntegerType(),new string Type()});
0条评论