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

	<context:property-placeholder location="classpath:jdbc.properties" />
	<bean id="dateSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="${jdbc.driverClass}" />
		<property name="jdbcUrl" value="${jdbc.url}" />
		<property name="user" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
	</bean>

	<bean id="accoutService" class="cn.muke.spring.demo1.AccoutServiceImpl">
		<property name="accountDao" ref="accountDao"></property>
	</bean>

	<bean id="accountDao" class="cn.muke.spring.demo1.AccountDaoImpl">
		<property name="dataSource" ref="dataSource"></property>
	</bean>

</beans>

package cn.muke.spring.demo1;

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

public class AccountDaoImpl extends JdbcDaoSupport implements AccountDao {

	public void outMoney(String out, Double money) {
		String sql = "update account set money = money - ? where out = ?";
		this.getJdbcTemplate().update(sql, money, out);

	}

	public void inMoney(String in, Double money) {
		String sql = "update account set money = money + ? where in = ?";
		this.getJdbcTemplate().update(sql, money, in);

	}

}

package cn.muke.spring.demo1;

public class AccoutServiceImpl implements AccountService {

	private AccountDao accountDao;
	
	public void setAccountDao(AccountDao accountDao) {
		this.accountDao = accountDao;
	}


	public void transfer(String out, String in, Double money) {
		accountDao.outMoney("aaa", 200d);
		accountDao.inMoney("bbb", 200d);
	}

}

package cn.muke.spring.demo1;

import javax.annotation.Resource;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.junit.runners.BlockJUnit4ClassRunner;
import org.springframework.test.context.ContextConfiguration;

@RunWith(BlockJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext1.xml")
public class AccountTest {
	@Resource(name = "accoutService")
	private AccountService accoutService;
	
	@Test
	public void testDome(){
		accoutService.transfer("aaa", "bbb", 200d);
	}

}