SpringBoot项目连接oracle，mysql的配置，maven项目

首先创建一个maven的webapp项目，

1.编辑pom.xml

1.1.首先到继承springboot项目，导入

  <!--继承springboot的父项目-->
  <parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>1.5.6.RELEASE</version>
  </parent>

1.2.导入项目所需要的jar包的坐标

    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
      <scope>test</scope>
    </dependency>

      <!--引入springboot的web支持-->
      <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-web</artifactId>
      </dependency>

      <!-- 测试 -->
      <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-test</artifactId>
          <!-- 只在test测试里面运行 -->
          <scope>test</scope>
      </dependency>

      <!--引入springboot支持jsp页面-->
      <dependency>
          <groupId>jstl</groupId>
          <artifactId>jstl</artifactId>
          <version>1.2</version>
      </dependency>

      <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-starter-tomcat</artifactId>
      </dependency>

      <dependency>
          <groupId>org.apache.tomcat.embed</groupId>
          <artifactId>tomcat-embed-jasper</artifactId>
      </dependency>

      <!--引入mybatis-->
      <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis</artifactId>
          <version>3.2.8</version>
      </dependency>

      <!--引入dbcp的jar-->
      <dependency>
          <groupId>commons-dbcp</groupId>
          <artifactId>commons-dbcp</artifactId>
          <version>1.4</version>
      </dependency>

      <!--mybatis整合springBoot-->
      <dependency>
          <groupId>org.mybatis.spring.boot</groupId>
          <artifactId>mybatis-spring-boot-starter</artifactId>
          <version>1.0.0</version>
      </dependency>

      <!--实体类注解-->
      <dependency>
          <groupId>org.projectlombok</groupId>
          <artifactId>lombok</artifactId>
          <version>1.18.4</version>
          <scope>provided</scope>
      </dependency>

1.3. 如果使用的是mysql数据库再加入mysql的jar包

mysql:

    <!--引入mysqljar包-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.38</version>
    </dependency>

oracle：

这个jar包是自己手动导入到本地maven仓库

      <!-- oraclejar包 -->
      <dependency>
          <groupId>com.zcnoracle</groupId>
          <artifactId>ojdbc6</artifactId>
          <version>6.0</version>
      </dependency>

1.4. 引入springboot启动插件

      <plugins>
          <!--引入启动插件，springboot-->
          <plugin>
              <groupId>org.springframework.boot</groupId>
              <artifactId>spring-boot-maven-plugin</artifactId>
              <!--支持jsp只能使用1.4.2版本的插件-->
              <version>1.4.2.RELEASE</version>
          </plugin>

      </plugins>

2.编写一个springboot项目的入口类

package com.baizhi;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.baizhi.dao")  //扫描Dao所在的包
public class App{
    public static void main( String[] args ){
        SpringApplication.run(App.class,args);
    }
}

3.编写springboot配置

3.1连接oracle的配置:application.yaml

server:
  port: 8989   #修改端口号
  context-path: /springBoot
  jsp-servlet:
    init-parameters:
      development: true   #开启springboot中对jsp页面修改之后热部署
spring:
  datasource:     #指定数据源对象
    driver-class-name: oracle.jdbc.driver.OracleDriver
    type: org.apache.commons.dbcp.BasicDataSource
    url: jdbc:oracle:thin:@localhost:1521:xe
    username: hr
    password: hr
  mvc:
    view:     #告知springboot使用jsp视图模板
      prefix: /
      suffix: .jsp
mybatis:
  mapper-locations: com/baizhi/mapper/*Mapper.xml    #配置mapper文件位置，读取mapper文件
  type-aliases-package: com.baizhi.entity   #实体类起别名

3.2连接mysql的配置:application.yaml

server:
  port: 8989  #修改端口号
  context-path: /springBoot
  jsp-servlet:
    init-parameters:
      development: true #开启springboot中对jsp页面修改之后热部署
spring:
  profiles:
    active: prod  #告知springboot的主配置文件使用哪个配置文件
  mvc:
    view:
      prefix: /
      suffix: .jsp   #告知springboot使用jsp视图模板
  datasource:  #指定数据源对象
    type: org.apache.commons.dbcp.BasicDataSource
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/test
    username: root
    password: root
mybatis:   #告知springboot mapper文件所在位置  创建sqlSessionFactory
  mapper-locations: com/baizhi/mapper/*.xml    #配置mapper文件位置，读取mapper文件
  type-aliases-package: com.baizhi.entity    #实体类起别名

4.编写entity,dao,service,serviceImpl

5.写测试类测试

package com.baizhi;

import com.baizhi.dao.EmsDao;
import com.baizhi.entity.Emp;
import com.baizhi.entity.Ems;
import com.baizhi.service.EmsService;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import javax.annotation.Resource;
import java.util.List;

@RunWith(SpringRunner.class)
@SpringBootTest(classes = App.class)
public class testEms {

    @Resource
    private EmsDao emsDao;

    @Resource
    private EmsService emsService;

    @Test   //通过
    public void queryAll(){
        List<Ems> emss = emsDao.queryAll();
        for (Ems ems : emss) {
            System.out.println(ems);
        }
    }

    @Test   //通过
    public void queryAlls(){
        List<Ems> emss = emsService.queryAll();
        for (Ems ems : emss) {
            System.out.println(ems);
        }
    }
}