开发过程:
1.建立三个表tb_topic,tb_reply,tb_manager
CREATE TABLE `tb_topic` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`author` varchar(20) DEFAULT NULL,
`face` varchar(10) DEFAULT NULL,
`content` text,
`ip` varchar(16) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`createTime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `tb_reply` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`topcid` int(10) DEFAULT NULL,
`author` varchar(20) DEFAULT NULL,
`content` text,
`createTime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `tb_manager` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) DEFAULT NULL,
`pwd` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
2.建立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">
<!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration>
<session-factory>
<property name="connection.username">root</property>
<property name="connection.url">
jdbc:mysql://localhost:3306/test
</property>
<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
<property name="myeclipse.connection.profile">mysql</property>
<property name="connection.driver_class">
com.mysql.jdbc.Driver
</property>
<property name="show_sql">true</property>
<property name="transaction.factory_class">
org.hibernate.transaction.JDBCTransactionFactory
</property>
</session-factory>
</hibernate-configuration>
3.创建实体类及其映射文件
package com.actionForm;
public class TopicForm {
private int id = -1;
private String author = "";
private String face = "";
private String content = "";
private String ip = "";
private String email = "";
private String createTime = "";
//getXXX() and setXXX()
}
TopicForm.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.actionForm.TopicForm" table="tb_topic">
<id name="id" column="id" type="int">
<generator class="increment" /><!--设置自动增值-->
</id>
<property name="author" column="author" type="string"
not-null="true" />
<property name="face" column="face" type="string"
not-null="true" />
<property name="content" column="content" type="string"
not-null="true" />
<property name="ip" column="ip" type="string" not-null="true" />
<property name="email" column="email" type="string" />
<property name="createTime" column="createTime" type="string"
not-null="true" />
</class>
</hibernate-mapping>
package com.actionForm;
public class ReplyForm {
private int id = -1;
private int topicid = -1;
private String author = "";
private String content = "";
private String createTime = "";
//getXXX() and setXXX()
}
ReplyForm.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.actionForm.ReplyForm" table="tb_Reply">
<id name="id" column="id" type="int">
<generator class="increment" /><!--设置自动增值-->
</id>
<property name="topicid" column="topicid" type="int"
not-null="true" />
<property name="author" column="author" type="string" />
<property name="content" column="content" type="string" />
<property name="createTime" column="createTime" type="string" />
</class>
</hibernate-mapping>