readqltoarray.java

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

package net.aetherial.gis.jiaotongbu.output.tocheck.read;

import net.aetherial.gis.jiaotongbu.outputJTB.txtOutput.module.excel.
    ReadQiaoLiang;
import net.aetherial.gis.jiaotongbu.outputJTB.txtOutput.module.excel.SheetItem;
import net.aetherial.gis.jiaotongbu.output.tocheck.type.BubaoQIaoliang;
import net.aetherial.gis.jiaotongbu.output.tocheck.PermanenceBubao;
import java.io.File;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2004</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class ReadQlToArray {
  ReadQiaoLiang QLReader = null;

  public ReadQlToArray(String inputPath) {
    SheetItem si = new SheetItem();

    si.setQiaoLiang(getExcel(inputPath));
    QLReader = new ReadQiaoLiang(si.getSheet_ql());
    QLReader.setRow(0);
    BubaoQIaoliang bubaoqiaoliang = null;
     for (int i = 0; !QLReader.isEmptyrow() && i < 500; i++) {
       bubaoqiaoliang = new BubaoQIaoliang();
       bubaoqiaoliang.setBianma(QLReader.getQiaoLiangBianMa());
       bubaoqiaoliang.setJianchengshijian(QLReader.getQiaoLiangJianChenShiJian());
       bubaoqiaoliang.setJianzhucailiao(QLReader.getQiaoLiangFenLei());
       bubaoqiaoliang.setKongshu(QLReader.getQiaoLiangKongShu());
       bubaoqiaoliang.setKuadu(QLReader.getQiaoLiangKuaDu());
       bubaoqiaoliang.setMingcheng(QLReader.getQiaoLiangName());
       bubaoqiaoliang.setShejihezai(QLReader.getQiaoLiangZaiHe());
       bubaoqiaoliang.setShifouweiqiao(QLReader.getQiaoLiangWeiQiao());
       bubaoqiaoliang.setX(QLReader.getQiaoLiangLongitude());
       bubaoqiaoliang.setY(QLReader.getQiaoLiangLatitude());
       bubaoqiaoliang.setXiangzhen(QLReader.getXiangzhenName());
       bubaoqiaoliang.setZ(QLReader.getQiaoLiangAltitude());
       PermanenceBubao.qiaoliang.add(bubaoqiaoliang);
       QLReader.moveNext();
     }
  }

  private String getExcel(String inputPath){
    File temp = new File(inputPath);
    File[] child = temp.listFiles();
    if (child == null) {
      System.out.println("没有\"补报表格 || 上报表格\"目录!");
      try {
        Thread.sleep(5000);
      }
      catch (InterruptedException ex) {
      }
      System.exit(0);
    }else{
      for (int i = 0; i < child.length; i++) {
        if ((child[i].getName().indexOf("上报表格") != -1) || (child[i].getName().indexOf("补报表格") != -1)) {
          File[] rech = child[i].listFiles();
          for (int j = 0; j < rech.length; j++) {
            if (rech[j].getName().indexOf("表-3") != -1 ||
                rech[j].getName().indexOf("桥梁") != -1 ||
                rech[j].getName().indexOf("表3") != -1) {
              return rech[j].getAbsolutePath();
            }
          }
        }
      }
    }
    System.out.println("没有\"补报表格 || 上报表格\\表-3  农村公路专项调查 桥梁基本信息表.xls\"文件!");
      try {
        Thread.sleep(5000);
      }
      catch (InterruptedException ex) {
      }
      System.exit(0);
      return "";
  }


}