ResultSetMetaDataExample.java Source code

Introduction

Here is the source code for ResultSetMetaDataExample.java

Source

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;

public class ResultSetMetaDataExample {
    public static void main(String args[]) throws Exception {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con = DriverManager.getConnection("jdbc:odbc:Inventory", "", "");
        Statement stmt = con.createStatement();

        boolean notDone = true;
        String sqlStr = null;
        BufferedReader br = new BufferedReader(new InputStreamReader(System.in));

        while (notDone) {
            sqlStr = br.readLine();
            if (sqlStr.startsWith("SELECT") || sqlStr.startsWith("select")) {
                ResultSet rs = stmt.executeQuery(sqlStr);
                ResultSetMetaData rsmd = rs.getMetaData();
                int columnCount = rsmd.getColumnCount();
                for (int x = 1; x <= columnCount; x++) {
                    String columnName = rsmd.getColumnName(x);
                    System.out.print(columnName);
                }
                while (rs.next()) {
                    for (int x = 1; x <= columnCount; x++) {
                        if (rsmd.getColumnTypeName(x).compareTo("CURRENCY") == 0)
                            System.out.print("$");
                        String resultStr = rs.getString(x);
                        System.out.print(resultStr + "\t");
                    }
                }
            } else if (sqlStr.startsWith("exit"))
                notDone = false;
        }
        stmt.close();
        con.close();
    }
}