h2 数据文件解析

在使用h2数据库时，，出现数据文件查询不出来。。

但是还有些数据有用，，就只有找到数据文件。

name.mv.db 数据文件

sina.trace.db 日志文件

 

package org.apache.commons.selenium.data;

import java.io.FileInputStream;
import java.util.Set;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import org.apache.commons.io.IOUtils;
import org.hsqldb.lib.HashSet;

public class Class1 {

	public static void main(String[] args) throws Exception {

		// String pattern = "乘+(.*)+车";

		/*
		 * String pattern = "乘+([^乘车]*)+车";
		 * 
		 * String target = "乘露车露露车,王者乘22路车归来，张军乘eei路车网";
		 */

		String regex1 = "[a-zA-Z]+[a-zA-Z0-9_]*@[a-zA-Z0-9]+[.][a-zA-Z0-9]+";

		String pattern = "Z+([^Z]*)+VT铁";

		String target = "adsdsf@siam.com1111VT铁啊飒飒asfZ222@sina.comVT铁";
		// String target = "adsdsfZ1111VT铁啊飒飒asfZ222VT铁";
		target = IOUtils.toString(new FileInputStream(
				"E:\\test\\db\\sina.mv.db"));
		// Pattern p = Pattern.compile(pattern);
		Pattern p = Pattern.compile(regex1);
		Matcher m = p.matcher(target);

		Set<String> set = new java.util.HashSet<String>();
		int i = 0;
		while (m.find()) {
			i++;
			String source = m.group();
			source = source.substring(2, source.length());
			if (source.contains("com")) {
				String[] mails = source.split("\\.com");
				if (mails != null && mails.length == 2) {
					String mail = mails[0] + ".com";
					String pwd = mails[1];

					pwd = pwd.substring(1, pwd.length() - 2);
					set.add(mail + "----" + pwd);
					System.out.println(mail + "----" + pwd);
				}

			} else {
				String[] mails = source.split("\\.net");
				if (mails != null && mails.length == 2) {
					String mail = mails[0] + ".net";
					String pwd = mails[1];
					pwd = pwd.substring(1, pwd.length() - 2);
					set.add(mail + "----" + pwd);
					System.out.println(mail + "----" + pwd);
				}

			}
			// set.add(source);
			// set.add(source.substring(1, source.length()));
			// System.out.println(source);

		}

		//System.out.println(i);
		System.out.println(set.size());

		// System.out.println(set);
		// System.out.println("XZorkahf60937@027168.c".substring(2,
		// "XZorkahf60937@027168.c".length()));
	}

}