spring配置c3p0连接池

spring配置c3p0连接池

Spring 配置连接池和dao使用jdbcTemplate

   1 spring配置c3p0连接池

      第一步  导入jar包

      

      第二步  创建spring配置文件，配置连接池

      （1）把代码在文件配置中进行配置

       

  

 2 dao使用jdbcTemplate
     （1）创建service和dao，配置service和dao对象，在service注入dao对象

    
具体代码：  演示一遍c3p0添加数据操作

bean3.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:aop="http://www.springframework.org/schema/aop" xsi:schemaLocation="
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd"> <!-- bean definitions here -->
	
	<!-- 开启c3p0连接池操作 -->
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
	    <!-- 注入属性值 -->
	    <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
	    <property name="jdbcUrl" value="jdbc:mysql:///news"></property>
	    <property name="user" value="root"></property>
	    <property name="password" value="root"></property>
	</bean>
	<!-- 创建service和dao对象， 在service注入dao对象 -->
    <bean id="userService" class="com.cn.c3p0.UserService">
       <!-- 注入dao对象 -->
       <property name="userDao" ref="userDao"></property>
    </bean>
     <bean id="userDao" class="com.cn.c3p0.UserDao">
        <property name="jdbcTemplate" ref="jdbcTemplate"></property>
     </bean>
     <!-- 创建jdbcTemplate对象 -->
     <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
     </bean>
     
     
</beans>

UserDao.java

package com.cn.c3p0;

import org.springframework.jdbc.core.JdbcTemplate;

public class UserDao {
	private JdbcTemplate   jdbcTemplate;
	//得到JdbcTemplate对象
	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}
	//添加操作
	public void add() {
		// TODO Auto-generated method stub
		String  sql="insert into my value(?,?)";
		jdbcTemplate.update(sql, "张悦", "520");
	}

}

UserService.java

package com.cn.c3p0;

public class UserService {
	private UserDao  userDao;

	public void setUserDao(UserDao userDao) {
		this.userDao = userDao;
	}
	public void add(){
		userDao.add();
	}
	
}

TestService.java

package com.cn.c3p0;

import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class TestService {
	@Test
	public void testDemo(){
		ApplicationContext context=
				new ClassPathXmlApplicationContext("bean3.xml");
		UserService  service=(UserService) context.getBean("userService");
		service.add();
	}
}