查询

HQL(Hibernate Query Language)是完全面对对象的查询语句，查询功能强大，具备继承、多态和关联等特性。

Dao层

public class StudentDao {
	private Session session = HibernateUtil.getSession();

	public Student selectStudentById(int ID) {
		Student stu = session.get(Student.class, ID);
		return stu;
	}

	public List<Student> selectStudentbyName(String name) {
		String sql = "FROM Student s WHERE s.name =?";
		Query<Student> query = session.createQuery(sql, Student.class);
		query.setParameter(0, name);
		List<Student> stus = query.list();
		return stus;
	}

	public List<Student> selectStudent() {
		String sql = "select * from STUDENT";
		Query<Student> query = session.createNativeQuery(sql, Student.class);
		List<Student> stus = (List<Student>) query.getResultList();
		return stus;
	}

	public int insertStudent(Student value) {
		session.beginTransaction();
		session.save(value);
		session.getTransaction().commit();
		return 1;
	}

	public int deleteStudentById(int ID) {
		session.beginTransaction();
		Student stu = session.get(Student.class, ID);
		session.delete(stu);
		session.getTransaction().commit();
		return 1;
	}

	public int updateStudentById(Student value) {
		session.beginTransaction();
		Student stu = session.get(Student.class, value.getID());
		stu = value;
		session.update(stu);
		session.getTransaction().commit();
		return 1;
	}
}

public class insertMain {
	private static StudentDao studao = null;

	public static void main(String[] args) {
		studao = new StudentDao();
		Student stu = new Student();
		stu.setName("你好");
		stu.setGender("F");
		stu.setAge(22);
		System.out.println(studao.insertStudent(stu));
	}
}

Hibernate: select max(ID) from STUDENT

Hibernate: insert into STUDENT (NAME, GENDER, AGE, ID) values (?, ?, ?, ?)

public class updateMain {
	private static StudentDao studao = null;

	public static void main(String[] args) {
		studao = new StudentDao();
		List<Student> stus = studao.selectStudent();
		for (Student s : stus) {
			System.out.println(s);
		}
		Student stu = stus.get(1);
		stu.setName("你好");
		System.out.println(studao.updateStudentById(stu));
		;
	}
}

Hibernate: select * from STUDENT

Student [ID=1, name=你好, gender=M, age=22]

Hibernate: update STUDENT set NAME=?, GENDER=?, AGE=? where ID=?

public class Main0529 {
	public static void main(String[] args) {
		Session session = HibernateUtil.getSession();
		String sql = "select s.gender,avg(age) from Student s group by s.gender";
		Query<Object[]> query = session.createQuery(sql, Object[].class);
		List<Object[]> list = query.list();
		for (Object[] s : list) {
			System.out.printf("%s:%s%n", s[0], s[1]);
		}
	}
}

Hibernate: select student0_.GENDER as col_0_0_, avg(student0_.AGE) as col_1_0_ from STUDENT student0_ group by student0_.GENDER

F:22.0

M:23.3333