三、SpringBoot 整合mybatis 多数据源以及分库分表，初级java面试题大全

MyBatisConfigTwo 类

@Configuration

@MapperScan(basePackages = “com.quellan.zlflovemm.dao.mapper2”,sqlSessionFactoryRef = “sqlSessionFactory2”,sqlSessionTemplateRef = “sqlSessionTemplate2”)

public class MyBatisConfigTwo {

@Resource(name = “dbTwo”)

DataSource dbTwo;

@Bean

SqlSessionFactory sqlSessionFactory2()throws Exception {

SqlSessionFactoryBean bean = new SqlSessionFactoryBean();

bean.setDataSource(dbTwo);

return bean.getObject();

}

@Bean

SqlSessionTemplate sqlSessionTemplate2()throws Exception {

return new SqlSessionTemplate(sqlSessionFactory2());

}

}

注意连个文件的区别：

dao 层

---

在dao 层创建了两个包mapper1 和mapper2 .包里面的UserMapper类的内容是完全一样，放在不同的包中只是区分使用哪个数据源。和昨天是一样的。

public interface UserMapper {

@Select(“select id,username as userName,password,email,role_code as roleCode,gmt_create as gmtCreate,gmt_update as gmtUpdate,nickname as nickName,user_create as userCreate from sys_user”)

List findUserList();

@Insert({“insert into sys_user(username,password,email) values(’$user.$