springboot+mybatisplus的增删改查操作评论区见源码地址

此demo的项目结构

用idea创建好一个springboot的基础项目之后，在pom.xml文件中加入以下依赖，

1.  
   <dependency>
2.  
   <groupId>com.baomidou</groupId>
3.  
   <artifactId>mybatis-plus-boot-starter</artifactId>
4.  
   <version>3.4.0</version>
5.  
   </dependency>
6.  
   <dependency>
7.  
   <groupId>org.projectlombok</groupId>
8.  
   <artifactId>lombok</artifactId>
9.  
   <optional>true</optional>
10.  
    </dependency>
11.  
    <dependency>
12.  
    <groupId>mysql</groupId>
13.  
    <artifactId>mysql-connector-java</artifactId>
14.  
    <scope>runtime</scope>
15.  
    </dependency>
16.  
    <dependency>
17.  
    <groupId>org.springframework.boot</groupId>
18.  
    <artifactId>spring-boot-starter-web</artifactId>
19.  
    </dependency>

安装完依赖之后，配置application.properties

1.  
   #修改tomcat端口
2.  
   server.port=8081
3.  
   #设定Url的地址路径
4.  
   #server.servlet.context-path=/springboot
5.  
   #设定前缀
6.  
   #spring.mvc.view.prefix=/
7.  
   #设定后缀
8.  
   #spring.mvc.view.suffix=.jsp
9.  
   #连接字符串Mysql
10.  
    spring.datasource.url=jdbc:mysql://localhost:3306/xiaozhoucms?serverTimezone=UTC
11.  
    #mysql驱动
12.  
    spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
13.  
    #mysql用户名
14.  
    spring.datasource.username=root
15.  
    #mysql密码
16.  
    spring.datasource.password=123456789
17.  
    #阿里巴巴数据库连接池
18.  
    #spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
19.  
    #扫描mapper下面的所有.xmlwen件
20.  
    mybatis.mapper-locations=classpath:mapper/*.xml
21.  
    #扫描entity下所有实体
22.  
    mybatis.type-aliases-package=com.example.demo.entity
23.  
     
24.  
    #SpringBoot打印MyBatis sql日志输出
25.  
    logging.level.com.example.cmscrud.demo.mapper=debug

在idea上连接上本地数据库，如下图，图中只用到了users这个表

在本地数据库创建数据库并且创建一个users的表格，内容如下。

然后按照结构创建全部的包名称，controller、entity、mapper、service。

Application文件

1.  
   package com.example.cmscrud.demo;
2.  
    
3.  
   import org.mybatis.spring.annotation.MapperScan;
4.  
   import org.springframework.boot.SpringApplication;
5.  
   import org.springframework.boot.autoconfigure.SpringBootApplication;
6.  
    
7.  
   @SpringBootApplication
8.  
   @MapperScan("com.example.cmscrud.demo.mapper")
9.  
   public class Application {
10.  
     
11.  
    public static void main(String[] args) {
12.  
    SpringApplication.run(Application.class, args);
13.  
    }
14.  
     
15.  
    }

controller包下的UsersController文件

1.  
   package com.example.cmscrud.demo.controller;
2.  
    
3.  
   import com.example.cmscrud.demo.entity.Users;
4.  
   import com.example.cmscrud.demo.service.impl.UsersServiceImpl;
5.  
   import org.springframework.beans.factory.annotation.Autowired;
6.  
   import org.springframework.util.DigestUtils;
7.  
   import org.springframework.web.bind.annotation.*;
8.  
    
9.  
   import java.util.List;
10.  
     
11.  
    @RestController
12.  
    public class UsersController {
13.  
    @Autowired
14.  
    private UsersServiceImpl usersService;
15.  
    /*
16.  
    get请求获取用户列表
17.  
    */
18.  
    @RequestMapping("/users")
19.  
    @ResponseBody
20.  
    public List<Users> getUser(){
21.  
    return usersService.getAllUser(1,10);
22.  
    }
23.  
    /*
24.  
    post请求添加用户
25.  
    */
26.  
    @RequestMapping(value = "/postuser",method = RequestMethod.POST)
27.  
    @ResponseBody
28.  
    public int insertUser(Users users){
29.  
    System.out.println(users);
30.  
    String md5Password=DigestUtils.md5DigestAsHex(users.getPassword().getBytes());
31.  
    System.out.println(md5Password);
32.  
    users.setPassword(md5Password);
33.  
    return usersService.insertUser(users);
34.  
    }
35.  
    /*
36.  
    delete请求删除用户数据
37.  
    */
38.  
    @RequestMapping(value = "/deleteuser",method = RequestMethod.DELETE)
39.  
    public int deleteUser(int id){
40.  
    System.out.println(id);
41.  
    return usersService.deleteUser(id);
42.  
    }
43.  
     
44.  
    /*
45.  
    update请求修改用户数据
46.  
    */
47.  
    @RequestMapping(value = "/updateuser",method = RequestMethod.POST)
48.  
    public int updateUser(Users users){
49.  
    return usersService.updateUser(users);
50.  
    }
51.  
    }

entity包下的Users文件

1.  
   package com.example.cmscrud.demo.entity;
2.  
    
3.  
   import lombok.Data;
4.  
    
5.  
   @Data
6.  
   public class Users {
7.  
    
8.  
   private long id;
9.  
   private String username;
10.  
    private String password;
11.  
    private java.sql.Timestamp createdAt;
12.  
    private java.sql.Timestamp updatedAt;
13.  
     
14.  
     
15.  
    public long getId() {
16.  
    return id;
17.  
    }
18.  
     
19.  
    public void setId(long id) {
20.  
    this.id = id;
21.  
    }
22.  
     
23.  
     
24.  
    public String getUsername() {
25.  
    return username;
26.  
    }
27.  
     
28.  
    public void setUsername(String username) {
29.  
    this.username = username;
30.  
    }
31.  
     
32.  
     
33.  
    public String getPassword() {
34.  
    return password;
35.  
    }
36.  
     
37.  
    public void setPassword(String password) {
38.  
    this.password = password;
39.  
    }
40.  
     
41.  
     
42.  
    public java.sql.Timestamp getCreatedAt() {
43.  
    return createdAt;
44.  
    }
45.  
     
46.  
    public void setCreatedAt(java.sql.Timestamp createdAt) {
47.  
    this.createdAt = createdAt;
48.  
    }
49.  
     
50.  
     
51.  
    public java.sql.Timestamp getUpdatedAt() {
52.  
    return updatedAt;
53.  
    }
54.  
     
55.  
    public void setUpdatedAt(java.sql.Timestamp updatedAt) {
56.  
    this.updatedAt = updatedAt;
57.  
    }
58.  
     
59.  
    @Override
60.  
    public String toString() {
61.  
    return "Users{"
62.  
    "id=" id
63.  
    ", username='" username '\''
64.  
    ", password='" password '\''
65.  
    ", createdAt=" createdAt
66.  
    ", updatedAt=" updatedAt
67.  
    '}';
68.  
    }
69.  
    }

mapper包下的UsersMapper文件

1.  
   package com.example.cmscrud.demo.mapper;
2.  
    
3.  
   import com.baomidou.mybatisplus.core.mapper.BaseMapper;
4.  
   import com.example.cmscrud.demo.entity.Users;
5.  
   import org.springframework.stereotype.Component;
6.  
    
7.  
   @Component
8.  
   public interface UsersMapper extends BaseMapper<Users> {
9.  
   }

service包下的UserService文件

1.  
   package com.example.cmscrud.demo.service;
2.  
    
3.  
   import com.example.cmscrud.demo.entity.Users;
4.  
   import org.springframework.stereotype.Service;
5.  
    
6.  
   import java.util.List;
7.  
    
8.  
   @Service
9.  
   public interface UsersService {
10.  
    public List<Users> getAllUser(Integer page,Integer limit);
11.  
    public int insertUser(Users users);
12.  
    public int deleteUser(int id);
13.  
    public int updateUser(Users users);
14.  
    }

service包内impl包里的UserServiceImpl文件

1.  
   package com.example.cmscrud.demo.service.impl;
2.  
    
3.  
   import com.baomidou.mybatisplus.core.metadata.IPage;
4.  
   import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
5.  
   import com.example.cmscrud.demo.entity.Users;
6.  
   import com.example.cmscrud.demo.mapper.UsersMapper;
7.  
   import com.example.cmscrud.demo.service.UsersService;
8.  
   import org.springframework.beans.factory.annotation.Autowired;
9.  
   import org.springframework.stereotype.Service;
10.  
     
11.  
    import java.util.List;
12.  
     
13.  
    @Service
14.  
    public class UsersServiceImpl implements UsersService {
15.  
    @Autowired
16.  
    private UsersMapper usersMapper;
17.  
    @Override
18.  
    public List<Users> getAllUser(Integer page, Integer limit) {
19.  
    IPage<Users> usersIPage=new Page<>(page,limit);
20.  
    IPage<Users> result=usersMapper.selectPage(usersIPage,null);
21.  
    List<Users> users=result.getRecords();
22.  
    return users;
23.  
    }
24.  
     
25.  
    @Override
26.  
    public int insertUser(Users users) {
27.  
    // System.out.println(users);
28.  
    return usersMapper.insert(users);
29.  
    }
30.  
     
31.  
    @Override
32.  
    public int deleteUser(int id) {
33.  
    return usersMapper.deleteById(id);
34.  
    }
35.  
     
36.  
    @Override
37.  
    public int updateUser(Users users) {
38.  
    return usersMapper.updateById(users);
39.  
    }
40.  
    }

最后运行，并用postman进行测试

 到这里就完成了springboot mybatis的简单crud操作了

这篇好文章是转载于：学新通技术网