配制一个applicationcontext.xml如下
<? xml version = " 1.0 "  encoding = " utf-8 " ?>
<! doctype beans public  " -//spring//dtd bean//en "   " http://www.springframework.org/dtd/spring-beans.dtd " >

< beans  default - autowire = " autodetect " >
     < import  resource = " classpath:conf/spring/demo.xml "   />
     < bean id = " datasource "   class = " org.apache.commons.dbcp.basicdatasource " >  
         < property name = " driverclassname " >  
             < value > com.mysql.jdbc.driver </ value >  
         </ property >  
         < property name = " url " >  
             < value > jdbc:mysql: // 192.168.1.10:3306/test?characterencoding=utf-8&amp;charactersetresults=utf-8</value>
         </ property >
         < property name = " username " >
             < value > root </ value >
         </ property >
         < property name = " password " >
             < value > xx </ value >
         </ property >
         < property name = " maxactive " >
             < value > 10 </ value >
         </ property >
         < property name = " maxidle " >
             < value > 2 </ 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 >
</ beans >
对应的testdaoimpl中加入这部分代码
     private  jdbctemplate jdbctemplate;
    
     public  jdbctemplate getjdbctemplate()  {
         return  jdbctemplate;
    }
     public   void  setjdbctemplate(jdbctemplate jdbctemplate)  {
         this .jdbctemplate  =  jdbctemplate;
    }
     // 插入,修改和删除类似
    string sql1  =   " insert into testdb1 values('1','2') " ;
    jdbctemplate.update(sql1);
     // 查询
     private   class  beanrowmapper  implements  rowmapper  {
         public  object maprow(resultset rs,  int  rownum)  throws  sqlexception  {
            string id  =  rs.getstring( " id " );
            string title  =  rs.getstring( " title " );
            bean bean  =   new  bean(id,title);
             return  bean;
        }
    }
    string sql1  =   " select *  from testdb1  " ;
    list list  =  jdbctemplate.query(sql1,  new  beanrowmapper());
     // call back    (回调)
    jt.execute( new  connectioncallback() {
         public  object doinconnection(java.sql.connection con)  throws  sqlexception, dataaccessexception  {
             return   null ;
        }
    } );