问题遇到的现象和发生背景
表格cis_t_abroadapply 的实体类是AboardForm,但是在这个SQL语句中返回的AbroadapprovalForm 数据不对
问题相关代码,请勿粘贴截图
@Select("<script>" +
"select a.*,b.deptname,b.name,b.leveltype from cis_t_abroadapply a, user_deptname_view b where a.userid = b.userid " +
"<if test='name!=null and name.length>0 '>" +
" and ( b.name like \"%\"#{name}\"%\" or b.deptname like \"%\"#{name}\"%\" or a.abroadname like \"%\"#{name}\"%\")" +
"</if>" +
"<if test='starttime!=null and starttime.length>0 '>" +
" and a.starttime >= #{starttime} " +
"</if>" +
"<if test='endtime!=null and endtime.length>0 '>" +
" and a.endtime <= #{endtime} " +
"</if>" +
"<if test='addtime!=null and addtime.length>0 '>" +
" and a.addtime >= #{addtime} " +
"</if>" +
"<if test='leveltype!=null and leveltype.length>0 '>" +
" and b.leveltype = #{leveltype} " +
"</if>" +
" and a.status = '3' ORDER BY a.addtime desc"+
"</script>")
Page<AbroadapprovalForm> findAll1(@Param("name") String name,@Param("starttime") String starttime,@Param("endtime") String endtime,@Param("addtime") String addtime,@Param("leveltype") String leveltype);
运行结果及报错内容
在页面上cis_t_abroadapply 表格的内容有显示不全
我的解答思路和尝试过的方法
我想要达到的结果
我在cis_t_abroadapply 表格加的一列数据没显示出来,是因为返回的实体类不对吗?