<? 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, 
DataAclearcase/" target="_blank" >ccessException   {

return   null ;

} 

} );