可以在Spring Boot项目中同时
连接MySQL和
SQL Server
数据库，具体步骤如下：
1. 在pom.xml文件中添加
MySQL和
SQL Server
数据库的驱动依赖，例如：
```xml
<dependency>
<groupId>
mysql</groupId>
<artifactId>
mysql-connector-java</artifactId>
<version>${
mysql.version}</version>
</dependency>
<dependency>
<groupId>com.microsoft.
sqlserver</groupId>
<artifactId>ms
sql-jdbc</artifactId>
<version>${
sqlserver.version}</version>
</dependency>
```
2. 在application.yml文件中配置两个
数据源，例如：
```yaml
spring:
datasource:
primary:
url: jdbc:
mysql://localhost:3306/db_
mysql
driver-class-name: com.
mysql.cj.jdbc.Driver
username: root
password: 123456
secondary:
url: jdbc:
sqlserver://localhost:1433;databaseName=db_
sqlserver
driver-class-name: com.microsoft.
sqlserver.jdbc.
SQLServerDriver
username: sa
password: 123456
```
3. 在Spring Boot项目中配置两个
数据源，例如：
```java
@Configuration
public class DataSourceConfig {
@Bean(name = "primaryDataSource")
@Qualifier("primaryDataSource")
@ConfigurationProperties(prefix = "spring.datasource.primary")
public DataSource primaryDataSource() {
return DataSourceBuilder.create().build();
}
@Bean(name = "secondaryDataSource")
@Qualifier("secondaryDataSource")
@ConfigurationProperties(prefix = "spring.datasource.secondary")
public DataSource secondaryDataSource() {
return DataSourceBuilder.create().build();
}
}
```
4. 在MyBatis中配置两个
数据源，并指定使用哪个
数据源，例如：
```java
@Configuration
@MapperScan(basePackages = "com.example.mapper",
sqlSessionTemplateRef = "primary
SqlSessionTemplate")
public class MybatisConfig {
@Bean(name = "primary
SqlSessionFactory")
@Primary
public
SqlSessionFactory primary
SqlSessionFactory(@Qualifier("primaryDataSource") DataSource dataSource) throws Exception {
SqlSessionFactoryBean bean = new
SqlSessionFactoryBean();
bean.setDataSource(dataSource);
return bean.getObject();
}
@Bean(name = "secondary
SqlSessionFactory")
public
SqlSessionFactory secondary
SqlSessionFactory(@Qualifier("secondaryDataSource") DataSource dataSource) throws Exception {
SqlSessionFactoryBean bean = new
SqlSessionFactoryBean();
bean.setDataSource(dataSource);
return bean.getObject();
}
@Bean(name = "primary
SqlSessionTemplate")
@Primary
public
SqlSessionTemplate primary
SqlSessionTemplate(@Qualifier("primary
SqlSessionFactory")
SqlSessionFactory
sqlSessionFactory) throws Exception {
return new
SqlSessionTemplate(
sqlSessionFactory);
}
@Bean(name = "secondary
SqlSessionTemplate")
public
SqlSessionTemplate secondary
SqlSessionTemplate(@Qualifier("secondary
SqlSessionFactory")
SqlSessionFactory
sqlSessionFactory) throws Exception {
return new
SqlSessionTemplate(
sqlSessionFactory);
}
@Bean
@Primary
public PlatformTransactionManager primaryTransactionManager(@Qualifier("primaryDataSource") DataSource dataSource) {
return new DataSourceTransactionManager(dataSource);
}
@Bean
public PlatformTransactionManager secondaryTransactionManager(@Qualifier("secondaryDataSource") DataSource dataSource) {
return new DataSourceTransactionManager(dataSource);
}
}
```
在定义Mapper时，可以通过@Qualifier注解指定使用哪个
数据源的
SqlSessionTemplate，例如：
```java
public interface UserMapper {
@Select("SELECT * FROM user")
@Results({
@Result(property = "id", column = "id"),
@Result(property = "name", column = "name"),
@Result(property = "age", column = "age")
})
List<User> getAllUsers();
@Select("SELECT * FROM user WHERE id = #{id}")
@Results({
@Result(property = "id", column = "id"),
@Result(property = "name", column = "name"),
@Result(property = "age", column = "age")
})
User getUserById(@Param("id") Long id);
}
```
在Service层中，可以通过@Autowired注解注入UserMapper，并指定使用哪个
数据源的
SqlSessionTemplate，例如：
```java
@Service
public class UserService {
@Autowired
@Qualifier("primary
SqlSessionTemplate")
private
SqlSessionTemplate primary
SqlSessionTemplate;
@Autowired
@Qualifier("secondary
SqlSessionTemplate")
private
SqlSessionTemplate secondary
SqlSessionTemplate;
public List<User> getAllUsersFromPrimaryDataSource() {
UserMapper userMapper = primary
SqlSessionTemplate.getMapper(UserMapper.class);
return userMapper.getAllUsers();
}
public User getUserByIdFromSecondaryDataSource(Long id) {
UserMapper userMapper = secondary
SqlSessionTemplate.getMapper(UserMapper.class);
return userMapper.getUserById(id);
}
}
```
这样就可以在Spring Boot项目中同时
连接MySQL和
SQL Server
数据库了。
最低0.47元/天 解锁文章
206
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
