hibernate系列之一

CREATE TABLE `customer` (
  `cust_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cust_name` varchar(255) DEFAULT NULL,
  `cust_source` varchar(255) DEFAULT NULL,
  `cust_industry` varchar(255) DEFAULT NULL,
  `cust_level` varchar(255) DEFAULT NULL,
  `cust_linkman` varchar(255) DEFAULT NULL,
  `cust_phone` varchar(255) DEFAULT NULL,
  `cust_mobile` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cust_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

package com.itwx.hibernate.pojo;

/**
 * 创建持久化类（实体类）
 * @author wangxuan
 *
 */
public class Customer {

	private Long cust_id;
	private String cust_name;
	private String cust_source;
	private String cust_industry;
	private String cust_level;
	private String cust_phone;
	private String cust_mobile;
	public Long getCust_id() {
		return cust_id;
	}
	public void setCust_id(Long cust_id) {
		this.cust_id = cust_id;
	}
	public String getCust_name() {
		return cust_name;
	}
	public void setCust_name(String cust_name) {
		this.cust_name = cust_name;
	}
	public String getCust_industry() {
		return cust_industry;
	}
	public void setCust_industry(String cust_industry) {
		this.cust_industry = cust_industry;
	}
	public String getCust_level() {
		return cust_level;
	}
	public void setCust_level(String cust_level) {
		this.cust_level = cust_level;
	}
	public String getCust_phone() {
		return cust_phone;
	}
	public void setCust_phone(String cust_phone) {
		this.cust_phone = cust_phone;
	}
	public String getCust_mobile() {
		return cust_mobile;
	}
	public void setCust_mobile(String cust_mobile) {
		this.cust_mobile = cust_mobile;
	}
	public String getCust_source() {
		return cust_source;
	}
	public void setCust_source(String cust_source) {
		this.cust_source = cust_source;
	}
	
	
}

<?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:实体类的全类名
    		table:数据库中与实体类相对应的表
    	 -->
    	<class name="com.itwx.hibernate.pojo.Customer" table="customer">
    		<!--  建立主键和实体类中的字段映射关系-->
    			<!-- id:主键之间的映射关系 
    				name:实体类中与数据库表中的主键对应的字段
    				column：数据库中表中的主键属性（实体类和数据库表中的字段名称一致可以省略）
    			-->
    		<id name="cust_id" column="cust_id">
    			<!--  设置主键增长策略-->
    			<generator class="native"/>
    		</id>
    		<!--建立实体类的其他字段和数据库中表的其他字段映射关系 （因为都是在一个实体类中和一张表的对应，所以标签元素的位置注意在class中）-->
				<!-- 
					property:标签建立其他属性和表中的字段之间建立映射关系
					name:类中的属性名
					columnL:表中的字段名
					length：字段长度
					type:字段属性，java数据类型
				 -->
			<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_phone" column="cust_phone"></property>
			<property name="cust_mobile" column="cust_mobile"></property>
    	</class>
    </hibernate-mapping>

<?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="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>		
			<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/hibernate_01</property>
			<property name="hibernate.connection.username">root</property>
			<property name="hibernate.connection.password">123456</property>
			<!-- 配置hibernate属性 -->
			<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
			<!-- hibernate显示SQL语句 -->
			<property name="hibernate.show_sql">true</property>
			<!-- hibernate格式化SQL语句 -->
			<property name="hibernate.foemat_sql">true</property>
			<property name="hibernate.hbm2ddl.auto">update</property>
			
			<!-- 配置加载映射文件:全路径-->
			<mapping resource="com/itwx/hibernate/pojo/Customer.hbm.xml"/>
		</session-factory>
	</hibernate-configuration>

package com.itwx.hibernate.test;

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

import com.itwx.hibernate.pojo.Customer;

public class HibernateTest {

	/**
	 * hibernate的执行步骤：
	 * 1.加载核心配置文件new COnfiguration().configure();
	 * 2.创建SessionFactory
	 * 3.创建Session
	 * 4.开启事务
	 * 5.执行操作
	 * 6.提交事务
	 * 7.释放资源（关闭session）
	 */
	@Test
	public void test(){
		//加载核心配置文件
		Configuration configuration = new Configuration().configure();
		
		SessionFactory sessionFactory = configuration.buildSessionFactory();
		
		Session session = sessionFactory.openSession();
		
		Transaction transaction = session.beginTransaction();
		
		//执行操作
		Customer customer = new Customer();
		customer.setCust_name("王五");
		customer.setCust_source("推销");
		
		session.save(customer);
		
		transaction.commit();
		session.close();
	}
}