HQL查询语句

List<Object[]> list = session.createQuery("select name,code from Province").list();
       for (int i = 0;i<list.size();i++){
             Object[] arr = list.get(i);
             for (int j = 0;j <arr.length;j++){
                 System.out.println(arr.length);
                 System.out.println(j);
                 System.out.println(arr[j]+"====");
             }

List<Province> list1 = session.createQuery("select new Province(id,name,code) from Province").list();
        for (int i = 0;i<list1.size();i++) {
            //System.out.println(p.getName()+" "+p.getCode());
            System.out.println(list1.get(i)+"========");
        }
       System.out.println(list1);

List<Province> list = session.createQuery("select new Province(p.id,p.name,p.code) from Province as p").list();
       for(Province province:list){
           System.out.println(province);
       }
       
 List<Province> list = session.createQuery("select p from Province p").list();
        for(Province province:list) {
            System.out.println(province);
        }

List<Province> list = session.createQuery("select p from Province p").list();
        for(Province province:list) {
            System.out.println(province);
        }

          List<Province> list = session.createQuery("from Province").list();
        for(Province province:list) {
            System.out.println(province);
        }

List<Province> list = session.createQuery("from Province p where id<?")
                .setParameter(0,4).list();
        for(Province province:list) {
            System.out.println(province);
        }
        List<Province> list = session.createQuery("from Province p where id<:id")
                .setParameter("id",4).list();
        for(Province province:list) {
            System.out.println(province);
        }

 /*
       setFirstResult():开始从这个下标开始，不包括这个下标
       setMaxResults():设置每页记录数pageSize
       */
       /* List<Province> list = session.createQuery("from Province p")
                .setFirstResult(3).setMaxResults(9).list();
        for(Province province:list) {
            System.out.println(province);
        }*/

 Number count =  (Number) session.createQuery("select max(p.id) from Province p").uniqueResult();
            System.out.println("总数："+count.byteValue());

  List<Object[]> list = session.createQuery("select p.name,count(p.id) from Province p group by p.name").list();
        for (Object[] objes:list){
            System.out.println(objes[0]+"   "+objes[1]);
        }

List<Province> list = session.createQuery("from Province order by id desc").list();
        for (Province province:list) {
            System.out.println(province);
        }

String hql = "from City c where c.province.name=:name";
        hql = "select c from City c join c.province d where d.name=:name";
        hql = "select c from City c inner join c.province d where d.name=:name";
        List<City> list = session.createQuery(hql).setString("name","河南省").list();
        for (City c:list
             ) {
            System.out.println(c);
        }

 String hql ="select p.name,c.name from City c left outer join c.province p";
        Query query = session.createQuery(hql);
        List<Object[]> list = query.list();
        for (Object[] o:list
             ) {
            System.out.println(o[0]+"  "+o[1]);

        }

String sql="select Name,Price from BOOK";
List<Object[]> list =session.createSQLQuery(sql)
.list();
for(Object[] b:list){
System.out.println(b[0]+"-"+b[1]);
}