Java determines whether database table exists-JavaBase-php.cn

Home

Java

JavaBase

Java determines whether database table exists

王林

Nov 15, 2019 pm 02:25 PM

javajudgmentexistDatabase Table

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:

Java determines whether database table exists

##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.

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)

4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

R.E.P.O. Best Graphic Settings

4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Assassin's Creed Shadows: Seashell Riddle Solution

2 weeks agoByDDD

R.E.P.O. How to Fix Audio if You Can't Hear Anyone

4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

WWE 2K25: How To Unlock Everything In MyRise

1 months agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.