PrintResultSet.java Source code

Introduction

Here is the source code for PrintResultSet.java

Source

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

public class PrintResultSet {
    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();
        ResultSet rs = stmt.executeQuery("select * from employee");
        ResultSetMetaData md = rs.getMetaData();

        int nColumns = md.getColumnCount();
        for (int i = 1; i <= nColumns; i++) {

            System.out.print(md.getColumnLabel(i) + ((i == nColumns) ? "\n" : "\t"));
        }
        while (rs.next()) {
            for (int i = 1; i <= nColumns; i++) {
                System.out.print(rs.getString(i) + ((i == nColumns) ? "\n" : "\t"));
            }
        }
    }
}