?? listing 10-19.java
字號:
String url = "jdbc:odbc:CustomerInformation";
String userID = "jim";
String password = "keogh";
Statement DataRequest1, DataRequest2 ;
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'";
DataRequest1= Database.createStatement();
DataRequest2= Database.createStatement();
DataRequest.executeUpdate (query1 );
DataRequest.executeUpdate (query2 );
Database.commit();
DataRequest1.close();
DataRequest2.close();
Database.close();
}
catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
if (con != null) {
try {
System.err.println("Transaction is being rolled back ");
con.rollback();
}
catch(SQLException excep) {
System.err.print("SQLException: ");
System.err.println(excep.getMessage());
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -