submittabletongjitext.java

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

package net.aetherial.gis.our.auto;

import net.aetherial.gis.our.FrameOur;
import org.w3c.dom.*;
import net.aetherial.gis.surface.ItemValue;
import net.aetherial.gis.dataType.WptType;
import net.aetherial.gis.table.WuWei;
import java.io.File;
import net.aetherial.gis.surface.CreateFile;
import net.aetherial.gis.table.ReferencePoint;
import net.aetherial.gis.table.TableTing;
import java.util.Calendar;
import java.util.GregorianCalendar;
import java.util.Date;
import net.aetherial.gis.dataType.GPSFile;
import net.aetherial.gis.dataType.TrackType;
import net.aetherial.gis.table.TrackTableName;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2004</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class SubmitTableTongjiText {
  private String filename = "";
  private String excelName = "";//
  private WuWei ww = new WuWei();
  private double licheng_all = 0.0;
  private double licheng_all_all = 0.0;
  private int fileCount = 0;//统计读取文件的次数
  private String log = "";
  private boolean xuyao_xzc = true; //需要行政村
  private boolean xuyao_njian = true; //需要拟建
  private boolean noLimited = false; //需要拟建
  private TrackTableName rodeName = null;
  TableTing tt = null;

  public SubmitTableTongjiText(String Table_Type) {
    tt = new TableTing(Table_Type);
  }
  public void setXuyao_xzc(boolean xuyao){
   this.xuyao_xzc = xuyao;
 }
 public void setXuyao_nijian(boolean xuyao){
   this.xuyao_njian = xuyao;
 }
 public void setFileName(String fileName){
   this.filename = fileName;
 }
 public void setExcelName(String excelName){
   this.excelName = excelName;
 }

  public void setNoLimited(boolean noLimited) {
    this.noLimited = noLimited;
  }

  //线路名称
 private String getRoadName(Node track){
   rodeName = new TrackTableName(track);
   String str = rodeName.getStartEndName();
   //str = ItemValue.get_kuahao_String(str);
   //str = ItemValue.getRidOf_kuahao(str);
   //str = ItemValue.getShortName(str);
   return str;
 }
 private String getRoadNameOfStartEnd(String[][] referencePoint){
   return referencePoint[0][0] + "-" + referencePoint[4][0];
 }
 //沟通的行政村名称
 private String getXZCName(Node[] xzcNode){
   if(xzcNode == null){
     return "";
   }
   String result = " ";
   for(int i=0; i<xzcNode.length; i++){
     result +=ItemValue.getWaypointShortName(xzcNode[i])+",";
   }
   return result.substring(0,result.length()-1);
 }
 //得到该航迹的行政村个数,形成数组
 private Node[] getXZCNode(Node track){
   Node[] wpt1 = ItemValue.getTracksWaypoint(track);
   if(wpt1 == null){
     return null;
   }
   Node[] wpt2 = ItemValue.getXingZCInWaypoint(wpt1);
   return wpt2;
 }
 /**
  * 得到一位小数的数据
  */
 private String getNumricDot1(double data){
   java.text.DecimalFormat formater = new java.text.DecimalFormat("#.###");
   try{
     return formater.format(data);
   }catch(Exception e){
     return "";
   }

 }

 private String getNowRoadDis(Node track){
   String dis = getNumricDot1(ItemValue.getTracksDistance(track)/1000);
   try {
     this.licheng_all = this.licheng_all + Double.parseDouble(dis);
   }
   catch (NumberFormatException ex) {
   }
   this.print("this.licheng_all:"+this.licheng_all);
   return dis;
 }
 private String getNowRoadbedWidth(Node track){
   return ItemValue.getTracksWidth(track);
 }
 private String getNowRoadsurfaceWidth(Node track){
   return ItemValue.getTracks_jitongbu_luji_With(track);
 }
 private String getNowRoadType(Node track){
   return ItemValue.getTracksType(track);
 }

 private int getXZCXiabiao(Node xzcNode){//得到行政村数组的下标
   if(xzcNode == null){
     return -1;
   }
   String xzcName = ItemValue.getWaypointName(xzcNode);

   for(int i =0;i<ww.wuwei_cun.length;i++){
     if(!ww.wuwei_cun[i].equals("")){
       if (xzcName.indexOf(ww.wuwei_cun[i]) != -1) {
         return i;
       }
     }
   }
   return -1;
 }
 private String getCunPopulation(int xiabaio){
   //人口
   if(xiabaio != -1){
     return ww.wuwei_renkou[xiabaio];
   }else{
     return "";
   }
 }


 private String getCunIncome(int xiabaio){
   //收入
   if(xiabaio != -1){
     return ww.wuwei_shouru[xiabaio];
   }else{
     return "";
   }
 }
 private String getCunEconomy(int xiabaio){
   //主要经济  作物
   if(xiabaio != -1){
     return ww.wuwei_jinji[xiabaio];
   }else{
     return "";
   }
 }
 //
 private String getHead(){
   return tt.getEHead();
 }

 private String getTop(){
   //得到头部描述
   return tt.getETop();
 }

 private String getRowData(Node trk){
   //得到trk数据
   String dataRow = "";
     dataRow = dataRow + tt.getEDataRow();
   return dataRow;
 }
 private String getOnlyRow(Node track, Node[] xzc) {
   String dataRow = this.getRowData(track);
   int xb = -1;
   dataRow = tt.getD1_1RoadName(dataRow, this.getRoadName(track));
   dataRow = tt.getD1_2XZCName(dataRow, this.getXZCName(xzc));
//   try {
     dataRow = getReferencePoint(dataRow, track);
//   }
//   catch (Exception ex) {
//   }
   dataRow = getNowString(dataRow, track);
   dataRow = this.getPlan(dataRow, track);
   dataRow = this.get_ganxian(dataRow, track);
   String[] xzcArray = setXZCArrayValue(ItemValue.getWaypointXZC(xzc[0]));
   //this.printXZCArray(xzcArray);
   if (xzcArray == null) {
     xb = this.getXZCXiabiao(xzc[0]);
     dataRow = getXZCString(dataRow,xb);
   }
   else {
     dataRow = this.getXZCString(dataRow,xzc[0]);
   }
   dataRow = this.get_beizhu(dataRow, track);
   return dataRow;
 }
 private String[] setXZCArrayValue(String[] xzc){
   if (xzc != null) {
     for (int i = 0; i < xzc.length; i++) {
       if (xzc[0] == null) {
         return null;
       }else if(xzc[0].equals("null")){
         return null;
       }else if(xzc[0].equals("")){
         return null;
       }
     }
   }
   return xzc;
 }
 private void printXZCArray(String[] xzc){
   if (xzc == null) {
     return;
   }
   else {
     for (int i = 0; i < xzc.length; i++) {
       if (xzc[i] == null) {
         System.out.println("xzc[" + i + "] ==" +xzc[i]);
       }else{
         System.out.println("xzc[" + i + "] equlse" +xzc[i]);
       }
       System.out.println("("+ xzc[i] + ")");
     }
   }

 }
 private String getRow(Node track) {
   String n = "";
   Node[] xzcArray = this.getXZCNode(track);

   if (noLimited) {
     if (xzcArray == null) {
       n = n + getOnlyRow(track, null);
     }
     else {
       n = n + getOnlyRow(track, xzcArray);
     }
     return n;
   }

   boolean isInPlan = TrackType.isInPlan(track);
   if (this.xuyao_xzc && this.xuyao_njian) { //行政村为true，拟建为true
     if ( isInPlan &&
         (ItemValue.getTracks_construct(track).equals(TrackType.Plan_NIJIAN))) {
       if (xzcArray == null) {
         return "";
       }
       n = n + getOnlyRow(track, xzcArray);
     }
   }
   else if ( (!this.xuyao_xzc) && this.xuyao_njian) { //行政村为false，拟建为true
     if ( isInPlan &&
         (ItemValue.getTracks_construct(track).equals(TrackType.Plan_NIJIAN)))
     {
       if (xzcArray == null) {
         n = n + getOnlyRow(track, null);
       }else{
        return "";
       }
     }
   }
   else if ( (this.xuyao_xzc) && (!this.xuyao_njian)) { //行政村为true，拟建为false
     if ( isInPlan )
     {
       if (xzcArray == null) {//如果行政村数组为空的话，
         return "";
       }else{
        n = n + getOnlyRow(track, xzcArray);
       }
     }
   }

   else if ( (!this.xuyao_xzc) && (!this.xuyao_njian)) {//行政村为和拟建都不限制，只限制是否是砂石或者土路
     if (isInPlan){
       if (xzcArray == null) {
         n = n + getOnlyRow(track, null);
       }else{
         n = n + getOnlyRow(track, xzcArray);
       }
     }
   }

   return n;
 }

 private String getReferencePoint(String string,Node track){
   ReferencePoint rp = new ReferencePoint();