readnianbo.java

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

/*
 * 创建日期 2006-9-7
 * 作    者  朱 闰
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */

package net.aetherial.gis.baobu.TongDa;

import java.io.File;
import java.util.ArrayList;
import java.util.Vector;

import net.aetherial.gis.jiaotongbu.output.publicuse.Item;
import net.aetherial.gis.our.duibi.readXLS.ReadFile;
import net.aetherial.gis.output.FileOperate;
import net.aetherial.gis.output.toLd.OpenDirectory;
import net.aetherial.gis.output.toTable.readglj.LdRow;
import net.aetherial.gis.output.toTable.readglj.ReadRow;
import net.aetherial.gis.output.toTable.zhurun.ReadAll;
import net.aetherial.gis.output.toTable.zhurun.ToGPS;

public class ReadNianBo extends ReadFile{
	  public static Vector allRow = new Vector();
	  public ReadNianBo() {
	    this.setSheet("file\\glj\\luduanxinxi.xls","t");
	    this.row = this.baseRow = 0;
	  }

	  public void read(){
//	    System.out.print("  正在读取公路局路段信息表:");
	    while (true) {
	      if (this.row >= 11274) {
	        break;
	      }
//	      if (this.row % 1000 == 1) {
//	        System.out.print(this.row + ", ");
//	      }
	      this.moveNext();
	      if (!this.isEmptyrow()) {
	        allRow.add((new ReadRow(this.rowData)).getLdRow());
	      }else{
	        break;
	      }
	    }
//	    System.out.println("");
	  }

	
	  
	  public static Vector getDuanTouRoad(){
		   Vector temp  = new Vector();
		   String lxNumber  = "";    //路线编号
		   String xingZhen  = "";     //行政单位
		   String isDuanTou = "是";
			
		    for (int i = 0; i < allRow.size(); i++) {
			   lxNumber  = ((LdRow)allRow.get(i)).getLxNumber();
			   isDuanTou = ((LdRow)allRow.get(i)).getIsDuanTou();
	 		  if (isDuanTou.indexOf("否") == -1)   
					  temp.add((LdRow)allRow.get(i));
			    }
		    
		   Vector allDuanTou = new Vector();
		   int n = 0;
		   for(int i = 0; i < temp.size() ; i++ ){
			   lxNumber=((LdRow)temp.get(i)).getLxNumber();
			   n = 0;
			   for(int j = 0; j < allDuanTou.size() ; j++){
				   String   roadNumber = ((LdRow)allDuanTou.get(j)).getLxNumber();
				   if(roadNumber.equals(lxNumber))
					   n++; 
			   }
			   if (n == 0) {
				   allDuanTou.add((LdRow)temp.get(i));
			   }
			   
		   }
		  
		  return allDuanTou;
	  }

	  //-----------根据市名获取所有县道
	  public static Vector getXianByCity(String shiName,String road){
		  Vector temp  = new Vector();
	      String lxNumber= "";    //路线编号
	      String xingZhen="";     //行政单位
	      String roadType="X";
	      if(road.equals("乡道")) roadType="Y"; 
	    for (int i = 0; i < allRow.size(); i++) {
		   lxNumber=((LdRow)allRow.get(i)).getLxNumber();
	       xingZhen=((LdRow)allRow.get(i)).getXinZhengName();
	
			 if (lxNumber.indexOf(roadType)!=-1 && xingZhen.indexOf(shiName) != -1)   
				  temp.add((LdRow)allRow.get(i));
		    }
 	   return temp;
		  
	  }
	  
	  

	  public boolean isEmptyrow(){
	    boolean empty = true;
	    if (rowData != null) {
	      for (int i = 0; i < rowData.length; i++) {
	        if (!(rowData[i].getContents().equals(""))) {
	          empty = false;
	          break;
	        }
	      }
	    }else{
	      return true;
	    }
	    return empty;
	  }
	

public static void main(String[] args) {
	 
	ReadNianBo rnb = new ReadNianBo();
	rnb.read();
	Vector allDuanTou = getDuanTouRoad();
	String lxNumber = "";
	String lxName = "";
	String rowStr = "";
	String xingZhen = "";
	for ( int i = 0; i < allDuanTou.size() ; i++ ){
		 lxNumber = ((LdRow)allDuanTou.get(i)).getLxNumber();
		 lxName   = ((LdRow)allDuanTou.get(i)).getLxName();
		 xingZhen = ((LdRow)allDuanTou.get(i)).getXinZhengName();
		 rowStr  += lxNumber+"\t\t"+lxName+"\t\t\t"+xingZhen+"\r\n";
	    System.err.println("==="+rowStr);
	 }
	 FileOperate fileOperate = new FileOperate();
     fileOperate.newFile("d:\\可能断头的路线.txt",rowStr);
   }
}