@Configuration
@MapperScan(
basePackages="com.*****.dal.casmapper",
sqlSessionFactoryRef="sqlSessionFactory1",
sqlSessionTemplateRef = "sqlSessionTemplate1")
public class CasDataSourceConfig {
@Bean("dataSource1")
public DataSource dataSource1()throws Exception{
Map<String, String> properties = new HashMap<>();
properties.put("driverClassName","com.mysql.jdbc.Driver");
properties.put("url","jdbc:mysql://********:3306/cas");
properties.put("username","****");
properties.put("password","*****");
DataSource dataSource = DruidDataSourceFactory.createDataSource(properties);
return dataSource;
}
@Bean("sqlSessionFactory1")
public SqlSessionFactory sqlSessionFactory1()throws Exception{
SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
sqlSessionFactoryBean.setDataSource(dataSource1());
sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:casmapper/*.xml"));
return sqlSessionFactoryBean.getObject();
}
@Bean("sqlSessionTemplate1")
public SqlSessionTemplate sqlSessionTemplate1()throws Exception{
SqlSessionTemplate sqlSessionTemplate = new SqlSessionTemplate(sqlSessionFactory1());
return sqlSessionTemplate;
}
}
注意:
根據(jù)@MapperScan中的basePackages配置mapper接口位置,根據(jù)sqlSessionFactoryRef 配置此數(shù)據(jù)源的sqlSessionFactory,根據(jù)sqlSessionTemplateRef 配置此數(shù)據(jù)源的sqlSessionTemplate,親測(cè)可用
