Spring之JdbcTemplate实现封装

首先配置config.xml

	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName">
			<value>com.mysql.jdbc.Driver</value>
		</property>
		<property name="url">
			<value>jdbc:mysql://localhost:3306/mytest1</value>
		</property>
		<property name="username">
			<value>root</value>
		</property>
		<property name="password">
			<value>123</value>
		</property>
	</bean>
	
	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource">
			<ref bean="dataSource"/>
		</property>
	</bean>
	<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
		<property name="dataSource">
			<ref bean = "dataSource"/>
		</property>
	</bean>
	<bean id="helloDao" class="com.gc.action.HelloDao">
	
		<property name="jdbcTemplate">
			<ref bean="jdbcTemplate"/>
		</property>
		<property name="transactionManager">
			<ref bean = "transactionManager"/>
		</property>
		<property name="sql">
			<value>insert into tb1 values(101,'gf','nihao')</value>
		</property>
		
	</bean>
	

再是实现的helloDao类

package com.gc.action;

import javax.sql.DataSource;

import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.support.DefaultTransactionDefinition;
import org.springframework.transaction.support.TransactionCallback;
import org.springframework.transaction.support.TransactionTemplate;

public class HelloDao {
	//private DataSource dataSource;
	private JdbcTemplate jdbcTemplate;
	private PlatformTransactionManager transactionManager;
	private String sql;
	
public void setSql(String sql) {
		this.sql = sql;
	}


	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}

	public void setTransactionManager(PlatformTransactionManager transactionManager) {
		this.transactionManager = transactionManager;
	}


	public void create(String name){
		DefaultTransactionDefinition def = new DefaultTransactionDefinition();
		TransactionStatus status = transactionManager.getTransaction(def);
		try {

			jdbcTemplate.update(this.sql);
		} catch (DataAccessException ex) {
			transactionManager.rollback(status);
			throw ex;
		}finally{
			transactionManager.commit(status);
		}
		System.out.println("*************************");
	}
}

最后测试类：

package com.gc.test;



import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;

import com.gc.action.HelloDao;
import com.gc.impl.FinanceInterface;
import com.gc.impl.TimeBookInterface;


public class testExample {

	public static void main(String[] args) throws InstantiationException,IllegalAccessException,
	ClassNotFoundException{
		String path = "D:\\tianWorkPlace\\5_2\\WebContent\\config.xml";
		ApplicationContext actx = new FileSystemXmlApplicationContext(path);
//		FinanceInterface financeProxy = (FinanceInterface) actx.getBean("logProxy");
//		financeProxy.doCheck("李四");
		
		HelloDao hello = (HelloDao) actx.getBean("helloDao");
		//timeBookProxy.doCheck("zhang San");
		hello.create("zhang san");
	}

}