package com.czxy;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.czxy.domain.Student;
import com.czxy.mapper.StudentMapper;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import javax.annotation.Resource;
import java.beans.Customizer;
import java.util.Arrays;
import java.util.Date;
import java.util.List;
@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest(classes = TestStudentApplication.class)
public class TestMapper_01_student {
@Resource
private StudentMapper studentMapper;
//1.查询所有
@Test
public void selectAll(){
List<Student> list = studentMapper.selectList(null);
list.forEach(System.out::println);
}
//1.1分页查询
@Test
public void testPage(){
int current=1;
int size=3;
Page<Student> page = new Page<>(current, size);
studentMapper.selectPage(page, null);
System.out.println("总共记录数:"+page.getRecords());
page.getRecords().forEach(System.out::println);
}
//1.2分页条件查询
@Test
public void testPageByCondition(){
//条件
String sname="三";
int age=18;
QueryWrapper<Student> queryWrapper = new QueryWrapper<>();
//姓名中包含三的 且年龄大于等于19的
queryWrapper.like(sname!=null&&!"".equals(sname),"sname",sname);
queryWrapper.ge("age",age);
//分页
int current=1;
int size=3;
Page<Student> page = new Page<>(current, size);
//查询
studentMapper.selectPage(page, queryWrapper);
page.getRecords().forEach(System.out::println);
}
//2.添加
@Test
public void insertStudent(){
Student student = new Student();
student.setSid("s007");
student.setSname("lihua");
int insert = studentMapper.insert(student);
System.out.println(insert);
}
//3.修改
@Test
public void updateStudent(){
//要修改成这个信息
Student student = new Student("s003", "赵san三", 19, new Date(), '0', "c001");
//不能修改成重名的
UpdateWrapper<Student> queryWrapper = new UpdateWrapper<>();
queryWrapper.ne("s_id",student.getSid());
queryWrapper.eq("sname",student.getSname());
Student selectOne = studentMapper.selectOne(queryWrapper);
System.out.println(selectOne);
if(selectOne!=null){
//改成和别人重名了
System.err.println("修改失败了");
}else {
//更新
// studentMapper.update(student, queryWrapper);
studentMapper.updateById(student);
System.out.println("修改成功了");
}
}
//4.删除
@Test
public void deleteStudent(){
int i = studentMapper.deleteById("s007");
System.out.println(i);
}
//批量删除
@Test
public void deleteBatchs(){
studentMapper.deleteBatchIds(Arrays.asList("s007","s008","s009"));
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
java中MybatisPlus中常见的案例,通用Mapper通用Service,以及XML书写SQL语句进行增删改查常见操作
![preview](https://csdnimg.cn/release/downloadcmsfe/public/img/white-bg.ca8570fa.png)
共26个文件
class:10个
java:10个
xml:3个
![preview-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/scale.ab9e0183.png)
需积分: 0 2 下载量 190 浏览量
更新于2022-06-14
1
收藏 25KB RAR 举报
基于java的高级知识, 对Mybatis+SpringBoot+Restful风格的增强其中MybatisPlus中常见的案例,通用Mapper通用Service,以及XML书写SQL语句进行增删改查常见操作
收起资源包目录
![package](https://csdnimg.cn/release/downloadcmsfe/public/img/package.f3fc750b.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
共 26 条
- 1
资源推荐
资源预览
资源评论
![](https://csdnimg.cn/release/downloadcmsfe/public/img/starY.0159711c.png)
115 浏览量
136 浏览量
2017-01-04 上传
154 浏览量
2018-09-30 上传
189 浏览量
![](https://csdnimg.cn/release/downloadcmsfe/public/img/starY.0159711c.png)
![](https://csdnimg.cn/release/downloadcmsfe/public/img/starY.0159711c.png)
2020-04-04 上传
2015-08-19 上传
2016-03-20 上传
153 浏览量
2024-03-23 上传
2018-08-21 上传
2018-04-04 上传
![](https://csdnimg.cn/release/downloadcmsfe/public/img/starY.0159711c.png)
2017-12-04 上传
2018-07-18 上传
2019-09-07 上传
2018-12-06 上传
2018-10-04 上传
177 浏览量
2019-06-15 上传
2018-05-04 上传
![](https://csdnimg.cn/release/downloadcmsfe/public/img/starY.0159711c.png)
124 浏览量
2017-10-12 上传
资源评论
![avatar-default](https://csdnimg.cn/release/downloadcmsfe/public/img/lazyLogo2.1882d7f4.png)
![avatar](https://profile-avatar.csdnimg.cn/cdba170a3eba4887b8cc1b80f0a3168e_m0_66379583.jpg!1)
扇贝壳
- 粉丝: 8
- 资源: 3
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![voice](https://csdnimg.cn/release/downloadcmsfe/public/img/voice.245cc511.png)
![center-task](https://csdnimg.cn/release/downloadcmsfe/public/img/center-task.c2eda91a.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![dialog-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/green-success.6a4acb44.png)