java鬼混笔记：springboot 6、springboot整合mybatis(支持多数源)

、、、、、、、、、、、、、、、、、、

玩玩springboot 整合mybatis，且支持多个数据源。

首先创建一个springboot web 项目，还是eclipse加插件好，创建出来的springboot项目比较全面。

注意：注意：注意：

想要程序扫描到@service或者@component之类的，相关的service类或controller类必须放在程序启动类的子包下，比如启动类：SbmApplication.java在cn.ywj包下，那么service获取controller类cn.ywj的子包下，比如cn.ywj.service等，，，不然没效果。。。

代码创建顺序：datasource-dao-service-controller

开始：

pom.xml

///<?xml version="1.0" encoding="UTF-8"?><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>cn.ywj</groupId><artifactId>sbm</artifactId><version>0.0.1-SNAPSHOT</version><packaging>war</packaging><name>sbm</name><description>Demo project for Spring Boot</description><parent><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-parent</artifactId><version>1.5.8.RELEASE</version><relativePath/></parent><properties><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding><java.version>1.8</java.version></properties><dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-tomcat</artifactId><scope>provided</scope></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-devtools</artifactId></dependency><dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>1.1.1</version></dependency>     <dependency>        <groupId>mysql</groupId>        <artifactId>mysql-connector-java</artifactId>    </dependency></dependencies><build><plugins><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId></plugin></plugins></build></project>///

编辑：application.properties(这里配置多个数据源)

#### 数据源Aspring.datasource.sysA.driverClassName = com.mysql.jdbc.Driverspring.datasource.sysA.url = jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8spring.datasource.sysA.username = rootspring.datasource.sysA.password = 123# 数据源Bspring.datasource.sysB.driverClassName = com.mysql.jdbc.Driverspring.datasource.sysB.url = jdbc:mysql://localhost:3306/test2?useUnicode=true&characterEncoding=utf-8spring.datasource.sysB.username = rootspring.datasource.sysB.password = 123###

创建两个数据源bean
DSSysA.java

///package cn.ywj.app.datasource;import javax.sql.DataSource;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.autoconfigure.jdbc.DataSourceBuilder;import org.springframework.boot.context.properties.ConfigurationProperties;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;import org.springframework.context.annotation.Primary;import org.springframework.jdbc.datasource.DataSourceTransactionManager;@Configuration// 扫描cn.ywj.app.mapper.a的mapper@MapperScan(basePackages = "cn.ywj.app.mapper.a", sqlSessionTemplateRef  = "sqlSessionTemplateA")public class DSSysA {@Bean(name = "dataSourceA")    @ConfigurationProperties(prefix = "spring.datasource.sysA")// 配置按application.properties中spring.datasource.sysA开关的为准@Primary // 配置一个默认的，不然启动项目报出出现多个DataSourcepublic DataSource dataSourceA() {return DataSourceBuilder.create().build();}@Bean(name = "sqlSessionFactoryA")    @Primary    public SqlSessionFactory sqlSessionFactoryA(@Qualifier("dataSourceA") DataSource dataSource) throws Exception {        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();        bean.setDataSource(dataSource);        return bean.getObject();    }@Bean(name = "transactionManagerA")    @Primary    public DataSourceTransactionManager transactionManagerA(@Qualifier("dataSourceA") DataSource dataSource) {        return new DataSourceTransactionManager(dataSource);    }@Bean(name = "sqlSessionTemplateA")    @Primary    public SqlSessionTemplate sqlSessionTemplateA(@Qualifier("sqlSessionFactoryA") SqlSessionFactory sqlSessionFactory) throws Exception {        return new SqlSessionTemplate(sqlSessionFactory);    }}///

DSSysB.java

///package cn.ywj.app.datasource;import javax.sql.DataSource;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.autoconfigure.jdbc.DataSourceBuilder;import org.springframework.boot.context.properties.ConfigurationProperties;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;import org.springframework.context.annotation.Primary;import org.springframework.jdbc.datasource.DataSourceTransactionManager;@Configuration// 扫描cn.ywj.app.mapper.b的mapper@MapperScan(basePackages = "cn.ywj.app.mapper.b", sqlSessionTemplateRef  = "sqlSessionTemplateB")public class DSSysB {@Bean(name = "dataSourceB")    @ConfigurationProperties(prefix = "spring.datasource.sysB")// 配置按application.properties中spring.datasource.sysA开关的为准public DataSource dataSourceB() {return DataSourceBuilder.create().build();}@Bean(name = "sqlSessionFactoryB")    public SqlSessionFactory sqlSessionFactoryB(@Qualifier("dataSourceB") DataSource dataSource) throws Exception {        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();        bean.setDataSource(dataSource);        return bean.getObject();    }@Bean(name = "transactionManagerB")    public DataSourceTransactionManager transactionManagerB(@Qualifier("dataSourceB") DataSource dataSource) {        return new DataSourceTransactionManager(dataSource);    }@Bean(name = "sqlSessionTemplateB")    public SqlSessionTemplate sqlSessionTemplateB(@Qualifier("sqlSessionFactoryB") SqlSessionFactory sqlSessionFactory) throws Exception {        return new SqlSessionTemplate(sqlSessionFactory);    }}///

接着创建entity
A.java

///package cn.ywj.app.entity.a;import java.io.Serializable;public class A implements Serializable {/** *  */private static final long serialVersionUID = -6710553326670371298L;private Long id;private String name;public Long getId() {return id;}public void setId(Long id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}}///

B.java

///package cn.ywj.app.entity.b;import java.io.Serializable;public class B implements Serializable {/** *  */private static final long serialVersionUID = 5698014106069164797L;private Long id;private String name;public Long getId() {return id;}public void setId(Long id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}}///

接着创建相关的DAOt和Mapper.xml

AMapper.java

///package cn.ywj.app.mapper.a;import cn.ywj.app.entity.a.A;public interface AMapper {/** * 根据id查询A * @param id id * @return */public A findById(Long id);}///

AMapper.xml

///<?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="cn.ywj.app.mapper.a.AMapper"><select id="findById" parameterType="java.lang.Long" resultType="cn.ywj.app.entity.a.A">SELECT*FROM Awhere id = #{id}</select></mapper>///

BMapper.java

///package cn.ywj.app.mapper.b;import cn.ywj.app.entity.b.B;public interface BMapper {/** * 根据id找到B * @param id id * @return */public B findById(Long id);}///

BMapper.xml

///<?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="cn.ywj.app.mapper.b.BMapper"><select id="findById" parameterType="java.lang.Long" resultType="cn.ywj.app.entity.b.B">SELECT*FROM Bwhere id = #{id}</select></mapper>///

接着创建Service层

AService.java

///package cn.ywj.app.service.a;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import org.springframework.transaction.annotation.Transactional;import cn.ywj.app.entity.a.A;import cn.ywj.app.mapper.a.AMapper;@Service@Transactionalpublic class AService {@Autowiredprivate AMapper aMapper;public A findById(Long id) {return aMapper.findById(id);}}///

BService.java

///package cn.ywj.app.service.b;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import org.springframework.transaction.annotation.Transactional;import cn.ywj.app.entity.b.B;import cn.ywj.app.mapper.b.BMapper;@Service@Transactionalpublic class BService {@Autowiredprivate BMapper bMapper;public B findById(Long id) {return bMapper.findById(id);}}///

接着创建controller

AController.java

///package cn.ywj.app.controller.a;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;import cn.ywj.app.service.a.AService;@RestControllerpublic class AController {@Autowiredprivate AService aService; @RequestMapping("/af.do")public Object findById(Long id) {return aService.findById(id);}}///

BController.java

///package cn.ywj.app.controller.b;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;import cn.ywj.app.service.b.BService;@RestControllerpublic class BController {@Autowiredprivate BService bService;@RequestMapping("/bf.do")public Object findById(Long id) {return bService.findById(id);}}///

OK，，，启动项目。。。打开浏览器
输入http://127.0.0.1:8080/af.do?id=1，返回{"id":1,"name":"uuu"}


输入http://127.0.0.1:8080/bf.do?id=1，返回{"id":1,"name":"uuu2"}

这两个数据都是不同数据里的数据来着的，OK！

后面再加数据库连接池加上去。。。