5.测试持久化对象的状态:测试(对HQL和Query的初步认识)

来源:互联网 发布:高德地图自定义数据库 编辑:程序博客网 时间:2024/06/05 10:26
package com.bjpowernode.test;import java.util.Iterator;import java.util.List;import junit.framework.TestCase;import org.hibernate.Query;import org.hibernate.Session;import com.bjpowernode.hibernate.HibernateUtils;import com.bjpowernode.hibernate.User;public class QueryTest extends TestCase {public void testQuery1() {Session session = null;try {session = HibernateUtils.getSession();session.beginTransaction();Query query = session.createQuery("from User");List userList = query.list();for (Iterator iter=userList.iterator(); iter.hasNext();) {User user = (User)iter.next();System.out.println("id=" + user.getId() + ", name=" + user.getName());}session.getTransaction().commit();}catch(Exception e) {e.printStackTrace();session.getTransaction().rollback();}finally {HibernateUtils.closeSession(session);}}public void testQuery2() {Session session = null;try {session = HibernateUtils.getSession();session.beginTransaction();Query query = session.createQuery("from User");query.setFirstResult(0);query.setMaxResults(1);List userList = query.list();for (Iterator iter=userList.iterator(); iter.hasNext();) {User user = (User)iter.next();System.out.println("id=" + user.getId() + ", name=" + user.getName());}session.getTransaction().commit();}catch(Exception e) {e.printStackTrace();session.getTransaction().rollback();}finally {HibernateUtils.closeSession(session);}}}