在使用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); Setset = new java.util.HashSet (); 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())); }}