test.java

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

/*
 * 创建时间：Nov 24, 2006
 * 作者：朱　闰
 * 安徽省通途信息技术有限公司 (c) 2006
 * 
 * 实现以下功能：
 */
package com.tongtu.comm.loadData;

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.tongtu.Dao.role.RoleDAO;
import com.tongtu.Dao.role.roleDao.RoleDAOImpl;

import jxl.Sheet;
import jxl.Workbook;

public class test {

	private String zlwb = null;
	private String jhbg = null;
	private Map map = new HashMap();
	private RoleDAO roleDao = new RoleDAOImpl();
	public static void main(String args[]){
		
		String path = "F:\\村村通数据\\安徽省\\合肥市\\肥西县";
		test t = new test();
		t.readFile(path);
	
	}
	public void readFile(String path){
		File file = new File(path);
		File f[];
		if(file.isDirectory()){
			if(file.getName().equals("整理完毕")){
				zlwb = file.getAbsolutePath() ;
				System.out.println(file.getAbsolutePath());
			}
			else if(file.getName().equals("计划表格")){
				jhbg = file.getAbsolutePath() ;
				System.out.println(file.getAbsolutePath());
				readJHBG(jhbg);
				if(zlwb!=null){

				}
			}
			else{
				f = file.listFiles();
				for(int i=0;i<f.length ;i++){
					readFile(f[i].getAbsolutePath());
				}
			}
		}
	}
	
	public void readJHBG(String path){
		File f = new File(path);
		File file[] = f.listFiles();
		
		for(int i=0; i<file.length; i++){
			if(file[i].getName().equals("乡村道沟通行政村.xls")){
				readXLS(file[i]);
			}
		}
	}
	
	public void readXLS(File file){
		String xzName ="";
		String td [] = new String[2];
		
		int qdmc = 2;
		int qdjd = 3;
		int zjd1 = 4;
		int zjd1jd = 5;
		int zjd2 = 6;
		int zjd2jd  = 7;
		int zjd3 = 8 ;
		int zjd3jd  = 9;
		int zdmc  =  10;
		int zdjd  = 11;
		int lxmc = 0;
		int xzcmc = 1;
		int xzlc = 12;
		int xzljkd = 13;
		int xzlmkd= 14;
		int xzlmlx = 15;
		int lc = 16;
		int ljkd = 17;
		int lmkd = 18;
		int lmlx = 19;
		int tze = 20;
		int sbzj = 21;
		int rk = 26;
		int sr = 27;
		int jjzw = 28;
		int begin = 22;
		int end = 23;
		
		try
		{
//		构建Workbook对象, 只读Workbook对象
//		直接从本地文件创建Workbook
//		从输入流创建Workbook
		InputStream is = new FileInputStream(file);
		jxl.Workbook rwb = Workbook.getWorkbook(is);
		
		Sheet rs = rwb.getSheet(0);
		String content = "路线名称\t乡镇名称\t乡镇编码\t行政村名称\t起点名称\t起点位置\t中间点1名称\t中间点1位置\t中间点2名称\t中间点2位置\t中间点3名称\t中间点3位置\t终点名称\t终点位置\t" +
				        "里程（现状）\t路基宽(现)\t路面宽度(现）\t路面类型(现）\t建设里程\t路基宽\t路面宽度\t路面类型\t投资金额\t省补资金\t开工时间\t完工时间\t人口\t收入\t经济作物\n";
		for(int i=7; i<rs.getRows(); i++){
			String rowStr = "";
			String roadName = "";
			String townName = "";
			String townCode = "";
			String xzcName = "";
			String beginTime = "";
			String endTime = "";
			String qdmc_lx,qdloc_lx,zjd1mc_lx,zjd1loc_lx,zjd2mc_lx,zjd2loc_lx,zjd3mc_lx,zjd3loc_lx,zdmc_lx,zdloc_lx;
			String lc_xz ,ljkd_xz,lmkd_xz,lmlx_xz;
			String jhlc,jhljkd,jhlmkd,jhlmlx,jhtze,jhsbzj,renkou,shouru,jj;
			if(!rs.getCell(0, i).getContents().equals("")&&rs.getCell(qdmc, i).getContents().equals("")){
				{
					xzName = rs.getCell(0 , i).getContents() ;
					townCode = roleDao.getTownCode(xzName);
					System.out.println("=============townCode====" + townCode);
				}
			if(map.get(xzName) == null)
				map.put(xzName, new ArrayList());
			System.out.println(xzName);
			}
			else if(!rs.getCell(0, i).getContents().equals("")&&!rs.getCell(qdmc , i).getContents().equals("")){
				System.out.println(xzName);
				System.out.println("----- 正在读取"+rs.getCell(0 , i).getContents());
				System.out.println(rs.getCell(qdmc, i).getContents()+"  "+rs.getCell(qdjd, i).getContents()+"  "+rs.getCell(qdjd, i+1).getContents());
				System.out.println(rs.getCell(zjd1, i).getContents()+"  "+rs.getCell(zjd1jd, i).getContents()+"  "+rs.getCell(zjd1jd, i+1).getContents());
				System.out.println(rs.getCell(zjd2, i).getContents()+"  "+rs.getCell(zjd2jd, i).getContents()+"  "+rs.getCell(zjd2jd, i+1).getContents());
				System.out.println(rs.getCell(zjd3, i).getContents()+"  "+rs.getCell(zjd3jd, i).getContents()+"  "+rs.getCell(zjd3jd, i+1).getContents());
				System.out.println(rs.getCell(zdmc, i).getContents()+"  "+rs.getCell(zdjd, i).getContents()+"  "+rs.getCell(zdjd, i+1).getContents());
				System.out.println("现状里程  "+rs.getCell(xzlc, i).getContents());
				
				qdmc_lx  = rs.getCell(qdmc, i).getContents();
				qdloc_lx = "POINT(" + rs.getCell(qdjd, i).getContents()+"  "+rs.getCell(qdjd, i+1).getContents() + ")";
				
				zjd1mc_lx  = rs.getCell(zjd1, i).getContents();
				zjd1loc_lx = "POINT(" + rs.getCell(zjd1jd, i).getContents()+"  "+rs.getCell(zjd1jd, i+1).getContents() + ")";
				
				zjd2mc_lx  = rs.getCell(zjd2, i).getContents();
				zjd2loc_lx = "POINT(" + rs.getCell(zjd2jd, i).getContents()+"  "+rs.getCell(zjd2jd, i+1).getContents()+ ")";
				
				zjd3mc_lx  = rs.getCell(zjd3, i).getContents();
				zjd3loc_lx = "POINT(" + rs.getCell(zjd3jd, i).getContents()+"  "+rs.getCell(zjd3jd, i+1).getContents() + ")";
			 
				zdmc_lx  = rs.getCell(zdmc, i).getContents();
				zdloc_lx = "POINT(" + rs.getCell(zdjd, i).getContents()+"  "+rs.getCell(zdjd, i+1).getContents() + ")";
			
				
				roadName = rs.getCell(lxmc, i).getContents();
				townName = xzName;
				xzcName = rs.getCell(xzcmc, i).getContents();
				lc_xz = rs.getCell(xzlc, i).getContents();
				ljkd_xz = rs.getCell(xzljkd, i).getContents();
				lmkd_xz = rs.getCell(xzlmkd, i).getContents();
				lmlx_xz = rs.getCell(xzlmlx, i).getContents();
				jhlc = rs.getCell(lc, i).getContents();
				jhljkd = rs.getCell(ljkd, i).getContents();
				jhlmkd = rs.getCell(lmkd, i).getContents();
				jhlmlx = rs.getCell(lmlx, i).getContents();
				jhtze = rs.getCell(tze, i).getContents();
				jhsbzj = rs.getCell(sbzj, i).getContents();
				renkou = rs.getCell(rk, i).getContents();
				shouru = rs.getCell(sr, i).getContents();
				jj = rs.getCell(jjzw, i).getContents();
				beginTime = rs.getCell(begin, i).getContents();
				endTime = rs.getCell(end, i).getContents();
				
				townCode = roleDao.getTownCode(xzName);
				System.out.println("=============townCode====" + townCode);
				rowStr = roadName + "\t" + townName+"\t" + townCode + "\t" +xzcName + "\t" + qdmc_lx+ "\t" +
				         qdloc_lx + "\t" + zjd1mc_lx + "\t" + zjd1loc_lx + "\t" + zjd2mc_lx+"\t" +
				         zjd2loc_lx + "\t"+	zjd3mc_lx + "\t" + zjd3loc_lx+"\t" +zdmc_lx + "\t"+
				         zdloc_lx + "\t" + lc_xz + "\t" + ljkd_xz + "\t" + lmkd_xz + "\t" + lmlx_xz + "\t" +
				         jhlc + "\t" + jhljkd + "\t" + jhlmkd+"\t" +jhlmlx + "\t" + jhtze + "\t" + jhsbzj + "\t" + 
				         beginTime + "\t" + endTime + "\t" +
				         renkou + "\t" + shouru + "\t" + jj + "\t";
			  content += rowStr+"\n";
			
			
			
			}
			else if(rs.getCell(3 , i).getContents().equals(""))
				break;
		}
		
		    System.out.println("filePaht===" + file.getAbsolutePath());
		    System.out.println("length=="+file.getAbsolutePath().length());
		    String fileName = file.getName();
		    String filePath = file.getAbsolutePath();
	    	FileOperate fo = new FileOperate();
	        fo.newFile("d:\\" + filePath.substring(13,20)+"\\" +fileName.substring(0,fileName.length()-4)+ ".txt", content);
		
		}
		catch (Exception e)
		{
		e.printStackTrace();
		}
	}
}