表顺序如下： delete from qrtz_CRON_TRIGGERS where 1=1; delete from qrtz_SIMPLE_TRIGGERS where 1=1; delete from qrtz_TRIGGERS where 1=1; delete from qrtz_JOB_DETAILS where 1=1; delete from qrtz_FIRED_TRIGGERS where 1=1; delete from qrtz_LOCKS where 1=1; delete from qrtz_SCHEDULER_STATE where 1=1; delete from qrtz_BLOB_TRIGGERS where 1=1; delete from qrtz_CALENDARS where 1=1; delete from qrtz_PAUSED_TRIGGER_GRPS where 1=1; delete from qrtz_SIMPROP_TRIGGERS where 1=1; 或者： SET FOREIGN_KEY_CHECKS=0; DELETE FROM `qrtz_locks` where 1=1; DELETE FROM `qrtz_paused_trigger_grps` where 1=1; DELETE FROM `qrtz_scheduler_state` where 1=1; DELETE FROM `qrtz_calendars` where 1=1; DELETE FROM `qrtz_job_details` where 1=1; DELETE FROM `qrtz_triggers` where 1=1; DELETE FROM `qrtz_blob_triggers` where 1=1; DELETE FROM `qrtz_cron_triggers` where 1=1; DELETE FROM `qrtz_simple_triggers` where 1=1; DELETE FROM `qrtz_simprop_triggers` where 1=1; DELETE FROM `qrtz_fired_triggers` where 1=1; SET FOREIGN_KEY_CHECKS=0;
function validate(code) { var factor = [7, 9, 10, 5, 8, 4, 2, 1, 6, 3, 7, 9, 10, 5, 8, 4, 2]; var parity = ['1', '0', 'X', '9', '8', '7', '6', '5', '4', '3', '2']; var sum = 0; var i = 0; if (!/^\d{6}(18|19|20)?\d{2}(0[1-9]|1[012])(0[1-9]|[12]\d|3[01])\d{3}(\d|X)$/i.test(code)) { return false; } for (i = 0; i < 17; i = i + 1) { sum += code.charAt(i) * factor[i]; } return parity[sum % 11] === code[17].toUpperCase(); } 按照算法，严格校验身份证。