事务 android,Android-事务(Transaction)

packageliudeli.datastorage;importandroid.app.Activity;importandroid.content.ContentValues;importandroid.database.Cursor;importandroid.database.sqlite.SQLiteDatabase;importandroid.os.Bundle;importandroid.util.Log;importandroid.view.View;importandroid.widget.Toast;importliudeli.datastorage.db.MySQLiteOpenHelper2;public class TransactionActivity extendsActivity {private final String TAG = TransactionActivity.class.getSimpleName();

MySQLiteOpenHelper2 dbHelper;

@Overrideprotected voidonCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);

setContentView(R.layout.activity_transaction);

dbHelper= MySQLiteOpenHelper2.getInstance(this);

}public voidqueryALl(View view) {

query(null); //查询全部

}private voidquery(String orderBy) {

SQLiteDatabase db=dbHelper.getReadableDatabase();

Cursor cursor=db.query(MySQLiteOpenHelper2.TABLE_NAME,new String[]{"*"},null,null,null,null,

orderBy);while(cursor.moveToNext()) {int _id = cursor.getInt(0);

String name= cursor.getString(1);int age = cursor.getInt(2);

String myAssets= cursor.getString(3);

Log.d(TAG," id:" + _id + " name:" + name + " age" + age + " my_assets:" +myAssets);

}

cursor.close();

db.close();

}/*** 转账

*@paramview*/

public voidmoveMoney(View view) {

SQLiteDatabase db=dbHelper.getWritableDatabase();try{int moneyValue1 = 1000000;int moneyValue2 = 2000;

db.beginTransaction();//开启事务

ContentValues contentValues= newContentValues();

contentValues.put("my_assets", moneyValue1 - 6000);int result1 = db.update(MySQLiteOpenHelper2.TABLE_NAME, contentValues, "_id = ?", new String[]{"1"});

contentValues.put("my_assets", moneyValue2 + 6000);int result2 = db.update(MySQLiteOpenHelper2.TABLE_NAME, contentValues, "_id = ?", new String[]{"2"});if (result1>0 && result2>0) {

db.setTransactionSuccessful();//事务默认是失败的,要设置成功,否则数据不会修改

Toast.makeText(TransactionActivity.this, "转帐成功", Toast.LENGTH_SHORT).show();

}else{

Toast.makeText(TransactionActivity.this, "转帐失败", Toast.LENGTH_SHORT).show();

}

}catch(Exception e) {

e.printStackTrace();

Toast.makeText(TransactionActivity.this, "转帐失败", Toast.LENGTH_SHORT).show();

}finally{

db.endTransaction();//注意⚠️:一定要结束事务,不然查询会报错

db.close();

}

}

@Overrideprotected voidonDestroy() {super.onDestroy();

}

}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值