commclass.java

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

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

package net.aetherial.gis.baobu.TotalExcel;

import net.aetherial.gis.baobu.TotalExcel.*;
import net.aetherial.gis.output.FileOperate;
import net.aetherial.gis.surface.ItemValue;

import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.List;
public class CommClass {
	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 void getTxtFile (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 = 1; listStr != null && i < listStr.length; i++) {
				lineStr = listStr[i];
			    qinBianMa = lineStr.split("\t")[0].substring(0,13);
		 		myFile.write(qinBianMa+"\r\n");  	 		         
		 	   // list += tempStr;	
		 	   System.out.println(qinBianMa);
			}
			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[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 [] 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 List getRoadTable() {
		ReadTxt rt = new ReadTxt();
		List list = new ArrayList();
        String filePath = this.txtFilePath + "\\Lx.txt";
		String[] listStr = rt.readFile(filePath);
		String lineStr = "";
		String[] childStr = null;
		String lxNumber = "";
		for (int i = 1; listStr != null && i < listStr.length; i++) {
			
			lineStr = listStr[i];
			if (lineStr.length() == 0) continue;
			childStr = lineStr.split("\t");
			lxNumber = childStr[0];
			isLxNumber(lxNumber); //验证编码
			
			list.add(lineStr);
		
		}
	
		return list;

	}
//	 读取路线信息表数组
	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 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 double  getRoadInfo (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);
			   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.size()){
				return mileCount;
		  }
		
		return temp;
		
		
	}
//	根据路线编码得到路断表中路线的里程
	public double  getRoadMile (String [] ldList , String lxNumber){
		double  temp = 0.0;
		double mileCount = 0.0;
		String lineStr = "";
		String[] childStr = null;
		double roadMile = 0.0;
		int n = 0;
		int isChongFu = 0;//是否重复路线
		int isDuanTou = 0;//是否断头路线
		childStr = null;
		for (int j = 1; ldList != null && j < ldList.length; j++) {
			   lineStr = ldList[j];
			   if (lineStr.length() == 0) continue;
			   childStr = lineStr.split("\t");
			   if (childStr[1].equals(lxNumber)){
				    isChongFu =  Integer.parseInt(childStr[22]);
					isDuanTou = Integer.parseInt(childStr[26]);
				   roadMile = Double.parseDouble(childStr[19]);