mybatisplus查詢練習代碼

package com.yase;import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.yase.entity.Student;
import com.yase.entity.Teacher;
import com.yase.mapper.StudentMapper;
import com.yase.mapper.TeacherMapper;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;import javax.annotation.Resource;
import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;@SpringBootTest
public class TestSelect {@Resourceprivate TeacherMapper mapper;@Resourceprivate StudentMapper studentMapper;@Testpublic void selectById(){Teacher teacher = mapper.selectById(105);System.out.println(teacher);}@Testpublic void selectByIds(){List<Teacher> list = mapper.selectBatchIds(Arrays.asList(105, 106, 107));list.forEach(System.out::println);}@Testpublic void selectByMap(){Map<String,Object> map = new HashMap<>();map.put("teacher_name","李四");map.put("gender","女");List<Teacher> list = mapper.selectByMap(map);list.forEach(System.out::println);}@Testpublic void exists(){QueryWrapper<Teacher> wrapper = new QueryWrapper<>();wrapper.eq("teacher","張三");boolean exists = mapper.exists(wrapper);System.out.println(exists);}@Testpublic void count(){QueryWrapper<Teacher> wrapper =new QueryWrapper<>();wrapper.like("teacher_name","張");Long aLong = mapper.selectCount(wrapper);System.out.println(aLong);}@Testpublic void selectMaps(){QueryWrapper<Teacher> wrapper = new QueryWrapper<>();wrapper.like("teacher","張");List<Map<String, Object>> list = mapper.selectMaps(wrapper);list.forEach(map->map.forEach((key,value) -> System.out.println(key+" "+value)));}//只返回第一個字段的值@Testpublic void selectObjs(){QueryWrapper<Teacher> wrapper = new QueryWrapper<>();wrapper.like("teacher_name","張");List<Object> objects = mapper.selectObjs(wrapper);objects.forEach(System.out::println);}@Testpublic void selectList() {//查詢全部數據，返回list<teacher>List<Teacher> list = mapper.selectList(null);list.forEach(System.out::println);}//and查詢方式@Testpublic void selectList1() {QueryWrapper<Teacher> wrapper = new QueryWrapper<>();wrapper.like("teacher_name", "張").eq("gender", "女");List<Teacher> list = mapper.selectList(wrapper);list.forEach(System.out::println);}//or查詢方式@Testpublic void selectList2() {QueryWrapper<Teacher> wrapper = new QueryWrapper<>();wrapper.like("teacher_name", "張").or().eq("gender", "女");List<Teacher> list = mapper.selectList(wrapper);list.forEach(System.out::println);}//查詢性別是女，并且年齡大于23的女性@Testpublic void selectList3() {QueryWrapper<Teacher> wrapper = new QueryWrapper<>();wrapper.like("teacher_name", "張").eq("gender", "女").or().gt("age", 23);List<Teacher> list = mapper.selectList(wrapper);list.forEach(System.out::println);}//查詢性張，并且（性別是女年齡大于23的女性）用and包括@Testpublic void selectList4() {QueryWrapper<Teacher> wrapper = new QueryWrapper<>();wrapper.likeRight("teacher_name", "張").and(i -> i.eq("gender", "女").or().gt("age", 23));List<Teacher> list = mapper.selectList(wrapper);list.forEach(System.out::println);}//按照年齡排序,相同用id降序排序@Testpublic void selectListOrderBy() {QueryWrapper<Teacher> wrapper = new QueryWrapper<>();wrapper.orderByDesc("age").orderByDesc("id");List<Teacher> list = mapper.selectList(wrapper);list.forEach(System.out::println);}//子查詢@Testpublic void selectListSub() {QueryWrapper<Student> wrapper = new QueryWrapper<>();wrapper.inSql("tid", " select id from teacher where teacher_name = '張老師'");List<Student> students = studentMapper.selectList(wrapper);students.forEach(System.out::println);}//分頁插件@Testpublic void selectPage() {//需要在構造方法里傳入2個參數，一個頁碼，一個每頁數量Page<Student> page = new Page<>(1, 5);QueryWrapper<Student> wrapper = new QueryWrapper<>();wrapper.likeRight("student_name", "李");//page里真正的數據List<Student> records = page.getRecords();records.forEach(System.out::println);studentMapper.selectPage(page, wrapper);System.out.println("總記錄數：" + page.getTotal() +"總頁數" + page.getPages() +"當前頁數" + page.getCurrent() +"每頁顯示" + page.getSize() + "條數據" +"是否有上一頁" + page.hasPrevious() +    //bollean"是否有下一頁" + page.hasNext()         //bollean);}@Testpublic void selectMapsPage(){Page<Map<String,Object>> page = new Page<>(1, 5);QueryWrapper<Student> wrapper = new QueryWrapper<>();wrapper.likeRight("student_name", "李");studentMapper.selectMapsPage(page, wrapper);//page里真正的數據List<Map<String,Object>> records = page.getRecords();records.forEach(map->map.forEach((key,value)-> System.out.println(key+" "+value)));System.out.println("總記錄數：" + page.getTotal() +"總頁數" + page.getPages() +"當前頁數" + page.getCurrent() +"每頁顯示" + page.getSize() + "條數據" +"是否有上一頁" + page.hasPrevious() +    //bollean"是否有下一頁" + page.hasNext()         //bollean);}//自定義查詢@Testpublic void selectCustomer(){List<Student> list = studentMapper.selectCustomer();list.forEach(System.out::println);}}