ReverseSelect.java Source code

Introduction

Here is the source code for ReverseSelect.java

Source

/*
    
Database Programming with JDBC and Java, Second Edition
By George Reese
ISBN: 1-56592-616-1
    
Publisher: O'Reilly
    
*/

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

/**
 * Example 3.5.
 */
public class ReverseSelect {
    public static void main(String argv[]) {
        Connection con = null;

        try {
            String url = "jdbc:msql://carthage.imaginary.com/ora";
            String driver = "com.imaginary.sql.msql.MsqlDriver";
            Properties p = new Properties();
            Statement stmt;
            ResultSet rs;

            p.put("user", "borg");
            Class.forName(driver).newInstance();
            con = DriverManager.getConnection(url, "borg", "");
            stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            rs = stmt.executeQuery("SELECT * from test ORDER BY test_id");
            // as a new ResultSet, rs is currently positioned
            // before the first row
            System.out.println("Got results:");
            // position rs after the last row
            rs.afterLast();
            while (rs.previous()) {
                int a = rs.getInt("test_id");
                String str = rs.getString("test_val");

                System.out.print("\ttest_id= " + a);
                System.out.println("/str= '" + str + "'");
            }
            System.out.println("Done.");
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (con != null) {
                try {
                    con.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}