public static void main(String[] args) throws Exception
{
// Load the database driver - in this case, we
// use the Jdbc/Odbc bridge driver.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // Open a connection to the database
Connection conn = DriverManager.getConnection("[jdbcURL]",
"[login]", "[passwd]"); // Get DatabaseMetaData
DatabaseMetaData dbmd = conn.getMetaData(); // Get all dbObjects. Replace the last argument in the getTables
// method with objectCategories below to obtain only database
// tables. (Sending in null retrievs all dbObjects).
String[] objectCategories = {"TABLE"};
ResultSet rs = dbmd.getTables(null, null, "%", null); // Printout table data
while(rs.next())
{
// Get dbObject metadata
String dbObjectCatalog = rs.getString(1);
String dbObjectSchema = rs.getString(2);
String dbObjectName = rs.getString(3);
String dbObjectType = rs.getString(4); // Printout
System.out.println("" + dbObjectType + ": " + dbObjectName);
System.out.println(" Catalog: " + dbObjectCatalog);
System.out.println(" Schema: " + dbObjectSchema);
} // Close database resources
rs.close();
conn.close();
}
{
// Load the database driver - in this case, we
// use the Jdbc/Odbc bridge driver.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // Open a connection to the database
Connection conn = DriverManager.getConnection("[jdbcURL]",
"[login]", "[passwd]"); // Get DatabaseMetaData
DatabaseMetaData dbmd = conn.getMetaData(); // Get all dbObjects. Replace the last argument in the getTables
// method with objectCategories below to obtain only database
// tables. (Sending in null retrievs all dbObjects).
String[] objectCategories = {"TABLE"};
ResultSet rs = dbmd.getTables(null, null, "%", null); // Printout table data
while(rs.next())
{
// Get dbObject metadata
String dbObjectCatalog = rs.getString(1);
String dbObjectSchema = rs.getString(2);
String dbObjectName = rs.getString(3);
String dbObjectType = rs.getString(4); // Printout
System.out.println("" + dbObjectType + ": " + dbObjectName);
System.out.println(" Catalog: " + dbObjectCatalog);
System.out.println(" Schema: " + dbObjectSchema);
} // Close database resources
rs.close();
conn.close();
}
解决方案 »
- 这样的一个xml如何读取. 取得里面的power.
- 实现JSP数据分页显示的具体方法(支持4种常见数据库)
- 谁有FCKeditor.java 2.3 (FCKeditot for java)
- 跪求 一个异常!
- Jsp页面引入问题
- 如何用java实现?
- grails vs spring
- 聊天室的问题:时间久了会服务器崩溃,用户不正常退出,没办法更新列表!请进来谈谈,我看不少人遇到这个问题的.
- 一公司要关于java的笔试,给点指引,谢先!===
- 请问在win2000,ibm http环境下怎么配置websphere才能执行*.jsp文件。请大家帮帮忙
- jsp中调用oracle的存储过程
- tomcat中引用类的问题
public static void main(String[] args) throws Exception
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connection conn = DriverManager.getConnection("[jdbcURL]",
"[login]", "[passwd]");DatabaseMetaData dbmd = conn.getMetaData();String tablename="talbename";
ResultSet rs = dbmd.getColumns(null, null,tablename , null);while(rs.next())
{
String dbObjectName = rs.getString(4);
System.out.println("columnname: " + dbObjectName);
}
if(conn!=null)
rs.close();
conn.close();
}