public class DatabaseMetaDateApplication extends Object
| Constructor and Description |
|---|
DatabaseMetaDateApplication() |
| Modifier and Type | Method and Description |
|---|---|
void |
colseCon() |
void |
getAllExportedKeys(String schemaName,
String tableName)
获得一个表的外键信息
|
void |
getAllPrimaryKeys(String schemaName,
String tableName)
获得一个表的主键信息
|
void |
getAllSchemas()
获得数据库中所有方案名称
|
void |
getAllTableList(String schemaName)
获得该用户下面的所有表
|
void |
getAllViewList(String schemaName)
获得该用户下面的所有视图
|
void |
getDataBaseInformations()
获得数据库的一些相关信息
|
void |
getIndexInfo(String schemaName,
String tableName)
获得一个表的索引信息
|
void |
getTableColumns(String schemaName,
String tableName)
获得表或视图中的所有列信息
|
static void |
main(String[] args) |
public void getDataBaseInformations()
public void getAllTableList(String schemaName)
schemaName - db namepublic void getAllViewList(String schemaName)
schemaName - db namepublic void getAllSchemas()
public void getTableColumns(String schemaName, String tableName)
schemaName - db nametableName - table namepublic void getIndexInfo(String schemaName, String tableName)
schemaName - db nametableName - table namepublic void getAllPrimaryKeys(String schemaName, String tableName)
schemaName - db nametableName - table namepublic void getAllExportedKeys(String schemaName, String tableName)
schemaName - db nametableName - table namepublic void colseCon()
public static void main(String[] args)
Copyright © 2016 Le. All rights reserved.