package ay.zk; import java.sql.Connection; import ay.db.ConnTools; import ay.db.DbUtil; public class Zk_ayjxjy_zk_czc { /********************* 河南周口出租车， 河南项城， 河南汝州，湖北潜江 1. 所有题库图片转阿里云 2. 所有登记照片转阿里云 3. 所有培训记录照片转阿里云 4.建运管 ，建驾校，挂运管 出租车 的视频方案和题库 ********************/ //导周口出租车 新版oracle 到新版ppas public static void main(String args[]) { try { String tfc_id="42900501"; String ay_id="42900502"; String zid="429005"; //String del_where=" 1<>1 and "; String del_where=" "; Connection conn_oracle_ayjxjy = ConnTools.make_oracle_ayjxjy_zk_czc_conn(); Connection conn_ppas_ayjxjy = ConnTools.make_ppas_ayjxjy_conn(); DbUtil d = new DbUtil(); //导入出租车相关设置 //d.update(conn_ppas_ayjxjy, "update res_questions set tid=(select id from res_TEACH_PROJECT where ) where "); // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "res_questions", // "select ID,CONTENT,ANSWER_CONTENT,ANSWER,IMAGE_URL,TYPE,IS_USE,TID,CREATE_TIME,CREATE_UID,ZID from res_questions where tid in (select id from res_teach_project where case_type='出租车驾驶员' )", // "insert into res_questions(ID,CONTENT,ANSWER_CONTENT,ANSWER,IMAGE_URL,TYPE,IS_USE,TID,CREATE_TIME,CREATE_UID,ZID)", // "delete from res_questions where tid in (select id from res_teach_project where case_type='出租车驾驶员' )"); //出租车题库 // // // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "res_teach_project", // "select ID,NAME,CONTENT,TARGET,STATUS,KM,TYPE,MODEL,CREATE_TIME,CREATE_UID,CASE_TYPE from res_teach_project where case_type='出租车驾驶员' ", // "insert into res_teach_project(ID,NAME,CONTENT,TARGET,STATUS,KM,TYPE,MODEL,CREATE_TIME,CREATE_UID,CASE_TYPE)", // "delete from res_teach_project where case_type='出租车驾驶员' " );//出租车教学计划 // // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "res_video_file", // "select ID,DELETED,VIDEO_TIME,FILE_NAME,CREATE_UID,CREATE_DATE,UPDATE_UID,UPDATE_DATE,V_TYPE,KU6_VID,KU6_STYLE,KU6_PATH,LS_VU,LS_UU,LS_VID from res_video_file where file_name like 'czc%' ", // "insert into res_video_file(ID,DELETED,VIDEO_TIME,FILE_NAME,CREATE_UID,CREATE_DATE,UPDATE_UID,UPDATE_DATE,V_TYPE,KU6_VID,KU6_STYLE,KU6_PATH,LS_VU,LS_UU,LS_VID)", // "delete from res_video_file where file_name like 'czc%' ");//出租车视频 // // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_cases", // "select ID,CASE_TYPE,CODE,DESCRIPTION,WEIGHT,IS_USE,TFC_ID,CREATE_TIME,CHANGE_TIME,NEED_TIME,IS_JZPX from sys_cases where ", // "insert into sys_cases(ID,CASE_TYPE,CODE,DESCRIPTION,WEIGHT,IS_USE,TFC_ID,CREATE_TIME,CHANGE_TIME,NEED_TIME,IS_JZPX)", // "delete from sys_cases where ay_id like '"+zid+"%'");//出租车 手工挂 // // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_case_detail", // "select ID,CASE_ID,CODE,KM,CONTENT,TIME_TYPE,WEIGHT,P_ID,NEED_TIME,TFC_ID,CREATE_TIME,CHANGE_TIME,VF_ID,VIDEO_NAME,UNIT_WEIGHT from sys_case_detail where code='czc' ", // "insert into sys_case_detail(ID,CASE_ID,CODE,KM,CONTENT,TIME_TYPE,WEIGHT,P_ID,NEED_TIME,TFC_ID,CREATE_TIME,CHANGE_TIME,VF_ID,VIDEO_NAME,UNIT_WEIGHT)", // "delete from sys_case_detail where code='czc' ");//出租车有无 // // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "BASE_COACHES", // "select ID,TFC_ID,AY_ID,NAME,SEX,NATION_TYPE,BIRTHDAY,SFZ_NO,SFZ_ADDRESS,DRV_CARTYPE,REMARK,PIC,STATE,CREATE_USER_ID,CREATE_USER_NAME,CREATE_TIME,FLAG,ORIGIN from BASE_COACHES where ay_id like '"+zid+"%'", // "insert into BASE_COACHES(ID,TFC_ID,AY_ID,NAME,SEX,NATION_TYPE,BIRTHDAY,SFZ_NO,SFZ_ADDRESS,DRV_CARTYPE,REMARK,PIC,STATE,CREATE_USER_ID,CREATE_USER_NAME,CREATE_TIME,FLAG,ORIGIN)", // "delete from BASE_COACHES where ay_id like '"+zid+"%'"); // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "base_std_archives", // "select ID,AY_ID,NAME,SEX,CREDENTIALS_TYPE,CREDENTIALS_NO,BIRTHDAY,ADDRESS,NOW_ADDRESS,LANDLINE,PHONE,ZIP_CODE,PIC,VEHICLE_TYPE,STATE,REMARK,CREATE_SCHOOL_ID,CREATE_SCHOOL_NAME,CREATE_USER_ID,CREATE_USER_NAME,CREATE_TIME,MODIFY_USER_ID,MODIFY_USER_NAME,MODIFY_TIME,NATIONALITY,NATION,SOURCE,ZID,USER_ID from base_std_archives where id in ( select stdt_id from tr_period_jxjy where ay_id like '"+zid+"%') ", // "insert into base_std_archives(ID,AY_ID,NAME,SEX,CREDENTIALS_TYPE,CREDENTIALS_NO,BIRTHDAY,ADDRESS,NOW_ADDRESS,LANDLINE,PHONE,ZIP_CODE,PIC,VEHICLE_TYPE,STATE,REMARK,CREATE_SCHOOL_ID,CREATE_SCHOOL_NAME,CREATE_USER_ID,CREATE_USER_NAME,CREATE_TIME,MODIFY_USER_ID,MODIFY_USER_NAME,MODIFY_TIME,NATIONALITY,NATION,SOURCE,ZID,USER_ID) ", // "delete from base_std_archives where "+del_where+" id in ( select stdt_id from tr_period_jxjy where ay_id like '"+zid+"%')"); //// ////// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "base_std_extend", ////// "select ID,STDT_ID,CASE_CODE,CASE_NAME,CASE_TYPE,CASE_NO,CREATE_TIME,CHANGE_TIME,LATEST_OVER_TIME,FIRST_TIME from base_std_extend where stdt_id in ( select stdt_id from tr_period_jxjy where ay_id like '"+zid+"%')", ////// "insert into base_stdt_extend(ID,STDT_ID,CASE_CODE,CASE_NAME,CASE_TYPE,CASE_NO,CREATE_TIME,CHANGE_TIME,LATEST_OVER_TIME,FIRST_TIME)", ////// "delete from base_std_extend where "+del_where+" stdt_id in ( select stdt_id from tr_period_jxjy where ay_id like '"+zid+"%')"); //// ////// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "personal_message", "select from personal_message where ","insert into personal_message()","delete from personal_message where ay_id like '"+zid+"%'"); //// //// ////// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_authorization", "select from sys_authorization where ","insert into sys_authorization()","delete from sys_authorization where ay_id like '"+zid+"%'"); ////// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_autocode", "select from sys_autocode where ","insert into sys_autocode()","delete from sys_autocode where ay_id like '"+zid+"%'"); //sys_autocode 取最大值 //// // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_card", // "select ID,CARD_CODE,PASSWORD,STATE,VALID_TIME,BIND_TIME,ACTIVE_DATE,OVER_DATE,CARD_TYPE,BOX_NO,ZID from sys_card where box_no in (select box_no from sys_card_box where zid like '"+zid+"%') ", // "insert into sys_card(ID,CARD_CODE,PASSWORD,STATE,VALID_TIME,BIND_TIME,ACTIVE_DATE,OVER_DATE,CARD_TYPE,BOX_NO,ZID)", // "delete from sys_card where "+del_where+" box_no in (select box_no from sys_card_box where zid like '"+zid+"%') "); // // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_card_box", // "select ID,BOX_NO,STATE,BATCH_NO,CARD_CODE_BEG,CARD_CODE_END,CARD_COUNT,USER_ID,CREATE_DATE,ZID,ZNAME from sys_card_box where zid like '"+zid+"%' ", // "insert into sys_card_box(ID,BOX_NO,STATE,BATCH_NO,CARD_CODE_BEG,CARD_CODE_END,CARD_COUNT,USER_ID,CREATE_DATE,ZID,ZNAME)", // "delete from sys_card_box where "+del_where+" zid like '"+zid+"%'"); //// ////// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_card_index", ////// "select ID,ZID,BOX_INDEX,CARD_INDEX from sys_card_index where zid like '"+zid+"%' ", ////// "insert into sys_card_index(ID,ZID,BOX_INDEX,CARD_INDEX)", ////// "delete from sys_card_index where zid like '"+zid+"%'"); ////// ////// ////// d.update(conn_ppas_ayjxjy, "update sys_case_detail a set a.case_id=b.id from sys_cases b where b.tfc_id like '"+zid+"%' "); ////// ////// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_dict", "select from sys_dict where ","insert into sys_dict()","delete from sys_dict where ay_id like '"+zid+"%'"); ////// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_function", "select from sys_function where ","insert into sys_function()","delete from sys_function where ay_id like '"+zid+"%'"); ////// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_message", "select from sys_message where ","insert into sys_message()","delete from sys_message where ay_id like '"+zid+"%'"); ////// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_organization", "select from sys_organization where ","insert into sys_organization()","delete from sys_organization where ay_id like '"+zid+"%'"); ////// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_param", "select from sys_param where ","insert into sys_param()","delete from sys_param where ay_id like '"+zid+"%'"); ////// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_role", "select from sys_role where ","insert into sys_role()","delete from sys_role where ay_id like '"+zid+"%'"); ////// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_school", "select from sys_school where ","insert into sys_school()","delete from sys_school where ay_id like '"+zid+"%'"); //// ////// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_school_case", ////// "select ID,SCH_AYID,CASE_CODE from sys_school_case where ", ////// "insert into sys_school_case(ID,SCH_AYID,CASE_CODE)", ////// "delete from sys_school_case where ay_id like '"+zid+"%'"); // 取最大值 //// // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_std_delete_log_jxjy", // "select ID,SFZ_NO,CARD_CODE,DELETE_USER_ID,DELETE_USER_NAME,REMARK,DELETE_DATE,AY_ID from sys_std_delete_log_jxjy where ay_id like '"+zid+"%' ", // "insert into sys_std_delete_log_jxjy(ID,SFZ_NO,CARD_CODE,DELETE_USER_ID,DELETE_USER_NAME,REMARK,DELETE_DATE,AY_ID)", // "delete from sys_std_delete_log_jxjy where "+del_where+" ay_id like '"+zid+"%'"); //// ////// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_train_rule", "select from sys_train_rule where ","insert into sys_train_rule()","delete from sys_train_rule where ay_id like '"+zid+"%'"); //// // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_user", // "select ID,SFZ_NO,CARD_CODE,DELETE_USER_ID,DELETE_USER_NAME,REMARK,DELETE_DATE,AY_ID from sys_user where id in (select a.id from sys_user a,base_std_archives b,tr_period_jxjy c where a.id=b.user_id and b.id=c.stdt_id and c.ay_id like '"+zid+"%') ", // "insert into sys_user(ID,SFZ_NO,CARD_CODE,DELETE_USER_ID,DELETE_USER_NAME,REMARK,DELETE_DATE,AY_ID)", // "delete from sys_user where "+del_where+" id in (select a.id from sys_user a,base_std_archives b,tr_period_jxjy c where a.id=b.user_id and b.id=c.stdt_id and c.ay_id like '"+zid+"%')"); // // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_user_pay", // "select ID,TP_ID,PAY_TYPE,PAY_ID from sys_user_pay where id in (select a.id from sys_user_pay a,tr_period_jxjy b where a.tp_id=b.id and b.ay_id like '"+zid+"%')", // "insert into sys_user_pay(ID,TP_ID,PAY_TYPE,PAY_ID)", // "delete from sys_user_pay where "+del_where+" id in (select a.id from sys_user_pay a,tr_period_jxjy b where a.tp_id=b.id and b.ay_id like '"+zid+"%')"); // //// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_user_role", "select from sys_user_role where ","insert into sys_user_role()","delete from sys_user_role where ay_id like '"+zid+"%'"); //// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_webservice_log", "select from sys_webservice_log where ","insert into sys_webservice_log()","delete from sys_webservice_log where ay_id like '"+zid+"%'"); //// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_yunguan", "select from sys_yunguan where ","insert into sys_yunguan()","delete from sys_yunguan where ay_id like '"+zid+"%'"); //// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_yunguan_school", "select from sys_yunguan_school where ","insert into sys_yunguan_school()","delete from sys_yunguan_school where ay_id like '"+zid+"%'"); //// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_zones", "select from sys_zones where ","insert into sys_zones()","delete from sys_zones where ay_id like '"+zid+"%'"); //// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_zone_site", "select from sys_zone_site where ","insert into sys_zone_site()","delete from sys_zone_site where ay_id like '"+zid+"%'"); //// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "sys_zone_teachproject", "select from sys_zone_teachproject where ","insert into sys_zone_teachproject()","delete from sys_zone_teachproject where ay_id like '"+zid+"%'"); //// //// //发送继续教育培训结果 //// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_case_type_detail_jxjy", //// "select ID,TP_ID,YZ_ID,CASE_NO,CASE_TYPE,FIRST_TIME,SFZ_NO,CREATE_TIME,EFFECT_BEGIN_TIME,EFFECT_END_TIME,UPLOAD_FLAG,DATA_VER from tr_case_type_detail_jxjy where yz_id like '"+zid+"%'", //// "insert into tr_case_type_detail_jxjy(ID,TP_ID,YZ_ID,CASE_NO,CASE_TYPE,FIRST_TIME,SFZ_NO,CREATE_TIME,EFFECT_BEGIN_TIME,EFFECT_END_TIME,UPLOAD_FLAG,DATA_VER)", //// "delete from tr_case_type_detail_jxjy where "+del_where+" yz_id like '"+zid+"%'"); //// // //学员培训类型 // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_case_type_jxjy", // "select ID,TP_ID,YZ_ID,CASE_NAME,CASE_NO,SFZ_NO,FIRST_TIME,EFFECT_BEGIN_TIME,EFFECT_END_TIME,DATA_VER,CASE_CODE,CASE_TYPE,UPLOAD_FLAG,IS_NEED,STATUS,CYZ_NO,TCT_ID_LL from tr_case_type_jxjy where id in (select a.id from tr_case_type_jxjy a,tr_period_jxjy b where a.tp_id=b.id and b.ay_id like '"+zid+"%') ", // "insert into tr_case_type_jxjy(ID,TP_ID,YZ_ID,CASE_NAME,CASE_NO,SFZ_NO,FIRST_TIME,EFFECT_BEGIN_TIME,EFFECT_END_TIME,DATA_VER,CASE_CODE,CASE_TYPE,UPLOAD_FLAG,IS_NEED,STATUS,CYZ_NO,TCT_ID_LL)", // "delete from tr_case_type_jxjy where id in (select tct.id from tr_case_type_jxjy tct,tr_period_jxjy tp where tct.tp_id = tp.id and tp.ay_id like '"+zid+"%') "); // //// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_examregister_jxjy", "select from tr_examregister_jxjy where ","insert into tr_examregister_jxjy()","delete from tr_examregister_jxjy where ay_id like '"+zid+"%'"); //// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_exam_delete_log", "select from tr_exam_delete_log where ","insert into tr_exam_delete_log()","delete from tr_exam_delete_log where ay_id like '"+zid+"%'"); //// d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_lessions_jxjy", "select from tr_lessions_jxjy where ","insert into tr_lessions_jxjy()","delete from tr_lessions_jxjy where ay_id like '"+zid+"%'"); // //打印培训记录 // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_printover_jxjy", // "select ID,TCT_ID,CREATETIME,NUM from tr_printover_jxjy where id in (select a.id from tr_printover_jxjy a,tr_case_type_jxjy b,tr_period_jxjy c where a.tct_id=b.id and b.tp_id=c.id and c.ay_id like '"+zid+"%')", // "insert into tr_printover_jxjy(ID,TCT_ID,CREATETIME,NUM)", // "delete from tr_printover_jxjy where "+del_where+" id in (select a.id from tr_printover_jxjy a,tr_case_type_jxjy b,tr_period_jxjy c where a.tct_id=b.id and b.tp_id=c.id and c.ay_id like '"+zid+"%') "); // // //培训周期 // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_period_jxjy", // "select ID,AY_ID,STDT_ID,REMARK,CREATE_USER_ID,CREATE_USER_NAME,CREATE_TIME,MODIFY_USER_ID,MODIFY_USER_NAME,MODIFY_TIME,AUD_TIME,AUD_UID,AUD_REMARK,OVER_TIME,OVER_UID,OVER_REMARK,EXAM_TIME,EXAM_UID,EXAM_REMARK,PICTURE,TFC_ID,ENTRY_DATE,GRADE,STATE,PAY_STATE,AUTO_CODE,STUDY_TYPE from tr_period_jxjy where ay_id like '"+zid+"%' ", // "insert into tr_period_jxjy(ID,AY_ID,STDT_ID,REMARK,CREATE_USER_ID,CREATE_USER_NAME,CREATE_TIME,MODIFY_USER_ID,MODIFY_USER_NAME,MODIFY_TIME,AUD_TIME,AUD_UID,AUD_REMARK,OVER_TIME,OVER_UID,OVER_REMARK,EXAM_TIME,EXAM_UID,EXAM_REMARK,PICTURE,TFC_ID,ENTRY_DATE,GRADE,STATE,PAY_STATE,AUTO_CODE,STUDY_TYPE)", // "delete from tr_period_jxjy where "+del_where+" ay_id like '"+zid+"%'"); // // // //考试结果 // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_std_exam_jxjy", // "select ID,AY_ID,TCT_ID,CASE_CODE,STATUS,SFZ_NO,STUDENT_NAME,KM,RESULT,EXAM_TIME,IS_OK,REMARK,CREATE_SCHOOL_ID,CREATE_SCHOOL_NAME,CREATE_USER_ID,CREATE_USER_NAME,CREATE_TIME,MODIFY_USER_ID,MODIFY_USER_NAME,MODIFY_TIME,EXAM_TYPE,CASE_NO from tr_std_exam_jxjy where ay_id like '"+zid+"%' ", // "insert into tr_std_exam_jxjy(ID,AY_ID,TCT_ID,CASE_CODE,STATUS,SFZ_NO,STUDENT_NAME,KM,RESULT,EXAM_TIME,IS_OK,REMARK,CREATE_SCHOOL_ID,CREATE_SCHOOL_NAME,CREATE_USER_ID,CREATE_USER_NAME,CREATE_TIME,MODIFY_USER_ID,MODIFY_USER_NAME,MODIFY_TIME,EXAM_TYPE,CASE_NO)", // "delete from tr_std_exam_jxjy where "+del_where+" ay_id like '"+zid+"%'"); // // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_std_fz_exam_jxjy", "select from tr_std_fz_exam_jxjy where ","insert into tr_std_fz_exam_jxjy()","delete from tr_std_fz_exam_jxjy where ay_id like '"+zid+"%'"); // // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_studytimetotal_jxjy", // "select ID,TCT_ID,KM1,KM2,KM3,CREATED,CHANGED,ZID,AUD_KM1,AUD_KM2,AUD_KM3,CUR_KM,NEED_TIME from tr_studytimetotal_jxjy where zid like '"+zid+"%'", // "insert into tr_studytimetotal_jxjy(ID,TCT_ID,KM1,KM2,KM3,CREATED,CHANGED,ZID,AUD_KM1,AUD_KM2,AUD_KM3,CUR_KM,NEED_TIME)", // "delete from tr_studytimetotal_jxjy where "+del_where+" zid like '"+zid+"%'"); // // // // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_studytime_delete_log", // "select ID,CONTENT,DELETE_USER_ID,DELETE_TIME,TCT_ID,REMARK from tr_studytime_delete_log where ", // "insert into tr_studytime_delete_log(ID,CONTENT,DELETE_USER_ID,DELETE_TIME,TCT_ID,REMARK)", // "delete from tr_studytime_delete_log where ay_id like '"+zid+"%'"); d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_studytime_jxjy", "select ID,TFC_ID,AY_ID,TP_ID,TCT_ID,COACH_ID,STDT_ID,COACH_ICNO,STDT_ICNO,FIELD_CODE,BEG_DAY,BEG_MINUTE,BEG_TIME,END_TIME,PH,KM,TIME_TYPE,IS_SIM,TR_MINUTE,DATA_FROM,DATA_FROM_INFO,COLLECT_DATE,STATE,USER_ID,ZID,CASE_TYPE,CASE_CODE,AUD_TIME,AUD_PASS,AUD_REMARK,CD_ID,TEMP_ID from tr_studytime_jxjy where state = 1 and to_char(beg_time,'yyyy-MM-dd') >'2017-05-01' and ay_id like '"+zid+"%'", "insert into tr_studytime_jxjy(ID,TFC_ID,AY_ID,TP_ID,TCT_ID,COACH_ID,STDT_ID,COACH_ICNO,STDT_ICNO,FIELD_CODE,BEG_DAY,BEG_MINUTE,BEG_TIME,END_TIME,PH,KM,TIME_TYPE,IS_SIM,TR_MINUTE,DATA_FROM,DATA_FROM_INFO,COLLECT_DATE,STATE,USER_ID,ZID,CASE_TYPE,CASE_CODE,AUD_TIME,AUD_PASS,AUD_REMARK,CD_ID,TEMP_ID)", "delete from tr_studytime_jxjy where "+del_where+" ay_id like '"+zid+"%'"); // // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_studytime_temp_jxjy", // "select ID,TFC_ID,AY_ID,TP_ID,TCT_ID,COACH_ID,STDT_ID,COACH_ICNO,STDT_ICNO,FIELD_CODE,BEG_DAY,BEG_MINUTE,BEG_TIME,END_TIME,PH,KM,TIME_TYPE,IS_SIM,TR_MINUTE,DATA_FROM,DATA_FROM_INFO,COLLECT_DATE,STATE,USER_ID,ZID,CASE_TYPE,CASE_CODE,AUD_TIME,AUD_PASS,AUD_REMARK,CD_ID,ACTUAL_BEG_TIME,ACTUAL_END_TIME,LESSION_ID from tr_studytime_temp_jxjy where ay_id like '"+zid+"%' ", // "insert into tr_studytime_temp_jxjy(ID,TFC_ID,AY_ID,TP_ID,TCT_ID,COACH_ID,STDT_ID,COACH_ICNO,STDT_ICNO,FIELD_CODE,BEG_DAY,BEG_MINUTE,BEG_TIME,END_TIME,PH,KM,TIME_TYPE,IS_SIM,TR_MINUTE,DATA_FROM,DATA_FROM_INFO,COLLECT_DATE,STATE,USER_ID,ZID,CASE_TYPE,CASE_CODE,AUD_TIME,AUD_PASS,AUD_REMARK,CD_ID,ACTUAL_BEG_TIME,ACTUAL_END_TIME,LESSION_ID)", // "delete from tr_studytime_temp_jxjy where "+del_where+" ay_id like '"+zid+"%'"); // // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_study_photo", // "select ID,TCT_ID,STUDY_TYPE,PHOTO_PATH,CREATE_TIME,TEMP_ID,CD_ID,EXAM_ID from tr_study_photo where id in (select * from tr_study_photo a,tr_studytime_temp_jxjy b where a.temp_id=b.id and b.ay_id like '"+zid+"%')", // "insert into tr_study_photo(ID,TCT_ID,STUDY_TYPE,PHOTO_PATH,CREATE_TIME,TEMP_ID,CD_ID,EXAM_ID)", // "delete from tr_study_photo where "+del_where+" id in (select * from tr_study_photo a,tr_studytime_temp_jxjy b where a.temp_id=b.id and b.ay_id like '"+zid+"%')"); // // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_user_video_jxjy", // "select ID,TCT_ID,CD_ID from tr_user_video_jxjy where id in (select a.id from tr_user_video_jxjy a,tr_case_type_jxjy b,tr_period_jxjy c where a.tct_id=b.id and b.tp_id=c.id and c.ay_id like '"+zid+"%')", // "insert into tr_user_video_jxjy(ID,TCT_ID,CD_ID)", // "delete from tr_user_video_jxjy where "+del_where+" id in (select a.id from tr_user_video_jxjy a,tr_case_type_jxjy b,tr_period_jxjy c where a.tct_id=b.id and b.tp_id=c.id and c.ay_id like '"+zid+"%')"); // // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_video_log_jxjy", // "select ID,TCT_ID,CD_ID,IS_OVER,PLAY_PERCENT,START_TIME from tr_video_log_jxjy where id in (select a.id from tr_video_log_jxjy a,tr_case_type_jxjy b,tr_period_jxjy c where a.tct_id=b.id and b.tp_id=c.id and c.ay_id like '"+zid+"%')", // "insert into tr_video_log_jxjy(ID,TCT_ID,CD_ID,IS_OVER,PLAY_PERCENT,START_TIME)", // "delete from tr_video_log_jxjy where "+del_where+" id in (select a.id from tr_video_log_jxjy a,tr_case_type_jxjy b,tr_period_jxjy c where a.tct_id=b.id and b.tp_id=c.id and c.ay_id like '"+zid+"%') "); // // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_video_log_jxjy_test", "select from tr_video_log_jxjy_test where ","insert into tr_video_log_jxjy_test()","delete from tr_video_log_jxjy_test where ay_id like '"+zid+"%'"); // d.insert(conn_oracle_ayjxjy, conn_ppas_ayjxjy, "tr_wrong_questions_jxjy", "select from tr_wrong_questions_jxjy where ","insert into tr_wrong_questions_jxjy()","delete from tr_wrong_questions_jxjy where ay_id like '"+zid+"%'"); conn_oracle_ayjxjy.close(); conn_ppas_ayjxjy.close(); }catch(Exception ex){ ex.printStackTrace(); } } }