<select id="queryId" resultType="map" >
select distinct user_id as userId
,loan_id as loanId
,cust_name as custName
,face_sig_status as faceSigStatus
from face_sig_appointment
where loan_id in
<foreach collection="list" item="employeeId" index="index"
open="(" close=")" separator=",">
#{employeeId}
</foreach>
</select>
如果傳入的集合沒有值,能正常運行嗎?
uj5u.com熱心網友回復:
自己測驗下就知道了轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/109466.html
標籤:MySQL
上一篇:主從復制的時候如何 設定 賬號
