第二节 基于XML映射文件实现数据的CURD

基于XML映射文件实现数据的CURD

项目结构

1. configuration文件需要放在resources根目录中。
2. **.hbm.xml文件要和实体类放在一起
3. 3.

项目开发步骤

1. hibernate.cfg.xml
2. User.java
3. User.hbm.xml
4. UserDao.java
5. UserDaoImpl.java
6. UserDaoTest.java

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>
        <!--hibernate链接的基本信息，数据库信息-->
        <property name="connection.driver_class">org.postgresql.Driver</property>
        <property name="connection.url">jdbc:postgresql://localhost:5432/hibernate</property>
        <property name="connection.username">postgres</property>
        <property name="connection.password">123456</property>
        <!--hibernate方言-->
        <property name="dialect"> org.hibernate.dialect.PostgresPlusDialect</property>
        <!--是否打印sql-->
        <!--
            update，存在就修改，不存在就创建
            create，每次都删除表然后再重新创建表
        -->
        <property name="hibernate.hbm2ddl.auto">update</property>
        <property name="show_sql">true</property>
        <property name="format_sql">true</property>
        <!--hibernate映射文件-->
        <mapping  resource="cn/edu/scnu/xmlcurd/entity/User.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

<!--Hibernate 3.0 dtd-->

User.java

package cn.edu.scnu.xmlcurd.entity;

import java.text.SimpleDateFormat;
import java.util.Date;

public class User {
    private int id;
    private String username;
    private String password;
    private Date registerDate;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public Date getRegisterDate() {
        return registerDate;
    }

    public void setRegisterDate(Date registerDate) {
        this.registerDate = registerDate;
    }

    @Override
    public String toString() {
        return "UserEntity{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", registerDate=" +
                new SimpleDateFormat("yyyy-MM-dd").format(registerDate) +
                '}';
    }
}

User.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">
<!--
    **.hbm.xml应该和类名相同
-->
<hibernate-mapping package="cn.edu.scnu.xmlcurd">
    <!--
        class 中的name应该对应实体类的类名
        class 中的table应该对应数据库表的名字
        class 中的catalog应该对应数据库的名字
    -->
    <class name="cn.edu.scnu.xmlcurd.entity.User" table="users" catalog="hibernate">
        <!--
            每一个实体类都必须有一个id属性
            generator:主键生成策略
                increment（hibernate递增方式）,
                identity（苏杭巨款底层自增）,
                sequence（数据库序列生成机制）,
                hilo（hibernate高低位算法生成）,
                native（自动识别数据库）,
                assigned（应用程序产生），当不指定generator时，默认这种策略
        -->
        <id name="id" type="java.lang.Integer">
            <column name="id"/>
            <generator class="native"/>
        </id>
        <!--
            属性中的name对应实体类中的属性名
            属性中的type对应实体类中属性的类型
        -->
        <property name="username" type="java.lang.String">
            <column name="username" length="16" not-null="true"/>
        </property>
        <property name="password" type="java.lang.String">
            <column name="password" length="16" not-null="true"/>
        </property>
        <property name="registerDate" type="java.util.Date">
            <column name="registerDate" not-null="true"/>
        </property>

    </class>

</hibernate-mapping>

UserDao.java

package cn.edu.scnu.xmlcurd.dao;

import cn.edu.scnu.xmlcurd.entity.User;

import java.util.List;

public interface UserDao {
    void save(User user);
    void delete(Integer id);
    void update(User user,Integer id);
    User findById(Integer id);
    List<User> getAll();
}

UserDaoImpl.java

package cn.edu.scnu.xmlcurd.dao.impl;

import cn.edu.scnu.xmlcurd.dao.UserDao;
import cn.edu.scnu.xmlcurd.entity.User;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;

import java.util.ArrayList;
import java.util.List;

/*
具体流程：
    提供sessionFactory
    通过sessionFactory获得session
    打开session
    开始transaction
 上面都是初始化
    事务开始
 下面都是结束
    提交transaction
    关闭session
    关闭sessionFactory
 */

/**
 * 注意：
 *      get方法获取数据，如果数据不存在会返回null
 *      load方法获取数据，如果数据不存在会出现ObjectNotFoundException异常，因此使用load方法时，数据必须存在
 */

public class UserDaoImpl implements UserDao {

    private SessionFactory sessionFactory;

    //初始化
    private Session session;
    private Transaction transaction;
    private void init(){
        session = sessionFactory.openSession();
        transaction = session.beginTransaction();
    }

    //销毁
    private void destroy(){
        transaction.commit();
        session.close();
        sessionFactory.close();
    }


    @Override
    public void save(User user) {
        try{
            init();
            session.save(user);
            destroy();
        }catch (Exception e){
            e.printStackTrace();
        }
    }

    @Override
    public void delete(Integer id) {

    }

    @Override
    public void update(User user,Integer id) {
        try {
            init();
            user.setId(id);
            session.update(user);
            destroy();
        }catch (Exception e){
            e.printStackTrace();
        }
    }

    @Override
    public User findById(Integer id) {
        User user = new User();
        try{
            init();
            user = session.get(User.class,1);

            destroy();
        }catch (Exception e){
            e.printStackTrace();
        }
        return user;
        //Load方式
        /*
        User user = new User();
        try{
            init();
            user = session.load(User.class,1);
            destroy();
        }catch (Exception e){
            e.printStackTrace();
        }
        return user;
        */
    }

    @Override
    public List<User> getAll() {
        List<User> users=new ArrayList<>();
        try{
            init();
            users = session.createQuery("from User").list();
            destroy();
        }catch (Exception e){
            e.printStackTrace();
        }
        return users;
    }

    public SessionFactory getSessionFactory() {
        return sessionFactory;
    }

    public void setSessionFactory(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
    }
}

UserDaoTest.java

package cn.edu.scnu.xmlcurd.dao.impl;

import cn.edu.scnu.xmlcurd.dao.UserDao;
import cn.edu.scnu.xmlcurd.entity.User;
import org.hibernate.cfg.Configuration;
import org.junit.Before;
import org.junit.Test;

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

import static org.junit.Assert.*;

public class UserDaoImplTest {

    private UserDaoImpl userDao;

    @Before
    public void before(){
        userDao = new UserDaoImpl();
        userDao.setSessionFactory(new Configuration().configure().buildSessionFactory());
        System.out.println(userDao.getSessionFactory());
    }

    @Test
    public void save() {
        User user = new User();
        user.setUsername("小李");
        user.setPassword("12345");
        user.setRegisterDate(new Date());
        userDao.save(user);
    }

    @Test
    public void delete() {
        userDao.delete(1);
    }

    @Test
    public void update() {
        User user = new User();
        user.setUsername("乔峰");
        user.setPassword("12345");
        user.setRegisterDate(new Date());
        userDao.update(user,1);

    }

    @Test
    public void findById() {
        User user = userDao.findById(1);
        System.out.println(user.toString());
    }

    @Test
    public void getAll() {
        List<User> users = userDao.getAll();
        for(User user :users){
            System.out.println(user.toString());
        }
    }
}