Hibernate练习

package com.hanqi.dao;
import org.hibernate.Transaction;
import org.hibernate.service.*;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
//JUnit测试用例
public class testUser {
        SessionFactory sf=null;
        Session  se=null;
        Transaction tr=null;
    //在test方法执行之前执行
    @Before
    public void init()
    {
        System.out.println("初始化的方法");
        
                //测试Hibernate
    
                //1.创建SessionFactory
                //(1)得到配置
                Configuration cfg=new Configuration().configure();
                //(2)注册服务
                ServiceRegistry sr=new StandardServiceRegistryBuilder().applySettings(cfg.getProperties()).build();
                //(3)得到SessionFactory
                sf=cfg.buildSessionFactory(sr);
                //2.创建Session打开数据库连接
                se=sf.openSession();
                //3.创建Transaction，开始事务
                 tr=se.beginTransaction();
                //之前是固定的写法            
    }
    
    
    @Test
    public void test0()
    {
        //插入数据
        User u=new User("测试用户",20,"123456");  
        //保存数据
        se.save(u);
        //获取数据
        User u1=(User)se.get(User.class,2);
        System.out.println(u1);
        //修改数据
        u1.setAge(30);
        u1.setUserName("新的名称");
        //删除数据
          se.delete(u1);
    }
    
    @Test
    public void test1()
    {
        //HQL查询
        //1.写HQL语句
        String hql="from User n where n.age>? and n.password=? order by n.userID Desc";
        hql="from User n where n.age>:age and n.password=:pw";
        //2.创建query
        Query q=se.createQuery(hql);
        //方法链编程,补充问号的空位
        List<User> lu=q.setInteger(0, 30).setString(1, "12456").list();
        //3.遍历结果
        for(User u:lu)
        {
            System.out.println(u);
        }
    }
@Test
    public void testTeacher()
    {
        String Hql="select t.tsex,count(t.tsex) from Teacher t group by t.tsex";
        //使用Object[]来装载数据
        List<Object[]> ls=se.createQuery(Hql).list();
        for(Object[] ary:ls)    
        {
            for(Object obj:ary)
            {
                System.out.print(" "+obj+";");
            }
            System.out.println();
        }
    }
    
    @Test
    public void testQuery1()
    {
        //可以在HQL使用new构造方法 返回持久化类的实例
        String Hql="select new Teacher(n.tno,n.tname) from Teacher n";
        List<Teacher> lt=se.createQuery(Hql).list();
        for(Teacher t:lt)
        {
            System.out.println(t);
        }
    }
    
    @Test
    public void testQuery2()
    {
        String Hql="From Course n where n.tno in"
                +"(select t.tno from Teacher t where t.depart='计算机系')";
        List<Course> lt=se.createQuery(Hql).list();
        for(Course t:lt)
        {
            System.out.println(t);
        }
    }
    
    @Test
    public void testQuery3()
    {
        String Hql="select c.cno,c.cname,t.tname from Course c,Teacher t where c.tno=t.tno";
        List<Object[]> ls=se.createQuery(Hql).list();
        for(Object[] ary:ls)    
        {
            for(Object obj:ary)
            {
                System.out.print(" "+obj+";");
            }
            System.out.println();
        }
    }
    
    @Test
    public void testGet1()
    {
        //得到单个实例
        Course c=(Course)se.get(Course.class, "3-126");
        //有框架自动获取相关数据
        Teacher t=(Teacher)se.get(Teacher.class, "804");
        System.out.println(c);
        //添加新课程
        Course c1=new Course("3-126","数据库",t);
        se.save(c1);
        System.out.println(t);
    }
    
    @Test
    public void testGet2()
    {
        Teacher t=(Teacher)se.get(Teacher.class, "825");
        System.out.println(t);
        se.delete(t);
    }
    
    //在test方法执行之后执行
    @After
    public void destory()
    {
        //6.提交事务
        tr.commit();
        //7.关闭
        se.close();
        sf.close();
    }
}