首先是配置文件
- 我这里使用yml配置文件
- 这里我配置了test1,test2两个数据源,如果想配置更多的数据源,可以继续加即可
application.yml:
spring:
datasource:
test1:
jdbc-url: jdbc:mysql://localhost:3306/test
username: root
password: root
driver-class-name: com.mysql.jdbc.Driver
test2:
jdbc-url: jdbc:mysql://localhost:3306/test2
username: root
password: root
driver-class-name: com.mysql.jdbc.Driver
myBatis多数据源配置文件
为每个数据源增加一个SpringBoot配置类
myBatis多数据源的原理是根据不同包,调用不同的数据源,所以只需要把mapper.java和mapper.xml(用注解,可不需要)建立在不同的package下,springboot会自动根据包实现数据源切换。
代码目录结构如下:
- test1数据源配置类DataSource1Config.java:
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import javax.sql.DataSource;
@Configuration //注册到springboot容器中
@MapperScan(basePackages = "com.multiDatasource.test1",sqlSessionFactoryRef = "test1SqlSessionFactory")
public class DataSource1Config {
/**
*
* @methodDesc: 功能描述:(配置test1数据源)
*/
@Bean(name = "test1DataSource")
@Primary
@ConfigurationProperties(prefix = "spring.datasource.test1")
public DataSource testDataSource() {
return DataSourceBuilder.create().build();
}
/**
*
* @methodDesc: 功能描述:(test1 sql会话工厂)
*/
@Bean(name = "test1SqlSessionFactory")
@Primary
public SqlSessionFactory testSqlSessionFactory(@Qualifier("test1DataSource") DataSource dataSource)
throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
// bean.setMapperLocations(
// new PathMatchingResourcePatternResolver().getResources("classpath:mybatis/mapper/test1/*.xml"));
return bean.getObject();
}
/**
*
* @methodDesc: 功能描述:(test1 事物管理)
*/
@Bean(name = "test1TransactionManager")
@Primary //主数据源
public DataSourceTransactionManager testTransactionManager(@Qualifier("test1DataSource") DataSource dataSource) {
return new DataSourceTransactionManager(dataSource);
}
@Bean(name = "test1SqlSessionTemplate")
public SqlSessionTemplate testSqlSessionTemplate(
@Qualifier("test1SqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
return new SqlSessionTemplate(sqlSessionFactory);
}
}
- test2数据源配置类DataSource2Config.java:
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import javax.sql.DataSource;
@Configuration //注册到springboot容器中
@MapperScan(basePackages = "com.multiDatasource.test2",sqlSessionFactoryRef = "test2SqlSessionFactory")
public class DataSource2Config {
/**
*
* @methodDesc: 功能描述:(配置test1数据源)
*/
@Bean(name = "test2DataSource")
@ConfigurationProperties(prefix = "spring.datasource.test2")
public DataSource testDataSource() {
return DataSourceBuilder.create().build();
}
/**
*
* @methodDesc: 功能描述:(test1 sql会话工厂)
*/
@Bean(name = "test2SqlSessionFactory")
public SqlSessionFactory testSqlSessionFactory(@Qualifier("test2DataSource") DataSource dataSource)
throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(dataSource);
// bean.setMapperLocations(
// new PathMatchingResourcePatternResolver().getResources("classpath:mybatis/mapper/test1/*.xml"));
return bean.getObject();
}
/**
*
* @methodDesc: 功能描述:(test1 事物管理)
*/
@Bean(name = "test2TransactionManager")
public DataSourceTransactionManager testTransactionManager(@Qualifier("test2DataSource") DataSource dataSource) {
return new DataSourceTransactionManager(dataSource);
}
@Bean(name = "test2SqlSessionTemplate")
public SqlSessionTemplate testSqlSessionTemplate(
@Qualifier("test2SqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
return new SqlSessionTemplate(sqlSessionFactory);
}
}
- 在test1包下建立test1数据源的mapper:
import com.multiDatasource.entity.User1;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
//mapper要在启动类中被扫描到才能使用
@Mapper
public interface User1Mapper {
@Select("SELECT * FROM user_table WHERE username = #{username}")
User1 findByName(@Param("username") String username);
@Insert("INSERT INTO USERS(id,username, password) VALUES(5,#{name}, #{pwd})")
int insert(@Param("name") String name, @Param("pwd") String pwd);
}
mapper文件
- 在test2包下建立test2数据源的mapper:
import com.multiDatasource.entity.User1;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
//mapper要在启动类中被扫描到才能使用
@Mapper
public interface User2Mapper {
@Select("SELECT * FROM user2 WHERE username = #{username}")
User1 findByName(@Param("username") String username);
@Insert("INSERT INTO USERS(id,username, password) VALUES(5,#{name}, #{pwd})")
int insert(@Param("name") String name, @Param("pwd") String pwd);
}
业务代码
其余service,controller,entity可在同一个package下,也可以分开,我这里都用写在同一个文件进行测试:
- UserService.java:
import com.multiDatasource.entity.User1;
import com.multiDatasource.test1.User1Mapper;
import com.multiDatasource.test2.User2Mapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class UserService {
@Autowired
private User1Mapper mapper1;
@Autowired
private User2Mapper mapper2;
public User1 getByMapper1(String name) {
User1 user = mapper1.findByName(name);
return user;
}
public User1 getByMapper2(String name) {
User1 user = mapper2.findByName(name);
return user;
}
}
- TestController.java:
import com.multiDatasource.entity.User1;
import com.multiDatasource.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
@RestController
@RequestMapping("/find")
public class TestController {
@Autowired
private UserService service;
@RequestMapping("/test1")
public String find1() {
User1 user = service.getByMapper1("张三");
return user.getPassword();
}
@RequestMapping("/test2")
public String find2() {
User1 user = service.getByMapper2("张三2");
return user.getPassword();
}
}
- User1.java:
import org.springframework.stereotype.Component;
@Component
public class User1 {
private String username;
private String password;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
- 项目启动类:
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
//标识为springboot启动类,必须是父路径,其他包路径必须是其子路径
@SpringBootApplication(scanBasePackages = {"com.multiDatasource"})
//@ComponentScan(basePackages = "com")
//@MapperScan("com.test1.mapper")//扫描mapper
public class DemoApplication {
public static void main(String[] args) {
SpringApplication.run(DemoApplication.class, args);
}
}
- 启动项目测试,url输入:http://localhost:8080/find/test1
测试数据源2,url输入:http://localhost:8080/find/test2
配置成功!