Hibernate4的CRUD

1. Hibernate4的CRUD

新建项目Hibernate02

1) HibernateUtil封装

HibernateUtil.java

package com.andrew.util;
import org.hibernate.SessionFactory;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
public class HibernateUtil {
    private static final SessionFactory sessionFactory = buildSessionFactory();
    private static SessionFactory buildSessionFactory() {
        // 1. 实例化配置文件
        Configuration configuration = new Configuration().configure();
        // 2. 实例化服务登记
        ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder()
                .applySettings(configuration.getProperties()).build();
        // 3. 获取Session工厂
        return configuration.buildSessionFactory(serviceRegistry);
    }
    public static SessionFactory getSessionFactory() {
        return sessionFactory;
    }
}

2) XML版CRUD实现

Student.java

package com.andrew.model;
public class Student {
    private long id;
    private String name;
    public long getId() {
        return id;
    }
    public void setId(long id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    @Override
    public String toString() {
        return "Student [id=" + id + ", name=" + name + "]";
    }
}

Student.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.andrew.model">
    <class name="Student" table="t_student">
        <id column="stuId" name="id">
            <generator class="native"/>
        </id>
        <property generated="never" lazy="false" name="name"/>
    </class>
</hibernate-mapping>

hibernate.cfg.xml

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <!-- 数据库连接设置 -->
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost:3306/hibernate4</property>
        <property name="connection.username">root</property>
        <property name="connection.password">root</property>
        <!-- 方言 -->
        <property name="dialect">org.hibernate.dialect.MySQL5Dialect</property>
        <!-- 控制台显示SQL -->
        <property name="show_sql">true</property>
        <!-- 自动更新表结构 -->
        <property name="hbm2ddl.auto">update</property>
        <!-- Mapper -->
        <mapping resource="com/andrew/model/Student.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

StudentTest.java

package com.andrew.service;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import com.andrew.model.Student;
import com.andrew.util.HibernateUtil;
public class StudentTest {
    private SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
    private void add() {
        Session session = sessionFactory.openSession(); // 1. 生成一个session
        session.beginTransaction(); // 2. 开启事务
        Student s = new Student();
        s.setName("学生一");
        session.save(s);
        session.getTransaction().commit(); // 3. 提交事务
        session.close(); // 4. 关闭session
    }
    private void delete() {
        Session session = sessionFactory.openSession(); // 1. 生成一个session
        session.beginTransaction(); // 2. 开启事务
        Student student = (Student)session.get(Student.class, Long.valueOf(2));
        session.delete(student);
        session.getTransaction().commit(); // 3. 提交事务
        session.close(); // 4. 关闭session
    }
    private void update() {
        Session session = sessionFactory.openSession(); // 1. 生成一个session
        session.beginTransaction(); // 2. 开启事务
        Student student = (Student)session.get(Student.class, Long.valueOf(1));
        student.setName("学生二");
        session.save(student);
        session.getTransaction().commit(); // 3. 提交事务
        session.close(); // 4. 关闭session
    }
    private void getAllStudent() {
        Session session = sessionFactory.openSession(); // 1. 生成一个session
        session.beginTransaction(); // 2. 开启事务
        String hql = "from Student";
        Query query = session.createQuery(hql);
        List<Student> studentList = query.list();
        for (Student student : studentList) {
            System.out.println(student);
        }
        session.getTransaction().commit(); // 3. 提交事务
        session.close(); // 4. 关闭session
    }
    public static void main(String[] args) {
        StudentTest studentTest = new StudentTest();
        // studentTest.add();
        // studentTest.delete();
        // studentTest.update();
        studentTest.getAllStudent();
    }
}

3) 注解版CRUD实现

Teacher.java

package com.andrew.model;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
import org.hibernate.annotations.GenericGenerator;
@Entity
@Table(name="t_teacher")
public class Teacher {
    private long id;
    private String name;
    @Id
    @GeneratedValue(generator="_native")
    @GenericGenerator(name="_native", strategy="native")
    public long getId() {
        return id;
    }
    public void setId(long id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    @Override
    public String toString() {
        return "Teacher [id=" + id + ", name=" + name + "]";
    }
}

hibernate.cfg.xml

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <!-- 数据库连接设置 -->
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="connection.url">jdbc:mysql://localhost:3306/hibernate4</property>
        <property name="connection.username">root</property>
        <property name="connection.password">root</property>
        <!-- 方言 -->
        <property name="dialect">org.hibernate.dialect.MySQL5Dialect</property>
        <!-- 控制台显示SQL -->
        <property name="show_sql">true</property>
        <!-- 自动更新表结构 -->
        <property name="hbm2ddl.auto">update</property>
        <!-- Mapper -->
        <mapping class="com.andrew.model.Teacher"/>
    </session-factory>
</hibernate-configuration>

TeacherTest.java

package com.andrew.service;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import com.andrew.model.Teacher;
import com.andrew.util.HibernateUtil;
public class TeacherTest {
    private SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
    private void add() {
        Session session = sessionFactory.openSession(); // 1. 生成一个session
        session.beginTransaction(); // 2. 开启事务
        Teacher s = new Teacher();
        s.setName("老师一");
        session.save(s);
        session.getTransaction().commit(); // 3. 提交事务
        session.close(); // 4. 关闭session
    }
    private void delete() {
        Session session = sessionFactory.openSession(); // 1. 生成一个session
        session.beginTransaction(); // 2. 开启事务
        Teacher teacher = (Teacher)session.get(Teacher.class, Long.valueOf(1));
        session.delete(teacher);
        session.getTransaction().commit(); // 3. 提交事务
        session.close(); // 4. 关闭session
    }
    private void update() {
        Session session = sessionFactory.openSession(); // 1. 生成一个session
        session.beginTransaction(); // 2. 开启事务
        Teacher teacher = (Teacher)session.get(Teacher.class, Long.valueOf(2));
        teacher.setName("老师三");
        session.save(teacher);
        session.getTransaction().commit(); // 3. 提交事务
        session.close(); // 4. 关闭session
    }
    private void getAllteacher() {
        Session session = sessionFactory.openSession(); // 1. 生成一个session
        session.beginTransaction(); // 2. 开启事务
        String hql = "from Teacher";
        Query query = session.createQuery(hql);
        List<Teacher> teacherList = query.list();
        for (Teacher teacher : teacherList) {
            System.out.println(teacher);
        }
        session.getTransaction().commit(); // 3. 提交事务
        session.close(); // 4. 关闭session
    }
    public static void main(String[] args) {
        TeacherTest teacherTest = new TeacherTest();
        // teacherTest.add();
        // teacherTest.delete();
        // teacherTest.update();
        teacherTest.getAllteacher();
    }
}

4) Junit4单元测试框架引入

junit jar包

junit4.4.jar

TeacherJunitTest.java

package com.andrew.junit;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.Test;
import com.andrew.model.Teacher;
import com.andrew.util.HibernateUtil;
public class TeacherJunitTest {
    private SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
    @Test
    public void testAdd() {
        Session session = sessionFactory.openSession(); // 1. 生成一个session
        session.beginTransaction(); // 2. 开启事务
        Teacher s = new Teacher();
        s.setName("张三");
        session.save(s);
        session.getTransaction().commit(); // 3. 提交事务
        session.close(); // 4. 关闭session
    }
    @Test
    public void testDelete() {
        Session session = sessionFactory.openSession(); // 1. 生成一个session
        session.beginTransaction(); // 2. 开启事务
        Teacher Teacher = (Teacher) session.get(Teacher.class, Long.valueOf(2));
        session.delete(Teacher);
        session.getTransaction().commit(); // 3. 提交事务
        session.close(); // 4. 关闭session
    }
    @Test
    public void testUpdate() {
        Session session = sessionFactory.openSession(); // 1. 生成一个session
        session.beginTransaction(); // 2. 开启事务
        Teacher Teacher = (Teacher) session.get(Teacher.class, Long.valueOf(3));
        Teacher.setName("张三2");
        session.save(Teacher);
        session.getTransaction().commit(); // 3. 提交事务
        session.close(); // 4. 关闭session
    }
    @Test
    public void testGetAllTeacher() {
        Session session = sessionFactory.openSession(); // 1. 生成一个session
        session.beginTransaction(); // 2. 开启事务
        String hql = "from Teacher";
        Query query = session.createQuery(hql);
        List<Teacher> TeacherList = query.list();
        for (Teacher Teacher : TeacherList) {
            System.out.println(Teacher);
        }
        session.getTransaction().commit(); // 3. 提交事务
        session.close(); // 4. 关闭session
    }
}