Springboot+mybatis+多数据源配置(图文详解!)
首先 注意一下目录结构
解读目录:红框 框起来的是必须的文件
resource资源文件下 放两个文件夹分别装 操控不同数据库的xml文件
controller层不需要变动
dao层 也就是 mapper接口层 创建两个不同的包 来对应上面两个 xml文件
创建datasource包来存放 两个数据源的配置文件 配置映射dao和mapper.xml的路径
service层 和实现类impl 不需要改变
vo实体类
run启动类
接下来直接上代码
yml
server:
tomcat:
uri-encoding:UTF-8
port: 8763
spring:
http:
encoding:
charset: UTF-8
force: true
enabled: true
max-file-size: 3MB
max-request-size: 100MB
application:
name: sportsSystem
# 主要是这里配置两个数据源 db1 和 db2
datasource:
db1:
url: jdbc:mysql://localhost:3306/clouddb01
username: root
password: root
driver-class-name: com.mysql.jdbc.Driver
db2:
url: jdbc:mysql://localhost:3306/clouddb02
username: root
password: root
driver-class-name: com.mysql.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
filters: stat
maxActive: 20
initialSize: 10
maxWait: 60000
minIdle: 10
timeBetweenEvictionRunsMillis: 60000
minEvictionRunsMillis: 300000
testWhileIdle: true
testOnBorrow: true
testOnReturn: false
poolPreparedStatements: true
maxOpenPreparedStatements: 20
mybatis:
mapperLocations: classpath:mapper/ *.xml
config-locations: classpath:mybatis/config.xml
run启动类
package com.rs;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.annotation.Configuration;
@SpringBootApplication
@Configuration
public class Run{
public static void main(String[] args) throws Exception {
SpringApplication.run(Run.class, args);
}
}
controller
package com.rs.controller;
import io.swagger.annotations.ApiOperation;
import java.util.ArrayList;
import java.util.Collections;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.CrossOrigin;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import springfox.documentation.annotations.ApiIgnore;
import com.rs.service.DeptService;
import com.rs.util.AddressUtil;
import com.rs.util.FileUpload;
import com.rs.vo.Dept;
@CrossOrigin
@Controller
/**
* 商家
* @author 12450
*
*/
public class DeptController {
Logger logger = LoggerFactory.getLogger(DeptController.class);
@Autowired
private DeptService deptService;
/**
* 查询所有商户信息
* @param user
* @return
*/
@ApiOperation(value="查询所有商户信息")
@RequestMapping(value = "/bisinessFandAll", method = RequestMethod.POST)
@ResponseBody
public Map<String,List<Dept>> bisinessFandAll(){
List<Dept> list= deptService.venueFindAll();
Map<String,List<Dept>> map=new HashMap<String,List<Dept>>();
map.put("business", list);
return map;
}
/**
* 查询所有商户信息
* @param user
* @return
*/
@ApiOperation(value="查询所有商户信息")
@RequestMapping(value = "/bisinessFandAll2", method = RequestMethod.POST)
@ResponseBody
public Map<String,List<Dept>> bisinessFandAll2(){
List<Dept> list= deptService.venueFindAll2();
Map<String,List<Dept>> map=new HashMap<String,List<Dept>>();
map.put("business", list);
return map;
}
}
service
package com.rs.service;
import java.util.List;
import java.util.Map;
import com.rs.vo.Dept;
public interface DeptService {
/**
* 查询所有场馆的名称
*/
List<Dept> venueFindAll();
/**
* 查询所有场馆的名称
*/
List<Dept> venueFindAll2();
}
impl
package com.rs.service.impl;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import com.rs.dao.DeptDao;
import com.rs.dao2.DeptDao2;
import com.rs.service.DeptService;
import com.rs.util.AddressUtil;
import com.rs.vo.Dept;
/**
* 商户业务实现类
* @author 82306
*
*/
@Service("businessService")
@Transactional
public class DeptServiceImpl implements DeptService {
//注入商家数据层
@Autowired
private DeptDao bisinessDao;
@Autowired
private DeptDao2 bisinessDao2;
@Override
public List<Dept> venueFindAll() {
List<Dept> deptlist = bisinessDao.bisinessFandAll();
for(int i = 0; i<=1 ; i++){
for (Dept dept : deptlist) {
bisinessDao2.addDept(dept);
}
}
return deptlist;
}
@Override
public List<Dept> venueFindAll2() {
// TODO Auto-generated method stub
List<Dept> deptlist = bisinessDao2.bisinessFandAll2();
return deptlist;
}
}
dao 两个dao包内的 class名字 最好要不同的
package com.rs.dao;
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import com.rs.vo.Dept;
@Mapper
public interface DeptDao {
List<Dept> bisinessFandAll();
}
dao2
package com.rs.dao2;
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import com.rs.vo.Dept;
@Mapper
public interface DeptDao2 {
List<Dept> bisinessFandAll2();
void addDept(Dept dept);
}
mapper
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.rs.dao.DeptDao">
<resultMap type="com.rs.vo.Dept" id="dept">
<id column="detid" property="detid"/>
<result column="dname" property="dname"/>
<result column="db_source" property="db_source"/>
</resultMap>
<select id="bisinessFandAll" resultMap="dept">
select * from dept
</select>
</mapper>
mapper2
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.rs.dao2.DeptDao2">
<resultMap type="com.rs.vo.Dept" id="dept">
<id column="detid" property="detid"/>
<result column="dname" property="dname"/>
<result column="db_source" property="db_source"/>
</resultMap>
<select id="bisinessFandAll2" resultMap="dept">
select * from dept
</select>
<insert id="addDept" parameterType="com.rs.vo.Dept">
insert into dept (dname,db_source) values (#{dname},#{db_source});
</insert>
</mapper>
pom 有很多 多余的jar 用到什么 请自行筛选
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.rs</groupId>
<artifactId>sports-system</artifactId>
<version>0.0.1-SNAPSHOT</version>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>1.5.4.RELEASE</version>
</parent>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<java.version>1.8</java.version>
<spring-cloud.version>Edgware.SR4</spring-cloud.version>
</properties>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<configuration>
<includeSystemScope>true</includeSystemScope>
</configuration>
</plugin>
</plugins>
</build>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>org.springframework.cloud</groupId>
<artifactId>spring-cloud-dependencies</artifactId>
<version>${spring-cloud.version}</version>
<type>pom</type>
<scope>import</scope>
</dependency>
</dependencies>
</dependencyManagement>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!-- 新添加的jar -->
<dependency>
<groupId>org.apache.directory.studio</groupId>
<artifactId>org.apache.commons.io</artifactId>
<version>2.1</version>
</dependency>
<dependency>
<groupId>dom4j</groupId>
<artifactId>dom4j</artifactId>
<version>1.6.1</version>
</dependency>
<dependency>
<groupId>org.jdom</groupId>
<artifactId>jdom</artifactId>
<version>1.1</version>
</dependency>
<!--微信授权 -->
<dependency>
<groupId>commons-beanutils</groupId>
<artifactId>commons-beanutils</artifactId>
<version>1.9.3</version>
</dependency>
<dependency>
<groupId>commons-collections</groupId>
<artifactId>commons-collections</artifactId>
<version>3.2.1</version>
</dependency>
<dependency>
<groupId>commons-lang</groupId>
<artifactId>commons-lang</artifactId>
<version>2.6</version>
</dependency>
<dependency>
<groupId>commons-logging</groupId>
<artifactId>commons-logging</artifactId>
<version>1.1.1</version>
</dependency>
<dependency>
<groupId>net.sf.ezmorph</groupId>
<artifactId>ezmorph</artifactId>
<version>1.0.6</version>
</dependency>
<dependency>
<groupId>net.sf.json-lib</groupId>
<artifactId>json-lib</artifactId>
<version>2.2.3</version>
<classifier>jdk15</classifier><!-- 指定jdk版本 -->
</dependency>
<!-- https://mvnrepository.com/artifact/dom4j/dom4j -->
<dependency>
<groupId>dom4j</groupId>
<artifactId>dom4j</artifactId>
<version>1.6.1</version>
</dependency>
<!-- 定位所需jar -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-core</artifactId>
<version>2.7.4</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.7.4</version>
</dependency>
<dependency>
<groupId>com.ning</groupId>
<artifactId>async-http-client</artifactId>
<version>1.8.7</version>
</dependency>
<!-- 阿里云短信验证 -->
<dependency>
<groupId>com.aliyun</groupId>
<artifactId>aliyun-java-sdk-core</artifactId>
<version>4.1.0</version>
</dependency>
<!-- 二维码生成 -->
<dependency>
<groupId>com.google.zxing</groupId>
<artifactId>core</artifactId>
<version>3.3.0</version>
</dependency>
<!--图片压缩 -->
<dependency>
<groupId>net.coobird</groupId>
<artifactId>thumbnailator</artifactId>
<version>0.4.8</version>
</dependency>
<!-- 数据库连接池 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.6</version>
</dependency>
<!-- swagger -->
<!-- https://mvnrepository.com/artifact/io.springfox/springfox-swagger2 -->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger2</artifactId>
<version>2.9.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/io.springfox/springfox-swagger-ui -->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger-ui</artifactId>
<version>2.9.2</version>
</dependency>
<dependency>
<groupId>com.google.guava</groupId>
<artifactId>guava</artifactId>
<version>25.1-jre</version>
</dependency>
<dependency>
<groupId>com.github.wxpay</groupId>
<artifactId>wxpay-sdk</artifactId>
<version>0.0.3</version>
</dependency>
<dependency>
<groupId>com.google.code.gson</groupId>
<artifactId>gson</artifactId>
<version>2.8.5</version>
</dependency>
<!-- 分页工具 -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
<!-- WX手机号解密 Josn包 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.60</version>
</dependency>
<!-- 输入法自带表情 转码 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>dubbo-common</artifactId>
<version>2.6.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-codec/commons-codec -->
<dependency>
<groupId>commons-codec</groupId>
<artifactId>commons-codec</artifactId>
<version>1.12</version>
</dependency>
</dependencies>
</project>
直接复制代码即可运行 ! 重点是 DataSource文件** 其次是 dao和mapper.xml需要分两个。其他无需修改。本人测试 两个数据库可以同时调用运行。