[color=red][size=large][b]获取配置的数据源[/b][/size][/color]
[size=large][color=blue][b]使用数据源[/b][/color][/size]
数据源VO
for(IDataSourceCfgVO sourceCfgVO:allDataSourceList){
if(!dataSourceMap.containsKey(sourceCfgVO.getCfgCode())){
/*
DriverManagerDataSource dataSource = new DriverManagerDataSource();
dataSource.setDriverClassName(sourceCfgVO.getDriverClass());
dataSource.setPassword(sourceCfgVO.getPasswd());
dataSource.setUrl(sourceCfgVO.getJdbcUrl());
dataSource.setUsername(sourceCfgVO.getUserName());
dataSourceMap.put(sourceCfgVO.getCfgCode(), dataSource);*/
BasicDataSource dataSource = new BasicDataSource();
dataSource.setDriverClassName(sourceCfgVO.getDriverClass());
dataSource.setMaxActive(sourceCfgVO.getMaxActive());
dataSource.setMaxIdle(sourceCfgVO.getMaxIdle());
dataSource.setMaxWait(sourceCfgVO.getMaxWait());
dataSource.setPassword(sourceCfgVO.getPasswd());
dataSource.setUrl(sourceCfgVO.getJdbcUrl());
dataSource.setUsername(sourceCfgVO.getUserName());
dataSource.setInitialSize(sourceCfgVO.getInitialSize());
dataSource.setPoolPreparedStatements(true);
dataSourceMap.put(sourceCfgVO.getCfgCode(), dataSource);
}
allDataSourceCfgMap.put(sourceCfgVO.getCfgCode(), sourceCfgVO);
}
[size=large][color=blue][b]使用数据源[/b][/color][/size]
JdbcTemplate newJdbcTemplate = getJdbcTemplate(dataSource);
return newJdbcTemplate.queryForList(sqlStr);
数据源VO
private java.lang.String id;
// fields
private java.lang.String cfgCode;
private java.lang.String cfgName;
private java.lang.String driverClass;
private java.lang.String jdbcUrl;
private java.lang.String userName;
private java.lang.String passwd;
private java.lang.String remark;
//最大激活链接数
private java.lang.Integer maxActive;
private java.lang.Integer maxIdle;
private java.lang.Integer maxWait;
private java.lang.Integer initialSize;