readxiangdao.java

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

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

import net.aetherial.gis.our.duibi.data.RoadGLJ;
import net.aetherial.gis.our.duibi.data.AllRoad;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2004</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class ReadXiangDao  extends ReadFile{
  private String number = "";
  public ReadXiangDao() {
    this.setSheet("file\\glj\\xiangdao.xls","T068");
    this.row = this.baseRow;
  }

  private RoadGLJ getGljRoad(){
    RoadGLJ glj = new RoadGLJ();
    glj.setRoadNumber(number);
    glj.setShixian(rowData[2].getContents().replaceAll(" ",""));
    try {
      glj.setLicheng(Double.parseDouble(rowData[5].getContents().trim()));
    }
    catch (NumberFormatException ex) {
//      System.out.println("Error:" +rowData[2].getContents()+"\t" + number);
      glj.setLicheng(0);
    }
    return glj;
  }


  /**
   * 是否是统计\小结
   */
  private boolean isTongji(){
    if ((rowData[1].getContents().trim()).equals("")) {
      return false;
    }else{
      this.number = rowData[1].getContents().trim();
      return true;
    }
  }

  public void addXianDao(){
    while (true) {
      this.moveNext();
      if (!this.isEmptyrow()) {
        if (!this.isTongji()) {
          AllRoad.add(this.getGljRoad());
        }
      }else{
        break;
      }
    }
  }



}