可以在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>mssql-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 = "primary
DataSource")
@Qualifier("primary
DataSource")
@ConfigurationProperties(prefix = "spring.
datasource.primary")
public
DataSource primary
DataSource() {
return
DataSourceBuilder.create().build();
}
@Bean(name = "secondary
DataSource")
@Qualifier("secondary
DataSource")
@ConfigurationProperties(prefix = "spring.
datasource.secondary")
public
DataSource secondary
DataSource() {
return
DataSourceBuilder.create().build();
}
}
```
4. 在
MyBatis中
配置两个
数据源，并指定使用哪个
数据源，例如：
```java
@Configuration
@MapperScan(basePackages = "com.example.mapper", sqlSessionTemplateRef = "primarySqlSessionTemplate")
public class
MybatisConfig {
@Bean(name = "primarySqlSessionFactory")
@Primary
public SqlSessionFactory primarySqlSessionFactory(@Qualifier("primary
DataSource")
DataSource dataSource) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.set
DataSource(
dataSource);
return bean.getObject();
}
@Bean(name = "secondarySqlSessionFactory")
public SqlSessionFactory secondarySqlSessionFactory(@Qualifier("secondary
DataSource")
DataSource dataSource) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.set
DataSource(
dataSource);
return bean.getObject();
}
@Bean(name = "primarySqlSessionTemplate")
@Primary
public SqlSessionTemplate primarySqlSessionTemplate(@Qualifier("primarySqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
return new SqlSessionTemplate(sqlSessionFactory);
}
@Bean(name = "secondarySqlSessionTemplate")
public SqlSessionTemplate secondarySqlSessionTemplate(@Qualifier("secondarySqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
return new SqlSessionTemplate(sqlSessionFactory);
}
@Bean
@Primary
public PlatformTransactionManager primaryTransactionManager(@Qualifier("primary
DataSource")
DataSource dataSource) {
return new
DataSourceTransactionManager(
dataSource);
}
@Bean
public PlatformTransactionManager secondaryTransactionManager(@Qualifier("secondary
DataSource")
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("primarySqlSessionTemplate")
private SqlSessionTemplate primarySqlSessionTemplate;
@Autowired
@Qualifier("secondarySqlSessionTemplate")
private SqlSessionTemplate secondarySqlSessionTemplate;
public List<User> getAllUsersFromPrimary
DataSource() {
UserMapper userMapper = primarySqlSessionTemplate.getMapper(UserMapper.class);
return userMapper.getAllUsers();
}
public User getUserByIdFromSecondary
DataSource(Long id) {
UserMapper userMapper = secondarySqlSessionTemplate.getMapper(UserMapper.class);
return userMapper.getUserById(id);
}
}
```
这样就可以在Spring Boot项目中同时连接
MySQL和SQL Server数据库了。
看到网上好多实例，都失败了，报扫描不到mapper文件，下面是我的完整实例1. pom文件的驱动jar包加上去，不说了2. application.yml spring:datasource: master: jdbc-url: jdbc:mysql://10.12.49.55:3306/smartcity-01 username: ro...
最低0.47元/天 解锁文章
571
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
