Hibernate整合连接池

来源：互联网发布：小程序 post php接收编辑：程序博客网时间：2024/06/11 17:06

整合c3p0(连接池)

整合c3p0：

步骤一：导入c3p0 jar包

步骤二：hibernate.cfg.xml 配置

hibernate.connection.provider_classorg.hibernate.connection.C3P0ConnectionProvider

c3p0具体配置参数：

###########################

### C3P0 Connection Pool###

###########################

#hibernate.c3p0.max_size 2

#hibernate.c3p0.min_size 2

#hibernate.c3p0.timeout 5000

#hibernate.c3p0.max_statements 100

#hibernate.c3p0.idle_test_period 3000

#hibernate.c3p0.acquire_increment 2

#hibernate.c3p0.validate false

配置：

<!--告诉Hibernate,我要使用C3p0连接池 hibernate.connection.provider_class org.hibernate.connection.C3P0ConnectionProvider --><property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property><!-- #hibernate.c3p0.max_size 2#hibernate.c3p0.min_size 2#hibernate.c3p0.timeout 5000#hibernate.c3p0.max_statements 100#hibernate.c3p0.idle_test_period 3000#hibernate.c3p0.acquire_increment 2#hibernate.c3p0.validate false --> <property name="hibernate.c3p0.max_size">5</property> <property name="hibernate.c3p0.min_size">2</property>

case：

package com.itheima.e_api;import java.util.List;import org.hibernate.Criteria;import org.hibernate.Query;import org.hibernate.Session;import org.hibernate.criterion.DetachedCriteria;import org.hibernate.criterion.Restrictions;import org.junit.Test;import com.itheima.domain.Customer;import com.itheima.utils.HibernateUtils;public class Demo {@Test//验证c3p0连接池public void fun1(){Session session = HibernateUtils.openSession();session.beginTransaction();//------------------------------------------------System.out.println(session);//------------------------------------------------session.getTransaction().commit();session.close(); // 游离状态}}

0 0