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: Contacts");
        Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
        ResultSet rs = stmt.executeQuery("SELECT Name,Description,Qty,Cost FROM Stock");
        ResultSetMetaData md = rs.getMetaData();

        if (rs.getConcurrency() == ResultSet.CONCUR_UPDATABLE)
            System.out.println("UPDATABLE");
        else
            System.out.println("READ_ONLY");

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