mybati-splus的EntityWrapper拼接sql并按照设置的column返回对应的字段

程序框架spring-boot

拼接sql，注意or语句的写法

@Service public class StudentsMainServiceImpl extends ServiceImpl<StudentsMainDao, StudentsMain> implements StudentsMainService { @Autowired StudentsMainDao studentsMainDao; @Override public List<Map<String,Object>> matchStudents(Map<String, Object> params) { String phone = params.get("fdUserCode").toString(); EntityWrapper<StudentsMain> wrapper = new EntityWrapper(); wrapper.setSqlSelect("FD_NO","STUDENT_NAME","NOW_GRADE","FD_ID"); wrapper.like("FATHER_MOBILE", phone).or().like("MOTHER_MOBILE", phone); List<Map<String,Object>> reList = this.selectMaps(wrapper); return reList; }

接口测试返回的结果

{ "msg": "查询成功", "code": 0, "data": "[{\"NOW_GRADE\":\"初中三年级 \",\"FD_ID\":\"1\",\"FD_NO\":\"00001\",\"STUDENT_NAME\":\"张晓\"},{\"NOW_GRADE\":\"高中一年级\",\"FD_ID\":\"2\",\"FD_NO\":null,\"STUDENT_NAME\":\"萨克森\"}]" }

后台打印的sql

但是之前经历了一点我还没有搞明白

@Service public class StudentsMainServiceImpl extends ServiceImpl<StudentsMainDao, StudentsMain> implements StudentsMainService { @Autowired StudentsMainDao studentsMainDao; @Override public List<StudentsMain> matchStudents(Map<String, Object> params) { String phone = params.get("fdUserCode").toString(); EntityWrapper<StudentsMain> wrapper = new EntityWrapper(); wrapper.setSqlSelect("FD_NO","STUDENT_NAME","NOW_GRADE","FD_ID"); wrapper.like("FATHER_MOBILE", phone).or().like("MOTHER_MOBILE", phone); List<StudentsMain> reList = this.selectList(wrapper); return reList; } }

虽然设置了要返回的字段属性

但是接口测试返回的是：

{ "msg": "查询成功", "code": 0, "data": "[{\"fatherName\":\"\",\"fdTeacherChargeId\":\"\",\"fdSex\":\"\",\"fdGrade\":\"\",\"fdRemark\":\"\",\"fdStatus\":0,\"fdCreateTime\":null,\"fdBirthday\":\"\",\"fatherMobile\":\"\",\"fdCustId\":\"\",\"fdCreateId\":\"\",\"fdId\":\"1\",\"fdSchoolidId\":\"\",\"fdPublicClass\":\"\",\"nowGrade\":\"初中三年级\",\"fdPublicSchool\":\"\",\"motherMobile\":\"\",\"motherName\":\"\",\"fdAge\":0,\"fdAlterTime\":null,\"fdNo\":\"00001\",\"informationOrigin\":\"\",\"fdCustMobile\":\"\",\"fdCustName\":\"\",\"studentName\":\"张晓\",\"fdAlterId\":\"\"},{\"fatherName\":\"\",\"fdTeacherChargeId\":\"\",\"fdSex\":\"\",\"fdGrade\":\"\",\"fdRemark\":\"\",\"fdStatus\":0,\"fdCreateTime\":null,\"fdBirthday\":\"\",\"fatherMobile\":\"\",\"fdCustId\":\"\",\"fdCreateId\":\"\",\"fdId\":\"2\",\"fdSchoolidId\":\"\",\"fdPublicClass\":\"\",\"nowGrade\":\"高中一年级\",\"fdPublicSchool\":\"\",\"motherMobile\":\"\",\"motherName\":\"\",\"fdAge\":0,\"fdAlterTime\":null,\"fdNo\":\"\",\"informationOrigin\":\"\",\"fdCustMobile\":\"\",\"fdCustName\":\"\",\"studentName\":\"萨克森\",\"fdAlterId\":\"\"}]" }

也就是说它把所有字段都返回了，后台打印的sql