、、、、、、、、、、、、、、、、、、
玩玩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!
后面再加数据库连接池加上去。。。