Transaction Management in Android-SQLite

Package COM. njupt. sqllist; import Java. util. arraylist; import Java. util. list; import android. content. context; import android. database. cursor; import android. database. SQLite. sqlitedatabase; public class persondao {dbopenhelper helper; Public persondao (context) {helper = new dbopenhelper (context);} public void remit (int from, int to, int count) {sqlitedatabase DB = helper. getwritabledatabase (); try {d B .begintransaction(mongomongodb.exe csql ("Update person set balance = balance -? Where id =? ", New object [] {count, from}); system. Out. println (1/0)mongodb.exe csql (" Update person set balance = balance +? Where id =? ", New object [] {count, to}); DB. settransactionsuccessful () ;}finally {dB. endtransaction (); DB. Close ();}}}

2. Explanation:

1) dB. begintransaction (); Start transaction

2) dB. settransactionsuccessful (); // set the successful vertex.

3) dB. endtransaction (); // ends the transaction. Commit the transaction before the successful point