import java.io.*;
public class MyGrep 
{
	public MyGrep(){
		System.out.println("My Grep is running.");
	}
	public static void main(String[] args) 
	{
		//System.out.println("Hello World!");
		//String work_dir="F:\\惠公司暴露资产管理系统betaV1\\ok0501\\ok\\";
		//String work_dir="C:\\myjava\\ok0502\\ok\\";
		//String work_dir="C:\\myjava\\sec\\ok0605\\ok\\";
		String work_dir="C:\\myjava\\cmd\\ok\\";
		File f=new File(work_dir);
		String files[]=f.list();
		for (int i=0;i<files.length;i++ )
		{
			
			//System.out.println(files[i]);
			String cols[]=files[i].split("_");
			String ip=cols[0];
			String time=cols[1].substring(4,8)+"-"+cols[1].substring(8,10)+"-"+cols[1].substring(10,12)+" "+cols[1].substring(12,14)+":"+cols[1].substring(14,16)+":"+cols[1].substring(16,18);
			try{
				BufferedReader br=new BufferedReader(new InputStreamReader(new FileInputStream(work_dir+files[i])));
				String line;
				String result="Host is down";
				int result_flag=0;
				while((line=br.readLine())!=null){
					if(result_flag==1){
						result=line;
						result_flag=0;
					}
					if(line.startsWith("Host is up")){
						result_flag=1;
					}
					if(line.contains("open")&&line.contains("/")){
						String cols2[]=line.split("/");

						System.out.println("insert into hlq_scan_open_port0605 values('"+ip+"','"+time+"','"+cols2[0]+"','"+cols2[1]+"');");
					}
				}
				System.out.println("insert into hlq_scan_file0605 values('"+ip+"','"+time+"','"+result+"');");
				br.close();
			}catch(Exception e){
				System.out.println(e);
			}

		}
	}
}