江西广告网

标题: 配制Spring事务和JdbcTemplate使用 [打印本页]

作者: 一寒 时间: 2008-12-30 11:14
标题: 配制Spring事务和JdbcTemplate使用
配制一个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 ;

}

} );

欢迎光临江西广告网 (http://bbs.jxadw.com/)