Connection con = null;
if( args.length != 2 ) {
System.out.println("Syntax: <java UpdateApp [number] [string]>");
return;
}
try {
String driver = "com.imaginary.sql.msql.MsqlDriver";
Class.forName(driver).newInstance();
String url = "jdbc:msql://carthage.imaginary.com/ora";
con = DriverManager.getConnection(url, "borg", "");
Statement s = con.createStatement();
String test_id = args[0];
String test_val = args[1];
int update_count =
s.executeUpdate("INSERT INTO test (test_id, test_val) " +
"VALUES(" + test_id + ", '" + test_val + "')");
System.out.println(update_count + " rows inserted.");
s.close();
}
catch( Exception e ) {
e.printStackTrace();
}
finally {
if( con != null ) {
try { con.close(); }
catch( SQLException e ) { e.printStackTrace(); }
}
}
