什么库呀?
oracle: select table_names from user_tables
sqlserver: SELECT * FROM sysobjects WHERE xtype = 'U'
oracle: select table_names from user_tables
sqlserver: SELECT * FROM sysobjects WHERE xtype = 'U'
调试欢乐多
import java.sql.*;
public class Table {
/**
* Method main
*
*
* @param args
*
*/
public static void main(String[] args) {
// TODO: Add your code here
String strDriver="oracle.jdbc.driver.OracleDriver";
String strJdbcUrl="jdbc:oracle:thin:@192.168.0.8:1521:db";
String strUserName="UserName";
String strPassword="Password";
try{
Class.forName(strDriver);
Connection conn=DriverManager.getConnection(strJdbcUrl,strUserName,strPassword);
DatabaseMetaData dmd=conn.getMetaData();
//关键就是这一句怎么传参数了,这句你看着来填,可以参考一下api手册
ResultSet rs=dmd.getTables(null,null,null,null);
while(rs.next()){
System.out.println(rs.getString(2));
}
}catch(Exception e){
e.printStackTrace();
}
}
}