Hibernate框架对mysql数据库进行CRUD（增改改删）

使用hibernate框架对mysql数据库进行增删改查

1、创建一个java工程，并且创建一个数据库hibernate

2、创建一个lib文件夹，拷贝jar包，并且build path（圈起的三个是测试jar包，编辑器有的话可以不考）

3、创建hibernate配置文件hibernate.cfg.xml，这里创建在根目录下

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE hibernate-configuration PUBLIC        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><hibernate-configuration>    <!-- 一个sessionFactory代表数据库的一个连接 -->    <session-factory>        <!-- 链接数据库的用户名 -->        <property name="connection.username">root</property>        <!-- 链接数据库的密码 -->        <property name="connection.password">newstar</property>        <!-- 链接数据库的驱动 -->        <property name="connection.driver_class">            com.mysql.jdbc.Driver        </property>        <!-- 链接数据库的url -->        <property name="connection.url">              <![CDATA[jdbc:mysql://localhost:3306/hibernate?useUnicode=true&characterEncoding=utf8]]>        </property>        <!-- 方言 告诉hibernate使用哪个数据库，hibernate就会在底层拼接相应的sql语句 -->        <property name="dialect">            org.hibernate.dialect.MySQLDialect        </property>        <!-- 根据持久化类生成表的策略 validate 通过映射文件检查持久化泪idea匹配 update hibernate每次启动的时候，检查表是否存在，弱国不存在，则创建，如果存在，则说明不进行任何操作             create hibernate每次启动的时候，根据持久化类和映射文件生成表 create-drop hibernate每次启动的时候，根据持久化类和映射文件生成表，之后再删除 -->        <property name="hbm2ddl.auto">update</property>        <!-- 显示sql语句(开发中写上，方便开发观察) -->        <property name="show_sql">true</property>        <!-- 映射文件， -->        <mapping resource="com/itstar/domain/Person.hbm.xml" />    </session-factory></hibernate-configuration>

4、创建持久化类

package com.itstar.domain;import java.io.Serializable;public class Person implements Serializable {    private Long pid;    private String name;    private String password;    public Long getPid() {        return pid;    }    public void setPid(Long pid) {        this.pid = pid;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public String getPassword() {        return password;    }    public void setPassword(String password) {        this.password = password;    }}

5、创建映射文Person.hbm.xml

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN""http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping>    <!-- hibernate映射文件 -->    <class name="com.itstar.domain.Person" table="person">        <!-- id 描述主键 name 属性的名称 column 属性的名称对应的表中的字段 （不写时，默认与属性名称一致) length 属性的名称对应的表的字段长度             （不写时，默认为最大值 -->        <id name="pid" column="pid" length="5">            <generator class="increment"></generator>        </id>        <property name="name" length="20" type="java.lang.String"></property>        <property name="password" length="20" type="java.lang.String"></property>    </class></hibernate-mapping>

6、创建测试类开始测试

package com.itstar.test;import org.hibernate.Session;import org.hibernate.SessionFactory;import org.hibernate.Transaction;import org.hibernate.cfg.Configuration;import org.junit.Test;import com.itstar.domain.Person;public class TestHibernateCRUD {    //保存用户    @Test    public void testSavePerson(){        Configuration configuration = new Configuration();        //在跟根目录，不需要添加参数        configuration.configure();        SessionFactory sessionFactory = configuration.buildSessionFactory();        Session session = sessionFactory.openSession();        Transaction transaction = session.beginTransaction();        Person person = new Person();        person.setPid(1L);        person.setName("张三");        person.setPassword("123456");        session.save(person);        transaction.commit();        session.close();    }    //查询用户    @Test    public void testGetPerson(){        Configuration configuration = new Configuration();        configuration.configure();        SessionFactory sessionFactory = configuration.buildSessionFactory();        Session session = sessionFactory.openSession();        Person  person = (Person)session.get(Person.class, 2L);        System.out.println(person.getName());        session.close();    }    //更改用户    @Test    public void testChangePerson(){        Configuration configuration = new Configuration();        configuration.configure();        SessionFactory sessionFactory = configuration.buildSessionFactory();        Session session = sessionFactory.openSession();        Transaction transaction = session.beginTransaction();        Person  person = (Person)session.get(Person.class, 2L);        person.setName("李四");        session.update(person);        transaction.commit();        session.close();    }    //删除用户    @Test    public void testDeletePerson(){        Configuration configuration = new Configuration();        configuration.configure();        SessionFactory sessionFactory = configuration.buildSessionFactory();        Session session = sessionFactory.openSession();        Transaction transaction = session.beginTransaction();        Person  person = (Person)session.get(Person.class, 3L);        session.delete(person);        transaction.commit();        session.close();    }}