Hibernate的自动建表首先需要配置好数据库表与javaBean的映射XML文件;
下面是用户表的entity
public class User {
private Integer id;
private String name;
private boolean sex;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public boolean isSex() {
return sex;
}
public void setSex(boolean sex) {
this.sex = sex;
}
}
User.hbm.xml
<?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.idea.user.User" table="tb_user">
<id name="id" column="id" type="int">
<generator class="native"></generator>
</id>
<property name="name" type="string" not-null="true" length="50">
<column name="name"></column>
</property>
<property name="sex" type="boolean">
<column name="sex"></column>
</property>
</class>
</hibernate-mapping>
hibernate.cfg.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!--数据库驱动-->
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<!--数据库连接URL-->
<property name="connection.url">jdbc:mysql://192.168.126.145:3306/hibernate</property>
<!--数据库连接名-->
<property name="connection.username">root</property>
<!--数据库连接密码-->
<property name="connection.password">040825</property>
<!--Hibernate方言-->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<!--打印SQL语句-->
<property name="show_sql">true</property>
<!--自动建表-->
<!--create每次创建SessionFactory时都会重新创建表,如果表已存在则删除-->
<!--Update如果表不存在则创建,如果存在则检查表是否与映射文件匹配,当不匹配时,更新表-->
<!--none无论何时都不创建或更新表-->
<property name="hibernate.hbm2ddl.auto">create</property>
<!--映射文件-->
<mapping resource="com/idea/dao/User.hbm.xml"/>
</session-factory>
</hibernate-configuration>
创建表的测试类
public class ExportTable {
public static void main(String[] args){
Configuration cfg = new Configuration().configure();
SchemaExport export = new SchemaExport(cfg);
export.create(true,true);
}
}
create()方法有两个布尔型参数,第一个参数是指定是否打印创建表所用的DDL语句,第二个参数指定是否再数据库中真正创建数据表