listing 10-21.java

来自「手机游戏开发大全」· Java 代码 · 共 58 行

String url = "jdbc:odbc:CustomerInformation";
String userID = "jim";
String password = "keogh";
Statement DataRequest;
Connection Database;
try {
      Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
      Database = DriverManager.getConnection(url,userID,password);
}
catch (ClassNotFoundException error) {
     System.err.println("Unable to load the JDBC/ODBC bridge." + 
            error);
     System.exit(1);
}
catch (SQLException error) {
     System.err.println("Cannot connect to the database." + error);
     System.exit(2);
 }
try {
  Database .setAutoCommit(false)
  String query1 = "UPDATE Customers SET Street = '5 Main Street' " +
      "WHERE FirstName = 'Bob'";
  String query2 = "UPDATE Customers SET Street = '10 Main Street' " +
      "WHERE FirstName = 'Tim'";
  DataRequest= Database.createStatement();
  DataRequest.addBatch(query1);
  DataRequest.addBatch(query2);
  int [ ] updated = DataRequest.executeBatch ();
  Database.commit();
  DataRequest1.close();
  DataRequest2.close();
  Database.close();
}
catch(BatchUpdateException error) {
   System.out.println("Batch error.");
   System.out.println("SQL State: " + error.getSQLState());
   System.out.println("Message: " + error.getMessage());
   System.out.println(Vendor: " + error.getErrorCode());
   int [ ] updated  = error.getUpdatecount();
   int count = updated.length();
   for int - i = 0; i < count; i++) {
       System.out.print (updated[i]);
   }
  SQLException sql = error;
  While (sql != null)
      {
        System.out.println("SQL error " + sql);
        sql = sql.getnextException();
      }
  try{ 
     DataRequest.clearBatch();
  }
  catch(BatchUpdateException error) {
      System.out.println("Unable to clear the batch: " + 
             error.getMessage());
  }
}