qsd.java

基于Java的地图数据管理软件。使用MySQL数据库管理系统。

                           formater.format(d) + "0");
              du.setLuDuanBianMa( (String) ItemValue.numberedTracks.get(key) +
                                 getLuDuanBianHao( (Node) nodes.get(i)));
              du.setJinDu(x);
              du.setWeiDu(y);
              du.setBianHao("D" + formater.format(d) + "0");
              du.setMingChen(key.replaceAll("\\[村道\\]","") + " " + number[d] + "渡");
              du.setQiDianZhuangHao(zhuangHaoFormater.format(zhuangHao));
              if (adder != null) {
                du.set0_4ColumnAdder(adder.getAdder());
                du.set0_5ColumnAdderPhone(adder.getAdderPhone());
                du.set0_6ColumnAsses(adder.getAsses());
                du.set0_7ColumnAssesPhone(adder.getAssesPhone());
                du.set0_8ColumnDept(adder.getDept());
                du.set0_9ColumnDeptPrin(adder.getDeptPrin());

              }
              this.D += du.toString() + "\r\n";
            }
            else {
              System.out.println(" 没有发现渡口信息, 跳过");
            }
          }
          if("涵洞".equals(type)){
            h++;
          }
        }
        ItemValue.hanDongTracks.put(nodes.get(i),new Integer(h));
        changDu = dis;
//        if(zhuangHao > changDu) zhuangHao = changDu;
      }
    }
  }

  protected String getLuDuanBianHao(Node luduan) {
    String result = "001";
    if (luduan != null) {
      result = (String) ItemValue.luDuanBianMa.get(luduan);
    }
    if (result == null) {
      result = "001";
    }

    return result;
  }

  protected boolean fillQLInfo(String excelFilePath, ql qiao, String x, String y) {
    if(QLReader == null){
      SheetItem si = new SheetItem();
      si.setQiaoLiang(excelFilePath);
      QLReader = new ReadQiaoLiang(si.getSheet_ql());
    }else{
      QLReader.setRow(0);
    }


//    int rows = si.getT1_XiangzhenRows() - Property.t3_QiaoLiang_Base_Row;
    for (int i = 0; !QLReader.isEmptyrow() && i < 500; i++) {
      String y1 = QLReader.getQiaoLiangLatitude();
      String x1 = QLReader.getQiaoLiangLongitude();
//      System.out.println(y + ""+y1.substring(0,y1.length()-1) );
//      System.out.println(x + ""+x1.substring(0,x1.length()-1) );
      if (y1.length() > 3 && y.indexOf(y1.substring(0, y1.length() - 1)) > -1 &&
          x1.length() > 3 && x.indexOf(x1.substring(0, x1.length() - 1)) > -1) {
        String kongShu = QLReader.getQiaoLiangKongShu();
        String kuaDu = QLReader.getQiaoLiangKuaDu();
        String jianChen = QLReader.getQiaoLiangJianChenShiJian();
        String zaiHe = QLReader.getQiaoLiangZaiHe();
        String cailiao = QLReader.getQiaoLiangFenLei();
        String weiQiao = QLReader.getQiaoLiangWeiQiao();
        String beiZhu = QLReader.getQiaoLiangBeizhu();
        double length = 0;
        try {
          length = Double.parseDouble(kuaDu);
        }
        catch (NumberFormatException ex) {
          length = 15;
        }

          qiao.setChangDu(kuaDu);
          qiao.setCaiLiao(cailiao);
          qiao.setJianChen(jianChen.length() > 3 ? jianChen : "1900");
          qiao.setJinDu(x);
          if (length > 1000) {
            qiao.setKuaJin("1");
          }
          else if (length >= 100) {
            qiao.setKuaJin("2");
          }
          else if (length > 30) {
            qiao.setKuaJin("3");
          }
          else if (length >= 8) {
            qiao.setKuaJin("4");
          }
          else {
            return false;
          }
          qiao.setWeiDu(y);
          qiao.setWeiQiao("2");
          qiao.setZaiHe(zaiHe);
          qiao.setZhongXingZhuangHao("");
          qiao.set0_3ColumnBeizhu(beiZhu);
          return true;
      }
      QLReader.moveNext();
    }
    return false;
  }

  protected boolean fillSDInfo(String excelFilePath, sd sui, String x, String y) {
    if(SDReader == null){
      SheetItem si = new SheetItem();
      si.setSuiDao(excelFilePath);
      SDReader = new ReadSuiDao(si.getSheet_sd());
    }else{
      SDReader.setRow(0);
    }


//    int rows = si.getT1_XiangzhenRows() - Property.t4_SuiDao_Base_Row;
    for (int i = 0; !SDReader.isEmptyrow() && i < 500; i++) {
      String y1 = SDReader.getSuiDaoLatitude();
      String x1 = SDReader.getSuiDaoLongitude();
//      System.out.println(y + ""+y1.substring(0,y1.length()-1) );
//      System.out.println(x + ""+x1.substring(0,x1.length()-1) );
      if (y1.length() > 3 && y.indexOf(y1.substring(0, y1.length() - 1)) > -1 &&
          x1.length() > 3 && x.indexOf(x1.substring(0, x1.length() - 1)) > -1) {

        String jianChen = SDReader.getSuiDaoJianChenShiJian();
        if (jianChen.length() < 4) {
          jianChen = "1900";
        }
        String jinGao = SDReader.getSuiDaoJingGao();
        String changDu = SDReader.getSuiDaoChangDu();
        String quanKuan = SDReader.getSuiDaoQuanKuan();
        String beiZhu = SDReader.getSuiDaoBeizhu();
        double length = 0;
        sui.set0_3ColumnBeizhu(beiZhu);
        sui.setJianChenShiJian(jianChen);
        sui.setJinDu(x);
        sui.setWeiDu(y);
        sui.setChangDu(changDu);
        sui.setJinGao(jinGao);
        sui.setQuanKuan(quanKuan);
//        sui.setBeiZhu(beiZhu);

        return true;

      }
      SDReader.moveNext();
    }
    return false;
  }

  protected boolean fillDKInfo(String excelFilePath, dk du, String x, String y) {
    if(DKReader == null){
      SheetItem si = new SheetItem();
      si.setDuKou(excelFilePath);
      DKReader = new ReadDuKou(si.getSheet_dk());
    }else{
      DKReader.setRow(0);
    }

//    int rows = si.getT1_XiangzhenRows() - Property.t3_QiaoLiang_Base_Row;
    for (int i = 0; !DKReader.isEmptyrow() && i < 500; i++) {
      String y1 = DKReader.getDuKouLatitude();
      String x1 = DKReader.getDuKouLongitude();
//      System.out.println(y + ""+y1.substring(0,y1.length()-1) );
//      System.out.println(x + ""+x1.substring(0,x1.length()-1) );
      if (y1.length() > 3 && y.indexOf(y1.substring(0, y1.length() - 1)) > -1 &&
          x1.length() > 3 && x.indexOf(x1.substring(0, x1.length() - 1)) > -1) {

        String jianChen = DKReader.getDuKouJianChen();
        if (jianChen.length() < 4) {
          jianChen = "1900";
        }
        String qiChe = DKReader.getDuKouQiCheDuKou();
        String kuanDu = DKReader.getDuKouKuanDu();
        String jiDong = DKReader.getDuKouJiDongDuKou();
        String beiZhu = DKReader.getDuKouBeizhu();

        du.setJinDu(x);
        du.setWeiDu(y);
        du.setJianChenShiJian(jianChen);
        du.setJiDong(jiDong);
        du.setKuanDu(kuanDu);
        du.setLeiXing(qiChe);
        du.set0_3ColumnBeizhu(beiZhu);

        return true;

      }
      DKReader.moveNext();
    }
    return false;
  }

  public void save(String pathOut) {
    ItemUse.saveFile(new File(pathOut + "Ql.txt"), this.Q);
    ItemUse.saveFile(new File(pathOut + "Sd.txt"), this.S);
    ItemUse.saveFile(new File(pathOut + "Dk.txt"), this.D);
  }
}