使用Hibernate自动生成表

在之前的文章中,我通过使用SQL语句的方法生成了数据库中的表,但在Hibernate中提供给了我们使用HIbernate自动生成表的方法,我们可以通过Hibernate自动生成数据库表。

首先,要在我们的hibernate.cfg.xml文件中进行对hibernate的配置,代码如下:

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

通过这行代码,可以使得hibrnate根据已存在的实体类自动的生成数据库表。

此处的参数类型以及作用如下:

update   当第一次运行Hibernate时候会自动建立表的结构,以后也会自动更新,起修改的作用

vaildate  验证作用,会与数据库中标进行比较而不会重新创建表

create    每次运行会删除上一次运行表格,重新建表

create-drop 每次假造Hibernate时候会根据Model类生成表,但是如果sessionFactry工厂一旦关闭,表也会自动删除

这里我们选择update方法

既然hibernate是根据实体类进行更新创建数据库表,那么实体类必不可少,我还是使用之前的ORMdemo实体类

package ORMclass;

public class ORMdemo {
	private int id;
	private String username;
	private String password;
	
	public ORMdemo(){}
	public ORMdemo(String username,String password){
		this.username=username;
		this.password=password;
	}
	public int getId() {
		return id;
	}
	
	public String getUsername() {
		return username;
	}
	
	public String getPassword() {
		return password;
	}
	
	public void setId(int id){
		this.id=id;
	}
	
	public void setUsername(String username){
		this.username=username;
	}
	
	public void setPassword(String password) {
		this.password=password;
	}
}

实体类和数据库表的映射文件我们也不用更改

<?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="ORMclass.ORMdemo" table="ORMdemo">
        <id name="id" column="id">
            <generator class="increment" />
        </id>
        <property name="username" column="username" />
        <property name="password" column="password" />
    </class>
</hibernate-mapping>

新建一个AutoTest类,测试自动生成表

package cn.itcast.test;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.junit.Test;

public class AutoTest {
	@Test  
	public void AutoUpdateTest(){
		// TODO Auto-generated method stub
		SessionFactory sf = null;	
		Session session = null;
		Transaction ts = null;
		try {
  			sf = HibernateUtil.getSessionFactory();
			session = sf.getCurrentSession();
		} catch (HibernateException e) {
			// TODO Auto-generated catch block
			if(ts != null)
			{
				ts.rollback();
			}
			e.printStackTrace();
		}
	}
}

private static void printTableMetaInfo(Session session) { Connection connection = session.connection(); try { DatabaseMetaData metaData = connection.getMetaData(); ResultSet result = metaData.getColumns(null, null, NameOfTable, null); String strInJava = ""; String typeInJava; while (result.next()) { String columnName = result.getString(4); if ("stampTime".equalsIgnoreCase(columnName)) { continue; } int columnType = result.getInt(5); String nameFirstLetterLower = columnName.substring(0, 1).toLowerCase() + columnName.substring(1); switch (columnType) { case Types.VARCHAR: case Types.LONGVARCHAR: case Types.LONGNVARCHAR: case Types.NVARCHAR: case Types.CHAR: typeInJava = "String"; break; case Types.TINYINT: case Types.SMALLINT: case Types.INTEGER: typeInJava = useInteger ? "Integer" : "int"; break; case Types.TIMESTAMP: case Types.BINARY: typeInJava = "Calendar"; break; case Types.DECIMAL: typeInJava = "BigDecimal"; break; case Types.BIGINT: typeInJava = "BigInteger"; break; case Types.LONGVARBINARY: typeInJava = "byte[]"; break; case Types.DATE: typeInJava = "Calendar"; break; default: throw new Exception("Unknown type " + columnType + " and column is " + columnName); } strInJava += " private " + typeInJava + " " + nameFirstLetterLower + ";\n"; // strInHibernate += "\n"; } String str = "import javax.persistence.Entity;\n" + "import javax.persistence.Id;\n" + "import javax.persistence.Table;\n" + "import java.util.Calendar;\n\n"; str += "@Entity\n"; str += "@Table(name=\"$\")\n".replace("$", NameOfTable); str += "public class $ {\n".replace("$", NameOfTable.substring(2)); str += "\n @Id\n"; str += strInJava; str += "}"; System.out.println(str); StringSelection stringSelection = new StringSelection(str); Clipboard clpbrd = Toolkit.getDefaultToolkit().getSystemClipboard(); clpbrd.setContents(stringSelection, null); } catch (Exception e) { e.printStackTrace(); }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值