使用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