81,092
社区成员
发帖
与我相关
我的任务
分享
package com.hibernate;
import org.hibernate.cfg.Configuration;
import org.hibernate.tool.hbm2ddl.SchemaExport;
/**
* 手动导出数据表
*
* @author puruidong
* @version 2013.8.30
*/
public class ShowDB {
public static void main(String[]args){
Configuration cfg = new Configuration().configure() ;//加载配置信息
SchemaExport export = new SchemaExport(cfg); //实例化SchemaExport.
System.out.println(export);
export.create(true,true);//到处数据表
}
}
package com.hibernate;
public class User {
private int num;
private String name;
private int age ;
private String address;
//省略set/get方法
}
<?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"><!-- dtd无法访问. -->
<hibernate-configuration>
<session-factory>
<!-- 方言 -->
<property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
<!-- 数据库驱动 -->
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<!-- 数据库连接 -->
<property name="hibernate.connection.url">jdbc:mysql://127.0.0.1:3306/Test</property>
<!-- 数据库连接用户名 -->
<property name="hibernate.connection.username">root</property>
<!-- 数据库连接密码 -->
<property name="hibernate.connection.password">root</property>
<!-- 打印SQL语句 -->
<property name="hibernate.hbm2ddl.auto">create</property>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.format_sql">true</property>
<mapping resource="com/hibernate/User.hbm.xml" />
</session-factory>
</hibernate-configuration>
<?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="com.hibernate.User" table="Studentss" >
<id name="num" column="num" type="int">
<generator class="native"></generator>
</id>
<property name="name" type="string" length="20">
<column name="name"></column>
</property>
<property name="age" type="int">
<column name="age"></column>
</property>
<property name="address" type="string" length="200">
<column name="address"></column>
</property>
</class>
</hibernate-mapping>