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 {
	@Test
	public 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);
		}
	}

	@Test
	public 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);
		}
	}

	@Test
	public 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);

	}

	@Test
	public 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());
		}
	}

	@Test
	public 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);
		}
	}

	@Test
	public 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));
		}
	}

	@Test
	public 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));
		}
	}

	@Test
	public 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);
		}
	}

	@Test
	public void test2() {
		Session session = HibernateSessionFactory.getSession();
		List<Dept> emps = session.createCriteria(Dept.class).list();
		for (Dept dept : emps) {
			System.out.println(dept.getEmps());
		}
	}

	@Test
	public 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);
		}
	}
}