请教一个问题 关于mybatis的实体传递的问题
关于mybatis 查询多张表的时候传递的实体参数 对应问题
SELECT
a.ID AS "id"
, a.TYPE AS "type"
, a.TITLE AS "title"
, a.CONTENT AS "content"
, a.FILES AS "files"
, a.STATUS AS "status"
, a.CREATE_BY AS "createBy.id"
, a.CREATE_DATE AS "createDate"
, a.UPDATE_BY AS "updateBy.id"
, a.UPDATE_DATE AS "updateDate"
, a.REMARKS AS "remarks"
, a.DEL_FLAG AS "delFlag"
, b.read_num
, b.un_read_num
, a.userId AS "userId"
, a.filesName AS "filesName"
, a.cpcid AS "cpcid"
, r.read_flag AS "readFlag"
FROM oa_notify a
LEFT JOIN
(SELECT r.oa_notify_id
, SUM(CASE WHEN r.read_flag = '1' THEN 1 ELSE 0 END ) read_num
, SUM(CASE WHEN r.read_flag != '1' THEN 1 ELSE 0 END ) un_read_num
FROM oa_notify_record r GROUP BY r.oa_notify_id) b ON b.oa_notify_id = a.id
JOIN oa_notify_record r ON r.oa_notify_id = a.id AND r.user_id = '1'
WHERE a.del_flag = '0' AND a.cpcid = '599a075a2270497cbc62d675f2a1e7ec'
OR a.cpcid IN (SELECT id FROM sys_office a WHERE a.id = '599a075a2270497cbc62d675f2a1e7ec'
OR FIND_IN_SET( '599a075a2270497cbc62d675f2a1e7ec' , a.parent_ids ))
AND a.STATUS = '1' ORDER BY a.update_date DESC
这条sql 查询语句在执行器里面执行是没有任何问题的
使用mybatis执行的时候就会出现错误
这个时候就出现了一个疑惑
这里的三个参数都是使用的同一个
这里是不是因为mybatis的映射关系造成了 后面2个参数 根本就不是取的当前传递过去的实体里面的值