packagecom.wlh.hibernate;
importjava.text.SimpleDateFormat;
importjava.util.Iterator;
importjava.util.List;
importjunit.framework.TestCase;
importorg.hibernate.Query;
importorg.hibernate.Session;
publicclassSimpleConditionQueryTestextendsTestCase{
publicvoidtestQuery1() {
Session session =null;
try{
session = HibernateUtils.getSession();
session.beginTransaction();
//可以拼字符串
List students=session.createQuery("select id,name from Student where name like '%1%'").list();
for(Iterator iter=students.iterator();iter.hasNext();){
Object[] o=(Object[])iter.next();
System.out.println(o[0]+","+o[1]);
}
session.getTransaction().commit();
}catch(Exception e) {
e.printStackTrace();
session.getTransaction().rollback();
}finally{
HibernateUtils.closeSession(session);
}
}
publicvoidtestQuery2() {
Session session =null;
try{
session = HibernateUtils.getSession();
session.beginTransaction();
[b]//可以使用 ?号方式传递参数
//参数的索引从0开始
//传递的参数值不用单引号引起来[/b]
/*Query query=session.createQuery("select id,name from Student where name like ?");
query.setParameter(0, "%1%");
List students=query.list();*/
List students=session.createQuery("select id,name from Student where name like ? ").setParameter(0,"%1%").list();
for(Iterator iter=students.iterato