mybatisPlus 的使用

mybatisPlus 的基本使用

一.查询操作

1.查询某表里的所有记录（无条件）
List users = userMapper.selectList(null);

2.根据用户id查询表里的一条记录
QueryWrapper wrapper = new QueryWrapper<>();
wrapper.eq(“username”,“zjh”);
User user = userMapper.selectOne(wrapper);

3.根据某字段进行排序，并且取前10条数据
QueryWrapper wrapper = new QueryWrapper<>();
wrapper.orderByDesc(“Count”).last(“limit 10”);
List tripsSitetosites = tripsSitetositeMapper.selectList(wrapper);

4.自定义联表查询
StationAllMapper.java

//通过区域名字获取该地区的信息
@Select("select s.* ,i.in_count ,o.out_count from station_all s ,trips_instationname i ,trips_outstationname o where s.station_name = i.instation_name and s.station_name = o.outstation_name and o.outstation_name = i.instation_name and s.station_areas = #{areas} ")
public List<StationAllInfo> getOIStaion(String areas);

使用如下
List oiStaion = stationAllMapper.getOIStaion(“字符串”);

二.插入操作

@Test

void insertTeacher(){

for(int i=0;i<15;i++) {
    Teacher teacher = new Teacher();
    teacher.setRealname("庄嘉濠");
    teacher.setAge(22);
    teacher.setGender("男");
    teacher.setPassword(encode);
    teacherMapper.insert(teacher);
}

}

三.更新操作

@Test
void updateTest(){

Student student = new Student();
student.setRealname("只开了名字");
student.setId(28L);
int i = studentMapper.updateById(student);

}

记录我的学习笔记