jdbc学习 oracle数据库使用
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
/*
* DatabaseMetaData中getTables获取数据库所有表(查表)
* http://blog.sina.com.cn/s/blog_707a9f0601014y1a.html
* */
public class getTables {
public static void main(String[] args) {
String url = “jdbc:oracle:thin:@localhost:1521:orcl”;
String user = “caj”;
String password = “123456”;
Connection con = null;
try {
Class.forName("oracle.jdbc.OracleDriver");
con = DriverManager.getConnection(url, user, password);
DatabaseMetaData dm = con.getMetaData();
ResultSet ts = dm.getTables(null, "CAJ", null,
new String[] { "TABLE" });
while (ts.next()) {
System.out.println(ts.getString("TABLE_NAME") + " "
+ ts.getString("TABLE_TYPE"));
}
System.out.println(dm.getDatabaseProductName());
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}