testtextparse.java

文本文件数据提取

import java.io.*;
import java.sql.*;
/**
 * 
 */

/**
 * @author Administrator
 *
 */
public class TestTextParse {

	/**
	 * @param args
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws IOException, SQLException{
		// TODO Auto-generated method stub
		String filename = new String();
		TextParse tp = new TextParse();
		filename = "Demo1.txt";
		tp.ReadFile(filename);
		String sensor = new String();
		
		sensor = "01484981";
		tp.FilterNonMDAndWellSensor(sensor);
		
		sensor = "01484983";
		tp.FilterNonMDAndWellSensor(sensor);
		
		sensor = "01595790";
		tp.FilterNonMDAndWellSensor(sensor);
		
		sensor = "01610000";
		tp.FilterNonMDAndWellSensor(sensor);
		
		sensor = "01619000";
		tp.FilterNonMDAndWellSensor(sensor);
		
		sensor = "03075670";
		tp.FilterNonMDAndWellSensor(sensor);
		
		sensor = "381956076275301";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "382407076260301";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "383231076411301";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "383238076412501";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "383239076354201";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "383248076405302";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "383248076405303";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "383250076405302";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "384333076394701";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "392045076512501";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "392047076512301";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "392449076331100";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "392517077190401";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "393126076244301";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "393148079010601";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "393402077434201";
		tp.FilterNonMDAndWellSensor(sensor);
		sensor = "393733077274801";
		tp.FilterNonMDAndWellSensor(sensor);
		
		tp.FilterComment();
		
		filename = "group.txt";
		//将过滤好数据段写文件
		//type=0 显示数据段数据
		//type=1 显示滤掉最值后的数据
		//head 是否打印表头
//		tp.WriteFilterFile(filename, 1, true);
		
		tp.GroupData();
		
		//写分组文件
		//将分组好的文件写入N个group文件中
		//head 是否打印表头
		//separate 分隔符
//		tp.WriteGroupFile(true,";");
		
		OraDBAccess myOracleTest = new OraDBAccess();
        Connection myConnection = myOracleTest.getConnection("127.0.0.1","syl","syl","syl");
        System.out.println("Now begin to excute.............");
        //将分组文件存入数据库
        //myOracleTest.InsertGroupData(myConnection,tp.groupDataList); 
        //填补空白值
        //myOracleTest.FillBlankData(myConnection);
        //将数据库中填补好空白值后的数据输出到文件中；
        myOracleTest.GenerateTargetFile(myConnection);
		
	}

}