根据id查询
Student byId = studentService.getById(1);
带条件的查询 根据id查询对象
Student one = studentService.lambdaQuery().eq(Student::getSno, 1).one();
查询学生集合
List<Student> list = studentService.list();
带条件的集合查询 根据地址查询所在上海的学生
List<Student> studentList = studentService.lambdaQuery().eq(Student::getAddress, "上海").list();
常见的分页查询
String name = "张三";
Integer current = 1;
Integer size = 10;
IPage<Student> studentIPage = studentService.page(new Page(current,size)
new QueryWrapper<Student>()
like(StrUtil.isNotBlank(name),"name",name));
根据id删除
studentService.removeById(1);
带条件的删除 删除名称为张三 年龄等于15的学生
studentService.lambdaUpdate().eq(Student::getName,"张三").eq(Student::getAge,15).remove();
修改 根据id修改
Student student = new Student();
student.setSno(1);
student.setAddress("上海");
student.setClassName("一年级一班");
studentService.updateById(student);
修改 将学号为1的学生的地址修改为湖南
studentService.lambdaUpdate().set(Student::getAddress,"湖南").eq(Student::getSno,1).update();
< <= > >= <>
lt() le() gt() ge() ne()
查询年龄小于20的学生集合 其他以此内推
List<Student> list1 = studentService.lambdaQuery().lt(Student::getAge, 20).list();