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條評論