记录sprint boot 集成mybatis 注解，多数据源配置项目搭建，非常详细，只要按照步骤来，项目绝对能跑起来！！！

这里搭建的是maven多模块（父子项目）

创建父子项目参考上一篇文章（

自己记录下关于MAVEN创建多模块项目步骤（Eclipse）

）

地址：http://blog.csdn.net/u012903135/article/details/78366536

下面来说说 spring boot集成mybatis注解 相关配置

首先看看项目结构附图：

父：Export --> pom.xml

子：sw-export-excel -->pom.xml

接下来看父pom  文件中的相关配置，

<?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>com.sw.export</groupId><artifactId>Export</artifactId><version>0.0.1-SNAPSHOT</version><packaging>pom</packaging><name>Export</name><url>http://maven.apache.org</url><modules><module>sw-export-excel</module></modules><properties>  <!-- 这里将引入相关包的版本，进行统一配置管理 --><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><spring-boot-version>1.4.1.RELEASE</spring-boot-version><spring-version>4.3.3.RELEASE</spring-version><mybatis-spring-version>1.2.3</mybatis-spring-version><mybatis-version>3.3.0</mybatis-version><druid-version>1.0.14</druid-version><mybatis-spring-version>1.2.3</mybatis-spring-version><mysql-version>5.1.30</mysql-version><tomcat.embed.jasper.version>8.0.23</tomcat.embed.jasper.version><spring-boot-maven-plugin-version>1.3.5.RELEASE</spring-boot-maven-plugin-version><spring-boot-loaded-version>1.2.6.RELEASE</spring-boot-loaded-version><maven-war-plugin-version>2.6</maven-war-plugin-version><start-class>com.transport.oa.App</start-class><maven-war-plugin-version>2.6</maven-war-plugin-version><maven-compiler-plugin-version>3.2</maven-compiler-plugin-version><maven-resources-plugin-version>2.6</maven-resources-plugin-version><maven-source-plugin-version>2.2.1</maven-source-plugin-version></properties><dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId><version>${spring-boot-version}</version></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-actuator</artifactId><version>${spring-boot-version}</version></dependency><dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId><version>${druid-version}</version></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><version>${spring-boot-version}</version><scope>test</scope></dependency><dependency><groupId>dom4j</groupId><artifactId>dom4j</artifactId><version>1.6.1</version></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId><version>${spring-boot-version}</version></dependency><!-- <dependency> <groupId>org.springframework.security</groupId> <artifactId>spring-security-web</artifactId> <version>4.1.1.RELEASE</version> </dependency> <dependency> <groupId>org.springframework.security</groupId> <artifactId>spring-security-config</artifactId> <version>4.1.1.RELEASE</version> </dependency> --><!-- SPRING basic begin(一般不需要显式定义) --><dependency><groupId>org.springframework</groupId><artifactId>spring-core</artifactId><version>${spring-version}</version><!-- <exclusions> <exclusion> <groupId>commons-logging</groupId> <artifactId>commons-logging</artifactId> </exclusion> </exclusions> --></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-beans</artifactId><version>${spring-version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>${spring-version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-aop</artifactId><version>${spring-version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-tx</artifactId><version>${spring-version}</version></dependency><!-- email/scheduler/freemarker --><dependency><groupId>org.springframework</groupId><artifactId>spring-context-support</artifactId><version>${spring-version}</version></dependency><!-- SPRING basic end --><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>${spring-version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-context-support</artifactId><version>${spring-version}</version></dependency><dependency><groupId>com.thoughtworks.xstream</groupId><artifactId>xstream</artifactId><version>1.4.9</version></dependency><dependency><groupId>xpp3</groupId><artifactId>xpp3</artifactId><version>1.1.4c</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>${mysql-version}</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>${mybatis-version}</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>${mybatis-spring-version}</version></dependency><dependency><groupId>commons-beanutils</groupId><artifactId>commons-beanutils</artifactId><version>1.9.3</version></dependency><!-- https://mvnrepository.com/artifact/com.oracle/ojdbc6 --><dependency><groupId>com.oracle</groupId><artifactId>ojdbc6</artifactId><version>11.1.0.7.0</version></dependency><dependency><groupId>com.google.code.gson</groupId><artifactId>gson</artifactId><version>2.8.0</version></dependency></dependencies><!-- 构建设置 --><build><resources><resource><directory>src/main/resources/${profiles.active}</directory><filtering>true</filtering></resource><resource><directory>src/main/resources</directory><filtering>true</filtering><includes><include>*.properties</include></includes></resource></resources><!-- <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> <version>1.3.5.RELEASE</version> </plugin> </plugins> --><pluginManagement><plugins><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId><version>${spring-boot-maven-plugin-version}</version><configuration><executable>true</executable></configuration><executions><execution><goals><goal>repackage</goal></goals></execution></executions><dependencies><dependency><groupId>org.springframework</groupId><artifactId>springloaded</artifactId><version>${spring-boot-loaded-version}</version></dependency></dependencies></plugin><plugin><groupId>org.apache.maven.plugins</groupId><artifactId>maven-war-plugin</artifactId><version>${maven-war-plugin-version}</version><configuration><failOnMissingWebXml>false</failOnMissingWebXml></configuration></plugin></plugins></pluginManagement><plugins><plugin><groupId>org.apache.maven.plugins</groupId><artifactId>maven-compiler-plugin</artifactId><version>${maven-compiler-plugin-version}</version><configuration><source>1.8</source><target>1.8</target></configuration></plugin><plugin><groupId>org.apache.maven.plugins</groupId><artifactId>maven-resources-plugin</artifactId><version>${maven-resources-plugin-version}</version><configuration><encoding>utf-8</encoding></configuration></plugin><plugin><groupId>org.apache.maven.plugins</groupId><artifactId>maven-source-plugin</artifactId><version>${maven-source-plugin-version}</version><configuration><attach>true</attach></configuration><executions><execution><phase>compile</phase><goals><goal>jar</goal></goals></execution></executions></plugin></plugins></build></project>

父pom  中配置好了就再来配置 子项目 pom文件

<?xml version="1.0"?><projectxsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><modelVersion>4.0.0</modelVersion><parent><groupId>com.sw.export</groupId><artifactId>Export</artifactId><version>0.0.1-SNAPSHOT</version></parent><artifactId>sw-export-excel</artifactId><name>sw-export-excel</name><url>http://maven.apache.org</url><dependencies><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>3.8.1</version><scope>test</scope></dependency></dependencies><build><finalName>sw-export-excel</finalName><plugins><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId><version>${spring-boot-maven-plugin-version}</version></plugin><plugin><groupId>org.apache.maven.plugins</groupId><artifactId>maven-compiler-plugin</artifactId><version>3.5.1</version><configuration><source>1.8</source><target>1.8</target><encoding>UTF-8</encoding></configuration></plugin></plugins></build></project>

3: application.properties

 

mysql.datasource.url=jdbc:mysql://address:prot/DBNAME?useUnicode=true&characterEncoding=utf8mysql.datasource.username=****mysql.datasource.password=*****oracle.datasource.url=jdbc:oracle:thin:@address:port:orcloracle.datasource.username=***oracle.datasource.password=***# 这里是配置端口export.server.port=9090mysql.datasource.driverclass=com.mysql.jdbc.Driveroracle.datasource.driverclass=oracle.jdbc.driver.OracleDriver#配置日志路径logging.file=/var/log/oanc/logs/oa.log

4：开始java类 接口的编写

 mysql 连接 配置类

在包名：com.export.configuation下面 不多说，直接贴代码，

package com.export.configuation;import javax.sql.DataSource;import org.apache.ibatis.session.SqlSessionFactory;import org.mybatis.spring.SqlSessionFactoryBean;import org.mybatis.spring.annotation.MapperScan;import org.springframework.beans.factory.annotation.Value;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;import org.springframework.context.annotation.Primary;import com.alibaba.druid.pool.DruidDataSource;@Configuration@MapperScan(basePackages = "com.export.oa.mysql",sqlSessionFactoryRef="mysqlSqlSessionFactory")public class MysqlConfig {    @Value("${mysql.datasource.url}")    private String url;    @Value("${mysql.datasource.username}")    private String username;    @Value("${mysql.datasource.password}")    private String password;    @Value("${mysql.datasource.driverclass}")    private String driverclass;    @Primary    @Bean(name = "mysqldatasouce")    public DataSource dataSource() {        DruidDataSource datasource = new DruidDataSource();        datasource.setUrl(url);        datasource.setUsername(username);        datasource.setPassword(password);        datasource.setDriverClassName(driverclass);        datasource.setInitialSize(5);        datasource.setMinIdle(5);        datasource.setMaxActive(50);        datasource.setMaxWait(60000);        datasource.setTimeBetweenEvictionRunsMillis(60000);        datasource.setMinEvictableIdleTimeMillis(300000);        datasource.setValidationQuery("SELECT 'x'");        datasource.setTestWhileIdle(true);        datasource.setTestOnBorrow(false);        datasource.setTestOnReturn(false);        return datasource;    }    @Primary    @Bean(name = "mysqlSqlSessionFactory")    public SqlSessionFactory sqlSessionFactory() throws Exception {        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();        factoryBean.setDataSource(dataSource());        return factoryBean.getObject();    }}

oracle 连接配置类：

package com.export.configuation;import javax.sql.DataSource;import org.apache.ibatis.session.SqlSessionFactory;import org.mybatis.spring.SqlSessionFactoryBean;import org.mybatis.spring.annotation.MapperScan;import org.springframework.beans.factory.annotation.Value;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;import com.alibaba.druid.pool.DruidDataSource;@Configuration@MapperScan(basePackages="com.export.oa.oracle",sqlSessionFactoryRef="oracleSqlSessionFactory")public class OracleConfig {@Value("${oracle.datasource.url}")private String url;@Value("${oracle.datasource.username}")private String username;@Value("${oracle.datasource.password}")private String password;@Value("${oracle.datasource.driverclass}")private String driverclass;@Bean(name="oracledatasouce")    public DataSource dataSource() {        DruidDataSource datasource = new DruidDataSource();        datasource.setUrl(url);        datasource.setUsername(username);        datasource.setPassword(password);        datasource.setDriverClassName(driverclass);        datasource.setInitialSize(5);        datasource.setMinIdle(5);        datasource.setMaxActive(50);        datasource.setMaxWait(60000);        datasource.setTimeBetweenEvictionRunsMillis(60000);        datasource.setMinEvictableIdleTimeMillis(300000);//        datasource.setValidationQuery("SELECT 'x'");        datasource.setTestWhileIdle(true);        datasource.setTestOnBorrow(false);        datasource.setTestOnReturn(false);        return datasource;    }    @Bean(name = "oracleSqlSessionFactory")    public SqlSessionFactory sqlSessionFactory() throws Exception {        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();        factoryBean.setDataSource(dataSource());        return factoryBean.getObject();    }}

5：spring boot 入口main方法：

package com.export.oa;import org.springframework.beans.factory.annotation.Configurable;import org.springframework.beans.factory.annotation.Value;import org.springframework.boot.SpringApplication;import org.springframework.boot.autoconfigure.SpringBootApplication;import org.springframework.boot.builder.SpringApplicationBuilder;import org.springframework.boot.context.embedded.ConfigurableEmbeddedServletContainer;import org.springframework.boot.context.embedded.EmbeddedServletContainerCustomizer;import org.springframework.boot.context.web.SpringBootServletInitializer;import org.springframework.context.annotation.ComponentScan;import org.springframework.context.annotation.Configuration;@Configuration@Configurable@SpringBootApplication(scanBasePackages = {"com.export"})public class App extends SpringBootServletInitializer implements EmbeddedServletContainerCustomizer {    /** 启动端口号 */    @Value("${export.server.port}")    private int serverPort;    public static void main(String[] args) {        SpringApplication.run(App.class, args);    }    @Override    protected SpringApplicationBuilder configure(SpringApplicationBuilder application) {        return application.sources(App.class);    }    public void customize(ConfigurableEmbeddedServletContainer container) {        container.setPort(serverPort);    }}

6： 开始编写dao：

例子：

package com.export.oa.mysql.dao;import org.apache.ibatis.annotations.Insert;import org.apache.ibatis.annotations.Param;public interface UserSwDao {@Insert("INSERT INTO usersw(name,age) values(#{name},#{age})")public int save(@Param(value="name") String name,@Param(value="age") int age);}

简单的insert 插入一条数据的语句。

7：编写server接口和实现：

package com.export.oa.service;public interface IService {String testInsertUser();}

实现类：

package com.export.oa.service;import org.slf4j.Logger;import org.slf4j.LoggerFactory;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.export.oa.mysql.dao.UserSwDao;@Service("testService")public class TestService implements IService{private static Logger logger=LoggerFactory.getLogger(TestService.class);@Autowiredprivate UserSwDao userSwDao;@Overridepublic String testInsertUser() {logger.info("打印日志的地方******");userSwDao.save("SHIWEI", 28);return "SUCCESS";}}

7：控制层：

package com.export.oa.controller;import org.slf4j.Logger;import org.slf4j.LoggerFactory;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;import com.export.oa.service.TestService;@RestControllerpublic class TestController {private static Logger logger= LoggerFactory.getLogger(TestController.class);@AutowiredTestService testService;@RequestMapping("home")public String helloWorld(){return "helloworld";}@RequestMapping("testInsert")public String testInsert(){testService.testInsertUser();return "SUCCESS";}}

8：我这里没有写实体，你们后续需要的话可以编写实体类作为参数传入 进行增删改查即可！

9：开始run  App的main方法： 项目跑起来后，

 localhost:9090/属于你需要调用的控制层 配置的

@RequestMapping即可localhost:9090/home只为记录方便自己以后回忆！不喜勿喷

项目下载 地址 ：

http://download.csdn.net/download/u012903135/10109341