---

關於Spring的JdbcTemplate介紹

完整的XML配置

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:context="http://www.springframework.org/schema/context"
	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/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 ">
	<!-- 配置連線池物件 -->
	<bean id="pool" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="com.mysql.jdbc.Driver" />
		<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/mybase2" />
		<property name="user" value="root"/>
		<property name="password" value="Hudie"/>
	</bean>
	<!-- 配置JdbcTemplate模板物件 -->	
	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource" ref="pool"></property>
	</bean>
</beans>

(1)編寫Spring配置檔案

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
	xmlns:aop="http://www.springframework.org/schema/aop"

</beans>

(2)配置資料來源

這裡使用的連線池是c3p0

	<!-- 配置連線池物件 -->
	<bean id="pool" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="com.mysql.jdbc.Driver" />
		<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/mybase2" />
		<property name="user" value="root"/>
		<property name="password" value="Hudie"/>
	</bean>

(3)配置JdbcTemplate模板物件

	<!-- 配置JdbcTemplate模板物件 -->	
	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource" ref="pool"></property>
	</bean>

(4)測試Spring框架整合JdbcTemplate

	@Test
	public void testSpringJdbcTemplate(){
		ClassPathXmlApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
		JdbcTemplate jdbcTemplate = (JdbcTemplate) ac.getBean("jdbcTemplate");
		String sql ="INSERT INTO user values(NULL,?,?)";
		int result = jdbcTemplate.update(sql, "xx",23);
		System.out.println(result);
	}

列印結果如下，成功先資料庫中新增了記錄。