Maven+Hibernate4.3.5+c3p0配置

最新推荐文章于 2025-05-11 08:20:15 发布

原创最新推荐文章于 2025-05-11 08:20:15 发布 · 4.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#maven #c3p0 #hibernate4.3.5

游戏服务器专栏收录该内容

4 篇文章

订阅专栏

本文档详细介绍了如何在Maven项目中配置Hibernate4.3.5，并结合c3p0实现数据库连接池。通过新建Maven项目，调整pom.xml文件依赖，配置hibernate核心文件和c3p0连接池参数，以提升数据库操作的效率和管理。

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

首先新建Maven项目，pom.xml配置为

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>

	<groupId>com.jinzhe</groupId>
	<artifactId>jinzhe</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

	<name>jinzhe</name>
	<url>http://maven.apache.org</url>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
	</properties>

	<dependencies>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>3.8.1</version>
			<scope>test</scope>
		</dependency>
		<dependency>
			<groupId>c3p0</groupId>
			<artifactId>c3p0</artifactId>
			<version>0.9.1.2</version>
		</dependency>
		<dependency>
			<groupId>ch.qos.logback</groupId>
			<artifactId>logback-classic</artifactId>
			<version>1.0.11</version>
		</dependency>
		<!-- hibernate 4.3.0 start -->
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-core</artifactId>
			<version>4.3.5.Final</version>
		</dependency>
		<dependency>
			<groupId>org.hibernate.javax.persistence</groupId>
			<artifactId>hibernate-jpa-2.1-api</artifactId>
			<version>1.0.0.Final</version>
		</dependency>
		<dependency>
			<groupId>org.hibernate.common</groupId>
			<artifactId>hibernate-commons-annotations</artifactId>
			<version>4.0.4.Final</version>
		</dependency>
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-c3p0</artifactId>
			<version>4.3.5.Final</version>
		</dependency>
		<!-- hibernate 4.3.0 end -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.26-bin</version>
		</dependency>
	</dependencies>
</project>

hibernate配置为：

<!DOCTYPE hibernate-configuration PUBLIC  
    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"  
    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
	<session-factory>
		<!-- 方言：为每种数据库提供适配器，方便转换 -->
		<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
		<property name="connection.url">jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=gb2312</property>
		<property name="connection.username">root</property>
		<property name="connection.password">123</property>
		
		<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
		<property name="hibernate.c3p0.max_size">1</property>
		<property name="hibernate.c3p0.min_size">1</property>
		<!-- 获得连接的超时时间,如果超过这个时间,会抛出异常，单位毫秒 -->
		<property name="hibernate.c3p0.timeout">120</property>
		<!-- 最大的PreparedStatement的数量 --> 
		<property name="hibernate.c3p0.max_statements">100</property>
		<!-- 每隔120秒检查连接池里的空闲连接 ，单位是秒--> 
		<property name="hibernate.c3p0.idle_test_period">120</property>
		<!-- 当连接池里面的连接用完的时候，C3P0一下获取的新的连接数 -->
		<property name="hibernate.c3p0.acquire_increment">1</property>
		
		<!--是否在后台显示Hibernate用到的SQL语句，开发时设置为true，便于差错，程序运行时可以在Eclipse的控制台显示Hibernate的执行Sql语句。
		项目部署后可以设置为false，提高运行效率-->
		<property name="show_sql">true</property>
        <!-- 使显示的sql格式化 -->
        <property name="format_sql">true</property>
        
		<mapping resource="com/jinzhe/project/server/bean/Users.hbm.xml"/>
		
	</session-factory>
</hibernate-configuration>

然后hibernate

confuguration = new Configuration().configure();
			StandardServiceRegistryBuilder builder = new StandardServiceRegistryBuilder().applySettings(confuguration.getProperties());
			StandardServiceRegistry sr = builder.build();
			sessionFactory = confuguration.buildSessionFactory(sr);

调用的测试代码：

public static void main(String[] args){
		System.out.println("11111111");
		Users user = new Users();
		user.setName("dddd");
		user.setAge(12);
		Session s = HibernateService.getSession();
		Transaction tx = s.beginTransaction();
		s.save(user);
		tx.commit();
		s.close();
	}