excel.java

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

package net.aetherial.gis.our.auto.extend;

import net.aetherial.gis.surface.ItemValue;
import net.aetherial.gis.excel.CreateExcelLast;
import java.io.File;
import net.aetherial.gis.our.FrameOur;
import net.aetherial.gis.our.auto.Auto;
import org.w3c.dom.Node;
import net.aetherial.gis.dataType.GPSFile;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2004</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Excel extends Auto {
  private String defalutType = "砂石路";
  private String SavedPath = "D:\\GIS\\GPS测量数据\\通村油路\\肥西\\Excel表格\\";
  public Excel(FrameOur fo) {
    this.setFrameOur(fo);
  }
  public void setSavedPath(String path){
    this.SavedPath = path;
  }
  public void setDefaultType(String type){
    this.defalutType = type;
  }

  public void run(){
    if(super.input == null){
      System.out.println("super.input");
      return;
    }
    for (int i = 0; i < this.input.length; i++) {
      this.open(this.input[i]);
      this.rollTracksAndCreate(GPSFile.getRidOfGPSSuffix(this.input[i].getName()));
      this.setMemoryReset();
    }
  }
  private void rollTracksAndCreate(String openFileName){
    int[] pos = ItemValue.getPosition("track");
    int count = 1;
    Node node = null;
    if(pos == null){
      return;
    }else{
      for(int i = 0; i<pos.length;i++){
        node = ItemValue.getTracks(pos[i]);
        if(ItemValue.getTracksType(node).equals(this.defalutType)){
          this.createExcel(new File(this.SavedPath + openFileName + "." + count +
                                    ".xls"), this.getFrameOur(), pos[i]);
          count++;
        }
      }
    }
  }
  private void createExcel(File file,java.awt.Window dte,int tracksPos){
    CreateExcelLast excel = new CreateExcelLast(file, dte, tracksPos);
    excel.run();
  }
}