041.SpringBoot+Mybaits 整合开发实例

SpringBoot+Mybatis整合开发简单实例

1、Maven引用依赖：pom.xml

<properties>
        <java.version>14</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>4.0.1</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>
        <!--druid连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.2.3</version>
        </dependency>
        <!-- 热部署 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <!-- HTTP协议请求响应相关依赖-->
        <dependency>
            <groupId>org.apache.httpcomponents</groupId>
            <artifactId>httpcore</artifactId>
        </dependency>
        <dependency>
            <groupId>org.apache.httpcomponents</groupId>
            <artifactId>httpclient</artifactId>
        </dependency>
    </dependencies>

2、appliction项目配置：application.yml

#服务器相关配置
server:
  port: 8888  #访问端口号
  tomcat:
    uri-encoding: utf-8 #编码格式
  servlet:
    session:
      timeout: 30m  #session生命周期

#数据库相关配置
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    #配置数据库连接
    #连接docker容器内的mysql若url不加useSSL=false就报The driver has not received any packets from the server错误
    url: jdbc:mysql://127.0.0.1:3306/heyischool?useSSL=false
    username: root
    password: password
    #配置druid连接池
    type: com.alibaba.druid.pool.DruidDataSource
    druid:
      filters: wall #防御sql注入
      initialSize: 1  #初始化时建立物理连接的个数
      maxActive: 20   #最大连接池数量
      maxWait: 60000  #获取连接时最大等待时间
      minIdle: 1  #最小连接池数量
      timeBetweenEvictionRunsMillis: 60000  #检测连接的间隔时间
      minEvictableIdleTimeMillis: 300000  #最小可收回空闲时间毫秒
      validationQuery: select 'x' #检测连接是否是有效的sql
      testWhileIdle: true   #申请连接的时候检测，如果空闲时间大于timeBetweenEvictionRunsMillis，检测连接是否有效。
      testOnReturn: false   #归还连接时检测连接是否有效
      poolPreparedStatements: false  #是否缓存preparedStatement池
      maxOpenPreparedStatements: 20  #statement池能够同时分配的打开的statements的最大数量

3、创建model层表对应的实体类：

package com.faithsinan.test.model;

import java.sql.Date;

/**
 * Notices表对应实体类
 */
public class Notices {
    private Integer notice_id;
    private String notice_title;
    private String notice_content;
    private String notice_author;
    private Date notice_date;
    private Integer notice_readnumber;

    public Integer getNotice_id() {
        return notice_id;
    }

    public void setNotice_id(Integer notice_id) {
        this.notice_id = notice_id;
    }

    public String getNotice_title() {
        return notice_title;
    }

    public void setNotice_title(String notice_title) {
        this.notice_title = notice_title;
    }

    public String getNotice_content() {
        return notice_content;
    }

    public void setNotice_content(String notice_content) {
        this.notice_content = notice_content;
    }

    public String getNotice_author() {
        return notice_author;
    }

    public void setNotice_author(String notice_author) {
        this.notice_author = notice_author;
    }

    public Date getNotice_date() {
        return notice_date;
    }

    public void setNotice_date(Date notice_date) {
        this.notice_date = notice_date;
    }

    public Integer getNotice_readnumber() {
        return notice_readnumber;
    }

    public void setNotice_readnumber(Integer notice_readnumber) {
        this.notice_readnumber = notice_readnumber;
    }
}

4、创建Mapper层Notices表的SQL映射接口：

package com.faithsinan.test.mapper;

import com.faithsinan.test.model.Notices;
import org.apache.ibatis.annotations.Select;

/**
 * Notices表的SQL映射接口
 */
public interface NoticesMapper {
    /**
     * 根据id检索notices表的内容
     * @param notice_id 传递进来的id
     * @return 返回Notices实体类构造的对象
     */
    //若使用@Select注解，则无需配置NoticesMapper.xml映射文件
    @Select("select * from notices where notice_id = #{notice_id}")
    Notices selectNoticeById(Integer notice_id);
}

5、创建Service层Notices表的业务逻辑接口类：

package com.faithsinan.test.service;

import com.faithsinan.test.model.Notices;

/**
 * Notices表的业务逻辑接口
 */
public interface NoticesService {

    /**
     * 根据id检索notices表的内容的逻辑实现方法
     * @param notice_id 传递进来的id值
     * @return  检索结果按Notices实体类的构造返回一个对象
     */
    public Notices selectNoticeById(int notice_id);
}

6、创建Service层Notices表的业务逻辑实现类：

package com.faithsinan.test.service.impl;

import com.faithsinan.test.mapper.NoticesMapper;
import com.faithsinan.test.model.Notices;
import com.faithsinan.test.service.NoticesService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

/**
 * Notices表的业务逻辑实现类
 */
@Service
public class NoticesServiceImpl implements NoticesService {
    @Resource
    private NoticesMapper noticesMapper;

    public Notices selectNoticeById(int notice_id){
        return noticesMapper.selectNoticeById(notice_id);
    }
}

7、创建Controller层Notices表的请求接口：

package com.faithsinan.test.contorller;

import com.faithsinan.test.model.Notices;
import com.faithsinan.test.service.NoticesService;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import javax.annotation.Resource;

/**
 * Notices表的数据请求接口类
 */
@Controller
@ResponseBody
public class NoticesController {
    @Resource
    private NoticesService noticesService;

    /**
     * 根据id检索notices表的内容的请求接口
     * @return  返回一个Notices实体类的构造对象
     */
    @RequestMapping("/select")
    public Notices selectNoticeById(){
        int noticeId = 1;
        return noticesService.selectNoticeById(noticeId);
    }
}

8、测试服务

浏览器访问：localhost:8888/select

显示 json 格式的查询结果则测试成功！

---

2020年12月08日 完结