readluduan.java

来自「基于Java的地图数据管理软件。使用MySQL数据库管理系统。」· Java 代码 · 共 58 行

package net.aetherial.gis.jiaotongbu.input.jxl;

import net.aetherial.gis.jiaotongbu.outputJTB.txtOutput.module.excel.ReadRecord;
import jxl.Sheet;
import net.aetherial.gis.jiaotongbu.outputJTB.txtOutput.module.excel.SheetItem;
import net.aetherial.gis.jiaotongbu.input.type.Luduan;
import net.aetherial.gis.jiaotongbu.input.publicuse.Permanence;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2004</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class ReadLuduan
    extends ReadRecord {
  public ReadLuduan(String heduiLuduanFile) {
    super(null);
    SheetItem si = new SheetItem();
    si.setHeduiLuduan(heduiLuduanFile);
    this.setSheet(si.getSheet_hdld());
    this.setRow(2);
  }

  public void read(){
    Luduan ld = null,pre = null;
    for (int i = 0;(!this.isEmptyrow()) && i < 5000; i++) {
      if (this.rowData != null && this.rowData.length >= 20) {
        ld = new Luduan();
        ld.setValue( this.rowData,pre);
        Permanence.heduidata_LD.add(ld);
        pre = ld;
      }
      this.moveNext();
    }
  }

  private void printPermanence(){
    for (int i = 0; i < Permanence.heduidata_LD.size(); i++) {
      System.out.println((Luduan)Permanence.heduidata_LD.get(i));
    }
    System.out.println("Permanence.heduidata_LD.size():" +Permanence.heduidata_LD.size());
  }

  public static void main(String args[]){
    ReadQiaoliang rl = new ReadQiaoliang("D:\\数据备份\\表格样式\\肥西报厅表格\\2_桥梁比较表.xls");
    rl.read();
    rl.printHeduidata_QL();
  }

}