Copy Code code as follows:
public void payment () {
Sqlitedatabase db = Dbopenhelper.getreadabledatabase ();
Db. BeginTransaction ()//Start a transaction
try {
Db.execsql ("Update person set amount=amount-10 where personid=2");
Db.execsql ("Update person set amount=amount+10 where personid=5");
Db. settransactionsuccessful ()//Set the transaction's flag to true, calling this method commits the transaction to the Endtransaction () method, and if this method is not called, the transaction is rolled back in the execution to the Endtransaction () method.
catch (SQLException e) {
finally {
Db. endtransaction ();
}
There are two things to end a transaction: Commit,rollback,
The commit or rollback of a transaction is determined by the flag of the transaction, and if the transaction's flag is true it commits, or rolls back, by default the label of the transaction is False
}
PS: Similar to the transfer function, two operations in the same transaction completed.
