面向對象的查詢語言 Hibernate Query Language
@Test public void testhql() { // TODO Auto-generated method stub //模糊匹配 //%代表任意字符一個活多個 _代表單字符通配符 //select stu.sname,stu.sex from Student as stu where stu.sname like '%陳%' //select stu.sname,stu.sex from Student as stu where stu.sname like '陳_' //distinct出去查詢結果中的關鍵字 String hqldistinct="select distinct stu.sex from Student as stu"; //默認以object[] 的形式返回 String hqlArray="select stu.sname,stu.sex from Student as stu"; //以list返回查詢結果 String hqlList="select new List(stu.sname,stu.sex) from Student as stu"; //以Map的形式返回 返回查詢結果 String hqlMaps="select new Map(stu.sname as name,stu.sex as sexs) from Student as stu"; //以自定的形式(需要在實體類中生命構造器) String hqlCustom="select new Student(stu.sname,stu.sex) from Student as stu"; Query query = session.createQuery(hqlList); List<List> list = query.list(); for (List list2 : list) { System.out.PRintln(list.get(0)); } }新聞熱點
疑難解答
