Spring Boot整合MyBatis连接Oracle数据库的步骤全纪录

<dependency>

  <groupid>org.mybatis.spring.boot</groupid>

  <artifactid>mybatis-spring-boot-starter</artifactid>

  <version> 1.3 . 2 </version>

</dependency>

<dependency>

  <groupid>com.oracle</groupid>

  <artifactid>ojdbc6</artifactid>

  <version> 11.2 . 0.1 . 0 </version>

</dependency>

#spring.datasource.driver- class -name=com.mysql.jdbc.driver

#spring.datasource.url=jdbc:mysql: //localhost:3306/ems

#spring.datasource.username=root

#spring.datasource.password=root

mybatis.mapper-locations=classpath:/com/example/demo/mapper/*.xml

server.port= 9090

spring.datasource.driver- class -name=oracle.jdbc.driver.oracledriver

spring.datasource.url=jdbc:oracle:thin: @134 .32. 9.247 : 1700 /mbss

spring.datasource.username=dbrtadm

spring.datasource.password=dbrtadm

package com.example.demo.entity;

import lombok.getter;

import lombok.setter;

@getter

@setter

public class user {

  public int id;

  public string order_id;

}

<?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= "com.example.demo.dao.usermapper" >

  <select id = "listuser" resulttype= "com.example.demo.entity.user" >

   select * from t_ps_order_qr

  </select>

</mapper>

package com.example.demo.dao;

import java.util.list;

import org.apache.ibatis.annotations.mapper;

@mapper

public interface usermapper {

  public list listuser();

}

package com.example.demo.controller;

import java.util.list;

import javax.annotation.resource;

import org.springframework.beans.factory.annotation.autowired;

import org.springframework.web.bind.annotation.getmapping;

import org.springframework.web.bind.annotation.restcontroller;

import com.example.demo.dao.usermapper;

@restcontroller

public class testcontroller {

  @resource

  usermapper um;

  @getmapping ( "/listu" )

  public list listuser() {

   return um.listuser();

  }

}