利用hibernate的bean和配置文件来将表创建到数据库中

最新推荐文章于 2020-06-02 19:51:50 发布

最新推荐文章于 2020-06-02 19:51:50 发布 · 160 阅读

文章标签：

#Bean #Hibernate #MySQL #Myeclipse #XML

本文介绍如何通过JavaBean、Hibernate映射文件及配置文件来搭建一个简单的留言系统，并演示了如何自动生成数据库表。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[size=xx-large]1、建立一个Javabean。LeaveMessage.java[/size]
package com.sipu.wcme.bean;

/**
* @author Administrator
*
*/
public class LeaveMessage {

private int id;
/**
* 留言人类别。
*/
private String type;
/**
* 留言的省份。
*/
private String province;
/**
* 留言人姓名。
*/
private String name;
/**
* 留言人所在公司。
*/
private String company;
/**
* 留言人的职位。
*/
private String position;
/**
* 留言人邮箱。
*/
private String email;
/**
* 留言内容。
*/
private String content;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public String getProvince() {
return province;
}
public void setProvince(String province) {
this.province = province;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getCompany() {
return company;
}
public void setCompany(String company) {
this.company = company;
}
public String getPosition() {
return position;
}
public void setPosition(String position) {
this.position = position;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getContent() {
return content;
}
public void setContent(String content) {
this.content = content;
}

}
[size=xx-large]
2、建立一个映射文件。LeaveMessage.hbm.xml[/size]
<?xml version="1.0" encoding="utf-8"?>
<!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.sipu.wcme.bean.LeaveMessage" table="_leavemessage">
<id name="id" type="java.lang.Integer">
<column name="id"/>
<generator class="native" />
</id>
<property name="type" type="java.lang.String">
<column length="20" name="type"/>
</property>
<property name="province" type="java.lang.String">
<column length="50" name="province"/>
</property>
<property name="name" type="java.lang.String">
<column length="50" name="name"/>
</property>
<property name="company" type="java.lang.String">
<column length="255" name="company"/>
</property>
<property name="position" type="java.lang.String">
<column length="50" name="position"/>
</property>
<property name="email" type="java.lang.String">
<column length="50" name="email"/>
</property>
<property name="content" type="java.lang.String">
<column length="500" name="content"/>
</property>
</class>
</hibernate-mapping>
[size=xx-large]3、配置hibernate.cfg.xml文件。[/size]
<!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.url">
jdbc:mysql://192.168.2.141:3306/wcme
</property>
<property name="hibernate.connection.driver_class">
com.mysql.jdbc.Driver
</property>
<property name="hibernate.connection.username">sulixun</property>
<property name="hibernate.connection.password">sulixun</property>
<property name="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</property>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.hbm2ddl.auto">update</property>

<mapping resource="com/sipu/wcme/bean/LeaveMessage.hbm.xml" />

</session-factory>
</hibernate-configuration>
[size=xx-large]4、调用ExportToDB运行直接生成表在数据库里面。[/size]
package com.sipu.wcme.util;

import org.hibernate.cfg.Configuration;
import org.hibernate.tool.hbm2ddl.SchemaExport;

public class ExportToDB {

/**
* @param args
*/
public static void main(String[] args) {

// 读取配置文件
Configuration cfg = new Configuration().configure();

// 创建SchemaExport对象
SchemaExport export = new SchemaExport(cfg);

// 创建数据库表
export.create(true, true);

}

}