コード例 #1
0
 public void updatePhone(Phone phone) throws DBException {
   Connection connection = DBConnection.connection;
   Statement statement = null;
   try {
     connection.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
     connection.setAutoCommit(false);
     statement = connection.createStatement();
     int id = phone.getId();
     String number = phone.getNumber();
     int type = phone.getType();
     System.out.print("4");
     statement.execute("UPDATE phones SET number='" + number + "' WHERE id=" + id + "");
     statement.execute("UPDATE phones SET type='" + type + "' WHERE id=" + id + "");
     System.out.print("3");
     connection.commit();
   } catch (SQLException e) {
     if (connection != null) {
       try {
         connection.rollback();
       } catch (SQLException e1) {
         e1.printStackTrace();
         throw new RuntimeException("Can't rollback connection");
       }
     }
     throw new DBException("Can't execute SQL");
   }
 }