[Java] database

Connection

Resultset

Databasemetadata
Gettables (null, new string [] {"table"}); // return resultset res. getstring ("table_name ")

Getcolumns (null, "%", "t_sarray2", "%"); // return resultset res. getstring ("column_name ")

Databasemetadata dbmd = con. getmetadata ();

1 resultset databasemetadata. gettables (string catalog, string schema, string tablename, string [] type );

Parameter: Catalog: directory name, which is generally empty.
Parameter: Schema: database name, which is the user name for Oracle.
Parameter: tablename: Table Name
Parameter: Type: Table type (Table | view)

Note: The parameter name must be in uppercase. Otherwise, get something.

2 resultset databasemetadata getcolumns (string
Catalog, string schema, string tablename, string columnname );

Parameter catalog: category name
Parameter Schema: User solution name
Parameter tablename: Database Table Name
Parameter columnname: column name

3 resultset databasemetadata getprimarykeys (string catalog, string schema, string tablename );

Parameter catalog
: Category name
Parameter Schema: User solution name
Parameter tablename: Database Table Name

C3p0-0.9.1.1.jar
Database Connection Pool class. Please import com. mchange. v2.c3p0. combopooleddatasource; Define combooleddatasource; and Use

Getconnection () gets a connection