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

1、建立一个Javabean。LeaveMessage.java
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;
}

}

2、建立一个映射文件。LeaveMessage.hbm.xml
<?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">
<!--
    Mapping file autogenerated by MyEclipse Persistence Tools

-->

<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>
3、配置hibernate.cfg.xml文件。
<!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>
4、调用ExportToDB运行直接生成表在数据库里面。
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);


}

}

评论

1 楼 qlhl2000 2009-12-13  

使用注解+Mysql-ds.xml+persistence.xml是否可以生成数据库表？