Spring - 13 持久层使用dao支持类 JdbcDaoSupport

现在可以通过持久层继承jdbcDaoSupport简化开发，该父类可以根据连接池自动创建JdbcTemplate对象。省去了大部分操作

 

	private JdbcTemplate jdbcTemplate;


	/**
	 * Set the JDBC DataSource to be used by this DAO.
	 */
	public final void setDataSource(DataSource dataSource) {
		if (this.jdbcTemplate == null || dataSource != this.jdbcTemplate.getDataSource()) {
			this.jdbcTemplate = createJdbcTemplate(dataSource);
			initTemplateConfig();
		}
	}

 

配置文件

<?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">
	
	<!-- 配置datasource C3P0 属性name值与JDBC不同需要注意-->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    	<property name="driverClass" value="com.mysql.jdbc.Driver"/>
    	<property name="jdbcUrl" value="jdbc:mysql:///spring_day03"/>
    	<property name="user" value="root"/>
    	<property name="password" value="Aa123456"/>
    </bean>
	
	<!-- 注入dataSource，持久层继承jdbcdaosupport，这里只传连接池就可以 -->
	<bean id="accountDao" class="demo1.AccountDaoImpl">
		<property name="dataSource" ref="dataSource"></property>
	</bean>
	
	<!-- 注入dao -->
	<bean id="accountService" class="demo1.AccountServiceImpl">
		<property name="accountDao" ref="accountDao"/>
	</bean>
	
	
	
</beans>

 

dao

package demo1;

import org.springframework.jdbc.core.support.JdbcDaoSupport;

/**
 * 	继承JdbcDaoSupport可直接使用父类的getJdbcTemplate方法获得jdbc模板执行增删改查操作
 * @author Administrator
 *
 */
public class AccountDaoImpl extends JdbcDaoSupport implements AccountDao {

	@Override
	public void demo() {
		System.out.println("running dao demo");
		
	}
}