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

 org.mybatis.spring.boot
 mybatis-spring-boot-starter
 1.3.2


 com.oracle
 ojdbc6
 11.2.0.1.0

#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"?>

 
 
  select * from t_ps_order_qr
 

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();
 }
}