如何在Java中检测SQL表的存在? [英] How can I detect a SQL table's existence in Java?
问题描述
如何检测某个表是否存在于给定的Java数据库中? href =http://java.sun.com/j2se/1.5.0/docs/api/java/sql/DatabaseMetaData.html#getTables(java.lang.String,%20java.lang.String,%20java.lang .String,%20java.lang.String [])rel =noreferrer> DatabaseMetaData.getTables()以获取有关现有表的信息。
此方法透明地工作,并且独立于数据库引擎。我认为它会在后台查询信息模式表。
编辑:
这是打印所有现有表名称的示例。 p>
DatabaseMetaData md = connection.getMetaData();
ResultSet rs = md.getTables(null,null,%,null);
while(rs.next()){
System.out.println(rs.getString(3));
}
How can I detect if a certain table exists in a given SQL database in Java?
You can use DatabaseMetaData.getTables() to get information about existing tables.
This method works transparently and is independent of the database engine. I think it queries information schema tables behind the scenes.
Edit:
Here is an example that prints all existing table names.
DatabaseMetaData md = connection.getMetaData();
ResultSet rs = md.getTables(null, null, "%", null);
while (rs.next()) {
System.out.println(rs.getString(3));
}
这篇关于如何在Java中检测SQL表的存在?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!