配制一个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&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 ;
}
} );
配制Spring事务和JdbcTemplate使用
关注图老师设计创意栏目可以让大家能更好的了解电脑,知道有关于电脑的更多有趣教程,今天给大家分享配制Spring事务和JdbcTemplate使用教程,希望对大家能有一点小小的帮助。