readfangxiang.java

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

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

import net.aetherial.gis.jiaotongbu.outputJTB.txtOutput.module.excel.ReadRecord;
import net.aetherial.gis.jiaotongbu.outputJTB.txtOutput.module.excel.SheetItem;
import net.aetherial.gis.jiaotongbu.input.type.Fangxiang;
import net.aetherial.gis.jiaotongbu.input.publicuse.Permanence;
import java.util.Enumeration;
import net.aetherial.gis.surface.ItemValue;
import net.aetherial.gis.table.WuWei;
import net.aetherial.gis.jiaotongbu.input.analyse.OpenDirect;
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
 */
public class ReadFangxiang extends ReadRecord {
  public ReadFangxiang(String fangxiangFile) {
    super(null);
    SheetItem si = new SheetItem();
    try {
      si.setQiaoliangFangxiang(fangxiangFile);
    }
    catch (Exception ex) {
      System.out.println("读取方向表有错误,请确认表7存在,且工作表Sheet名为:\"路线走向确认表\".");
      this.sleepToExist();
    }
    this.setSheet(si.getSheet_ql());
    this.setRow(2);
  }

  public void read(){

    Fangxiang fx = null;
    for (int i = 0;(!this.isEmptyrow()) && i < 5000; i++) {
      if (this.rowData != null) {
        fx = new Fangxiang();
        fx.setValue(this.rowData);
        Permanence.ql_fangxiang.put(fx.getLxNumber(), fx);
      }
      this.moveNext();
    }
//    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();
//    }
//      for (int i = 0;(!this.isEmptyrow()) && i < 5000; i++) {
//        for (int j = 0; j < this.rowData.length; j++) {
//          System.out.print(this.rowData[j].getContents());
//        }
//        this.moveNext();
//        System.out.println("");
//      }
  }

  public void checkXiangzhen(String inputPath){
    OpenDirect od = new OpenDirect();
    ItemValue.setArrayPath(od.getArrayPath(inputPath));
    WuWei ww = new WuWei();

    String n = "";
    Fangxiang fx = null;
    Enumeration keys = Permanence.ql_fangxiang.keys();
        String key = "";
        while(keys.hasMoreElements()){
          key = "" + keys.nextElement();
//          System.out.println(key);
          fx = (Fangxiang)Permanence.ql_fangxiang.get(key);
          if (fx.getXiangzhen().equals("")) {
            n += "\t路线" + key + "乡镇为空.\r\n";
          }else if(!this.isInArray(fx.getXiangzhen(),ww)){
            n += "\t路线" + key + "乡镇\"" + fx.getXiangzhen() + "\"有误.请检查Array与表7乡镇文字是否一致.\r\n";
          }
//          System.out.println(key +"," +Permanence.ql_fangxiang.get(key));
    }

    if (!(n.trim().equals(""))) {
      System.out.println("检查出表7乡镇一栏有误,信息如下:");
      System.out.println(n);

      this.sleepToExist();
    }
  }

  private void sleepToExist(){
    System.out.println("程序10秒后自动退出.");
    try {
        Thread.sleep(10000);
      }
      catch (InterruptedException ex) {
      }
      System.exit(0);
  }
  private boolean isInArray(String xiangzhen,WuWei ww){
    StringTokenizer st = new StringTokenizer(xiangzhen,"、");
    String myxiangzhen = "";
    while(st.hasMoreTokens()){
      myxiangzhen = st.nextToken().trim();
      if (!this.isXiangzhenInArray(myxiangzhen,ww)) {
        return false;
      }
    }
    return true;
  }

  private boolean isXiangzhenInArray(String xiangzhen,WuWei ww){
    if (xiangzhen.trim().equals("")) {
      return true;
    }
    if (xiangzhen.length() > 2) {
      xiangzhen = xiangzhen.substring(0,2);
    }

    for (int i = 0; i < ww.wuchen_xiangzhen.length; i++) {
      if (ww.wuchen_xiangzhen[i].trim().indexOf(xiangzhen) != -1 || xiangzhen.indexOf(ww.wuchen_xiangzhen[i].trim()) != -1) {
        return true;
      }
    }

    return false;
  }
  private void printPermanence(){
    Enumeration keys = Permanence.ql_fangxiang.keys();
    String key = "";
    while(keys.hasMoreElements()){
      key = "" + keys.nextElement();

      System.out.println(key +"," +((Fangxiang)Permanence.ql_fangxiang.get(key)).getFangxiang());
    }
    System.out.println(Permanence.ql_fangxiang.size());
  }

  public static void main(String args[]){
    ReadFangxiang rf = new ReadFangxiang("C:\\Documents and Settings\\Administrator\\桌面\\杨志成\\7_路线走向确认表.xls");
    rf.read();
    rf.printPermanence();
  }
}