Hibernate的批量查询——原生sql查询

 （2）直接封装到学生对象中，将对象存储到list集合：

<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> testSel() {
            Session session </span>=<span style="color: #000000;"> HibernateUtils.openSession();
            Transaction transaction </span>=<span style="color: #000000;"> session.beginTransaction();
            String sql</span>=<span style="color: #800000;">"</span><span style="color: #800000;">Select * from Student</span><span style="color: #800000;">"</span><span style="color: #000000;">;
            SQLQuery sqlQuery</span>=<span style="color: #000000;">session.createSQLQuery(sql);
            sqlQuery.addEntity(Student.</span><span style="color: #0000ff;">class</span><span style="color: #000000;">);
            List</span><Student>list=<span style="color: #000000;"> sqlQuery.list();
            System.</span><span style="color: #0000ff;">out</span><span style="color: #000000;">.println(list);
            transaction.commit();
            session.close();
        }</span>

 2、占位符的使用：

    <span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> testSel() {
            Session session </span>=<span style="color: #000000;"> HibernateUtils.openSession();
            Transaction transaction </span>=<span style="color: #000000;"> session.beginTransaction();
            String sql</span>=<span style="color: #800000;">"</span><span style="color: #800000;">Select * from Student where sex=?</span><span style="color: #800000;">"</span><span style="color: #000000;">;
            SQLQuery sqlQuery</span>=<span style="color: #000000;">session.createSQLQuery(sql);
            sqlQuery.setParameter(</span><span style="color: #800080;">0</span>,<span style="color: #800000;">"</span><span style="color: #800000;">女</span><span style="color: #800000;">"</span><span style="color: #000000;">);
            sqlQuery.addEntity(Student.</span><span style="color: #0000ff;">class</span><span style="color: #000000;">);
            List</span><Student>list=<span style="color: #000000;"> sqlQuery.list();
            System.</span><span style="color: #0000ff;">out</span><span style="color: #000000;">.println(list);
            transaction.commit();
            session.close();
        }</span>

3、分页查询：

<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> testSel() {
            Session session </span>=<span style="color: #000000;"> HibernateUtils.openSession();
            Transaction transaction </span>=<span style="color: #000000;"> session.beginTransaction();
            String sql</span>=<span style="color: #800000;">"</span><span style="color: #800000;">Select * from Student limit ?,?</span><span style="color: #800000;">"</span><span style="color: #000000;">;
            SQLQuery sqlQuery</span>=<span style="color: #000000;">session.createSQLQuery(sql);
            sqlQuery.setParameter(</span><span style="color: #800080;">0</span>,<span style="color: #800080;">0</span><span style="color: #000000;">);
            sqlQuery.setParameter(</span><span style="color: #800080;">1</span>,<span style="color: #800080;">1</span><span style="color: #000000;">);
            sqlQuery.addEntity(Student.</span><span style="color: #0000ff;">class</span><span style="color: #000000;">);
            List</span><Student>list=<span style="color: #000000;"> sqlQuery.list();
            System.</span><span style="color: #0000ff;">out</span><span style="color: #000000;">.println(list);
            transaction.commit();
            session.close();
        }</span>

Hibernate的批量查询——原生sql查询

标签：占位符   tor   sts   objects   obj   分页查询   span   generator   create