ÔÚÒ»¸öoracleÊý¾Ý¿â¿âÖÐÓÐn¶à±í, Ö»ÖªµÀÔÚÕâЩ±íÖеÄij¸ö×ֶδæÔÚÕâÑùµÄ¸ñʽ¹Ì¶¨µÄÊý¾Ý£ºÈç0001.123456789
ÔõôÑù²ÅÄÜÆ¥Åäµ½ÕâÖÖÊý¾Ý´æÔÚÄĸö±íÖУ¿
´úÂëÈçÏ£º
public static void main(String[] args) throws SQLException,ClassNotFoundException {
Class.forName(¡°oracle.jdbc.driver.OracleDriver¡±);
Connection c = DriverManager.getConnection(¡°jdbc:Oracle:thin:@127.0.0.1:1521:orcl¡±, ¡°scott¡±, ¡°tiger¡±);
Statement s = c.createStatement();
//ͨ¹ýÊý¾Ý×ÖµäÀ´²éѯÓû§ÏÂËùÓñí
ResultSet tabres = s.executeQuery(¡°select t.table_name from user_tables t¡±);
Set set=new HashSet();
while (tabres.next()) {
Statement st = c.createStatement();
//ÔÚµ¥¸öµ¥¸ö±í²éѯƥÅä×Ö¶ÎÊý¾Ý
ResultSet res = st.executeQuery(¡°select * from ¡°+tabres.getObject(1));
int count=res.getMetaData().getColumnCount();
boolean falg=false;
while(res.next()){
for(int i=1;i<=count;i++){
if(!¡±".equals(res.getObject(i))&&null!=res.getObject(i)){
String str=res.getObject(i).toString();
//ͨ¹ýÕýÔòÆ¥ÅäÌض¨Êý¾Ý
if(regexp(str)){
set.add(tabres.getObject(1));
}
}
}
}
}
s.close();
//´òÓ¡
System.err.println(set);
}
public static boolean regexp(String str){
Pattern pattern = Pattern.compile(¡°^.* [0-9]{4}\\.[0-9]{9}¡±);
Matcher matcher = pattern.matcher(str);
return matcher.matches();
}