Oops! Hibernate + Access Quick Start
Purpose:
為了用hibernate鏈接access,花了我一個(gè)下午。他nnd，網(wǎng)上一群混蛋，沒(méi)有一篇能夠說(shuō)明為什么的。
Reference:
Eclipse + Access
http://www.tkk7.com/pixysoft/archive/2007/08/30/141392.html
Eclipse + Hibernate
http://www.tkk7.com/pixysoft/archive/2007/09/01/141932.html
Quick Start:
所有的步驟參考上面的文章，幾乎沒(méi)有變，下面2個(gè)文件修改就行了。
假設(shè)我的access數(shù)據(jù)庫(kù)保存在c:\demo.mdb，數(shù)據(jù)格式：
表名：CUSTOMER
字段：
id 自增，主鍵
username: 文本
password: 文本
則：
Customer.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="Customer" table="CUSTOMER">
<id name="id" column="id">
<generator class="increment" />
</id>
<property name="username" column="USERNAME" />
<property name="password" column="PASSWORD" />
</class>
</hibernate-mapping>
hibernate.cfg.xml
<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE hibernate-configuration
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
<session-factory name="java:/hibernate/HibernateFactory">
<property name="show_sql">true</property>
<property name="connection.driver_class">
sun.jdbc.odbc.JdbcOdbcDriver<!-- 這里是Access的JDBCdriverclass名 -->
</property>
<property name="connection.url">
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:/demo.mdb
</property>
<property name="connection.username">
sa
</property>
<property name="connection.password">
</property>
<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
<mapping resource="Customer.hbm.xml" />
</session-factory>
</hibernate-configuration>
posted on 2007-09-08 17:36
張辰 閱讀(1086)
評(píng)論(0) 編輯 收藏 所屬分類:
Dr. Oops