source: main/trunk/model-sites-dev/cambridge-museum/collect/waikato-independent/pre-import/MSAccessToCSV/src/main/java/org/greenstone/accessdb/JDBCBase.java@ 34500

package org.greenstone.accessdb;
 
import java.sql.*;
import java.io.OutputStreamWriter;

public class JDBCBase
{
    
    final static String TABLE_NAME = "WAIKATO_INDEPENDENT";
    
    public static void printDatabaseMetadata(Connection connection)
    {
        try {

        System.out.println("----");
        System.out.println("Database Table Names");
        System.out.println("----");
            DatabaseMetaData dbmd = connection.getMetaData();
            String[] types = {"TABLE"};
            ResultSet rs = dbmd.getTables(null, null, "%", types);
            while (rs.next()) {
                System.out.println(rs.getString("TABLE_NAME"));
            }
        System.out.println("----");
        } 
            catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public static void printTable(Connection connection, String table_name)
    {
    try {
        Statement st = connection.createStatement();
        ResultSet rs = st.executeQuery("SELECT * from " + table_name);
        ResultSetMetaData rsmd = rs.getMetaData();
        
        int columnsNumber = rsmd.getColumnCount();                     
        
        // Iterate through the data in the result set and display it. 
        System.out.println("----");
        System.out.println("Table: " + table_name);
        System.out.println("----");

        for(int i = 1; i <= columnsNumber; i++) {
        System.out.print(rsmd.getColumnLabel(i)+ "|");
        }
        System.out.println();
        
        while (rs.next()) {
        for(int i = 1 ; i <= columnsNumber; i++){
            System.out.print(rs.getString(i));
            if (i != columnsNumber) { System.out.print(","); }
        }
        
        System.out.println();
        
        }
            
        System.out.println("----");
        
    }
    catch (Exception e) {
        e.printStackTrace();
    }
    
    }

}