tag:blogger.com,1999:blog-59465307047421309702024-03-06T16:20:07.273+08:00Jax 的工作紀錄除了在整理學習上的經驗,同時也能幫助其他需要的人Jax Huhttp://www.blogger.com/profile/01953021685585893658noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-5946530704742130970.post-23506363444405207432015-02-21T18:10:00.000+08:002015-02-24T15:47:45.289+08:00[轉載] Get Tables And Columns Details In Schema Using JDBC轉載自:<a href="http://www.javaroots.com/2013/09/print-tables-details-in-schema-jdbc.html" target="_blank">JavaRoots: Get Tables And Columns Details In Schema Using JDBC</a><br />
<br />
This is a sample program written using java and JDBC API , to print all the tables in a database schema . It also prints columns available in the particular table.<br />
<br />
<pre class="java:nogutter:nocontrols" name="code">package com.datamigration.main;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.datamigration.db.DataBase;
/**
* @author Abhishek Somani
*/
public class PrintTable {
public static String SCHEMA_NAME = "${YOUR_SCHEMA_NAME}";
public static void main(String[] args) {
// create and setup your database and get db connection
DataBase db = new DataBase();
db.init();
try {
Connection con = db.getConnection();
DatabaseMetaData metaData = con.getMetaData();
String tableType[] = { "TABLE" };
StringBuilder builder = new StringBuilder();
ResultSet result = metaData.getTables(
null, SCHEMA_NAME, null, tableType
);
while (result.next()) {
String tableName = result.getString(3);
builder.append(tableName + "( ");
ResultSet columns = metaData.getColumns(
null, null, tableName, null
);
while (columns.next()) {
String columnName = columns.getString(4);
builder.append(columnName);
builder.append(",");
}
builder.deleteCharAt(builder.lastIndexOf(","));
builder.append(" )");
builder.append("\n");
builder.append("----------------");
builder.append("\n");
}
System.out.println(builder.toString());
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
</pre><br />
This program will print tables along with colmuns like this :<br />
<pre class="none:nogutter:nocontrols" name="code">TABLE1( ID,NAME,STATUS,CREATED_AT,UPDATED_AT)
-----------------------------------
TABLE2( ID,NAME,STATUS,CREATED_AT,UPDATED_AT)
</pre>Jax Huhttp://www.blogger.com/profile/01953021685585893658noreply@blogger.com0