一个不是很的查询语句用ibatis
1: <select id="getTenderProcess" parameterresultopen="(" close=")" conjunction=",">
<![CDATA[
Trim(#tendermap[].returnItemId#)
]]>
</iterate>
</isNotEmpty>
</select>
2:
<delete id="delete_dbpurge_return_cust" parameterparameter/>
where
return_auth_id = #returnAuthorizationId#
</update>
5：
<select id="queryMiscNOByDivNO" parameterresultclose=")" conjunction=",">
#[]#
</iterate>
</isNotEmpty>
</dynamic>
</select>
6： 这里插点切面
<aop:config>
<aop:advisor
pointcut="execution(* com.shc.rrs.returns.domain.*Impl.*(..))||execution(* com.shc.rrs.returns.dao.*Impl.*(..))"
advice-ref="txAdvice" />
</aop:config>
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="tran*" propagation="REQUIRED" rollback-for="Exception" />
</tx:attributes>
</tx:advice>
7： <select id="getUpdateData" parameterfrom
return_auth a left join auth_update_details b on
a.return_auth_id=b.return_auth_id and b.upd_trans_id = #transId#
where a.return_auth_id = #returnAuthorizationId# and
b.upd_trans_id = null or a.return_auth_id =
#returnAuthorizationId#;
</select>
8： SELECT EML FROM
(
SELECT distinct USR_ID,EML FROM TRP,SITE_SRC_LOC,USR
WHERE
TRP_ID=#tripNumber#
AND
<isEqual property="checkFlag"
compareValue="true">
(TRP.CARR_ID=SITE_SRC_LOC.SCAC_CD OR TRP.DTC_LOC_CARR=SITE_SRC_LOC.SCAC_CD
OR SITE_SRC_LOC.SCAC_CD IN (SELECT RESP_TC FROM TRP_STOP WHERE TRP_ID=#tripNumber#))
</isEqual>
<isNotEqual property="checkFlag"
compareValue="true">
TRP.NEW_DTC=SITE_SRC_LOC.SCAC_CD
</isNotEqual>
AND
(USR.SITE_SRC_ID=SITE_SRC_LOC.SITE_SRC_ID OR USR.SITE_SRC_ID IS NULL)
AND
EML IS NOT NULL
AND
ROLE_ID in
<iterate property="acessLevelList" open="(" close=")" conjunction=",">
$acessLevelList[]$
</iterate>
)
