MyBatisPlus搭建教程

简介

搭建MyBatisPlus2.x

构建项目

配置Maven

引入依赖

springboot

  		<dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId></dependency><dependency><groupId>com.alibaba</groupId><artifactId>druid-spring-boot-starter</artifactId><version>1.2.18</version></dependency><dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>2.1.4</version></dependency>

配置springboot

数据库搭建

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Book {private Integer id;private String title;private String author;private String price;private String descx;
}

---

表名

---

搭建测试环境

添加修改测试

查询数据

LambdaQueryWrapper<Book> queryWrapper = new LambdaQueryWrapper<>();
// queryWrapper.like(Book::getAuthor, "吴");
queryWrapper.eq(Book::getAuthor,"吴承恩").eq(Book::getTitle,"西游记");
System.out.println(mapper.selectList(queryWrapper));

常用方法

eq 相等
in 范围查询
like 模糊查询
likeRight 右侧通配符查询
likeLeft 左侧通配符查询
or() 或
r.selectList(queryWrapper));

### 常用方法eq 相等
in 范围查询
like 模糊查询
likeRight 右侧通配符查询
likeLeft 左侧通配符查询
or() 或
and() 并且