1 原sql:SELECT * FROM sys_role sr,sys_role_dept srd,sys_user_role sur WHERE sr.role_id = sur.role_id AND sr.role_id = srd.role_id AND sur.user_id = #{userId} 处理后:SELECT * FROM sys_role sr, sys_role_dept srd, sys_user_role sur WHERE sr.role_id = sur.role_id AND sr.role_id = srd.role_id AND sur.user_id = ? AND (srd.dept_id = 105) AND (srd.dept_id = 105) AND (srd.dept_id = 105) 2 原sql:SELECT * FROM sys_role sr INNER JOIN sys_role_dept srd on sr.role_id = srd.role_id INNER JOIN sys_user_role sur on sr.role_id = sur.role_id WHERE sur.user_id = #{userId} 处理后:SELECT * FROM sys_role sr INNER JOIN sys_role_dept srd ON sr.role_id = srd.role_id AND (srd.dept_id = 105) AND (srd.dept_id = 105) INNER JOIN sys_user_role sur ON sr.role_id = sur.role_id AND (srd.dept_id = 105) WHERE sur.user_id = ?

Comment From: nieqiurong

详细描述,期望是什么,补充提供复现工程