spring boot集成mybatis -plus

最新推荐文章于 2024-07-29 20:18:06 发布

天幕流光-

最新推荐文章于 2024-07-29 20:18:06 发布

阅读量357

点赞数

分类专栏： IT资料

本文链接：https://blog.csdn.net/qq_43455410/article/details/84591874

版权

IT资料专栏收录该内容

26 篇文章 1 订阅

订阅专栏

本文详细介绍了如何将Mybatis-Plus与Spring Boot进行集成，从配置pom.xml文件开始，逐步讲解了entity层、controller、mapper接口、service层的创建，以及分页插件的使用和配置，最后在application.properties中设置相关属性，同时提供了HTML页面和Layui框架的集成方法。

摘要由CSDN通过智能技术生成

1.配置pom.xml文件

项目目录;
在这里插入图片描述

<?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>cn.ps</groupId>
    <artifactId>SpringBootMyBatisPlus</artifactId>
    <version>1.0-SNAPSHOT</version>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.0.6.RELEASE</version>
    </parent>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>commons-lang</groupId>
            <artifactId>commons-lang</artifactId>
            <version>2.1</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.0.5</version>
        </dependency>
    </dependencies>
</project>

2.创建entity层

//实体类
package cn.ps.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import org.hibernate.validator.constraints.NotBlank;

import javax.validation.constraints.DecimalMax;
import javax.validation.constraints.DecimalMin;
import javax.validation.constraints.Pattern;
import javax.validation.constraints.Size;

@TableName("stu1")
public class MySqlUser {
	@TableId(type= IdType.AUTO)
	private String id;
	@NotBlank(message = "学生姓名不能为空")
	private String name;
	@DecimalMin(value="1",message = "年龄不能小于1岁")
	@DecimalMax(value="130",message = "年龄最大为130岁")
	private String age;
	private String sex;
	@Pattern(regexp = ".+@.+\\..+",message = "邮箱格式错误")
	private String eamil;
	@Size(max = 11,min = 11,message = "手机号码必须为11位数")
	private String phone;
    public String getId() {
        return id;
    }
    public void setId(String id) {
        this.id = id;
    }
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public String getAge() {
		return age;
	}

	public void setAge(String age) {
		this.age = age;
	}

	public String getEamil() {
		return eamil;
	}

	public void setEamil(String eamil) {
		this.eamil = eamil;
	}

	public String getPhone() {
		return phone;
	}

	public void setPhone(String phone) {
		this.phone = phone;
	}
}

package cn.ps.entity;

import java.util.List;

public class Result {
    private  int code;
    private  String msg;
    private int count;
    private List data;

    public int getCode() {
        return code;
    }

    public void setCode(int code) {
        this.code = code;
    }

    public String getMsg() {
        return msg;
    }

    public void setMsg(String msg) {
        this.msg = msg;
    }

    public int getCount() {
        return count;
    }

    public void setCount(int count) {
        this.count = count;
    }

    public List getData() {
        return data;
    }

    public void setData(List data) {
        this.data = data;
    }
}

3.控制层 coutroller

 package cn.ps.coutroller;


 import cn.ps.entity.MySqlUser;
 import cn.ps.entity.Result;
 import cn.ps.service.EmpService;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.web.bind.annotation.*;

 import javax.validation.Valid;


 @RestController
public class DataCoutroller {
	@Autowired
	private EmpService service;

	 /**
	  * 多条件搜索
	  *  传参   /emps?stu=1&curPage=2&pageNum=3
	  * @return
	  */

	@GetMapping(value = "/emps")
	public Result listEmp(String name, String page, String limit)  {
		try {
			Result pb=service.queryClass(name,page,limit);
			return pb;
		}  catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}

	 @PostMapping(value = "/emp")
	 public Result addEmp(MySqlUser emp)  {
		 Result r=new Result();
			try{
				service.addEmp(emp);
			}catch(Exception e){
				r.setCode(1);
				r.setMsg("新增出错"+e.getMessage());
			}

		 return r;
	 }

	 @DeleteMapping(value = "/emp/{id}")
	 public Result deleteEmp(@PathVariable  String id)  {
		 Result r=new Result();
	 	try{
			service.deleteEmp(id);
	 	}catch(Exception e){
			r.setCode(1);
			r.setMsg("删除失败"+e.getMessage());
	 	}
		 return r;
	 }

	 @PutMapping(value = "/emp/{id}")
	 public Result updateEmp(@PathVariable  String id, @Valid MySqlUser emp)  {
		 Result r=new Result();
		 try{
			 emp.setId(id);
			 service.updateEmp(emp);
		 }catch(Exception e){
			 r.setCode(1);
			 r.setMsg("修改失败"+e.getMessage());
		 }
		 return r;
	 }

}

4.接口映射类mapper

package cn.ps.mapper;

import cn.ps.entity.MySqlUser;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import org.apache.ibatis.annotations.*;


@Mapper
public interface EmpMapper extends BaseMapper<MySqlUser> {

}

5.分页插件类

package cn.ps.confBaen;

import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;
@EnableTransactionManagement
@Configuration
@MapperScan("com.baomidou.cloud.service.*.mapper*")
public class MyConf {
        /**
         * 分页插件
         */
        @Bean
        public PaginationInterceptor paginationInterceptor() {
            return new PaginationInterceptor();
        }

}

6.服务层service

package cn.ps.service;

import cn.ps.entity.MySqlUser;
import cn.ps.entity.Result;

public interface EmpService {
	public Result queryClass(String name, String curPage, String pageNum) throws Exception;

	public void addEmp(MySqlUser emp);

    void deleteEmp(String id);

	void updateEmp(MySqlUser emp);
}

package cn.ps.service.impl;


import cn.ps.entity.MySqlUser;
import cn.ps.entity.Result;
import cn.ps.mapper.EmpMapper;
import cn.ps.service.EmpService;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.commons.lang.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;



@Service
public class EmpServiceImpl implements EmpService {

    @Autowired
	private EmpMapper dao;

	public Result queryClass(String name, String curPage, String pageNum) throws Exception{

        //第一次访问 没有当前页
		if(StringUtils.isEmpty(curPage)) {
			curPage="1";
		}
		if(StringUtils.isEmpty(pageNum)) {
			pageNum="10";
		}

		//转换成int类型
		int curPageIn=Integer.parseInt(curPage);
		int pageNumIn=Integer.parseInt(pageNum);
        if(StringUtils.isEmpty(name)) {
            name="";
        }
		QueryWrapper<MySqlUser> qw=new QueryWrapper<MySqlUser>();
        qw.like("name", name);
        IPage<MySqlUser> pa=dao.selectPage(new Page(curPageIn,pageNumIn), qw);
		Result re=new Result();
		re.setCode(0);
		re.setCount((int)pa.getTotal());
		re.setData(pa.getRecords());
		return re;
	}

	public void addEmp(MySqlUser emp) {
		dao.insert(emp);
	}

	public void deleteEmp(String id) {
		dao.deleteById(id);
	}

	public void updateEmp(MySqlUser emp) {
		dao.updateById(emp);
	}

}

7.spring boot main 方法

package cn.ps;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;


@MapperScan("cn.ps.mapper.EmpMapper")
@SpringBootApplication
public class Example {

    public static void main(String[] args) throws Exception {

        SpringApplication.run(Example.class, args);//@SpringBootApplication必须要是这个注释下面的类
    }

}

8.资源文件(application.properties)

spring.datasource.url=jdbc:mysql://localhost/unit02
spring.datasource.username=root
spring.datasource.password=ps123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.druid.stat-view-servlet.login-username=xff
spring.datasource.druid.stat-view-servlet.login-password=123456

9.hmtl和layui(下载地址：https://www.layui.com/)

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
    <link rel="stylesheet" href="resources/layui/css/layui.css"/>
    <script src="resources/layui/layui.js"></script>
    <script src="https://cdn.staticfile.org/jquery/1.10.2/jquery.min.js">
    </script>
    <script>
        layui.use('form',function () {
            var form=layui.form;
            form.on('submit(myForm)', function(data){
                data.field["page"]=1;
                layui.table.reload('myEmpTable', {
                    url: 'emps'
                    ,where:data.field
                });
                return false;
            });
            form.on('submit(addForm)', function(data){
               $.ajax({
                  url:'emp',
                   dataType:'json',
                   data:data.field,
                   type:'post',
                   success:function (da) {
                       if(da.code==0){
                           layer.close(addwindow);
                           layui.table.reload('myEmpTable', {
                               url: 'emps'
                           });
                       }else{
                           alert(da.msg)
                       }
                   }
               });
                return false;
            });
            form.on('submit(upForm)', function(data){
                data.field["_method"]="put";
                $.ajax({
                    url:'emp/'+data.field.id,
                    dataType:'json',
                    data:data.field,
                    type:'post',
                    success:function (da) {
                        if(da.code==0){
                            layer.close(update);
                            layui.table.reload('myEmpTable', {
                                url: 'emps'
                            });
                        }else{
                            alert(da.msg)
                        }
                    }
                });
                return false;
            });
        });
        layui.use('table', function(){
            var table = layui.table;
            //第一个实例
            table.render({
                elem: '#myEmpTable'
                ,height: 312
                ,width:'100%'
                ,url: 'emps' //数据接口
                ,page: true //开启分页
                ,cols: [[ //表头
                    {field: 'id', title: '学生ID', width:210, sort: true, fixed: 'left'}
                    ,{field: 'name', title: '学生姓名', width:210}
                    ,{field: 'sex', title: '学生性别', width:210, sort: true}
                    ,{field: 'age', title: '年龄', width:210}
                    ,{field: 'eamil', title: '邮箱', width: 210}
                    ,{field: 'phone', title: '手机号码', width: 210, sort: true}
                    ,{field: 'as', title: '删除操作', width: 210, sort: true ,templet: function(d){
                            return "<button onclick='toDelete("+d.id+")'>删除</button>";
                        }}
                    ,{field: 'acc', title: '修改操作', width: 210, sort: true ,templet: function(d){
                            var str=JSON.stringify(d);
                            //return  '<a href=javascript:toUpdate('+d.id+',"'+d.name+'","'+d.sex+'","'+d.age+'","'+d.phone+'","'+d.eamil+'")>修改</a>';
                            //return "<button onclick=toUpdate('"+d.id+"','"+d.name+"','"+d.sex+"','"+d.age+"','"+d.phone+"','"+d.eamil+"')>修改</button>";
                            return "<button onclick=\"toUpdate()\" data='"+str+"'>修改</button>";
                        }}
                ]]
            });
        });
        var addwindow=null;
        function toAdd() {
            layui.use('layer', function(){
                addwindow=layer.open({
                    type: 1,
                    area: ['500px', '400px'],
                    content:$('#addForm')
                });
            });
        }
        function toDelete(id) {
            $.ajax({
                url:'emp/'+id,
                dataType:'json',
                data:{
                    "_method":"delete"
                },
                type:'post',
                success:function (da) {
                    if(da.code==0){
                        layui.table.reload('myEmpTable', {
                            url: 'emps'
                            ,page: {
                            curr: 1 //重新从第 1 页开始
                            }
                        });
                    }else{
                        alert(da.msg)
                    }
                }
            });
            return false;
        }
        var update=null;
        function toUpdate(da) {
           //获取字符串
           var attribute = event.srcElement.getAttribute("data");
           //转换成JSON 对象
           var parse = JSON.parse(attribute);
            layui.use('layer', function(){
                update=layer.open({
                    type: 1,
                    area: ['500px', '400px'],
                    content:$('#upForm')
                });
            });
            layui.form.val("upForm",parse);
        }
    </script>
</head>
<body>
<form class="layui-form" action="">
    <div class="layui-inline">
        <label class="layui-form-label">学生姓名</label>
        <div class="layui-input-inline" style="width: 200px;">
            <input type="text" name="name"  autocomplete="off" class="layui-input">
        </div>
        <div class="layui-input-inline" style="width: 200px;">
            <button class="layui-btn" lay-submit lay-filter="myForm">查询</button>
            <a href="javascript:toAdd()" class="layui-btn">新增</a>
        </div>
    </div>
</form>
    <table id="myEmpTable" ></table>
</body>
</html>



<!--新增的表单-->
<form  id="addForm" class="layui-form" style="display: none" > <!-- 提示：如果你不想用form，你可以换成div等任何一个普通元素 -->
    <div class="layui-form-item">
        <label class="layui-form-label" >学生姓名</label>
        <div class="layui-input-block">
            <input type="text" name="name" lay-verify="required" autocomplete="off" class="layui-input" >
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">学生性别</label>
        <div class="layui-input-block">
            <input type="text" name="sex" autocomplete="off" class="layui-input" >
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">学生年龄</label>
        <div class="layui-input-block">
            <input type="text" name="age" lay-verify="number" autocomplete="off" class="layui-input" >
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">邮箱</label>
        <div class="layui-input-block">
            <input type="text" name="eamil" lay-verify="email"  autocomplete="off" class="layui-input" >
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">手机号码</label>
        <div class="layui-input-block">
            <input type="text" name="phone" lay-verify="phone" autocomplete="off" class="layui-input" >
        </div>
    </div>
    <div class="layui-form-item">
        <div class="layui-input-block">
            <button class="layui-btn" lay-submit lay-filter="addForm">立即提交</button>
            <button type="reset" class="layui-btn layui-btn-primary">重置</button>
        </div>
    </div>
</form>
<!--修改的表单-->
<form  id="upForm" class="layui-form" lay-filter="upForm" style="display: none"  > <!-- 提示：如果你不想用form，你可以换成div等任何一个普通元素 -->
    <div class="layui-form-item">
        <label class="layui-form-label" >学生姓名</label>
        <div class="layui-input-block">
            <input type="text" name="name" lay-verify="required" autocomplete="off" class="layui-input" id="a">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">学生性别</label>
        <div class="layui-input-block">
            <input type="text" name="sex" autocomplete="off" class="layui-input" id="b">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">学生年龄</label>
        <div class="layui-input-block">
            <input type="text" name="age" lay-verify="number" autocomplete="off" class="layui-input" id="c">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">邮箱</label>
        <div class="layui-input-block">
            <input type="text" name="eamil" lay-verify="email"  autocomplete="off" class="layui-input" id="d">
        </div>
    </div>
    <div class="layui-form-item">
        <label class="layui-form-label">手机号码</label>
        <div class="layui-input-block">
            <input type="text" name="phone" lay-verify="phone" autocomplete="off" class="layui-input" id="e">
        </div>
    </div>
    <div class="layui-form-item" style="display: none">
        <label class="layui-form-label">学生编号</label>
        <div class="layui-input-block">
            <input type="text" name="id"  autocomplete="off" class="layui-input" id="f">
        </div>
    </div>
    <div class="layui-form-item">
        <div class="layui-input-block">
            <button class="layui-btn" lay-submit lay-filter="upForm">立即提交</button>
            <button type="reset" class="layui-btn layui-btn-primary">重置</button>
        </div>
    </div>
</form>

10. 集成mybatis

1.把分页插件改成：

package cn.ps.conf;

import com.github.pagehelper.PageHelper;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import java.util.Properties;

@Configuration
public class confBean {
    @Bean
      public PageHelper pageHelper() {
        PageHelper pageHelper = new PageHelper();
        Properties properties = new Properties();

        properties.setProperty("dialect", "mysql");    //配置mysql数据库的方言
        //表示支持从接口中读取 pageNum和pageSize
        properties.setProperty("supportMethodsArguments","true");
        pageHelper.setProperties(properties);
        return pageHelper;
    }
}

2.把mapper类改成：

package cn.ps.mapper;

import cn.ps.entity.MySqlUser;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface EmpMapper {
    @Select("select * from stu1 where name like #{name}")
    public List<MySqlUser> queryClass(@Param("name") String name, @Param("pageNum") int pageNum,@Param("pageSize") int pageSize);

    @Insert("insert into stu1(name,age,eamil,sex,phone) values(#{name},#{age},#{eamil},#{sex},#{phone})")
    public void addEmp(MySqlUser emp);

    @Delete("delete from stu1 where id=#{0}")
    void deleteEmp(String id);

    @Update("update stu1 set name=#{name},age=#{age},eamil=#{eamil},sex=#{sex},phone=#{phone} where id=#{id}")
    void updateEmp(MySqlUser emp);
}

3.service实现类

package cn.ps.service.impl;


import cn.ps.entity.MySqlUser;
import cn.ps.entity.Result;
import cn.ps.mapper.EmpMapper;
import cn.ps.service.EmpService;
import com.github.pagehelper.PageInfo;
import org.apache.commons.lang.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;


@Service
public class EmpServiceImpl implements EmpService {

    @Autowired
	private EmpMapper dao;

	public Result queryClass(String name, String curPage, String pageNum) throws Exception{

        //第一次访问 没有当前页
		if(StringUtils.isEmpty(curPage)) {
			curPage="1";
		}
		if(StringUtils.isEmpty(pageNum)) {
			pageNum="10";
		}

		//转换成int类型
		int curPageIn=Integer.parseInt(curPage);
		int pageNumIn=Integer.parseInt(pageNum);
        if(StringUtils.isEmpty(name)) {
            name="";
        }
        List<MySqlUser> emps = dao.queryClass("%"+name+"%", curPageIn, pageNumIn);
        PageInfo pi=new PageInfo(emps);

		Result re=new Result();
		re.setCode(0);
		re.setCount((int)pi.getTotal());
		re.setData(emps);
		return re;
	}

	public void addEmp(MySqlUser emp) {
		dao.addEmp(emp);
	}

	public void deleteEmp(String id) {
		dao.deleteEmp(id);
	}

	public void updateEmp(MySqlUser emp) {
		dao.updateEmp(emp);
	}

}

4.启动类main方法

package cn.ps;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
@SpringBootApplication
public class Example {
    // springboot 只要加上@RestController这个注解就会自动转换会josn数组
    @GetMapping("/")
    String home() {
        return "Hello World!";
    }

    public static void main(String[] args) throws Exception {

        SpringApplication.run(Example.class, args);//@SpringBootApplication必须要是这个注释下面的类
    }


}

5.pom.xml文件

<?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>cn.ps</groupId>
    <artifactId>SpringBootMyBatis</artifactId>
    <version>1.0-SNAPSHOT</version>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.0.6.RELEASE</version>
    </parent>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>commons-lang</groupId>
            <artifactId>commons-lang</artifactId>
            <version>2.1</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>
        <dependency>
                <groupId>com.github.pagehelper</groupId>
                 <artifactId>pagehelper</artifactId>
                 <version>4.1.6</version>
        </dependency>
    </dependencies>

</project>