/*
構建HQL語句進行查詢
*/
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()來進行多條件查詢,使用setParameterList把所有的查詢的條件放入list中
//可以用 :參數  來傳遞參數
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.
//日期查詢語句
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.
//日期段的查詢

//首先構建一個日期對象
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();