javaはどうやってデータベースに表と表があるかどうかを検証します。
javaは、データベースにテーブルとテーブルの中に列があるかどうかをDatabaseMetaDataで確認することができます。
参考:
http://docs.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html
http://stackoverflow.com/questions/11699205/how-to-check-if-a-table-or-a-column-exists-in-a-database
参考:
http://docs.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html
http://stackoverflow.com/questions/11699205/how-to-check-if-a-table-or-a-column-exists-in-a-database
package com.zuidaima;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
public class CheckTableAndColumnExist {
public static void main(String[] args) {
Connection connection = null;
try {
String userName = "root";
String password = "111111";
String jdbcurl = "jdbc:mysql://localhost:3306/zuidaima?useUnicode=true&characterEncoding=utf-8";
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(jdbcurl, userName,
password);
DatabaseMetaData md = connection.getMetaData();
String tableName = "staff";
String columnName = "column_name";
ResultSet rs = md.getTables(null, null, tableName, null);
if (rs.next()) {
System.out.println("Table " + tableName + " exist");
rs = md.getColumns(null, null, tableName, columnName);
if (rs.next()) {
System.out.println("Table " + tableName
+ " exist in Table " + tableName);
} else {
System.out.println("Column " + tableName
+ " not exist in Table " + tableName);
}
} else {
System.out.println("Table " + tableName + " not exist");
}
} catch (Exception e) {
System.err.println("Cannot connect to database server,Exception:"
+ e.getMessage());
} finally {
if (connection != null) {
try {
connection.close();
connection = null;
} catch (Exception e) { /* ignore close errors */
}
}
}
}
}
回転:http://www.zuidaima.com/share/1550463554800640.htm