hibernate自动生成表的代码

最新推荐文章于 2021-02-15 22:49:42 发布

转载最新推荐文章于 2021-02-15 22:49:42 发布 · 3.3k 阅读

文章标签：

#hibernate #myeclipse #string #integer #constructor #sqlserver

sql-数据库同时被 2 个专栏收录

6 篇文章

订阅专栏

框架

1 篇文章

订阅专栏

本文介绍了一个使用Hibernate框架配置数据库连接及通过配置文件自动生成表的示例。具体包括Hibernate配置文件设置、实体类定义、映射文件说明及生成表的Java代码。

<?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">  <hibernate-configuration> <session-factory> <property name="myeclipse.connection.profile">jxkh</property> <property name="connection.url"> jdbc:microsoft:sqlserver://localhost:1433 </property> <property name="connection.username">sa</property> <property name="connection.password">sa</property> <property name="connection.driver_class"> com.microsoft.jdbc.sqlserver.SQLServerDriver </property> <property name="dialect"> org.hibernate.dialect.SQLServerDialect </property> <property name="connection.autocommit">true</property> <property name="show_sql">true</property> <mapping resource="com/lhkj/entity/Users.hbm.xml" /> </session-factory> </hibernate-configuration> 实体类 package com.lhkj.entity; /** * Users generated by MyEclipse Persistence Tools */ public class Users implements java.io.Serializable { // Fields private Integer id; private String username; private String userpwd; // Constructors /** default constructor */ public Users() { } /** full constructor */ public Users(String username, String userpwd) { this.username = username; this.userpwd = userpwd; } // Property accessors public Integer getId() { return this.id; } public void setId(Integer id) { this.id = id; } public String getUsername() { return this.username; } public void setUsername(String username) { this.username = username; } public String getUserpwd() { return this.userpwd; } public void setUserpwd(String userpwd) { this.userpwd = userpwd; } } 配置文件 <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">  <hibernate-mapping> <class name="com.lhkj.entity.Users" table="users" schema="dbo" catalog="jxkh"> <id name="id" type="java.lang.Integer"> <column name="id" /> <generator class="native"></generator> </id> <property name="username" type="java.lang.String"> <column name="username" length="50" /> </property> <property name="userpwd" type="java.lang.String"> <column name="userpwd" length="50" /> </property> </class> </hibernate-mapping> 生成表的代码 package com.lhkj.util; import org.hibernate.cfg.Configuration; import org.hibernate.tool.hbm2ddl.SchemaExport; public class ExportDb { /** * @param args */ public static void main(String[] args) { Configuration conf=new Configuration().configure(); SchemaExport se=new SchemaExport(conf); se.create(true, true); } }