Spring boot 整合 Mybatis （完整版）

2021-10-06 04:52:40

　　最近工作上时间有点多，然后自己就学习了一下Spring boot，外加上Mybatis，在实际开发中都是比较常用的，所以这篇写一下SpringBoot整合Mybatis。

一、数据准备

CREATE TABLE `bookbean` (

  `name` varchar(255) DEFAULT NULL,

  `author` varchar(255) DEFAULT NULL,

  `price` varchar(255) DEFAULT NULL

) 

INSERT INTO `bookbean` VALUES ('张三', 'ZHANGSAN', '');

INSERT INTO `bookbean` VALUES ('李四', 'LISI', '');

INSERT INTO `bookbean` VALUES ('王五', 'WANGWU', '');

二、引入依赖

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>

    <groupId>com.example</groupId>

    <artifactId>demo</artifactId>

    <version>0.0.1-SNAPSHOT</version>

    <packaging>jar</packaging>

    <name>demo</name>

    <description>Demo project for Spring Boot</description>

    <parent>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-parent</artifactId>

        <version>2.0.1.RELEASE</version>

        <relativePath/> <!-- lookup parent from repository -->

    </parent>

    <properties>

        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>

        <java.version>1.8</java.version>

        <mybatis.version>3.4.5</mybatis.version>

        <mybatis-spring.version>1.3.1</mybatis-spring.version>

        <mysql.version>6.0.6</mysql.version>

    </properties>

    <dependencies>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-web</artifactId>

        </dependency>

        <!-- 热部署 -->

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-devtools</artifactId>

            <optional>true</optional>

            <scope>true</scope>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-test</artifactId>

            <scope>test</scope>

        </dependency>

        <!-- mybatis依赖 -->

        <dependency>

            <groupId>org.mybatis</groupId>

            <artifactId>mybatis</artifactId>

            <version>${mybatis.version}</version>

        </dependency>

        <!-- mybatis-spring -->

        <dependency>

            <groupId>org.mybatis</groupId>

            <artifactId>mybatis-spring</artifactId>

            <version>${mybatis-spring.version}</version>

        </dependency>

        <!-- mysql驱动包 -->

        <dependency>

            <groupId>mysql</groupId>

            <artifactId>mysql-connector-java</artifactId>

            <version>${mysql.version}</version>

        </dependency>

        <dependency>

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

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

            <version>1.3.0</version>

        </dependency>

        <!-- 数据源 -->

        <dependency>

            <groupId>com.alibaba</groupId>

            <artifactId>druid</artifactId>

            <version>1.0.29</version>

        </dependency>

    </dependencies>

    <build>

        <plugins>

            <plugin>

                <groupId>org.springframework.boot</groupId>

                <artifactId>spring-boot-maven-plugin</artifactId>

            </plugin>

        </plugins>

    </build>

</project>

三、数据库配置文件

　　项目application.properties内容如下：

banner.charset=UTF-8

server.tomcat.uri-encoding=UTF-8

spring.http.encoding.charset=UTF-8

spring.http.encoding.enabled=true

spring.http.encoding.force=true

spring.messages.encoding=UTF-8

#配置设置不同的信息名字获取不同的配置文件

#application-dev.properties：用于开发环境

#application-test.properties：用于测试环境

#application-prod.properties：用于生产环境

spring.profiles.active=dev

#spring boot 默认会加载 classpath:logback-spring.xml 或者 classpath:logback-spring.groovy。

#如需要自定义文件名称，在 application.properties 中配置 logging.config 选项即可

logging.config=classpath:logback-spring.xml

######数据库链接配置########

spring.datasource.url=jdbc\:mysql\://127.0.0.1\:3306/aa

spring.datasource.username=root

spring.datasource.password=123456

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

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

spring.datasource.initialSize=5

spring.datasource.minIdle=5

spring.datasource.maxActive=20

spring.datasource.maxWait=60000

mybatis.mapperLocations=classpath:mybatis/mapper/*.xml

mybatis.config-location=classpath:mybatis/mybatis-config.xml

四、代码

实体类BookBean.java

public class BookBean {

    private String name;

    private String author;

    private String price;

    public String getName() {

        return name;

    }

    public void setName(String name) {

        this.name = name;

    }

    public String getAuthor() {

        return author;

    }

    public void setAuthor(String author) {

        this.author = author;

    }

    public String getPrice() {

        return price;

    }

    public void setPrice(String price) {

        this.price = price;

    }

    @Override

    public String toString() {

        return "BookBean [name=" + name + ", author=" + author + ", price="

                + price + "]";

    }

    public BookBean(String name, String author, String price) {

        super();

        this.name = name;

        this.author = author;

        this.price = price;

    }

    public BookBean() {

        // TODO Auto-generated constructor stub

    }

}

BookBeanMapper.java

package com.example.demo.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.example.demo.bean.BookBean;

@Mapper

public interface BookBeanMapper {

    /**

     * 集合

     * @return

     */

    public List<BookBean> findBookBeanInfo();

    /**

     * 添加

     * @param bookBean

     * @return

     */

    public int addBookBeanInfo(BookBean bookBean);

    /**

     * 删除

     * @param id

     * @return

     */

    public int delBookBeanInfo(String id);

}

BookBeanService.java

package com.example.demo.service;

import java.util.List;

import com.example.demo.bean.BookBean;

public interface BookBeanService {

    /**

     * 集合

     * @return

     */

    public List<BookBean> findBookBeanInfo();

    /**

     * 添加

     * @param bookBean

     * @return

     */

    public int addBookBeanInfo(BookBean bookBean);

    /**

     * 删除

     * @param id

     * @return

     */

    public int delBookBeanInfo(String id);

}

BookBeanServiceImpl.java

package com.example.demo.service.impl;

import java.util.List;

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

import org.springframework.stereotype.Service;

import com.example.demo.bean.BookBean;

import com.example.demo.mapper.BookBeanMapper;

import com.example.demo.service.BookBeanService;

@Service

public class BookBeanServiceImpl implements BookBeanService{

    @Autowired

    private BookBeanMapper bookBeanMapper;

    @Override

    public List<BookBean> findBookBeanInfo() {

        return bookBeanMapper.findBookBeanInfo();

    }

    @Override

    public int addBookBeanInfo(BookBean bookBean) {

        return bookBeanMapper.addBookBeanInfo(bookBean);

    }

    @Override

    public int delBookBeanInfo(String id) {

        return bookBeanMapper.delBookBeanInfo(id);

    }

}

TestController.java

package com.example.demo.controller;

import java.util.List;

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

import org.springframework.http.ResponseEntity;

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

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

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

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

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

import com.example.demo.bean.BookBean;

import com.example.demo.service.BookBeanService;

import com.example.demo.util.JsonResult;

@RestController

@RequestMapping(value="/demo")

public class TestController {

    @Autowired

    private BookBean bookBean;

    @Autowired

    private BookBeanService bookBeanService;

    @RequestMapping(value="/helloworld",produces="text/plan;charset=UTF-8")

    public String helloworld() {

        System.out.println(bookBean.toString());

        return "helloworld-"+bookBean.getName()+"----"+bookBean.getAuthor()+"----"+bookBean.getPrice();

    }

    @GetMapping("/helloworld2")

    public String helloworld2() {

        return "helloworld2";

    }

    /**

     * 根据id删除用户

     * @param id

     * @return

     */

    @RequestMapping(value = "/delete/{id}", method = RequestMethod.GET)

    public ResponseEntity<JsonResult> delete (@PathVariable(value = "id") String id){

        JsonResult r = new JsonResult();

        try {

            int ret = bookBeanService.delBookBeanInfo(id);

            if (ret < 0) {

                r.setResult(ret);

                r.setStatus("fail");

            } else {

                r.setResult(ret);

                r.setStatus("ok");

            }

        } catch (Exception e) {

            r.setResult(e.getClass().getName() + ":" + e.getMessage());

            r.setStatus("error");

            e.printStackTrace();

        }

        return ResponseEntity.ok(r);

    }

    /**

     * 查询

     * @return

     */

    @RequestMapping(value="/find")

    public ResponseEntity<JsonResult> add(){

        JsonResult r = new JsonResult();

        try {

            System.out.println(1);

            List<BookBean> findBookBeanInfo = bookBeanService.findBookBeanInfo();

            r.setResult(findBookBeanInfo);

            r.setStatus("ok");

        } catch (Exception e) {

            r.setResult(e.getClass().getName() + ":" + e.getMessage());

            r.setStatus("error");

            e.printStackTrace();

        }

        return ResponseEntity.ok(r);

    }

}

JsonResult类是一个通用转json的工具类如下：

package com.example.demo.util;

/**

 * 通用json返回类

 * @author Administrator

 *

 */

public class JsonResult {

    private String status = null;

    private Object result = null;

    public JsonResult status(String status) {

        this.status = status;

        return this;

    }

    public String getStatus() {

        return status;

    }

    public void setStatus(String status) {

        this.status = status;

    }

    public Object getResult() {

        return result;

    }

    public void setResult(Object result) {

        this.result = result;

    }

}

目录结构：

BookbeanMapper.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.mapper.BookBeanMapper" >

    <resultMap id="bookBeanMap" type="bookBean" >

        <result column="name" property="name" jdbcType="VARCHAR" />

        <result column="author" property="author" jdbcType="VARCHAR" />

        <result column="price" property="price" jdbcType="VARCHAR"/>

    </resultMap>

    <sql id="bookbean" >

        name,author,price

    </sql>

    <select id="findBookBeanInfo" resultMap="bookBeanMap">

        select <include refid="bookbean"/> from BOOKBEAN

    </select>

    <insert id="addBookBeanInfo" parameterType="bookBean">

        insert into BOOKBEAN(name,author,price) values(#{name},#{author},#{price})

    </insert>

    <delete id="delBookBeanInfo" parameterType="string">

        delete from BOOKBEAN where price = #{price}

    </delete>

</mapper>

然后启动DemoApplication.java 打开浏览器输入http://localhost:8081/demo/find 就出现下图

完成到这里说明springboot整合mybatis就成功了，有什么不对的地方欢迎朋友们提出建议！

http://www.cnblogs.com/tangyin/p/8862687.html

码农公寓

二、引入依赖

三、数据库配置文件

四、代码

相关文章