MyEclipse--Hibernate连接ACCESS数据库

最新推荐文章于 2023-04-07 21:07:33 发布

iteye_2040

最新推荐文章于 2023-04-07 21:07:33 发布

阅读量163

点赞数

CC 4.0 BY-SA版权

分类专栏：工作随笔文章标签： Hibernate Access Myeclipse Spring SQL

本文链接：https://blog.youkuaiyun.com/iteye_2040/article/details/81734445

工作随笔专栏收录该内容

2 篇文章

订阅专栏

本文详细介绍了如何在Java项目中使用Hibernate框架连接Microsoft Access数据库，包括必要的jar包配置、数据源设置及Hibernate配置文件的具体参数。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、在lib目录下导入2个jar包

Access_JDBC30.jar

hibernate.jar

2、Hibernate添加数据源

Driver templat:

Driver name: access

Connection URL:jdbc:access:///G:/ACCESS/test1.mdb

Driver JARs :Access_JDBC30.jar

3、Hibernate数据源配置
<property name="dialect">com.hxtt.support.hibernate.HxttAccessDialect</property>

<?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">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

<session-factory>
	<property name="connection.url">
		jdbc:access:///G:/ACCESS/test1.mdb
	</property>
	<property name="myeclipse.connection.profile">access</property>
	<property name="connection.driver_class">
		com.hxtt.sql.access.AccessDriver
	</property>
	<property name="show_sql">true</property>
	<property name="connection.username"></property>
	<property name="connection.password"></property>
	<property name="hibernate.dialect">
		com.hxtt.support.hibernate.HxttAccessDialect
	</property>
	<property name="dialect">com.hxtt.support.hibernate.HxttAccessDialect</property>
	<mapping resource="com/jsw/hibernate/entity/TUser.hbm.xml" />

</session-factory>

</hibernate-configuration>