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

最新推荐文章于 2022-11-30 20:41:21 发布

最新推荐文章于 2022-11-30 20:41:21 发布

阅读量1k

点赞数 1

分类专栏： SpringBoot 文章标签： springboot整合mybatis支

本文链接：https://blog.csdn.net/u013845177/article/details/78306029

版权

SpringBoot 专栏收录该内容

28 篇文章 1 订阅

订阅专栏

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

玩玩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(这里配置多个数据源)

###
# 数据源A
spring.datasource.sysA.driverClassName = com.mysql.jdbc.Driver
spring.datasource.sysA.url = jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8
spring.datasource.sysA.username = root
spring.datasource.sysA.password = 123

# 数据源B
spring.datasource.sysB.driverClassName = com.mysql.jdbc.Driver
spring.datasource.sysB.url = jdbc:mysql://localhost:3306/test2?useUnicode=true&characterEncoding=utf-8
spring.datasource.sysB.username = root
spring.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 // 配置一个默认的，不然启动项目报出出现多个DataSource
	public 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 A
		where 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 B
		where 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
@Transactional
public class AService {

	@Autowired
	private 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
@Transactional
public class BService {
	
	@Autowired
	private 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;

@RestController
public class AController {

	@Autowired
	private 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;

@RestController
public class BController {

	@Autowired
	private 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！

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