maven中Hibernate的环境搭建与基础使用

使用mysql数据库与maven
新建web项目
在maven导入如下坐标:

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.8</maven.compiler.source>
    <maven.compiler.target>1.8</maven.compiler.target>
    <slf4j.version>1.6.6</slf4j.version>
    <log4j.version>1.2.12</log4j.version>
  </properties>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
    <dependency>
      <groupId>org.hibernate</groupId>
      <artifactId>hibernate-core</artifactId>
      <version>5.4.10.Final</version>
    </dependency>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.6</version>
    </dependency>
    <!-- log start -->
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>${log4j.version}</version>
    </dependency>

    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-api</artifactId>
      <version>${slf4j.version}</version>
    </dependency>

    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-log4j12</artifactId>
      <version>${slf4j.version}</version>
    </dependency>

    <!-- log end -->
  </dependencies>

根据数据库创建实体类(这里需自行添加get与set方法):

public class CustomerEntity {
    //包装类的默认值null
    private Long cust_id;
    private String cust_name;
    private Long cust_user_id;
    private Long cust_create_id;
    private String cust_industry;
    private String cust_level;
    private String cust_linkman;
    private String cust_phone;
    private String cust_mobile;
    private String cust_source;
}

给实体类创建其对应的映射配置文件（与实体类文件于同一目录）:CustomerEntity.hbm.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <!--配置类和表结构的映射-->
<class name="com.hyx.mapping.CustomerEntity" table="cst_customer">
    <!--配置id
    name属性，javabean的属性
    column属性，表结构字段
    两属性相同可以省略column-->
    <id name="cust_id" column="cust_id">
        <!--主键生成策略，自动递增-->
        <generator class="native"></generator>
    </id>
    <property name="cust_create_id" column="cust_create_id"/>
    <property name="cust_industry" column="cust_industry"/>
    <property name="cust_source" column="cust_source"/>
    <property name="cust_level" column="cust_level"/>
    <property name="cust_linkman" column="cust_linkman"/>
    <property name="cust_mobile" column="cust_mobile"/>
    <property name="cust_name" column="cust_name"/>
    <property name="cust_phone" column="cust_phone"/>
    <property name="cust_user_id" column="cust_user_id"/>
</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>
    
    <!-- 记住：先配置SessionFactory标签，一个数据库对应一个SessionFactory标签 -->
    <session-factory>
        
        <!-- 必须要配置的参数有5个，4大参数，数据库的方言 -->
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.url">jdbc:mysql:///hibernate_day01</property>
        <property name="hibernate.connection.username">root</property>
        <property name="hibernate.connection.password">密码</property>

        <!-- 数据库的方言 使用创建表时不能开启方言-->
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
        
        <!-- 可选配置 -->
        <!-- 显示SQL语句，在控制台显示 -->
        <property name="hibernate.show_sql">true</property>
        <!-- 格式化SQL语句 -->
        <property name="hibernate.format_sql">true</property>
        <!-- 生成数据库的表结构 
            update：如果没有表结构，创建表结构。如果存在，不会创建，添加数据
        -->
        <!--<property name="hibernate.hbm2ddl.auto">update</property>-->
        
        <!-- 映射配置文件，需要引入映射的配置文件 -->
        <mapping resource="com/hyx/mapping/Customer.hbm.xml"/>
        
    </session-factory>
    
</hibernate-configuration>

测试程序编写:

@Test
    public void test2(){
        Session session = HibernateUtil.getSession();
        //开启事务
        Transaction transaction = session.beginTransaction();
        //编写保存的代码

        CustomerEntity c=new CustomerEntity();

        c.setCust_name("测试");
        c.setCust_level("2");
        c.setCust_industry("111");

        //保存
        session.save(c);
        //通过主键查询1条记录
        CustomerEntity customerEntity = session.get(CustomerEntity.class, 4L);
        System.out.println(customerEntity);
        //删除
        session.delete(customerEntity);
        //修改
        c.setCust_name("嘟嘟嘟");
        session.update(c);
        //添加或修改
//        session.saveOrUpdate(c);
        //查询所有
        Query query = session.createQuery("from com.hyx.mapping.CustomerEntity");
        List<CustomerEntity> list = query.list();
        for (CustomerEntity cx : list) {
            System.out.println(cx);

        }
        //提交事务
        transaction.commit();
        //回滚事务
//        transaction.rollback();
        //释放资源
        session.close();

    }