a.real_name AS "realName", a.id_card AS "idCard", a.qualified AS "qualified" SELECT qualified FROM sys_idcard a WHERE a.real_name = #{realName} and a.id_card = #{idCard} and a.del_flag != '1' INSERT INTO sys_idcard( id, real_name, id_card, qualified, create_date, create_by, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{realName}, #{idCard}, #{qualified}, #{createDate}, #{createBy}, #{updateBy}, #{updateDate}, #{remarks}, #{delFlag} )