MybatisPlus实现简单增删改查功能
作者:''''Beyond'''' 时间:2021-12-27 06:25:21
实现步骤:
工具:IDEA
数据库版本:mysql5.7
一、环境搭建
1.创建springboot项目
pom.xml
2.pom.xml : spring web、lombok mysql
<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>
<scope>runtime</scope>
<optional>true</optional>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
3.添加mybatisplus依赖
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.3.1.tmp</version>
</dependency>
application.properties
4.application.properties配置文件:用户名、密码、连接驱动、配置日志
注意:mysql8 需要增加时区的配置 serverTimezone=GMT%2B8 东八区
#mysql5 驱动不同
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://localhost:3306/mybatisplus?useSSL=false&useUnicode=true&characterEncoding=utf-8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#配置日志
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
数据库数据
#建表
DROP TABLE IF EXISTS user;
CREATE TABLE user
(
id BIGINT(20) NOT NULL COMMENT '主键ID',
name VARCHAR(30) NULL DEFAULT NULL COMMENT '姓名',
age INT(11) NULL DEFAULT NULL COMMENT '年龄',
email VARCHAR(50) NULL DEFAULT NULL COMMENT '邮箱',
PRIMARY KEY (id)
);
#插入数据
DELETE FROM user;
INSERT INTO user (id, name, age, email) VALUES
(1, 'Jone', 18, 'test1@baomidou.com'),
(2, 'Jack', 20, 'test2@baomidou.com'),
(3, 'Tom', 28, 'test3@baomidou.com'),
(4, 'Sandy', 21, 'test4@baomidou.com'),
(5, 'Billie', 24, 'test5@baomidou.com');
代码详解
1.新建实体类User
lombok注解详解:
@Data:自动生成get\set方法
@AllArgsConstructor :有参方法
@NoArgsConstructor:无参方法
@TableId(value = “id”,type = IdType.AUTO) :给实体设置自增
package com.sh.entity;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.springframework.context.annotation.Primary;
import java.util.Date;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
@TableId(value = "id",type = IdType.AUTO)
private Integer id;
private String name;
private Integer age;
private String email;
private Date createTime;
private Date updateTime;
}
2. 新建mapper包
在mapper包里建UserMappe接口r 继承BaseMapper<实体类>
package com.sh.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sh.entity.User;
import org.springframework.stereotype.Repository;
@Repository
public interface UserMapper extends BaseMapper<User> {
}
3.创建控制层controller:
新建UserController类
package com.sh.controller;
import com.sh.entity.User;
import com.sh.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
@RestController
public class UserController {
@Autowired
private UserMapper userMapper;
//查询 查询所以 null 就是没有条件
@GetMapping("/selectUser")
public List<User> getAll(){
List<User> user = userMapper.selectList(null);
return user;
}
//根据id查询
@GetMapping("/selectById")
public User selectUserById(){
User user = userMapper.selectById(1);
return user;
}
//根据多个id查询 Arrays.asList集合
@GetMapping("/selectByIds")
public List<User> selectUserByIds(){
List<User> user = userMapper.selectBatchIds(Arrays.asList(1,2,3));
return user;
}
//添加
@PostMapping("/insertUser")
public Integer insertUsers(User user){
Integer result = userMapper.insert(user);
return result;
}
//修改 根据id
@PutMapping("/updateUser")
public Integer updateUsers(User user){
Integer result = userMapper.updateById(user);
return result;
}
//删除 根据id
@DeleteMapping("/deleteUser")
public Integer deleteUsers(Integer id){
Integer result = userMapper.deleteById(id);
return result;
}
}
项目结构
注意:添加,修改操作需要数据库和实体设置自增
来源:https://blog.csdn.net/Beyonod/article/details/115318914
标签:MybatisPlus,增删,改查
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
怎么把本地jar包放入本地maven仓库和远程私服仓库
2023-12-05 20:13:00
![](https://img.aspxhome.com/file/2023/8/63088_0s.png)
浅谈java异常处理之空指针异常
2022-07-31 03:12:27
浅谈Java中Int、Integer、Integer.valueOf()、new Integer()之间的区别
2023-10-29 20:08:53
![](https://img.aspxhome.com/file/2023/4/68154_0s.png)
SpringCloud基本Rest微服务工程搭建过程
2023-08-28 16:23:29
![](https://img.aspxhome.com/file/2023/0/63090_0s.png)
C# WinForm导出Excel方法介绍
2022-12-01 13:25:57
JAVA 枚举单例模式及源码分析的实例详解
2022-04-30 23:57:44
springboot嵌套子类使用方式—前端与后台开发的注意事项
2023-09-16 12:37:22
MyBatis中使用$和#所遇到的问题及解决办法
2023-03-25 12:27:55
Java定义泛型方法实例分析
2023-11-20 20:28:22
详解Java编程中protected修饰符与static修饰符的作用
2022-05-11 03:53:17
![](https://img.aspxhome.com/file/2023/9/62959_0s.png)
springboot中.yml文件参数的读取方式
2021-06-20 00:57:51
![](https://img.aspxhome.com/file/2023/3/62413_0s.png)
Java截取字符串的几种方法示例
2023-11-29 12:36:32
![](https://img.aspxhome.com/file/2023/5/60585_0s.png)
C#控制图像旋转和翻转的方法
2023-11-26 08:25:08
Java ArrayList深入源码层分析
2021-10-18 04:12:31
![](https://img.aspxhome.com/file/2023/9/60919_0s.png)
Java异常的处理机制
2023-12-03 15:33:19
![](https://img.aspxhome.com/file/2023/7/71147_0s.png)
SpringBoot上传文件大小受限问题的解决办法
2023-04-19 09:46:16
![](https://img.aspxhome.com/file/2023/9/63629_0s.jpg)
Java 设计模式之责任链模式及异步责任链详解
2021-08-08 19:14:23
![](https://img.aspxhome.com/file/2023/9/72639_0s.png)
Nacos 动态服务发现、配置和服务管理平台初体验
2022-09-10 23:56:53
![](https://img.aspxhome.com/file/2023/2/66222_0s.png)
Spring Boot插件spring tool suite安装及使用详解
2021-12-15 03:29:23
![](https://img.aspxhome.com/file/2023/4/71844_0s.png)
关于Java中BeanMap进行对象与Map的相互转换问题
2023-09-18 07:25:36