hibernate映射到mysql数据库时应该注意的几点

iteye_6481

于 2012-10-26 08:46:00 发布

阅读量91

点赞数

文章标签： java 数据库开发工具

本文详细介绍了数据库连接、编码格式设定、驱动版本选择、连接池配置等关键步骤，包括使用MySQL数据库时如何设置字符集、选择合适的驱动程序、配置连接池以提升性能，以及提供了一个示例的Hibernate配置文件。

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

.要指定数据库中存储的数据的编码格式。

根据mysql建库时指定的字符集。

<wbr></wbr>

2.驱动程序要选择合适的版本，并且放置到应用的/WEB-INF/lib下即可。

<wbr></wbr>

3.选择合适的连接池。

如果使用tomcat作为web容器，则不推荐使用DBCP。

目前我一般选择c3p0，具体配置需要参考网上的一些资料，其实这个东西的配置并不简单。

<wbr></wbr>

下面给出一个供参考的hibernate的配置文件：

<wbr></wbr>

Xml代码

<?xml version='1.0' encoding='UTF-8'?><wbr><wbr><br> <!DOCTYPE hibernate-configuration PUBLIC<wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> "-//Hibernate/Hibernate Configuration DTD 3.0//EN"<wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr> "<a href="http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><span style="color:#765f47">http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd</span></a>"><wbr><wbr><br><wbr><br> <wbr><wbr><br> <hibernate-configuration><wbr><wbr><br><wbr><br><wbr><wbr><wbr> <session-factory><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <property name="connection.username">root</property><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <property name="connection.url">jdbc:mysql://127.0.0.1:3306/zc_info_manage</property><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <property name="connection.useUnicode">true</property><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <property name="connection.characterEncoding">GBK</property><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <property name="show_sql">true</property><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <property name="dialect">org.hibernate.dialect.MySQLDialect</property><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <property name="connection.driver_class">com.mysql.jdbc.Driver</property><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <property name="jdbc.fetch_size">50</property><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <property name="jdbc.batch_size">30</property><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <property name="hibernate.connection.provider_class"><wbr><wbr><br><wbr><wbr><wbr> org.hibernate.connection.C3P0ConnectionProvider<wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> </property><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <property name="c3p0.min_size">10</property><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <property name="c3p0.max_size">50</property><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <property name="c3p0.timeout">300</property><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <property name="c3p0.max_statements">0</property><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr> <property name="hibernate.c3p0.acquire_increment">0</property><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

评论

被折叠的条评论为什么被折叠?

到【灌水乐园】发言

查看更多评论

添加红包

成就一亿技术人!

hope_wisdom

发出的红包

实付元

使用余额支付

点击重新获取

扫码支付

钱包余额 0

抵扣说明：

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