hibernate

package cn.jbit;import java.util.Arrays;import java.util.List;import oracle.net.aso.a;import org.hibernate.Criteria;import org.hibernate.Session;import org.hibernate.criterion.DetachedCriteria;import org.hibernate.criterion.MatchMode;import org.hibernate.criterion.Order;import org.hibernate.criterion.Projection;import org.hibernate.criterion.ProjectionList;import org.hibernate.criterion.Projections;import org.hibernate.criterion.Property;import org.hibernate.criterion.Restrictions;import org.junit.Test;import cn.jbit.bean.Dept;import cn.jbit.bean.Emp;import cn.jbit.util.HibernateSessionFactory;public class TestHibernate {@Testpublic void test1() {Session session = HibernateSessionFactory.getSession();List<Emp> emps = session.createCriteria(Emp.class)// .add(Restrictions.eq("ename", "SCOTT"))// .add(Restrictions.eq("empno", 7788))// .add(Restrictions// .in("empno", new Object[] { 7788, 7799, 7499 }))// .add(Restrictions.ilike("ename", "S", MatchMode.ANYWHERE)).addOrder(Order.desc("ename")).list();for (Emp emp : emps) {System.out.println(emp);}}@Testpublic void test3() {Session session = HibernateSessionFactory.getSession();Criteria criteria = session.createCriteria(Emp.class);criteria.setFirstResult(5);criteria.setMaxResults(5);List<Emp> emps = criteria.list();for (Emp emp : emps) {System.out.println(emp);}}@Testpublic void test4() {Session session = HibernateSessionFactory.getSession();Criteria criteria = session.createCriteria(Emp.class);Emp emp = (Emp) session.createCriteria(Emp.class).add(Restrictions.eq("ename", "SCOTT")).setMaxResults(1).uniqueResult();System.out.println(emp);}@Testpublic void test5() {Session session = HibernateSessionFactory.getSession();List<Emp> list = session.createCriteria(Emp.class, "e").createAlias("dept", "d")// .add(Restrictions.ilike("e.empName", "a",// MatchMode.ANYWHERE))// .add(Restrictions.eq("d.deptName", "财务部").ignoreCase()).list();for (Emp emp : list) {System.out.println(emp + emp.getDept().getDname());}}@Testpublic void test6() {Session session = HibernateSessionFactory.getSession();List list = session.createCriteria(Emp.class).setProjection(Property.forName("ename")).setProjection(Property.forName("empno")).list();for (Object object : list) {System.out.println(object);}}@Testpublic void test7() {Session session = HibernateSessionFactory.getSession();List<Object[]> list = session.createCriteria(Emp.class).setProjection(Projections.projectionList().add(Property.forName("ename")).add(Property.forName("empno"))).list();for (Object[] objs : list) {System.out.println(Arrays.toString(objs));}}@Testpublic void test8() {Session session = HibernateSessionFactory.getSession();List<Object[]> list = session.createCriteria(Emp.class).setProjection(Projections.projectionList().add(Projections.groupProperty("job")).add(Projections.count("job"))).list();for (Object[] objects : list) {System.out.println(Arrays.toString(objects));}}@Testpublic void test9() {Session session = HibernateSessionFactory.getSession();List<Object> list = session.createCriteria(Emp.class).setProjection(Projections.rowCount()).list();for (Object objects : list) {System.out.println(objects);}}@Testpublic void test2() {Session session = HibernateSessionFactory.getSession();List<Dept> emps = session.createCriteria(Dept.class).list();for (Dept dept : emps) {System.out.println(dept.getEmps());}}@Testpublic void test10() {DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Dept.class);Session session = HibernateSessionFactory.getSession();List<Dept> emps = detachedCriteria.getExecutableCriteria(session).list();for (Dept dept : emps) {System.out.println(dept);}}}