Shulou(Shulou.com)05/31 Report--

This article is about how JDBC can get all kinds of information about how to make pc28 program database. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

First of all, in order to describe the relationship between tables and columns, you must do a simple modeling:

There is an one-to-many relationship between table objects and column objects.

Public class TableInfoBean {

Private String tableName

Private String tableComment

Private List columnList=new ArrayList ()

Public class ColumnBean {

Private String columnName

Private String columnComment

Private String SqlType

This relationship is very simple, so it is done, and it is used to save a table information.

Here's how to read table information from a database.

Here we rely on a class DatabaseMetaData, which can be obtained from a database connection. Everything will be all right with it, just ask it what you want to know:

DatabaseMetaData databaseMetaData = conn.getMetaData ()

/ / get all tables

ResultSet tableSet = databaseMetaData.getTables (null, "%", "%", new String [] {"TABLE"})

/ / get tableName table column information

ResultSet columnSet = databaseMetaData.getColumns (null, "%", tableName, "%")

The above code will get two result sets. Compared with the DatabaseMetaData document, we can get the desired information through the column names of the result set, for example

String tableName = tableSet.getString ("TABLE_NAME")

String tableComment = tableSet.getString ("REMARKS")

String columnName = columnSet.getString ("COLUMN_NAME")

String columnComment = columnSet.getString ("REMARKS")

String sqlType = columnSet.getString ("DATA_TYPE")

Thank you for reading! This is the end of this article on "JDBC how to get all kinds of information about making pc28 program database". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.