update index

unknown

2014-06-12 1b4367fca20eb8fa7ce7dd1aa990dca959af3060

 xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/DMMSNddUpdateJob.java

@@ -318,6 +318,7 @@
      logger.info("begin nddxml to postsql");
      logger.info("getftpfile...");
      String[] xmls= getNDDStrings(info, "neighbor_affect_customers.xml") ;

      logger.info(String.format("total %d file(s)",xmls.length));
      for(int iRow=0;iRow<xmls.length;iRow++)
      {
@@ -386,13 +387,13 @@
          t0=        t0.substring(t0.length()-2);
          t1=        t1.substring(t1.length()-2);
          String insertDBSQL=" insert into ndd.nddcanton_history (project_id,department_id,county_id,district_id,neighbor_id,affectcustomers,affectcustomersever"+
                  ",yy,mm,dd,tt) values ";
                  ",yy,mm,dd,tt,ts_ser) values ";
          for(int j=0;j<arraySQLVals.size();j++)
          {
              sqlExec(postsql,insertDBSQL + arraySQLVals.get(j)+
                      String.format(",%s,%s,%s,'%s%s')",
                      yy,mm,dd,t0,t1

                      String.format(",%s,%s,%s,'%s%s',%s)",
                      yy,mm,dd,t0,t1,
                      yy+mm+dd+"."+t0+t1
                      )  ,
                      new String[]{});

@@ -2455,7 +2456,7 @@
        if(lstXML.size()>0)
            return lstXML. toArray(new String[0]);

        return null;
        return new String[]{};
    }