Collect data base meta data by JDBC

最新推荐文章于 2025-02-08 16:44:21 发布

原创最新推荐文章于 2025-02-08 16:44:21 发布 · 344 阅读

CC 4.0 BY-SA版权

文章标签：

1 篇文章

订阅专栏

本文介绍如何使用Java从SQL Server中收集存储过程(Sproc)的元数据，并列出所需的依赖库，包括Apache Commons DBCP2、Microsoft SQL JDBC驱动等。文章还提到XStream在XML支持方面的应用，并推荐了Freemarker等模型生成工具。

I have not to update the blog for a long time, it seems hard to hold every day

I will introduce how to collect data base meta data for Sproc based on SQL Server

The dependent jar libs as below:

<dependency>
    <groupId>org.apache.commons</groupId>
    <artifactId>commons-dbcp2</artifactId>
</dependency>

<dependency>
    <groupId>com.microsoft</groupId>
    <artifactId>sqljdbc</artifactId>
</dependency>

<dependency>
    <groupId>com.thoughtworks.xstream</groupId>
    <artifactId>xstream</artifactId>
    <version>RELEASE</version>
</dependency>

<dependency>
    <groupId>com.google.guava</groupId>
    <artifactId>guava</artifactId>
    <version>19.0</version>
</dependency>

BTW, the XStream is good for XML support.

1), Initialized sproc setting for sproc XML(custom)

2), Create connection for SQL Server.

3), Use DatabaseMetaData object to get sproc meta data

4), Parse data list to your object.

and we can use third plugin(model tool) to auto generate Object of my expected, such as

<dependency>
    <groupId>org.freemarker</groupId>
    <artifactId>freemarker</artifactId>
    <version>2.3.23</version>
</dependency>

The referenced link:

For XStream: http://x-stream.github.io/javadoc/index.html

For DataBaseMetaData API: https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html

For Sql Type convertion: https://docs.oracle.com/javase/7/docs/api/constant-values.html, we can use ENUM type to convert