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

前言

本文主要分享了spring boot整合mybatis连接oracle数据库的相关内容，下面话不多说了，直接来详细的步骤吧。

步骤如下：

1、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>

2、配置application.properties：

				?

									#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

3、新建实体类，注意与数据库字段对应：

				?

									package com.example.demo.entity;

									import lombok.getter;

									import lombok.setter;

									@getter

									@setter

									public class user {

									 public int id;

									 public string order_id;

									}

4、新建mapper（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="com.example.demo.dao.usermapper"> 

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

									  select * from t_ps_order_qr

									 </select>

									</mapper>

5、新建dao接口：

				?

									package com.example.demo.dao;

									import java.util.list;

									import org.apache.ibatis.annotations.mapper;

									@mapper

									public interface usermapper {

									 public list listuser();

									}

　此处应加@mapper注解，interface的方法名对应xml的标签id。

6、新建controller：

				?

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

									 }

									}