mysql优化

1.当group by列多时使用md5(str),保障数据的唯一

性

  String md5= MD5.digest(keyArray[0]+"_"+keyArray[1]+"_"+keyArray[2]+"_"+keyArray[3]+"_"+ keyArray[4]+"_"+keyArray[5]+"_"+keyArray[6]+"_"+ keyArray[7]+"_"+keyArray[8]);
                                  System.out.println(md5+"加密");
                                 String sql_basic_ods_intnl_org= "select * from basic_ods_intnl_org_new where MD5_="+md5;
                                 System.out.println("执行了一句"+sql_basic_ods_intnl_org);
                                 int ifInsert=0;
                                 ResultSet rs = st.executeQuery(sql_basic_ods_intnl_org);
                                 if(rs.next()){
                                     ifInsert=1;
                                 }
                                 System.out.println(ifInsert+"该执行呢");
                                 //如果不重复就执行
                                 if(ifInsert==0){
                                     String sql_basic_ods_intnl_org_new="insert into basic_ods_intnl_org_new(dept_id,dept_crm_id,dept_name,belong_bureau,belong_agent_name,sub_chnl_desc,chnl_desc,chnl_admin_sub_type,chnl_sale_admin_duty_dept,createdate,MD5_)values('"+ keyArray[0]+"','"+ keyArray[1]+"','"+ keyArray[2]+"','"+ keyArray[3]+"','"+ keyArray[4]+"','"+ keyArray[5]+"','"+ keyArray[6]+"','"+ keyArray[7]+"','"+ keyArray[8]+"','"+md5+"')";
                                     st.execute(sql_basic_ods_intnl_org_new);
                                 }




----------------------------------;

                                         //从basic_ods_zhi_area导入到basic_ods_zhi_area_new里
                                   String md5_=MD5.digest(keyArray[0]+"_"+ keyArray[1]+"_"+keyArray[2]);
                                   String sql_basic_ods_zhi_area="select * from   basic_ods_zhi_area_new "+md5_;
                                   ResultSet rs=st.executeQuery(sql_basic_ods_zhi_area);
                                   int ifInsert=0;
                                   if(rs.next()){
                                       ifInsert=1;
                                   }
                                   //当没有重复的就插入数据
                                   if(ifInsert==0){
                                       String sql_basic_ods_zhi_area_new="insert into basic_ods_zhi_area(area_id,bureau_name,adm_sub_bureau_name,MD5_)values('"+ keyArray[0]+"','"+ keyArray[1]+"','"+ keyArray[2]+"','"+md5_+"' )";
                                       st.execute(sql_basic_ods_zhi_area_new); chi
                                   }