package?com.lz.check;


import?java.io.File;
import?java.io.IOException;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;

import?org.apache.commons.io.FileUtils;
import?org.apache.commons.lang.StringUtils;
import?org.json.JSONArray;
import?org.json.JSONobject;
import?org.jsoup.Jsoup;
import?org.jsoup.nodes.Document;
import?org.jsoup.nodes.Element;
import?org.jsoup.select.Elements;

import?com.jindi.companyname.hu.Utils.SqlUtil;
import?com.jindi.companyname.hu.Utils.StringUtil;
import?com.jindi.companyname.utils.FileUtil;
import?com.jindi.companyname.utils.OSUtils;
import?com.lz.controller.QCCController;
import?com.lz.webmagic.processor.QichachaInfoProcessor;
import?com.lz.webmagic.processor.QixinbaoInfoProcessor;


public?class?CheckNotExistCompany?{
	private?static?String?basePath?=?OSUtils.isWinOS（）?“D:/companyData/checkDB/“:“/mnt/data4/huling/data/online/checkDB/“;//server3

	/**
	?*?@param?args
	?*/
	public?static?void?main（String[]?args）?{
//		args?=?new?String[1];
//		args[0]?=?basePath?+?“publish-stock-notexist.txt“;
		if?（args?!=?null?&&?args.length?>?0）?{
			checkDB（args[0]）;
		}
	}
	
	public?static?void?checkDB（String?filePath）?{
		File?file?=?new?File（filePath）;
		if?（!file.exists（）?||?!file.isFile（））?{
			System.out.println（filePath）;
			System.out.println（“請輸入要檢查的文件名...“）;
			return;
		}
		List?companyList?=?new?ArrayList（）;
		try?{
			companyList?=?FileUtils.readLines（file）;
		}?catch?（IOException?e1）?{
			//?TODO?Auto-generated?catch?block
			e1.printStackTrace（）;
		}
//		List?companyList?=?FileUtil.instance.readFile（“D://creditHz/result/newEnt-20170212.csv“）;
		StringBuffer?listStr?=?new?StringBuffer（““）;
		StringBuffer?existStr?=?new?StringBuffer（““）;
		StringBuffer?oldNameStr?=?new?StringBuffer（““）;
		int?min?=?0;
		int?max?=?companyList.size（）;
		int?total?=?0;
		int?notExist?=?0;
		int?oldNameCount?=?0;
		for?（int?i?=?min;?i?			try?{
				String?company?=?companyList.get（i）;
				if?（StringUtils.isNotBlank（company））?{
					total?++;
					String?companyName?=?company.split（““）[0].replace（“（“?“（“）.replace（“）“?“）“）.trim（）.replace（“?“?““）;//最后一個replace是去掉utf-8BOM文件的頭部字符A279;
					if?（!SqlUtil.companyExistsAndHasbase（companyName））?{
						if?（SqlUtil.isOldName（companyName））?{
							oldNameCount?++;
							oldNameStr.append（company?+?“\r\n“）;
							System.out.println（“第“?+?i?+?“條，曾用名：========“?+?companyName?+?“==“）;
						}?else?{
							notExist?++;
							listStr.append（company?+?“\r\n“）;
							System.out.println（“第“?+?i?+?“條，找到新公司：========“?+?companyName?+?“==“）;
						}
					}?else?{
						existStr.append（company?+?“\r\n“）;
//						System.out.println（“第“?+?i?+?“條，已存在：“?+?companyName）;
					}
				}
			}?catch?（Exception?e）?{
				//?TODO:?handle?exception
				e.printStackTrace（）;
				continue;
			}
		}
		System.out.println（“total:“?+?total）;
		System.out.println（

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-08-15?18:35??CRMlz\
?????文件????????1780??2017-07-23?14:49??CRMlz\.classpath
?????目錄???????????0??2017-08-15?18:35??CRMlz\.externalToolBuilders\
?????文件?????????548??2017-04-04?20:11??CRMlz\.externalToolBuilders\org.eclipse.wst.jsdt.core.javascriptValidator.launch
?????文件????????1354??2017-07-09?11:13??CRMlz\.project
?????目錄???????????0??2017-08-15?18:35??CRMlz\.settings\
?????文件?????????639??2017-01-02?21:01??CRMlz\.settings\.jsdtscope
?????文件?????????334??2017-07-16?14:57??CRMlz\.settings\org.eclipse.core.resources.prefs
?????文件????????7137??2017-01-20?10:15??CRMlz\.settings\org.eclipse.jdt.core.prefs
?????文件??????????90??2017-01-02?21:01??CRMlz\.settings\org.eclipse.m2e.core.prefs
?????文件?????????665??2017-07-09?18:10??CRMlz\.settings\org.eclipse.wst.common.component
?????文件?????????321??2017-01-20?09:45??CRMlz\.settings\org.eclipse.wst.common.project.facet.core.prefs.xml
?????文件?????????346??2017-01-20?10:32??CRMlz\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-01-02?21:01??CRMlz\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-01-02?21:01??CRMlz\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件??????????50??2017-01-02?21:01??CRMlz\.settings\org.eclipse.wst.validation.prefs
?????目錄???????????0??2017-08-15?18:35??CRMlz\logs\
?????文件??????609021??2017-08-10?11:12??CRMlz\logs\ssm.log
?????文件????????7366??2017-08-10?11:11??CRMlz\pom.xml
?????目錄???????????0??2017-08-15?18:35??CRMlz\src\
?????目錄???????????0??2017-08-15?18:35??CRMlz\src\main\
?????目錄???????????0??2017-08-15?18:35??CRMlz\src\main\java\
?????目錄???????????0??2017-08-15?18:35??CRMlz\src\main\java\com\
?????目錄???????????0??2017-08-15?18:35??CRMlz\src\main\java\com\lz\
?????目錄???????????0??2017-08-15?18:35??CRMlz\src\main\java\com\lz\check\
?????文件????????4192??2017-07-23?18:34??CRMlz\src\main\java\com\lz\check\CheckNotExistCompany.java
?????文件????????5790??2017-07-23?18:22??CRMlz\src\main\java\com\lz\check\ThrowSearchQueue.java
?????文件????????2598??2017-07-23?18:23??CRMlz\src\main\java\com\lz\check\ThrowSearcQueueDiao.java
?????文件????????1812??2017-07-21?09:49??CRMlz\src\main\java\com\lz\check\writeTxt.java
?????目錄???????????0??2017-08-15?18:35??CRMlz\src\main\java\com\lz\controller\
?????文件????????1570??2017-07-10?09:25??CRMlz\src\main\java\com\lz\controller\LoginController.java
............此處省略1550個文件信息