閱讀947 返回首頁    go 微軟 go windows


使用hibernate自動在MYSQL中創建表,極其簡單,改下配置文件。

通過程序,自己手動寫建表語句挺麻煩的。

如下所示:

 <property name="hbm2ddl.auto">update</property>

將update改為create,然後運行JUNIT的單個方法,比如save()即可。


然後進入mysql查看建表語句:

mysql> use hibernate;
Database changed
mysql> show create table teacher;
+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table   | Create Table                                                                                                                                                                                                                                                                                                     |
+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| teacher | CREATE TABLE `teacher` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `birthDate` datetime DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `good` bit(1) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gbk |
+---------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set

mysql> 


大致就這樣,很簡單,嗬嗬嗬。

最後更新:2017-04-02 17:28:38

  上一篇:go 模擬hibernate實現的JAVA源碼
  下一篇:go SMSLib開發指南