/*
構(gòu)建HQL語(yǔ)句進(jìn)行查詢
*/
1.
Query query = session.createQuery("select s.id, s.name from Student s where s.name like ? ");
//用?占位符
query.setParameter(0, "%1%");
//添加查詢條件
List students = query.list();
//返回查詢列表


2.
//可以用in()來(lái)進(jìn)行多條件查詢,使用setParameterList把所有的查詢的條件放入list中
//可以用 :參數(shù)  來(lái)傳遞參數(shù)
List students = session.createQuery("select s.id, s.name from Student s where s.id in(:myids) ")
                       .setParameterList(myids, new Object[]{1,2})
                       .list();
 
3.
//日期查詢語(yǔ)句
List students = session.createQuery("select s.id, s.name from Student s where date_format(s.createTime, '%Y-%m')=? ")
                       .setParameterList(0, 2009-1)
                       .list();

4.
//日期段的查詢

//首先構(gòu)建一個(gè)日期對(duì)象
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

List students = session.createQuery("select s.id, s.name from Student s where s.createTime between ? and ? ")
                       .setParameter(0, sdf.setparse("2009-1-1 00:00:00"))
                       .setParameter(1, sdf.setparse("2009-2-1 23:59:59"))
                       .list();