readdiquexcel.java

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

package net.aetherial.gis.test.tools.lost.diqu;

import net.aetherial.gis.jiaotongbu.outputJTB.txtOutput.module.excel.ReadRecord;
import net.aetherial.gis.publicuse.excel.ReadSheet;
import java.util.Hashtable;
import java.util.Enumeration;
import java.util.List;
import java.util.ArrayList;
import net.aetherial.gis.test.tools.lost.publicuse.Parameter;
/**
 * <p>标题: 农村公路数据采集与核对工具</p>
 *
 * <p>描述: </p>
 *
 * <p>版权: Copyright (c) 2006</p>
 *
 * <p>公司: 安徽省通途信息技术公司</p>
 *
 * @author 王爱国
 * @version 1.0
 */
public class ReadDiquExcel
    extends ReadRecord {
  private Hashtable ht = new Hashtable();
  public ReadDiquExcel(String diquFile) {
    super(null);
    ReadSheet rs = new ReadSheet();
    rs.setSheetFile(diquFile, 0);
//    si.setQiaoliangFangxiang(fangxiangFile);
    this.setSheet(rs.getMySheet());
    if (this.mySheet == null) {
      System.out.println("没有发现" + Parameter.DIQU_EXCEL);
      System.exit(0);
    }
    this.setRow(2);
  }

  public void read(){
    List list = null;
    String primal_shi = "",shi,primal_ctt_xian  = "",cct_xian,zd_xian = "";
    for (int i = 0;(!this.isEmptyrow()) && i < 115; i++) {
      shi = this.rowData[0].getContents().trim();
      zd_xian = this.rowData[2].getContents().trim();
      cct_xian = this.rowData[1].getContents().trim();
      if (!cct_xian.equals("")) {
        if (!primal_ctt_xian.equals("")) {
          this.ht.put(primal_shi + "\\" + primal_ctt_xian,list);
        }
        list = new ArrayList();
        primal_ctt_xian = cct_xian;

      }

      if (!shi.equals("")) {
        primal_shi = shi;
      }

      list.add(primal_shi + "\\" + zd_xian);


      this.moveNext();
    }
    this.ht.put(primal_shi + "\\" + primal_ctt_xian,list);
  }

  public void print(){
    Enumeration keys = ht.keys();
    String key = "";
    List list = null;
    int k = 0;
    while(keys.hasMoreElements()){
      key ="" + keys.nextElement();
      list = (List)ht.get(key);
      System.out.println("key:" + key);
      for (int i = 0; i < list.size(); i++) {
        System.out.println("\t" + "Value:" + list.get(i));
        k++;
      }
    }
    System.out.println("length = " + k);
  }


  public static void main(String args[]){
    ReadDiquExcel read = new ReadDiquExcel(Parameter.DIQU_EXCEL);
    read.read();
    read.print();
  }

  public Hashtable getHt() {
    return ht;
  }

}