//以下功能为:查询数据库用户中所有的表名
try
{
rs = stmt.executeQuery("select table_name,column_name from user_tab_columns where data_type <> /'DATE/' and DATA_TYPE <> /'BLOB/'");
while(rs.next())
{
tabName = rs.getString("table_name");
tablst.add(tabName);
colName = rs.getString("column_name");
collst.add(colName);
}
rs.close();
for(int i = 0; i < tablst.size(); i++)
{
tabArray = tablst.toArray();
colArray = collst.toArray();
//System.out.println(tabArray[i].toString());
}
} catch (SQLException e) {
e.printStackTrace();
}//try end
for(int i = 0; i < tablst.size(); i++)
try
{
String sql = "select " + colArray[i].toString() + " from " + tabArray[i].toString()
+ " where " + colArray[i].toString() + " like " + "/'%" + str + "%/'";
rs = stmt.executeQuery(sql);
ResultSetMetaData data=rs.getMetaData();
while(rs.next())
{
colValue = rs.getString(data.getColumnName(1));
sb.append(tabArray[i].toString() + "." + colArray[i].toString() + ": " + colValue + "/n");
System.out.println(tabArray[i].toString() + "." + colArray[i].toString() + ": " + colValue + "/n");
cnt++;
}//end while
rs.close();
}catch (SQLException e) {
e.printStackTrace();
}//end try
用Java实现遍历Oracle数据库某用户下的所有数据,找出想要查找的记录
最新推荐文章于 2023-07-05 17:43:12 发布