hibernate的query

package com.yuzd.hibernate;

import java.util.Iterator;
import java.util.List;

import junit.framework.TestCase;

import org.hibernate.Query;
import org.hibernate.Session;

import com.yuzd.util.HbmUtils;

public class QueryTest extends TestCase {

    public void testQuery(){
        Session session =null;
        try {
            session = HbmUtils.getSession();
            session.beginTransaction();
            Query query = session.createQuery("from User");
            query.setFirstResult(1);
            query.setMaxResults(2);
            List userList = query.list();
            for(Iterator iter=userList.iterator();iter.hasNext();){
                User user = (User) iter.next();
                System.out.println("user.id =" + user.getId());
                System.out.println("user.name="+user.getName());
            }
            session.getTransaction().commit();
        } catch (Exception e) {
            e.printStackTrace();
            session.getTransaction().rollback();
        }finally{
            HbmUtils.closeSession(session);
        }
    }
}

 

posted on 2013-10-17 22:04  鱼东鱼  阅读(371)  评论(0编辑  收藏  举报

导航