Java hibernate QBC查询（查询所有，排序查询，条件查询，in字句查询）

Student.java类

package cn.com.edu;


import javax.persistence.CascadeType;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.ManyToOne;

@Entity
public class Student {
	@Id
	@GeneratedValue(strategy=GenerationType.AUTO)
	private int id;
	private String name;
	private String sex;
	@ManyToOne(cascade={CascadeType.MERGE},fetch=FetchType.EAGER)
	private Project pro;
	public Student() {
		super();
	}
	public Student(String name, String sex) {
		super();
		this.name = name;
		this.sex = sex;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public Project getPro() {
		return pro;
	}
	public void setPro(Project pro) {
		this.pro = pro;
	}
	@Override
	public String toString() {
		return "Student [id=" + id + ", name=" + name + ", sex=" + sex + "]";
	}

}

Project.java类

package cn.com.edu;

import java.util.HashSet;
import java.util.Set;

import javax.persistence.CascadeType;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.OneToMany;



@Entity
public class Project {
	@Id
	@GeneratedValue(strategy=GenerationType.AUTO)
	private int id;
	private String name;
	@OneToMany(cascade={CascadeType.ALL},mappedBy="pro",fetch=FetchType.LAZY)
	private Set<Student> students=new HashSet<Student>();
	public Project() {
		super();
		// TODO Auto-generated constructor stub
	}
	public Project(String name) {
		super();
		this.name = name;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Set<Student> getStudents() {
		return students;
	}
	public void setStudents(Set<Student> students) {
		this.students = students;
	}
}

hibernate.cfg.xml

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

    <session-factory>
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="connection.url">jdbc:mysql:///test?characterEncoding=utf8</property>
        <property name="connection.username">root</property>
        <property name="connection.password">root</property>
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="myeclipse.connection.profile">firstTest</property>
    	<property name="show_sql">true</property>
    	<property name="format_sql">true</property>
<!--     	<property name="hbm2ddl.auto">create</property> -->
    	
    	<mapping class="cn.com.edu.Student"/>
    	<mapping class="cn.com.edu.Project" />
    </session-factory>

</hibernate-configuration>

hiberTest.java  测试类

package cn.com.edu;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;

public class hiberTest {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		Configuration con = new Configuration().configure();// 读取解析配置文件
		SessionFactory sf = con.buildSessionFactory(); // 创建工厂，读取映射信息

		Session session = sf.openSession();// 打开Session

		Transaction tr = session.beginTransaction(); // 创建并开始一个事务
		// function1(session);// 查询所有员工
		// function2(session);// 排序查询
		// function3(session);// 条件查询
		function4(session);// in字句查询
		tr.commit();
		session.close();
		sf.close();
	}

	private static void function4(Session session) {
		Criteria cri = session.createCriteria(Student.class);
		Object[] values = { "小明", "小灰" };
		List<Student> list = cri.add(Restrictions.in("name", values)).list();
		for (Student stu : list) {
			System.out.println(stu);
		}

	}

	private static void function3(Session session) {
		Criteria cri = session.createCriteria(Student.class);
		cri.add(Restrictions.eq("name", "小红"));
		List<Student> list = cri.list();
		for (Student stu : list) {
			System.out.println(stu);
		}

	}

	private static void function2(Session session) {
		Criteria cri = session.createCriteria(Student.class);
		cri.addOrder(Order.asc("name"));
		List<Student> list = cri.list();
		for (Student stu : list) {
			System.out.println(stu);
		}

	}

	private static void function1(Session session) {
		Criteria cri = session.createCriteria(Student.class);
		List<Student> list = cri.list();
		for (Student stu : list) {
			System.out.println(list);
		}

	}

}