Spring4 JDBC模板的使用（内置的连接池/DBCP/C3P0）

1 创建web项目，并导入jar包（spring 4个 +数据库连接驱动1个 + jdbc模板 + 事务tx+【连接池jar】）暂时不添加使用AOP相应的包

2 创建数据库和表

create database spring4_day03;
use spring4_day03;
create table account(
	id int primary key auto_increment,
	name varchar(20),
	money double
);

3 编写测试类

public class JdbcDemo1 {
	@Test
	// jdbc模板的使用类似于Dbutils。
	public void demo1() {
		// 创建连接池
		// spring内置的连接池
		DriverManagerDataSource driverManagerDataSource = new DriverManagerDataSource();
		driverManagerDataSource.setDriverClassName("com.mysql.jdbc.Driver");
		driverManagerDataSource.setUrl("jdbc:mysql:///spring4_day03");
		driverManagerDataSource.setUsername("root");
		driverManagerDataSource.setPassword("123456");
		// 创建JDBC模板
		JdbcTemplate jdbcTemplate = new JdbcTemplate(driverManagerDataSource);
		
		// 保存
		jdbcTemplate.update("insert into account values(null,?,?)","cxk",10000d);

	}
}

4  加入spring进行IOC

<?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:context="http://www.springframework.org/schema/context"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
	http://www.springframework.org/schema/beans/spring-beans.xsd
	http://www.springframework.org/schema/context
	http://www.springframework.org/schema/context/spring-context.xsd
	http://www.springframework.org/schema/aop
	http://www.springframework.org/schema/aop/spring-aop.xsd
	http://www.springframework.org/schema/tx 
	http://www.springframework.org/schema/tx/spring-tx.xsd">

	<!-- 配置Spring的内置的连接池 -->
	<!-- <bean id="driverManagerDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 
		<property name="driverClassName" value="com.mysql.jdbc.Driver"></property> 
		<property name="url" value="jdbc:mysql:///spring4_day03"></property> <property 
		name="username" value="root"></property> <property name="password" value="123456"></property> 
		</bean> -->

	<!-- 配置DBCP连接池 (引入dbcp+pool jar) -->
	<!-- <bean id="driverManagerDataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
		<property name="url" value="jdbc:mysql:///spring4_day03"></property>
		<property name="username" value="root"></property>
		<property name="password" value="123456"></property>
	</bean> -->
	<!-- 配置C3P0连接池=c3p0 jar包 -->
	<bean id="driverManagerDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="com.mysql.jdbc.Driver"></property>
		<property name="jdbcUrl" value="jdbc:mysql:///spring4_day03"></property>
		<property name="user" value="root"></property>
		<property name="password" value="123456"></property>

	</bean>




	
	<!--配置Spring的JDBC模板  -->
	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
	<property name="dataSource" ref="driverManagerDataSource"></property>
	</bean>
</beans>

 

5 编写测试类验证

public class JdbcDemo2 {
	@Test
	public void demo2() {
		ApplicationContext applicationContext = new ClassPathXmlApplicationContext(
				"applicationContext.xml");
		JdbcTemplate jdbcTemplate = (JdbcTemplate) applicationContext
				.getBean("jdbcTemplate");
		jdbcTemplate.update("insert into account values(null,?,?)", "陈赫",
				100000d);
	}
}