利用QueryWrapper构造查询条件,组装sql语句
组装查询条件
组装排序查询
单独查询几列
in语句的拼接
inValue中可以传去sql语句,并以结果为值传入
在开发中前端传过来的值通常咱们应该进行判断在接收
StringUtils.isNotBlank("username")判断username不为null,不为”“ 不为空格
@Test
public void aVoid(){
String username = "";
int i = 20;
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.like(StringUtils.isNotBlank("username"),"username","李")
.ge(i>10,"id","3");
for (User user : userMapper.selectList(queryWrapper)) {
System.out.println(user);
}
利用Querwrapper组装删除条件
利用Querwrapper组装修改条件
将数据库中密码为123的全部改为1234
UpdateWrapper修改条件构造器
package icu.lijiaqi.springboot;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import icu.lijiaqi.springboot.mapper.UserMapper;
import icu.lijiaqi.springboot.pojo.User;
import icu.lijiaqi.springboot.service.UserService;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
/**
* @author:LeeGaki
* @date:2022/3/27
*/
@SpringBootTest
public class WrapperTest {
@Autowired
private UserMapper userMapper;
@Autowired
private UserService userService;
@Test
public void aVoid(){
UpdateWrapper<User> updateWrapper = new UpdateWrapper();
updateWrapper.like("password","1234");
updateWrapper.set("password","123");
int update = userMapper.update(null, updateWrapper);
}
}