同样的sql语句在数据库中能查出结果,但是在java项目中,查不出来
数据库语句:select
d."INST_DATE",
d."PAN",
d."CARD_ACCP_TERM_ID",
d."TERM_SSN",
d."TRANS_TYPE"
from
TBL_N_TXN
d
left join
TBL_MCHT_BASE_INF
m
on m.MAPPING_MCHNTCDTWO=d.CARD_ACCP_ID
where
CARD_ACCP_TERM_ID='47568349'
and
TERM_SSN='000005'
and
CARD_ACCP_ID = '111111111111111'
and TRANS_TYPE='P' and RESP_CODE='00' and REVSAL_FLAG='0'
java语句:select
d."INST_DATE",
d."PAN",
d."CARD_ACCP_TERM_ID",
d."TERM_SSN",
d."TRANS_TYPE"
from
<include refid="tableNameN"></include>
d
left join
<include refid="tableNameMchnt"></include>
m
on m.MAPPING_MCHNTCDTWO=d.CARD_ACCP_ID
where 1=1
<if test="pd.CARD_ACCP_TERM_ID!= null and pd.CARD_ACCP_TERM_ID != ''">
and
(
CARD_ACCP_TERM_ID=#{pd.CARD_ACCP_TERM_ID}
)
</if>
<if test="pd.TERM_SSN!= null and pd.TERM_SSN != ''">
and
(
TERM_SSN=#{pd.TERM_SSN}
)
</if>
<if test="pd.CARD_ACCP_ID!= null and pd.CARD_ACCP_ID != ''">
and
(
CARD_ACCP_ID = #{pd.CARD_ACCP_ID}
)
</if>
and TRANS_TYPE='P' and RESP_CODE='00' and REVSAL_FLAG='0'