exceltogps.java

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

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

import org.w3c.dom.Node;
import java.util.Vector;
import net.aetherial.gis.surface.ItemValue;
import net.aetherial.gis.dataType.WptType;
import net.aetherial.gis.jiaotongbu.input.type.Qiaoliang;
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 ExcelToGPS {
  Node[] gpsQiaoliang = null;
  public ExcelToGPS() {

  }

  /**
   * 得到桥梁的航点
   */
  private Node[] getQiaoliangWaypoint() {
    Node[] wpts = ItemValue.getWaypoint();
    Vector temp = new Vector();
    for (int i = 0; wpts != null && i < wpts.length; i++) {
      if (ItemValue.getWaypointKP(wpts[i]).equals(WptType.W3QiaoLiang)) {
        temp.add(wpts[i]);
      }
    }
    wpts = new Node[temp.size()];
    temp.copyInto(wpts);
    return wpts;
  }

  /**
   * 得到指定航点桥梁的Excel桥梁对象
   */
  public Qiaoliang getCurrentQiaoliang(Node ql_wpt){
    String lon_wpt = ItemValue.getWaypointX(ql_wpt);
    String lat_wpt = ItemValue.getWaypointY(ql_wpt);
    if (lon_wpt.length() > 10) {
      lon_wpt = lon_wpt.substring(0,10);
    }

    if (lat_wpt.length() > 10) {
      lat_wpt = lat_wpt.substring(0,10);
    }

    Qiaoliang ql = null;
    for (int i = 0; i < Permanence.heduidata_QL.size(); i++) {
      ql = (Qiaoliang)Permanence.heduidata_QL.get(i);
      if (ql.getLon().indexOf(lon_wpt) != -1 && ql.getLat().indexOf(lat_wpt) != -1 ) {
        return ql;
      }
    }
    return null;
  }

  public void setWaypointQiaoliangValue(Node waypoint,Qiaoliang ql){
    String[] qlArray = new String[10];
    qlArray[0] = ql.getName();
    qlArray[1] = ql.getKongshu();
    qlArray[2] = ql.getKuajin();
    qlArray[3] = ql.getNumber();
    qlArray[4] = ql.getShijian();
    qlArray[5] = ql.getZhuanghao();
    qlArray[6] = ql.getQuanchang();
    qlArray[7] = ql.getHezai();
    qlArray[8] = ql.getCailiao();
    qlArray[9] = ql.getWeiqiao();
    ItemValue.setWaypointQiaoliang(waypoint,qlArray);
  }

  public static void main(String args[]){

  }
}