Hibernate和Access(转载)
<!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:hibtest <!-- 这里是你刚才指定的数据库名字 -->
????????? </property>??????
????????? <property name="connection.username">sa</property>??????
????????? <property name="connection.password"></property>??????
????????? <property name="dialect">??????
?????????????? net.sf.hibernate.dialect.MySQLDialect <!-- 这里是Access的Dialect -->
????????? </property>??????
????????? <mapping resource="Customer.hbm.xml"/> <!-- 指定Customer的映射文件 -->??????
???? </session-factory>???????
? </hibernate-configuration>
方法三：
1、<!-- SQL方言，Access和SQLserver相近，所以这么写，严格意义会出错，但是尝试简单连接时可以的 -->
<property name="dialect">
org.hibernate.dialect.SQLServerDialect
</property>
2、<!-- JDBC驱动程序 -->
<property name="connection.driver_class">
sun.jdbc.odbc.JdbcOdbcDriver
</property>
3、<!-- JDBC URL ，需要注意的是数据库位置使用绝对路径就可以-->
<property name="connection.url">
jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E:\STDateBase\student.mdb
</property> ???
