Java JDBC HSQL Connection printSchema()

Description

print Schema

License

Apache License

Declaration

public static void printSchema() throws Exception 

Method Source Code

//package com.java2s;
//License from project: Apache License 

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;

public class Main {
    public static void printSchema() throws Exception {
        Class.forName("org.hsqldb.jdbcDriver");
        Connection connection = DriverManager.getConnection("jdbc:hsqldb:data/tutorial", "sa", "");
        Statement st = connection.createStatement();

        DatabaseMetaData metaData = connection.getMetaData();
        ResultSet results = metaData.getTables(null, null, null, new String[] { "TABLE" });
        while (results.next()) {
            String tableName = results.getString(3);
            System.out.println("\n\n\n\nTable Name: " + tableName);

            ResultSet rs = st.executeQuery("select * from " + tableName);
            ResultSetMetaData metadata = rs.getMetaData();
            while (rs.next()) {
                System.out.println(" Row:");
                for (int i = 0; i < metadata.getColumnCount(); i++) {
                    System.out.println("    Column Name: " + metadata.getColumnLabel(i + 1) + ",  ");
                    System.out.println("    Column Type: " + metadata.getColumnTypeName(i + 1) + ":  ");
                    Object value = rs.getObject(i + 1);
                    System.out.println("    Column Value: " + value + "\n");
                }//from  w w w .j a v a  2 s .  co m
            }
        }
    }
}

Related

1. createSchemasForHSQLDB(String dbName, String[] schemaNames)
2. getConnection()
3. getDbConnection()
4. createTweetTable()
5. getHSQLConnection()
6. stopHSQL()