mysql外键
//暂时关闭mysql的外键检查功能，foreign_key_checks=0，表示不检查外键string closeforeignkey = set @orig_foreign_key_checks=@@foreign_key_checks, foreign_key_checks=0;integer close = jdbctemplate.update(closeforeignkey);//执行自己的sql语句string branchsql = insert into scpn_branchinfo (branch_id,branch_code,branch_name,branch_secretary,contact_person,branch_create_time,branch_address,email,telephone,office_phone,create_time) values (+presentid+,'+maxcode+', '+branchinfo.getbranchname()+', '+branchinfo.getbranchsecretary()+', '+branchinfo.getcontactperson()+', '+branchcreatetime+', '+branchinfo.getbranchaddress()+','+branchinfo.getemail()+','+branchinfo.gettelephone()+','+branchinfo.getofficephone()+','+currenttime+');jdbctemplate.update(branchsql); //打开mysql的外键检查功能,foreign_key_checks=1，表示检查外键closeforeignkey = set @orig_foreign_key_checks=@@foreign_key_checks, foreign_key_checks=1;integer open = jdbctemplate.update(closeforeignkey);