Hibernate查询数据

最新推荐文章于 2025-07-17 14:19:15 发布

转载最新推荐文章于 2025-07-17 14:19:15 发布 · 303 阅读

Java 专栏收录该内容

57 篇文章

订阅专栏

本文介绍了一个使用Hibernate框架实现的学生信息管理系统。该系统包括学生信息的增删查改操作，并演示了如何通过SQL和HQL进行数据查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package com.ittx.hibernate002.model;

import java.util.Date;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

public class StudentTest {
	SessionFactory sessionFactory;
	Transaction transaction;
	Session session;

	@Before
	public void setUp() throws Exception {
		// 读取hibernate.cfg.xml文件
		Configuration config = new Configuration().configure();
		ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder().applySettings(config.getProperties())
				.build();
		// 建立SessionFactory
		sessionFactory = config.buildSessionFactory(serviceRegistry);
//		session = sessionFactory.openSession();
		session = sessionFactory.getCurrentSession();
		transaction = session.beginTransaction();
	}
	
	@After
	public void tearDown() throws Exception {
		transaction.commit();
//		session.close();
//		sessionFactory.close();
	}

	@Test
	public void testSaveStudent() {
		Student student = new Student(1001, "小丽", 18,"男",new Date());
		session.save(student);
		
		student = new Student(1002, "小明", 23,"女",new Date());
		session.save(student);
		
//		Student student = new Student(1001, "小明", 23,"女",new Date());
//		session.delete(student);
		
	}
	/**
	 * SQL方法
	 * 
	 */
	@Test
	public void testQueryStudent(){
		String sql = "select * from student where age=18 or number=1002 order by age DESC";
		SQLQuery sqlQuery = session.createSQLQuery(sql).addEntity(Student.class);
		List<Student> list = sqlQuery.list();
		for(Student student:list){
			System.out.println(student);
		}
	}
	/**
	 * HSQL方法
	 */
	@Test
	public void testHQLStudent(){
		String hsql = "FROM Student";
		Query query = session.createQuery(hsql);
		List<Student> list = query.list();
		for(Student student:list){
			System.out.println(student);
		}
	}
	/**
	 * HSQL
	 */
	@Test
	public void testHQLStudentValue(){
		String hsql = "SELECT count(*) FROM Student";
		Query query = session.createQuery(hsql);
		Long r = (Long) query.uniqueResult();
		System.out.println(r);
	}
	/**
	 * 查找指定属性记录
	 * 1.创建包含查询属性构造方法
	 * 2.若查询结果唯一，用uniqueResult()，有多条结果，用list()
	 */
	@Test
	public void testHQLStudentSelect(){
		String hsql = "SELECT new Student(s.name,s.number) FROM Student AS s where s.number=:num";
		Query query = session.createQuery(hsql);
		query.setParameter("num", 1001);
		Student r = (Student) query.uniqueResult();
		System.out.println(r);
	}
	
}