首页 > Web开发 > 详细

hibernate---session查询

时间:2018-09-22 11:41:29      阅读:142      评论:0      收藏:0      [点我收藏+]

 

 

public class MyTest {
    public static void main(String[] args) {
        
        //查询集合
        Session session = SessionUtil.openSession();
        String hql = "from Emp";
        Query query = session.createQuery(hql);
        @SuppressWarnings("unchecked")
        List<Emp> list = query.list();
        
        //带条件查询方法1
        String hql2 = "from Emp where empno = ?";
        Query query2 = session.createQuery(hql2);
        query2.setInteger(0, 23);
        Emp emp = (Emp) query2.uniqueResult();
        
        //带条件查询方法2
        String hql3 = "from Emp where empno = ?";
        Query query3 = session.createQuery(hql3);
        query3.setParameter(0, 23);
        Emp emp2 = (Emp) query2.uniqueResult();
        
        //带条件查询方法3
        String hql4 = "from Emp where empno = :xx";
        Query query4 = session.createQuery(hql4);
        query4.setParameter("xx", 23);
        Emp emp3 = (Emp) query2.uniqueResult();
        
        //分页查询
        String hql5 = "from Emp";
        Query query5 = session.createQuery(hql5);
        query5.setFirstResult(0);
        query5.setMaxResults(10);
        @SuppressWarnings("unchecked")
        List<Emp> list2 = query5.list();
        
        System.out.println(list);
        System.out.println(emp);
        System.out.println(emp2);
        System.out.println(emp3);
        System.out.println(list2);
    }
}

 

hibernate---session查询

原文:https://www.cnblogs.com/pecool/p/9689500.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!