springboot集成mybatis-plus

矫情吗；* 2022-01-16 08:05 266阅读 0赞

1、使用IDEA创建一个springboot的工程，创建springboot工程详细步骤请移步查看：[https://blog.csdn.net/qq\_38555490/article/details/90260295][https_blog.csdn.net_qq_38555490_article_details_90260295]

2、修改pom文件，添加mybatis-plus的依赖，以及连接数据库mysql的依赖

<dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>3.1.1</version>
            </dependency>
            
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.46</version>
            </dependency>

图示：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NTU1NDkw_size_16_color_FFFFFF_t_70][]

3、pom文件添加一个lombok的插件来对我们的pojo生成get,set方法

<dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>1.16.18</version>
                <scope>provided</scope>
            </dependency>

图示：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NTU1NDkw_size_16_color_FFFFFF_t_70 1][]

3、创建我们的工程目录结构（我这里创建的是一个demo）

![20190615180633171.png][]

4、我们的dao层继承我们mybatis-plus的BaseMapper<T>

继承了我们就拥有了操作单表的方法，而不用像mybatis用逆向工程生成mapper.xml文件，是不是很方便，极大的使我们的开发效率上升。

public interface StuDao extends BaseMapper<Student> {
    }

图示：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NTU1NDkw_size_16_color_FFFFFF_t_70 2][]

5、修改application.properties文件，后缀改为yml，yml类型是springboot支持文件类型的一种。

具体yml介绍使用方法，请移步该文章查看：[https://blog.csdn.net/qq\_38555490/article/details/90264257][https_blog.csdn.net_qq_38555490_article_details_90264257]

![20190615165530786.png][]

6、application.yml配置数据源，配置端口

#配置数据源
    spring:
      datasource:
        url: jdbc:mysql://localhost:3306/mydb
        username: root
        password: root
        driver-class-name: com.mysql.jdbc.Driver
    #配置服务器端口
    server:
      port: 8888

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NTU1NDkw_size_16_color_FFFFFF_t_70 3][]

6、springboot启动类配置注解扫描

@SpringBootApplication(scanBasePackages = "com.xiaomin")
    @MapperScan("com.xiaomin.mapper")

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NTU1NDkw_size_16_color_FFFFFF_t_70 4][]

6、测试

创建数据库表

CREATE TABLE sutdent(
     id INT PRIMARY KEY AUTO_INCREMENT,
     NAME VARCHAR(20) NOT NULL,
     age INT  NOT NULL,
     birthday DATE NOT NULL
    )

图示：  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NTU1NDkw_size_16_color_FFFFFF_t_70 5][]

pojo-Student.java 创建我们的实体类

package com.xiaomin.pojo;
    
    import lombok.AllArgsConstructor;
    import lombok.Getter;
    import lombok.NoArgsConstructor;
    import lombok.Setter;
    
    import java.util.Date;
    
    /**
     * @author jattxgt
     * @site jattxgt
     * @company jattxgt.com
     * @create 2019-06-13 9:17
     */
    @Getter //get方法
    @Setter  //set方法
    @AllArgsConstructor  //有参构造方法
    @NoArgsConstructor  //无参构造方法
    public class Student {
        private int id;
        private String name;
        private int age;
        private Date birthday;
    }

mapper-StuDao.java

package com.xiaomin.mapper;
    
    import com.baomidou.mybatisplus.core.mapper.BaseMapper;
    import com.xiaomin.pojo.Student;
    
    /**
     * @author jattxgt
     * @site jattxgt
     * @company jattxgt.com
     * @create 2019-06-13 9:16
     */
    public interface StuDao extends BaseMapper<Student> {
    }

server-StuServer.java

package com.xiaomin.service;
    
    import com.xiaomin.pojo.Student;
    
    import java.util.List;
    
    /**
     * @author jattxgt
     * @site jattxgt
     * @company jattxgt.com
     * @create 2019-06-13 9:17
     */
    public interface StuService {
        //删除
        int deleteById(int id);
        //查询
        List<Student> selectAll();
    
    }

serverimpl-StuServerImpl.java

package com.xiaomin.service.impl;
    
    import com.baomidou.mybatisplus.core.conditions.Wrapper;
    import com.xiaomin.mapper.StuDao;
    import com.xiaomin.pojo.Student;
    import com.xiaomin.service.StuService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.List;
    
    /**
     * @author jattxgt
     * @site jattxgt
     * @company jattxgt.com
     * @create 2019-06-13 9:26
     */
    @Service
    public class StuServiceImpl implements StuService {
        @Autowired
        private StuDao stuDao;
    
        /**
         * 通过Id来删除
         * @param id 页面传入过来的id
         * @return
         */
        @Override
        public int deleteById(int id) {
            int aa=stuDao.deleteById(id);
            return aa;
        }
    
        /**
         * 查询所有的学生信息
         * @return
         */
        @Override
        public List<Student> selectAll() {
            List<Student> list=stuDao.selectList(null);
            return list;
        }
    }

controller-StuController.java

package com.xiaomin.controller;
    
    import com.xiaomin.pojo.Student;
    import com.xiaomin.service.StuService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.PathVariable;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    import java.util.Date;
    import java.util.List;
    
    /**
     * @author jattxgt
     * @site jattxgt
     * @company jattxgt.com
     * @create 2019-06-13 9:17
     */
    @RestController
    public class StuController {
        @Autowired
        private StuService stuService;
    
        /**
         * 通过id删除
         * @param id
         * @return
         */
        @RequestMapping(value = "/delete/{id}")
        public String deleteById(@PathVariable int id){
            int aa=stuService.deleteById(id);
            return "删除成功,影响行数为："+aa;
        }
    
        /**
         * 查询所有的学生信息
         * @return
         */
        @RequestMapping("/selectAll")
        public List<Student> selectAll(){
            List<Student> list= stuService.selectAll();
            return list;
        }
    }

浏览器测试

![20190615183046877.png][]

demo百度云地址：

链接：https://pan.baidu.com/s/15kezv4uXQgzPtq5y115CbA   
提取码：yh3w

[https_blog.csdn.net_qq_38555490_article_details_90260295]: https://blog.csdn.net/qq_38555490/article/details/90260295
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NTU1NDkw_size_16_color_FFFFFF_t_70]: /images/20220114/d78471f9a1ba493283f88dc417f108f8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NTU1NDkw_size_16_color_FFFFFF_t_70 1]: /images/20220114/41b566887a25445f9d0fe0d1321e4eaf.png
[20190615180633171.png]: /images/20220114/e6a0b6bcd19c45bfae9999e6ceec1903.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NTU1NDkw_size_16_color_FFFFFF_t_70 2]: /images/20220114/2952eb9d38274bb083b961928c1a178b.png
[https_blog.csdn.net_qq_38555490_article_details_90264257]: https://blog.csdn.net/qq_38555490/article/details/90264257
[20190615165530786.png]: /images/20220114/89692854025a42a2ba839dac47fa1677.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NTU1NDkw_size_16_color_FFFFFF_t_70 3]: /images/20220114/a8cd0f9d21694b9b97079776ab82ec0b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NTU1NDkw_size_16_color_FFFFFF_t_70 4]: /images/20220114/2a16cebd16a24857888898fa109070c8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NTU1NDkw_size_16_color_FFFFFF_t_70 5]: /images/20220114/17106b14d82e4abaac56f30f510928bf.png
[20190615183046877.png]: /images/20220114/d699d489f9b64e239c5894e7f5d4b2d9.png