【SSH框架】电力项目持久层搭建

1. 建立测试表elec_text (使用数据库MySQL)

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50626
Source Host           : localhost:3306
Source Database       : elec

Target Server Type    : MYSQL
Target Server Version : 50626
File Encoding         : 65001

Date: 2017-07-06 19:53:45
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for elec_text
-- ----------------------------
DROP TABLE IF EXISTS `elec_text`;
CREATE TABLE `elec_text` (
  `textID` varchar(50) NOT NULL,
  `textName` varchar(50) DEFAULT NULL,
  `textDate` datetime DEFAULT NULL,
  `textRemark` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2. 建立JavaBean对象（PO对象）属于持久层对象

package cn.tk.elec.domain;

import java.io.Serializable;
import java.util.Date;
/**
 * 
 * @ClassName ElecText
 * @Description TODO 持久层测试类
 * @author TK
 * @Date 2017年7月6日 下午4:46:21
 * @version 1.0.0
 */
@SuppressWarnings("serial")
public class ElecText implements Serializable{
	private String textID;   	//测试ID
	private String textName; 	//测试名
	private Date textDate;	 	//测试时间
	private String textRemark;  //测试备注
	public String getTextID() {
		return textID;
	}
	public void setTextID(String textID) {
		this.textID = textID;
	}
	public String getTextName() {
		return textName;
	}
	public void setTextName(String textName) {
		this.textName = textName;
	}
	public Date getTextDate() {
		return textDate;
	}
	public void setTextDate(Date textDate) {
		this.textDate = textDate;
	}
	public String getTextRemark() {
		return textRemark;
	}
	public void setTextRemark(String textRemark) {
		this.textRemark = textRemark;
	}
	
	
}

3.  创建映射文件

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2017-6-1 20:44:47 by Hibernate Tools 3.4.0.CR1 -->
<!-- 创建ElecText的数据表映射文件 -->
<hibernate-mapping>
	<!-- 指定映射PO文件的所在位置、数据表名 -->
    <class name="cn.tk.elec.domain.ElecText" table="ELEC_TEXT">
        <id name="textID" type="java.lang.String">
            <column name="TEXTID" not-null="true" sql-type="varchar(50)" />
            <generator class="uuid" />
        </id>
        <property name="textName" type="java.lang.String">
            <column name="TEXTNAME" />
        </property>
        <property name="textDate" type="java.util.Date">
            <column name="TEXTDATE" length="50" />
        </property>
        <property name="textRemark" type="java.lang.String">
            <column name="TEXTREMARK" sql-type="varchar(500)"/>
        </property>
    </class>
</hibernate-mapping>

4. 创建hibernate配置文件

<?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>
    <session-factory>
    <property name="hibernate.connection.username">root</property>
		<property name="hibernate.connection.password">x5</property>
		<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/elec</property>
		<property name="hibernate.connection.autocommit">true</property>
		
		<property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
		<property name="hibernate.hbm2ddl.auto">update</property>
		<property name="hibernate.show_sql">true</property>
		
		<mapping resource="cn/tk/elec/domain/ElecText.hbm.xml"/>
    </session-factory>
</hibernate-configuration>