配制Spring事务和JdbcTemplate使用
配制一个applicationContext.xml如下www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
<? xml version = " 1.0 "encoding = " UTF-8 " ?>
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
<! DOCTYPE beans PUBLIC" -//SPRING//DTD BEAN//EN " " http://www.springframework.org/dtd/spring-beans.dtd " >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< beansdefault - autowire = " autodetect " >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< importresource = " classpath:conf/spring/demo.xml " />
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< bean id = " DataSource " class = " org.apache.commons.dbcp.BasicDataSource " >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< property name = " driverClassName " >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< value > com.mysql.jdbc.Driver </ value >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
</ property >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< property name = " url " >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< value > jdbc:mysql: // 192.168.1.10:3306/test?characterEncoding=UTF-8&amp;characterSetResults=UTF-8</value>
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
</ property >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< property name = " username " >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< value > root </ value >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
</ property >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< property name = " password " >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< value > xx </ value >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
</ property >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< property name = " maxActive " >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< value > 10 </ value >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
</ property >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< property name = " maxIdle " >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< value > 2 </ value >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
</ property >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
</ bean >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< bean id = " TransactionManager "
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
class = " org.springframework.jdbc.datasource.DataSourceTransactionManager " >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< property name = " dataSource " >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< ref bean = " DataSource " />
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
</ property >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
</ bean >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< bean id = " JdbcTemplate "
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
class = " org.springframework.jdbc.core.JdbcTemplate " >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< property name = " dataSource " >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
< ref bean = " DataSource " />
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
</ property >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
</ bean >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
</ beans >
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
对应的TestDaoImpl中加入这部分代码
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
privateJdbcTemplate jdbcTemplate;
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123998477802.gif
www.ad119.cn/bbs/attachments/basic/20081230/200812301112404677803.gif
publicJdbcTemplate getJdbcTemplate()
www.ad119.cn/bbs/attachments/basic/20081230/200812301112409377804.gif
{
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124014077805.gif
returnjdbcTemplate;
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124018777806.gif
}
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123998477802.gif
www.ad119.cn/bbs/attachments/basic/20081230/200812301112404677803.gif
public voidsetJdbcTemplate(JdbcTemplate jdbcTemplate)
www.ad119.cn/bbs/attachments/basic/20081230/200812301112409377804.gif
{
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124014077805.gif
this .jdbcTemplate=jdbcTemplate;
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124018777806.gif
}
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
// 插入,修改和删除类似
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
String sql1= " insert into testdb1 values('1','2') " ;
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
jdbcTemplate.update(sql1);
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
// 查询
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123998477802.gif
www.ad119.cn/bbs/attachments/basic/20081230/200812301112404677803.gif
private classBeanRowMapperimplementsRowMapper
www.ad119.cn/bbs/attachments/basic/20081230/200812301112409377804.gif
{
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124023477807.gif
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124028177808.gif
publicObject mapRow(ResultSet rs,introwNum)throwsSQLException
www.ad119.cn/bbs/attachments/basic/20081230/200812301112409377804.gif
{
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124014077805.gif
String id=rs.getString( " ID " );
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124014077805.gif
String title=rs.getString( " TITLE " );
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124014077805.gif
Bean bean= newBean(id,title);
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124014077805.gif
returnbean;
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124032877809.gif
}
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124018777806.gif
}
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
String sql1= " select *from testdb1" ;
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
List list=jdbcTemplate.query(sql1,newBeanRowMapper());
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123979677801.gif
// call back (回调)
www.ad119.cn/bbs/attachments/basic/20081230/2008123011123998477802.gif
www.ad119.cn/bbs/attachments/basic/20081230/200812301112404677803.gif
jt.execute( newConnectionCallback()
www.ad119.cn/bbs/attachments/basic/20081230/200812301112409377804.gif
{
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124023477807.gif
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124028177808.gif
publicObject doInConnection(java.sql.Connection con)throwsSQLException, DataAccessException
www.ad119.cn/bbs/attachments/basic/20081230/200812301112409377804.gif
{
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124014077805.gif
return null ;
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124032877809.gif
}
www.ad119.cn/bbs/attachments/basic/20081230/2008123011124018777806.gif
} );
页:
[1]