SPRING-JDBC多个数据源



SPRINGJDBC:

 

1、

<beanid="jdbcTemplate"class="org.springframework.jdbc.core.JdbcTemplate"lazy-init="true">

<propertyname="dataSource">

<refbean="dataSource" />

</property>

</bean>

 

2、

@Service

@Lazy(true)

public classSpringJdbcDbRunner extends AbstractDbRunner {

 

@Autowired

privateJdbcTemplate jdbcTemplate;

 

@Override

publiclong count(String sql, Object... values) throws DbRuntimeException {

if(StringUtils.isEmpty(sql))

thrownew DbRuntimeException(DbErrorCode.ARGUMENT_ILLEGAL,

"SQL不能为空！！！");

returnjdbcTemplate.queryForObject(sql, values, Long.class);

}

 

 

 

JDBC

 

1、

<beanid="dataSource"class="org.apache.commons.dbcp.BasicDat