Select.java Source code

Java tutorial

Introduction

Here is the source code for Select.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.Statement;

/**
 * Example 3.1.
 */
public class Select {
    public static void main(String args[]) {
        String url = "jdbc:msql://carthage.imaginary.com/ora";
        Connection con = null;

        try {
            String driver = "com.imaginary.sql.msql.MsqlDriver";

            Class.forName(driver).newInstance();
        } catch (Exception e) {
            System.out.println("Failed to load mSQL driver.");
            return;
        }
        try {
            con = DriverManager.getConnection(url, "borg", "");
            Statement select = con.createStatement();
            ResultSet result = select.executeQuery("SELECT test_id, test_val FROM test");

            System.out.println("Got results:");
            while (result.next()) { // process results one row at a time
                int key = result.getInt(1);
                String val = result.getString(2);

                System.out.println("key = " + key);
                System.out.println("val = " + val);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (con != null) {
                try {
                    con.close();
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        }
    }
}