sql/hql对比

来源：互联网发布：梦幻小号注册软件编辑：程序博客网时间：2024/05/21 22:54

1、hql分页

String queryString = "from EqpEquipment model " + conditions + " and  "                    + GlobalRoleUtil.getResourceAuthConditions("model.equipcode") + " order by nlssort(equipname,'NLS_SORT=SCHINESE_PINYIN_M')";            session = this.getHibernateTemplate().getSessionFactory().getCurrentSession();            Query query = session.createQuery(queryString);            query.setFirstResult(curpage * pagesize);            query.setMaxResults(pagesize);            return query.list().toArray();

2、sql分页

SQLQuery query = this.getSessionFactory().getCurrentSession().createSQLQuery(sql + where)                    <span style="background-color: rgb(255, 255, 153);">.addEntity("t", TgsPassedcarHis10.class);</span>            query.setFirstResult(cp * ps);            query.setMaxResults(ps);            return query.list();

3、hql查询数量（int）

<span style="white-space:pre"></span>    Query query = this.getSessionFactory().getCurrentSession().createQuery(sql + where);            int temp = Integer.parseInt(String.valueOf(query.uniqueResult()));            return temp;

<span style="white-space:pre"></span>    String quertString = "select count(*) from SysPoint as model "+condition;

<span style="white-space:pre"></span>    return ((long)getHibernateTemplate().find(queryString).listIterator().next()).intValue();

//    <span style="font-family: Arial, Helvetica, sans-serif;"> return ((Number)getHibernateTemplate().find(queryString).listIterator().next()).intValue();</span>

4、sql查询数量（long）

Long i =(Long) this.getHibernateTemplate().getSessionFactory().getCurrentSession().createQuery("select count(*) from EqpEquipment t ").uniqueResult();return ""+i;

0 0