applicationContext.xml

1 
      2 
     
      17     18     
      19 20     
      
       21         
       22         
       23         
       24         
       25     
      26     27     
      
       28         
       29     
      30     31     
      
       32         
       33     
      34 35 
     

TestDaoImpl.java

package cn.byref.spring.demo;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.jdbc.core.support.JdbcDaoSupport;public class TestDaoImpl extends JdbcDaoSupport implements TestDao {    @Override    public void addAge(String userName, int age) {        JdbcTemplate tpl = this.getJdbcTemplate();        String sql = "update test set age = ? where username = ?";        int cnt = tpl.update(sql, new Object[] { age, userName});        System.out.println("effected = " + cnt);    }}

TestClass.java

package cn.byref.spring.demo;import javax.annotation.Resource;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.test.context.ContextConfiguration;import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;import com.mchange.v2.c3p0.ComboPooledDataSource;@RunWith(SpringJUnit4ClassRunner.class)@ContextConfiguration("classpath:applicationContext.xml")public class TestClass {        @Resource    private ComboPooledDataSource dataSource;        @Resource    private TestDao testDao;        @Resource     TestService testService;        @Test    public void test(){//        testDao.addAge("侠客", 1001);        testService.addAge("侠客", 110);    }}