readkeyanbaogao.java

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

package net.aetherial.gis.our.duibi.readXLS;

import net.aetherial.gis.our.duibi.data.RoadGLJ;
import jxl.NumberCell;
import net.aetherial.gis.our.duibi.data.AllRoad;
import java.util.StringTokenizer;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2004</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */

//[0][0]
//[0][1]
//[0][2]
//[0][3]
//[0][4]　审查时间： 2006年2 月8 日
//[0][5]
//[1][0]项 目 名 称
//[1][1]宋牌坊至王园
//[1][2]
//[1][3]
//[1][4]
//[1][5]
//[2][0]项目所在地
//[2][1]　　涡阳县    店集镇
//[2][2]
//[2][3]
//[2][4]公路性质
//[2][5]乡村道
//[3][0]途经行政村名称
//[3][1]宋牌坊、洪光、王园
//[3][2]
//[3][3]
//[3][4]
//[3][5]
//[4][0]公 路 现 状
//[4][1]线路等级
//[4][2]四级
//[4][3]
//[4][4]线路长度
//[4][5]6公里
//[5][0]
//[5][1]路基宽度
//[5][2]5—6  米
//[5][3]
//[5][4]路面宽度
//[5][5]4—5  米
//[6][0]
//[6][1]路面类型、现状
//[6][2]砂石路面、损坏严重
//[6][3]
//[6][4]
//[6][5]
//[7][0]线路控制点
//[7][1]     起点：宋牌坊
//[7][2]
//[7][3]
//[7][4]终 点：王园
//[7][5]
//[8][0]
//[8][1]   主要控制点：洪光
//[8][2]
//[8][3]
//[8][4]
//[8][5]
//[9][0]建 设 方 案
//[9][1]建设性质
//[9][2]改建
//[9][3]
//[9][4]线路等级
//[9][5]四级
//[10][0]
//[10][1]建设里程
//[10][2]6公里　
//[10][3]
//[10][4]路基宽度
//[10][5]9　米
//[11][0]
//[11][1]路面宽度
//[11][2]　　4　米
//[11][3]
//[11][4]路面类型
//[11][5]沥青贯入
//[12][0]
//[12][1]路面结构
//[12][2]沥青贯入+石灰土
//[12][3]
//[12][4]
//[12][5]
//[13][0]
//[13][1]中桥及以上
//[13][2]        米/座
//[13][3]
//[13][4]小桥
//[13][5]  14/2   米/座
//[14][0]
//[14][1]新征用土地面积
//[14][2]        亩
//[14][3]
//[14][4]拆迁房屋面积
//[14][5]210平方米
//[15][0]总   投   资
//[15][1]180.6971万元
//[15][2]
//[15][3]
//[15][4]建设年限
//[15][5]6个月
//[16][0]资 金 来 源
//[16][1]中央补助60万元,地方自筹120.6971万元
//[16][2]
//[16][3]
//[16][4]
//[16][5]
//[17][0]项 目 业 主
//[17][1]涡阳县县乡公路管理站
//[17][2]
//[17][3]
//[17][4]
//[17][5]
//[18][0]其 它 事 项
//[18][1]
//[18][2]
//[18][3]
//[18][4]
//[18][5]
//[19][0]专 家 签 名
//[19][1]
//[19][2]
//[19][3]
//[19][4]
//[19][5]

public class ReadKeYanBaoGao
    extends ReadFile {
  private String sourceFile = "";
  public String[][] data = new String[20][6];
  public ReadKeYanBaoGao() {
    for(int i=0; i< data.length; i++){
      for(int j=0; j< data[i].length; j++){
        data[i][j] = "";
      }
    }
//    this.setSheet("I:\\《安徽省村村通油（水泥）路工程》\\06年发改委项目审查\\专家审查表(宋牌坊-王园).XLS",
//                  "Sheet1");
//     this.row = this.baseRow;
  }

  public void read() {
    for (int i = 0; i < data.length; i++) {
      moveNext();

      for (int j = 0; j < data[i].length; j++) {
        if (rowData != null) {
          data[i][j] = rowData[j].getContents().trim();
        }
      }
    }

  }

  private String clean(String src) {
    if (src == null) {
      return "";
    }
    else {
      return src.replaceAll(" ", "")
          .replaceAll("\t", "")
          .replaceAll("　", "")
          .replaceAll(",", "、")
          .replaceAll("，", "、")
          .replaceAll("（", "(")
          .replaceAll("）", ")")
          .replaceAll("\n", "、")
          .replaceAll("\r", "、")
          .replaceAll("、、", "、")
          .replaceAll("、、", "、");
    }
  }

  private String clean(String src, String replace) {
    if (src == null) {
      return "";
    }
    else {
      return src.replaceAll(" ", "").replaceAll("\t", "").replaceAll("　", ""); //.replaceAll("、",",");
    }
  }

  public void setSourceFile(String src) {
    sourceFile = src;
  }

  public String getPianQu() {
    return getSourceArray()[0];
  }

  public String getShi() {
    return getSourceArray()[1];
  }

  public String getXian() {

    return getSourceArray()[2];
  }

  public String getWengJian() {

    return getSourceArray()[3];
  }

  public String[] getSourceArray() {

    java.util.StringTokenizer token = new StringTokenizer(getSource(), ",");
    String[] str = new String[token.countTokens()];
    int i = 0;
    while (token.hasMoreTokens()) {
      str[i] = token.nextToken();
      i++;
    }
    return str;

  }

  public String getSource() {
    if (sourceFile == null) {
      return "";
    }
    else {
      return clean(sourceFile).replaceAll("\\\\",
                                          ",").replaceAll(
          "E:,Projs,HR,06年发改委项目审查,专家评审表,", "");
    }
  }

  public String getMinCheng() {
    return clean(data[1][1]);
  }

  public String getSuoZaiDi() {
    return data[2][1];
  }

  public String getXingZhi() {
    return clean(data[2][5]);
  }

  public String getTuJinXZC() {
    return clean(data[3][1]);
  }

  public String getDengJi() {
    return clean(data[4][2]);
  }

  public String getChangDu() {
    return clean(data[4][5]).replaceAll("公里", "");
  }

  public String getLuJi() {
    return clean(data[5][2]).replaceAll("米", "");
  }

  public String getLuMian() {
    return clean(data[5][5]).replaceAll("米", "");
  }

  public String getLeiXing() {
    return clean(data[6][2]).replaceAll("路面", "");
  }

  public String getQiDian() {
    return clean(data[7][1]).replaceAll("起点：", "");
  }

  public String getZhongDian() {
    return clean(data[7][4]).replaceAll("终点：", "");
  }

  public String getKongZhiDian() {
    return clean(data[8][1]).replaceAll("主要控制点：", "").replaceAll("\n", "、").
        replaceAll("\r", "、").replaceAll("、、", "、").replaceAll("、、", "、");
  }

  public String getJianSheXinZhi() {
    return clean(data[9][2]);
  }

  public String getJianSheDengJi() {
    return clean(data[9][5]);
  }

  public String getJianSheLiChen() {
    return clean(data[10][2]).replaceAll("公里", "");
  }

  public String getJianSheLuJi() {
    return clean(data[10][5]).replaceAll("米", "");
  }

  public String getJianSheLuMian() {
    return clean(data[11][2]).replaceAll("米", "");
  }

  public String getJianSheLuMianLeiXin() {
    return clean(data[11][5])
        .replaceAll("\n", "、")
        .replaceAll("\r", "、")
        .replaceAll("、、", "、")
        .replaceAll("、、", "、");
  }

  public String getJianSheLuMianJieGou() {
    return clean(data[12][2]);
  }

  public String getJianSheZhongQiao() {
    return clean(data[13][2]).replaceAll("米/座", ""); //.replaceAll("米","").replaceAll("座","");
  }

  public String getJianSheXiaoQiao() {
    return clean(data[13][5]).replaceAll("米/座", ""); //.replaceAll("米","").replaceAll("座","");
  }

  public String getJianSheLZhengDi() {
    return clean(data[14][2]).replaceAll("亩", "");
  }

  public String getJianSheChaiQian() {
    return clean(data[14][5]).replaceAll("平方米", "");
  }

  public String getJianSheTouZi() {
    return clean(data[15][1]).replaceAll("万", "").replaceAll("元", "");
  }

  public String getJianSheNianXian() {
    return clean(data[15][5]);
  }

  public String getJianSheZiJinLaiYuan() {
    return clean(data[16][1]);
  }

  public String getYeZhu() {
    return clean(data[17][1]);
  }

  public void export() {
    System.out.println("" +
                       getPianQu() + "," +
                       getShi() + "," +
                       getXian() + "," +
                       getWengJian() + "," +
                       getMinCheng() + "," +
                       getSuoZaiDi() + "," +
                       getXingZhi() + "," +
                       getTuJinXZC() + "," +
                       getDengJi() + "," +
                       getChangDu() + "," +
                       getLuJi() + "," +
                       getLuMian() + "," +
                       getLeiXing() + "," +
                       getQiDian() + "," +
                       getZhongDian() + "," +
                       getKongZhiDian() + "," +
                       getJianSheXinZhi() + "," +
                       getJianSheDengJi() + "," +
                       getJianSheLiChen() + "," +
                       getJianSheLuJi() + "," +
                       getJianSheLuMian() + "," +
                       getJianSheLuMianLeiXin() + "," +
                       getJianSheLuMianJieGou() + "," +
                       getJianSheZhongQiao() + "," +
                       getJianSheXiaoQiao() + "," +
                       getJianSheLZhengDi() + "," +
                       getJianSheChaiQian() + "," +
                       getJianSheTouZi() + "," +
                       getJianSheNianXian() + "," +
                       getJianSheZiJinLaiYuan() + "," +
                       getYeZhu() + ","

        );
//    System.out.println(
//        data[1][1] + "," +
//        data[2][1] + "," +
//        data[2][5] + "," +
//        data[3][1] + "," +
//        data[4][2] + "," +
//        data[4][5] + "," +
//        data[5][2] + "," +
//        data[5][5] + "," +
//        data[6][2] + "," +
//        data[7][1] + "," +
//        data[7][4] + "," +
//        data[8][1] + ","
//        );

  }

  public static void main(String args[]) {
    if (args.length < 2) {
      System.out.println("too few arguements");
      System.exit(0);
    }
    ReadKeYanBaoGao rx = new ReadKeYanBaoGao();
    rx.setSheet(args[0], args[1]);
    rx.read();
    rx.export();

  }

  public void setSheet(String fileName, String sheetName) {
    super.setSheet(fileName, sheetName);
    setSourceFile(fileName);
  }
}