首先给类打上@Configuration注解,使项目启动时加载这个类,然后打上@MapperScan指定basePackages(你Mapper接口所在的位置)和sqlSessionFactoryRef
接下来就是去扫描你在application.properties里面配置的数据源,这里我用的是阿里的Druid
@ConfigurationProperties("spring.datasource")
@Primary
@Bean(name = "masterDataSource")
public DruidDataSource druidDataSource() {
return new DruidDataSource();
}
再创建事务管理
@Bean(name = "masterTransactionManager")
@Primary
public DataSourceTransactionManager masterTransactionManager() {
return new DataSourceTransactionManager(druidDataSource());
}
最后创建SqlFactory
@Bean(name = "masterSqlFactory")
@Primary
public SqlSessionFactory masterSqlSessionFactory(@Qualifier("masterDataSource") DataSource dataSource) throws Exception {
final SqlSessionFactoryBean sessionFactoryBean = new SqlSessionFactoryBean();
sessionFactoryBean.setDataSource(dataSource);
return sessionFactoryBean.getObject();
}
这样就配置好了,连接数据库开始你的工作吧!!