UpdateLogic.java Source code

Introduction

Here is the source code for UpdateLogic.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.SQLException;
import java.sql.Statement;

/**
 * Example 3.4.
 */
public class UpdateLogic {
    public static void main(String args[]) {
        Connection con = null;

        if (args.length != 2) {
            System.out.println("Syntax: <java UpdateLogic [number] [string]>");
            return;
        }
        try {
            String driver = "com.imaginary.sql.msql.MsqlDriver";

            Class.forName(driver).newInstance();
            String url = "jdbc:msql://carthage.imaginary.com/ora";
            Statement s;

            con = DriverManager.getConnection(url, "borg", "");
            con.setAutoCommit(false); // make sure auto commit is off!
            s = con.createStatement();// create the first statement
            s.executeUpdate("INSERT INTO test (test_id, test_val) " + "VALUES(" + args[0] + ", '" + args[1] + "')");
            s.close(); // close the first statement
            s = con.createStatement(); // create the second statement
            s.executeUpdate("INSERT into test_desc (test_id, test_desc) " + "VALUES(" + args[0]
                    + ", 'This describes the test.')");
            con.commit(); // commit the two statements
            System.out.println("Insert succeeded.");
            s.close(); // close the second statement
        } catch (Exception e) {
            if (con != null) {
                try {
                    con.rollback();
                } // rollback on error
                catch (SQLException e2) {
                }
            }
            e.printStackTrace();
        } finally {
            if (con != null) {
                try {
                    con.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}