cz596738622 2016-05-27 11:33 采纳率: 75%
浏览 6203
已采纳

mybatis如何处理返回实体类屏蔽null

sql和配置 添加callSettersOnNulls这个属性没起作用

 <select id="selectClassIdByUserId" resultType="entity.SysClass" parameterType="java.lang.Long">
    select tc.class_id,c.`name` from(
    select * from sys_teacher where user_id = #{user_id,jdbcType=BIGINT}) t left join 
    sys_teacher_class_subject tc on t.id = tc.teacher_id 
    left join sys_class c ON tc.class_id = c.id
    where c.`status` = 1
  </select>
<settings>
        <setting name="cacheEnabled" value="true" />  
        <setting name="lazyLoadingEnabled" value="true" />  
        <setting name="multipleResultSetsEnabled" value="true" />  
        <setting name="useColumnLabel" value="true" />  
        <setting name="useGeneratedKeys" value="false" />
        <setting name="defaultExecutorType" value="SIMPLE" />  
        <setting name="callSettersOnNulls" value="true" />  
    </settings>

返回的LIST

List<SysClass> classList = classs.selectClassIdByUserId(Long.parseLong(uid));结果如下:

  [SysClass [id=null, name=小学二年级(1)班, schoolId=null, school=null, gradeId=null, remark=null, academicYear=null, status=null, chargeTeacherId=null, grade=null, chargeTeacher=null, students=null], SysClass [id=null, name=小学二年级(2)班, schoolId=null, school=null, gradeId=null, remark=null, academicYear=null, status=null, chargeTeacherId=null, grade=null, chargeTeacher=null, students=null]]
  • 写回答

4条回答 默认 最新

  • 凌岩歌-贰拾肆 2016-05-29 07:39
    关注

    你查询返回的是实体类,但Sql只查询2个字段,其他没查询的字段默认值就是null,如果不想为null,那就赋值为空串,就是""

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(3条)

报告相同问题?