日期:2014-05-18  浏览次数:20672 次

Hibernate创建数据库表无效
持久化类
package org.crazyit.app.domain;

public class News {
private Integer id;
private String title;
private String content;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getContent() {
return content;
}
public void setContent(String content) {
this.content = content;
}
}


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>
<property name="connection.url">
jdbc:mysql://localhost:3306/hibernate
</property>
<property name="connection.username">root</property>
<property name="connection.password">root</property>

<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.min_size">1</property>

<property name="hibernate.c3p0.timeout">5000</property>
<property name="hibernate.c3p0.max_statements">100</property>
<property name="hibernate.c3p0.idle_test_period">3000</property>
<property name="hibernate.c3p0.acquire_increment">2</property>
<property name="hibernate.c3p0.validata">true</property>

<property name="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
<property name="hbm2ddl.auto">update</property>

<mapping resource="org/crazyit/app/domain/News.hbm.xml"></mapping>
</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 package="org.crazyit.app.domain">
<class name="News" table="news_table">
<id name="id">
<generator class="identity"></generator>
</id>
<property name="title"></property>
<property name="content"></property>
</class>
</hibernate-mapping>


创建数据库表
package lee;


import org.crazyit.app.domain.News;
import org.hibernate.Session;
import org.hibernate.cfg.Configuration;

public class NewsManager {
public static void main(String[] args)
{
//读取配置文件hibernate.cfg.xml
Configuration cfg = new Configuration().configure();

//创建SchemaExport实例;
SchemaExport sExport = new SchemaExport(cfg);

//创建数据表项
sExport.create(