Java determines whether database table exists

Judgment method:

First establish the JDBC data source, and then determine whether the database table exists through the Java.sql.DatabaseMetaData interface.

The example is as shown:

##Remarks: Parameter analysis

getConnection("jdbc:oracle:" "thin:@127.0.0.1:1521:orcl", "username","password");

getTables(String catalog,String schemaPattern,String tableNamePattern,String[ ] types)

Parameters: catalog: catalog name, usually empty

Parameters: schema: database name, for Oracle, it is the user name

Parameters: tablename: Table name

Parameters: type: type of table (TABLE | VIEW)

Note: During use, parameter names must be in uppercase letters.

Recommended tutorial:

Java tutorial

The above is the detailed content of Java determines whether database table exists. For more information, please follow other related articles on the PHP Chinese website!