hibernate框架的搭建

1.导包

2.创建数据库，准备表，实体

CREATE TABLE `cst_customer` (
  `cust_id` bigint(32) NOT NULL AUTO_INCREMENT COMMENT '客户编号(主键)',
  `cust_name` varchar(32) NOT NULL COMMENT '客户名称(公司名称)',
  `cust_source` varchar(32) DEFAULT NULL COMMENT '客户信息来源',
  `cust_industry` varchar(32) DEFAULT NULL COMMENT '客户所属行业',
  `cust_level` varchar(32) DEFAULT NULL COMMENT '客户级别',
  `cust_linkman` varchar(64) DEFAULT NULL COMMENT '联系人',
  `cust_phone` varchar(64) DEFAULT NULL COMMENT '固定电话',
  `cust_mobile` varchar(16) DEFAULT NULL COMMENT '移动电话',
  PRIMARY KEY (`cust_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

3.书写orm元数据(对象与表的映射配置文件)

1)导入约束:window--->Preferences--->XML--->XML Catalog--->User Specified Entries窗口，点击Add按钮

2)实体

public class Customer {
private long cust_id;
private String cust_name;
private long cust_user_id;
private long cust_create_id;
private String cust_source;
private String cust_industry;
private String cust_level;
private String cust_linkman;
private String cust_phone;
private String cust_mobile;
}

3)orm元数据

创建CstCustomer.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>
<!-- name:映射类的类名 table:映射类的表名catalog:数据库名,可省（mysql使用catalog指定数据库） -->
<class name="com.hibernate.domain.CstCustomer" table="cst_customer">
<!-- <cache usage="read-write" /> -->
<!-- 主键映射配置 name:指定当前映射类中属性id对应user表的主键 type:指定当前映射类中属性id的类型 column:指定user表的主键为id字段 
generator:指定主键的生成策略，identity为采用数据库的主键自增长策略，常用的还有uuid、sequence等 -->
<id name="cust_id" column="cust_id">
<generator class="native"></generator>
</id>


<!-- 普通字段映射 -->
<property name="cust_name" column="cust_name">
</property>
<property name="cust_source" column="cust_source">
</property>
<property name="cust_industry" column="cust_industry">
</property>
<property name="cust_level" column="cust_level">
</property>
<property name="cust_linkman" column="cust_linkman">
</property>
<property name="cust_phone" column="cust_phone">
</property>
<property name="cust_mobile" column="cust_mobile">
</property>
</class>
</hibernate-mapping>

4.书写主配置文件

<?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.dialect org.hibernate.dialect.MySQLDialect #hibernate.dialect 
org.hibernate.dialect.MySQLInnoDBDialect #hibernate.dialect org.hibernate.dialect.MySQLMyISAMDialect 
#hibernate.connection.driver_class com.mysql.jdbc.Driver #hibernate.connection.url 
jdbc:mysql:///test #hibernate.connection.username gavin #hibernate.connection.password -->
<!-- 数据库驱动 -->
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<!-- 数据库url -->
<property name="hibernate.connection.url">jdbc:mysql:///crm_hibertane</property>
<!-- 数据库连接用户名 -->
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">123</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<!-- 将hibernate生成的sql语句打印到控制台 -->
<property name="hibernate.show_sql">true</property>
<!-- 将hibernate生成的sql语句格式化(语法缩进) -->
<property name="hibernate.format_sql">true</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<!-- 引入orm元数据 路径书写: 填写src下的路径 -->
<mapping resource="com/hibernate/domain/CstCustomer.hbm.xml" />
</session-factory>
</hibernate-configuration>

5.创建Test类测试

package com.hibernate.domain;


import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;


public class Test {
@org.junit.Test
public void fun1() {
Configuration conf = new Configuration().configure();
SessionFactory sessionFactory = conf.buildSessionFactory();
Session session = sessionFactory.openSession();
Transaction tx = session.beginTransaction();

//------------------
CstCustomer c = new CstCustomer();
c.setCust_name("CSDN");
session.save(c);
//------------------
tx.commit();
session.close();
sessionFactory.close();
}
}