newcommclass.java

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

package net.aetherial.gis.baobu.TotalExcel;

import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.List;

import net.aetherial.gis.output.FileOperate;
import net.aetherial.gis.surface.ItemValue;

public class NewCommClass {
	String txtFilePath = "";
	public List getXiangZhengTbl() {
		ReadTxt rt = new ReadTxt();
		List list = new ArrayList();
        String filePath = this.txtFilePath;
		String[] listStr = rt.readFile(filePath);
		String lineStr = "";
		String[] childStr = null;
		for (int i = 1; listStr != null && i < listStr.length; i++) {
			lineStr = listStr[i];
			if (lineStr.length() == 0) continue;
			// System.err.println(lineStr);
			list.add(lineStr);
			childStr = lineStr.split("\t");
			//System.err.println("========Number===" + childStr[0]);
		}
		//System.err.println("========Size===" + listStr.length);
		return list;

	}
	  public List getTxtAndInt ( String fileName){
		  ReadTxt rt = new ReadTxt();
			List list = new ArrayList();
			String[] listStr = null;
			String lineStr = "";
			String  bianMa = "";
			//读取行政村信息
			listStr = rt.readFile(fileName);
			int n = 0 ;
			String  qinLineStr = "";
			String qinBianMa = "";
			String tempStr = "";
			for (int i = 0; listStr != null && i < listStr.length; i++) {
				lineStr = listStr[i];
				if (i != 0){
					qinLineStr = listStr[i-1];
					qinBianMa = qinLineStr.split("\t")[0];
				}
		 		  bianMa = lineStr.split("\t")[0];
		 		  if (bianMa.equals(qinBianMa)){
		 			  tempStr = "\t" + lineStr + "\r\n" ; 
		 		  }else {
		 			   n ++;
		 			  tempStr = n+ "\t" + lineStr + "\r\n" ;
		 		  }
		 		  	 		  
		 	   list.add(tempStr);	
		 	  // System.out.println(tempStr);
			}
			
			return list;
	  }
	  public void getTxtAndIntToStringBuffer (String fileName ,String outPutFile) throws IOException{
		  ReadTxt rt = new ReadTxt();
		  FileOperate fo = new FileOperate();
		  File newFile = fo.createFolder(outPutFile);
		  FileWriter resultFile = new FileWriter(newFile);
		  PrintWriter myFile = new PrintWriter(resultFile);
			String list ="";
			String[] listStr = null;
			String lineStr = "";
			String  bianMa = "";
			//读取行政村信息
			listStr = rt.readFile(fileName);
			int n = 0 ;
			String  qinLineStr = "";
			String qinBianMa = "";
			String tempStr = "";
			for (int i = 0; listStr != null && i < listStr.length; i++) {
				lineStr = listStr[i];
				if (i != 0){
					qinLineStr = listStr[i-1];
					qinBianMa = qinLineStr.split("\t")[0];
				}
		 		  bianMa = lineStr.split("\t")[0];
		 		  if (bianMa.equals(qinBianMa)){
		 			  tempStr = "\t" + lineStr + "\r\n" ; 
		 		  }else {
		 			   n ++;
		 			  tempStr = n+ "\t" + lineStr + "\r\n" ;
		 		  }
		 		myFile.write(tempStr);  	 		         
		 	   // list += tempStr;	
		 	   System.out.println(tempStr);
			}
			resultFile.close();
			
	  }
	
	public List getAllTxt(String fileName){
		ReadTxt rt = new ReadTxt();
		List list = new ArrayList();
		String[] listStr = null;
		String lineStr = "";
		String  bianMa = "";
		//读取行政村信息
		listStr = rt.readFile(fileName);
		for (int i = 1; listStr != null && i < listStr.length; i++) {
			lineStr = listStr[i];
			if (lineStr.length() == 0) continue;
			//System.out.println(lineStr);
			list.add(lineStr);
		}
		
		return list;
	}
	//获取新增的乡镇、行政村信息
	public List getAllNewCunAndXiang(String filePath){
		ReadTxt rt = new ReadTxt();
		List list = new ArrayList();
		String[] listStr = null;
		String lineStr = "";
		String  bianMa = "";
		//读取行政村信息
		listStr = rt.readFile(filePath);
		for (int i = 1; listStr != null && i < listStr.length; i++) {
			lineStr = listStr[i];
			if (lineStr.length() == 0) continue;
			//System.out.println(lineStr);
			list.add(lineStr);
		}
		
		return list;
	}
	
	public List getVillagesAndTowns(){
		ReadTxt rt = new ReadTxt();
		List list = new ArrayList();
		String villageFilePath = this.txtFilePath + "\\Jzcjbqk.txt";
		String townFilePath = this.txtFilePath + "\\Xzjbqk.txt";
		String[] listStr = null;
		String lineStr = "";
		String  bianMa = "";
		//读取行政村信息
		listStr = rt.readFile(villageFilePath);
		for (int i = 1; listStr != null && i < listStr.length; i++) {
			lineStr = listStr[i];
			if (lineStr.length() == 0) continue;
			bianMa = lineStr.split("\t")[0];
			isXzcAndXzBianMa(bianMa);//验证编码
			list.add(lineStr);
		}
		//读取乡镇信息
		listStr = rt.readFile(townFilePath);
		for (int i = 1; listStr != null && i < listStr.length; i++) {
			
			lineStr = listStr[i];
			if (lineStr.length() == 0) continue;
			list.add(lineStr);
		}
		
		
		return list;
	}
	//获取乡镇、建制村的名称和编码
	public String [] getNameAndNumber(String name , String number , List list){
		   String [] temp = new String [2];
		   String lineStr = "";
		   String [] childStr =null;
		   String oldName = "";
		   String oldNumber = "";
		   String  bianMa = "";
		   for (int i = 0; i< list.size();i++){
			   lineStr = (String)list.get(i);
			   if (lineStr.length() == 0) continue;
			   childStr = lineStr.split("\t");
			  // bianMa = childStr[0];
			   oldName = childStr[4];
			   oldNumber = childStr[5];
			 //  isXzcAndXzBianMa(bianMa);//验证编码
			   if (oldName.equals(name) || oldNumber.equals(number)){
				   temp[0] = oldNumber;
				   temp[1] = oldName;
				   return temp;
			   }
		   }
		
		return temp;
	}
	
//	获取乡镇、建制村的名称和编码
	public String [] getOldNameAndNumber(String name , String number , String [] list){
		   String [] temp = new String [2];
		   String lineStr = "";
		   String [] childStr =null;
		   String oldName = "";
		   String oldNumber = "";
		   String  bianMa = "";
		   for (int i = 0; i< list.length;i++){
			   lineStr = list[i];
			  // if (lineStr.length() == 0) continue;
			   childStr = lineStr.split("\t");
			   bianMa = childStr[0];
			   oldName = childStr[1];
			   oldNumber = childStr[0];
			 //  isXzcAndXzBianMa(bianMa);//验证编码
			   if (oldName.equals(name) || oldNumber.equals(number)){
				   temp[0] = oldNumber;
				   temp[1] = oldName;
				   return temp;
			   }
		   }
		
		return temp;
	}
	
//	 读取路线信息表
	public String []  getRoadTable(String filePath) {
		ReadTxt rt = new ReadTxt();
	    filePath = filePath + "\\Lx.txt";
		String[] listStr = rt.readFile(filePath);
		
		return listStr;

	}
//	 读取路线信息表数组
	public String []  getRoadTableArray() {
		ReadTxt rt = new ReadTxt();
		List list = new ArrayList();
        String filePath = this.txtFilePath + "\\Lx.txt";
		String[] listStr = rt.readFile(filePath);
		
		return listStr;

	}
//	 读取路线信息表数组
	public String []  getRoadArray(String filePath) {
		ReadTxt rt = new ReadTxt();
		List list = new ArrayList();
	
		String[] listStr = rt.readFile(filePath + "\\Lx.txt");
		
		return listStr;

	}
	
	public int  getCityCount(String cityNumber) {
		FileOperate fo = new FileOperate();
		String outPutFile = "c:\\马鞍山市路线.txt";
		File newFile = fo.createFolder(outPutFile);
		FileWriter resultFile = null;
		try {
			resultFile = new FileWriter(newFile);
		} catch (IOException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		PrintWriter myFile = new PrintWriter(resultFile);
		ReadTxt rt = new ReadTxt();
	   String[] listStr = rt.readFile("E:\\增加的路线列表.txt");
	   int n = 0;
		for (int i = 1 ; listStr != null && i < listStr.length ; i++){
			if (listStr[i].split("\t")[1].substring(4,8).equals(cityNumber)){
				n ++;
				myFile.write(listStr[i]+"\r\n");
			}
			
		}
		myFile.close();
		return n;
	}
	
//	 读取路线信息表数组
	public String []  getCFWArray(String filePath) {
		ReadTxt rt = new ReadTxt();
		List list = new ArrayList();
	
		String[] listStr = rt.readFile(filePath);
		
		return listStr;

	}
	  // 判断是否是上次通达路线
	public List  isTongDa(String filePath){
   	        List list = new ArrayList();
   	        ReadTxt rt = new ReadTxt();
			String txtPath = filePath + "\\Xztdqk.txt";
	  		String[] listStr = rt.readFile(txtPath);
			String lineStr = "";
		    String roadNumber = "";
			//读取乡镇通达路线信息
			for (int i = 1; listStr != null && i < listStr.length; i++) {
				lineStr = listStr[i];
				if (lineStr.length() == 0) continue;
				roadNumber = lineStr.split("\t")[1];
				if (!roadNumber.substring(0,1).equals("C")) continue;
				list.add(lineStr);
				}
			
			//读取行政村通达路线信息
			 txtPath = filePath + "\\Jzctdqk.txt";
	  		 listStr = rt.readFile(txtPath);
	  		for (int i = 1; listStr != null && i < listStr.length; i++) {
				lineStr = listStr[i];
				roadNumber = lineStr.split("\t")[1];
				if (!roadNumber.substring(0,1).equals("C")) continue;
				if (lineStr.length() == 0) continue;
				list.add(lineStr);
				}
       
     
    	 return list;
    }
	public boolean isTongDaLx(List list,String lxNumber){
	  	String lineStr = "";
	    String roadNumber = "";
	
 	 for (int i = 0 ; list != null && i < list.size(); i++){
		 lineStr = (String)list.get(i);
	     roadNumber = lineStr.split("\t")[1];
		 if (roadNumber.equals(lxNumber))
			return false;
		
	 }
	 return true;
}
	//判断是否为通达路线
	public boolean isTDLx(List list,String lxNumber){
	  	String lineStr = "";
	    String roadNumber = "";
	
 	 for (int i = 0 ; list != null && i < list.size(); i++){
		 lineStr = (String)list.get(i);
	     roadNumber = lineStr.split("\t")[7];
		 if (roadNumber.equals(lxNumber))
			return false;
		//System.out.println("=========="+roadNumber);
	 }
	 return true;
}
	//根据路线编码得到路断表中路线的里程
	public double  getRoadInfo (String [] ldList , String lxNumber){
		double  temp = 0.0;
		double mileCount = 0.0;
		ReadTxt rt = new ReadTxt();
		List list = new ArrayList();
		String lineStr = "";
		String[] childStr = null;
		String roadNumber = "";
		String roadWidth = "";
		String luJiWidth = "";
		double roadMile = 0.0;
		int n = 0;
	
		childStr = null;
		for (int j = 0; ldList != null && j < ldList.length ; j++) {
			   lineStr = ldList[j];
			   if (lineStr.length() == 0) continue;
			   childStr = lineStr.split("\t");
			   roadNumber = childStr[1].trim(); 
			   roadWidth = childStr[20];
			   luJiWidth = childStr[21];
			   roadMile = Double.parseDouble(childStr[19]);
			   mileCount += roadMile;
				if ((Double.parseDouble(roadWidth) < 3.5 &&  Double.parseDouble(luJiWidth) < 4.5)){
				n ++;
               
          	}
    	}
		  if (n == ldList.length ){
				return mileCount;
		  }
		
		return temp;
		
		
	}
	
	
	public List getLdByLxnumber(List ldList,String lxNumber){
		 List list = new ArrayList();
			String lineStr = "";
			String[] childStr = null;
			String roadNumber = "";
			String roadWidth = "";
			String luJiWidth = "";
			double roadMile = 0.0;
			int n = 0;
		
			childStr = null;
			for (int j = 0; ldList != null && j < ldList.size() ; j++) {
				   lineStr = (String) ldList.get( j);
				   if (lineStr.length() == 0) continue;
				   childStr = lineStr.split("\t");
				   roadNumber = childStr[1].trim(); 
				   if (roadNumber.equals(lxNumber))
					   list.add(lineStr);
		          
	    	}
		 
		 return list;
	}
	
	public List getLdByLxnumber1(List ldList,String lxNumber){
		 List list = new ArrayList();
			String lineStr = "";
			String[] childStr = null;
			String roadNumber = "";
			String roadWidth = "";
			String luJiWidth = "";
			double roadMile = 0.0;
			int n = 0;
		
			childStr = null;
			for (int j = 0; ldList != null && j < ldList.size() ; j++) {
				   lineStr = (String) ldList.get( j);
				   if (lineStr.length() == 0) continue;
				   childStr = lineStr.split("\t");
				   roadNumber = childStr[5].trim(); 
				   if (roadNumber.equals(lxNumber))
					   list.add(lineStr);
		          
	    	}
		 
		 return list;
	}
//	根据路线编码得到路断表中路线的里程
	public double  getRoadInfo2 (List  ldList , String lxNumber){
		double  temp = 0.0;
		double mileCount = 0.0;
		ReadTxt rt = new ReadTxt();
		List list = new ArrayList();
		String lineStr = "";
		String[] childStr = null;
		String roadNumber = "";
		String roadWidth = "";
		String luJiWidth = "";
		double roadMile = 0.0;
		int n = 0;
	
		childStr = null;
		for (int j = 0; ldList != null && j < ldList.size() ; j++) {
			   lineStr = (String) ldList.get( j);