先去看了实体类,没有问题。
无法调用xml,查看xml的时候发现
错误应该是在if test=
验证的时候发生的,百度了下,如果是验证String类型的参数的话,接参应该用_parameter
<if test="_parameter != null and _parameter != ''">
改完之后
<select id="selectPlanDeptListOutConform" parameterType="com.ibp.report.domain.PlanDept" resultMap="PlanDeptResult">
select id, planid, deptkey,
(select c2.ORGANname from T00_ORGAN c1, T00_ORGAN c2
where c1.upORGANkey=c2.ORGANkey and c1.ORGANkey=deptkey)||deptname deptname, status
from T21_rpt_plan_dept
where 1=1
<if test="_parameter != null and _parameter != ''">
and planid = #{planId}
and deptkey not in (select c1.createdeptid
from t21_rpt_conform c1,T21_rpt_plan c2
where c2.planid=c1.planid and c2.planid = #{planId}
)
</if>
</select>