datacheck.java

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

package com.tongtu.comm.loadData;

import java.util.List;

import com.tongtu.Dao.plan.PlanDAO;
import com.tongtu.Dao.plan.planDao.PlanDAOImpl;
import com.tongtu.Dao.role.RoleDAO;
import com.tongtu.Dao.role.roleDao.RoleDAOImpl;
import com.tongtu.util.City;
import com.tongtu.util.PlanDetail;

public class DataCheck {
	
	public void printNoHaveVillage(){
		PlanDAO plandao = new PlanDAOImpl();
		RoleDAO roledao = new RoleDAOImpl();
		FileOperate fo = new FileOperate();
		for (int k = 0; k < 17 ;k ++){
			String cityCode = City.allcity[k][0].substring(0,4);
			List planList = plandao.getPlanListByAll(cityCode);
			String rowStr = "";
			String content = "项目ID\t路线名称\t市\t县\t乡镇\t建制村名称\n";
			String cityName = City.allcity[k][1];
			for (int i = 0;i < planList.size();i++){
				PlanDetail pd = (PlanDetail)planList.get(i);
				rowStr = "";
				String code = pd.getTownsId().substring(0,6);
				String villageCode = roledao.getVillageCode(pd.getVillageName(), code);
				if (villageCode==null){
					rowStr = pd.getPlanId() + "\t" + pd.getRoadName() + "\t" + pd.getCityName()+"\t" + pd.getCountyName() + "\t" 
					         + pd.getTownName() + "\t" + pd.getVillageName()+ "\n";
					content += rowStr;
					System.out.println("========路线名称: " + pd.getRoadName()+"    建制村名称: " + pd.getVillageName());
				}
			}
			
			 fo.newFile("d:\\村村通数据检查结果\\建制村\\找不到的建制村("+cityName+").txt", content);
			
		}
			
	}
	
	
	public void priNoHaveTown(){
		RoleDAO roledao = new RoleDAOImpl();
		FileOperate fo = new FileOperate();
		String rowStr = "";
		for (int k = 0; k < 17 ;k ++){
			String cityCode = City.allcity[k][0].substring(0,4);
			List planList = roledao.getTownListByAll(cityCode);
		    String content = "市\t县\t乡镇名称\n";
			String cityName = City.allcity[k][1];
		for (int i = 0;i < planList.size();i++){
			PlanDetail pd = (PlanDetail)planList.get(i);
			rowStr = "";
			String code = pd.getTownsId().substring(0,6);
			String townCode = roledao.getTownCode(pd.getTownName(), code);
			if (townCode == null){
				System.out.println("========乡镇名称: " + pd.getTownName());
				rowStr = pd.getCityName() + "\t" + pd.getCountyName() + "\t" + pd.getTownName() + "\n";
				content += rowStr;
				
			}
			}
		
		    fo.newFile("d:\\村村通数据检查结果\\乡镇\\找不到的乡镇("+cityName+").txt", content);
		}
	}
	
	
	public static void main(String[] args){
		DataCheck dc = new DataCheck();
		dc.printNoHaveVillage();
		//dc.priNoHaveTown();
	}

}