readbubaosuidao.java

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

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

import net.aetherial.gis.jiaotongbu.outputJTB.txtOutput.module.excel.ReadSuiDao;
import net.aetherial.gis.jiaotongbu.output.tocheck.PermanenceBubao;
import net.aetherial.gis.jiaotongbu.output.tocheck.type.BubaoQIaoliang;
import net.aetherial.gis.jiaotongbu.outputJTB.txtOutput.module.excel.ReadQiaoLiang;
import net.aetherial.gis.jiaotongbu.outputJTB.txtOutput.module.excel.SheetItem;
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 ReadBuBaoSuidao {
  ReadSuiDao SDReader = null;
  public ReadBuBaoSuidao() {

  }

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

    si.setQiaoLiang(getExcel(inputPath));
    SDReader = new ReadSuiDao(si.getSheet_ql());
    SDReader.setRow(0);
    BubaoQIaoliang bubaoqiaoliang = null;
     for (int i = 0; !SDReader.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 "";
  }
}