Spring Boot 集成Mybatis-蒲公英云

注：接上一篇Spring Tool Suite4搭建spring boot项目

1、把搭建好的Spring Boot项目中的application.properties改成application.yml同时配置本地***-dev.yml 文件，

application.yml中的配置如下：

server: 
  port: 8081
  servlet:
    context-path: /
spring: 
  profiles:
    active:
    - dev

application-dev.yml中的配置如下(主要是数据库连接配置和mybatis的xml扫描路径配置)：

spring: 
  datasource:
    druid:
      url: jdbc:oracle:thin:@IP地址:端口:服务名
      username: 用户名
      password: 密码
      driver-class-name: oracle.jdbc.OracleDriver
      maxWait: 10000
      initial-size: 10
      max-active: 30
      min-idle: 10
      validation-query: select 1 from dual
mybatis: 
  mapper-locations: classpath*:com/bj/loan/mapper/*.xml

2、需要在POM中引入oracle、spring druid、mybatis的相关jar包

<!-- mybatis -->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.2.0</version>
</dependency>
<!-- druid数据源 -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.2.6</version>
</dependency>
<!-- oracle数据驱动 -->
<dependency>
    <groupId>com.bijiangzb.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>1.0.0</version>
</dependency>

注意：ojdbc在Maven仓库中是不存在的可能会报红，直接在百度下载jar包上传到本地maven个人仓库中就行了。

3、在com.bj包下创建实体包entity、dao、mapper、service、controller已经在service包下创建impl业务实现包

创建实体对象：

package com.bj.loan.entity;
import java.io.Serializable;
/**
 * @author huxiangen
 * @date 2021-06-17 14:40:00
 * @description BIZ_ORDER
 * @version 1.0
 */
public class Order implements Serializable{
    private static final long serialVersionUID = -196857271193419843L;
    /**
     * @description 主键
     */
    private String orderId;
    /**
     * @description 客户名称
     */
    private String custName;
    /**
     * @description 主键
     * @return ORDER_ID 主键
     */
    public String getOrderId() {
        return orderId;
    }
    /**
     *@description 主键
     * @param orderId 主键
     */
    public void setOrderId(String orderId) {
        this.orderId = orderId == null ? null : orderId.trim();
    }
    /**
     * @description 客户名称
     * @return CUST_NAME 客户名称
     */
    public String getCustName() {
        return custName;
    }
    /**
     *@description 客户名称
     * @param custName 客户名称
     */
    public void setCustName(String custName) {
        this.custName = custName == null ? null : custName.trim();
    }
}

创建dao操作数据库：

package com.bj.loan.dao;
import com.bj.loan.entity.Order;
public interface OrderMapper {
    Order selectByPrimaryKey(String orderId);
}

创建mapper XML执行SQL

<?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.bj.loan.dao.OrderMapper">
  <resultMap id="BaseResultMap" type="com.bj.loan.entity.Order">
    <id column="ORDER_ID" jdbcType="VARCHAR" property="orderId" />
    <result column="CUST_NAME" jdbcType="VARCHAR" property="custName" />
  </resultMap>
  <sql id="Base_Column_List">
    ORDER_ID, CUST_NAME
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.String" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from BIZ_ORDER
    where ORDER_ID = #{orderId,jdbcType=VARCHAR}
  </select>
</mapper>

创建service接口类

package com.bj.loan.service;
import com.bj.loan.entity.Order;
public interface OrderService {
    Order findOrder(String orderId);
}

创建接口的实现类

package com.bj.loan.service.impl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.bj.loan.dao.OrderMapper;
import com.bj.loan.entity.Order;
import com.bj.loan.service.OrderService;
@Service
public class OrderServiceImpl implements OrderService {
    @Autowired
    private OrderMapper orderMapper;
    @Override
    public Order findOrder(String orderId) {
        return orderMapper.selectByPrimaryKey(orderId);
    }
}

在controller下创建控制层对外提供方法实现业务操作后返回结果

package com.bj.loan.controller;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
import com.bj.loan.entity.Order;
import com.bj.loan.service.OrderService;
@RestController
public class OrderController {
    @Autowired
    private OrderService orderService;
    @GetMapping("/order")
    public Order getOrder() {
        System.out.println("进入订单查询");
        Order order=orderService.findOrder("f51fe14d-843d-11ea-8a2e-f58d34ffebe3");
        System.out.println("order:"+order.toString());
        return order;
    }
}

然后在启动类增加dao包扫描 @MapperScan(“com.bj.loan.dao”)

package com.bj;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.web.servlet.support.SpringBootServletInitializer;
@SpringBootApplication(scanBasePackages = {"com.bj.loan"})
@MapperScan("com.bj.loan.dao")
public class SpringBootTestApplication extends SpringBootServletInitializer{
    public static void main(String[] args) {
        SpringApplication.run(SpringBootTestApplication.class, args);
    }
}

启动项目页面输入http://127.0.0.1:8081/order

页面：

后台：

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1eGlhbmdlbg_size_16_color_FFFFFF_t_70

至此集成mybatis结束，项目中使用到的数据库表及字段自行创建，上面mapper.xml中有映射关系；

项目下载地址：https://download.csdn.net/download/huxiangen/19699619

问题处理：Invalid bound statement (not found):

出现这个问题主要是我们打包的文件没有将resource下面的打包进去在maven中加入如下配置即可

<build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
        <!-- 新增配置 -->
        <resources>
            <resource>
                <directory>${project.basedir}/src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                    <include>**/*.yml</include>
                </includes>
                <!-- 是否替换资源中的属性 -->
                <filtering>false</filtering>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                    <include>**/*.yml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>
    </build>