hibernate分页查询

最新推荐文章于 2021-06-18 12:33:55 发布

torch921

最新推荐文章于 2021-06-18 12:33:55 发布

阅读量198

点赞数

文章标签： hibernate list session exception object string

本文链接：https://blog.csdn.net/torch921/article/details/6285362

版权

//hibernate分页查询：

public List find(final String hsql, final   int firstRow, final   int maxRow) throws Exception {
           return getHibernateTemplate().executeFind( new HibernateCallback() {
             public Object doInHibernate(Session s) throws HibernateException, SQLException {
                   Query query = s.createQuery(hsql);
                   query.setFirstResult(firstRow);
                   query.setMaxResults(maxRow);
                   List list = query.list();
                   return list;
                   }
             });
    }

//hibernate直接运行sql语句

List list = null;
        try {
            list= getHibernateTemplate().executeFind(new HibernateCallback() {
                public Object doInHibernate(Session session)
                        throws HibernateException, SQLException {
                    String sql = "select * from noticetb n left join noticereadrecordstb b " +
                            "on n.nid=b.nid where n.pid = '"+ pid +"' and (b.sid != '"+ sid +"' or b.sid is null)";
                    return session.createSQLQuery(sql).list();
                }
            });
        }