ID, STATUS , CREATE_TIME, CONTENT #{id}, case when #{status} is null then '0' else '1' end, #{createTime}, #{content} and STATUS = #{status} and CREATE_TIME = #{createTime} and CONTENT = #{content} select from bis_insp_qrcode_login where ID = #{id} select from bis_insp_qrcode_login select from bis_insp_qrcode_login select from bis_insp_qrcode_login select count(ID) from bis_insp_qrcode_login insert into bis_insp_qrcode_login( ) values ( ) delete from bis_insp_qrcode_login where ID = #{id} delete from bis_insp_qrcode_login update bis_insp_qrcode_login set flag_valid = 0 where ID = #{id} update bis_insp_qrcode_login STATUS = #{status}, CREATE_TIME = #{createTime}, CONTENT = #{content}, ID = #{id} update bis_insp_qrcode_login STATUS = #{status}, CREATE_TIME = #{createTime}, CONTENT = #{content},