SQL笔记

增删改查语句：入参是多个参数，是个list，最好的实现方法是Java代码里面用一个map接收，sql里面取key,拿到list遍历

例：

<!-- Shaun -->
	<update id="updateUnderwritingStatusByApplicationNumber" parameterClass="java.util.HashMap" >
		update	cssp_relapse_user_info 		
		set  underwriting_status ='0050'
		where  id_cssp_relapse_user_info in (
			select id_cssp_relapse_user_info from  cssp_relapse_user_info crui 
			left join cssp_relapse_application cra on crui.application_no = cra.application_no
			where  cra.application_no in (
				select  cmt.id_cssp_order from cssp_middle_trade cmt where cmt.id_cssp_trade in 
					<iterate property="updateUnderwritingStatusList"  open="(" close=")" conjunction=",">    
	            	 #updateUnderwritingStatusList[]#
	           		</iterate>
			)
		)
	</update>


<!-- shaun -->
	<