SessionFactory 执行原生态的SQL语句

最新推荐文章于 2023-02-18 22:46:16 发布

weixin_33946020

最新推荐文章于 2023-02-18 22:46:16 发布

阅读量615

点赞数

文章标签： java

    public List<User> getPageIndex(int pageIndex,int topNum){
        String hql = "select top("+topNum+""+")* from " +
                     "(select * from LMY_MYDJM316 a where a.id not in " +
                     "(select b.id from " +
                     "(select top("+ (pageIndex-1)*topNum+""+")* from LMY_MYDJM316)b))c";    
        SQLQuery query  =  sessionFactory.getCurrentSession().createSQLQuery(hql).addEntity(User.class);  
        System.out.println(query.list());
        return query.list(); 
    }