请教个问题,在mapper中的动态sql中<if test="#{loginUser.user_id} == 'wangty55'.toString()">比对失败,其中传的值绝对是正确的,是不是写发有问题,以下是具体的代码: <select id="select_cust_product_all" parameterType="Map" resultMap="select_cust_product_all_map">
SELECT
c.*, d.product_status
FROM
(
SELECT
a.cust_id,
a.cust_name,
a.lt_manager_name,
a.department_name,
b.product_id,
b.industry_id
FROM
t_sj_cust a,
t_sj_industry_product b
WHERE
a.industry_id = #{industry_id}
AND b.industry_id IN (#{industry_id}, '12')
<if test="#{loginUser.user_id} == 'wangty55'.toString()">
AND a.lt_manager_id = 'wangty55'</if>
) c
LEFT JOIN t_sj_cust_product_status d ON c.cust_id = d.cust_id
AND c.product_id = d.product_id
</select>
SELECT
c.*, d.product_status
FROM
(
SELECT
a.cust_id,
a.cust_name,
a.lt_manager_name,
a.department_name,
b.product_id,
b.industry_id
FROM
t_sj_cust a,
t_sj_industry_product b
WHERE
a.industry_id = #{industry_id}
AND b.industry_id IN (#{industry_id}, '12')
<if test="#{loginUser.user_id} == 'wangty55'.toString()">
AND a.lt_manager_id = 'wangty55'</if>
) c
LEFT JOIN t_sj_cust_product_status d ON c.cust_id = d.cust_id
AND c.product_id = d.product_id
</select>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货