安卓 SQlite事务

创建一个BankDBOpenHelper类继承 SQLiteOpenHelper

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class BankDBOpenHelper extends SQLiteOpenHelper {
public BankDBOpenHelper(Context context) {
super(context, "bank.db", null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table account (_id integer primary key autoincrement,name varchar(20),money varchar(2))");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}

模拟A给B转账

import android.app.Activity;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;


public class MainActivity extends Activity {
private String s;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
}
public void click(View view) {
BankDBOpenHelper helper = new BankDBOpenHelper(this);
SQLiteDatabase db = helper.getWritableDatabase();
db.beginTransaction(); // 开启事务
try {
// 模拟转账的操作
db.execSQL("update account set money=money-100 where name='zhangsan'");
s.endsWith("haha");
db.execSQL("update account set money=money+100 where name='lisi'");
db.setTransactionSuccessful();// 设置事务执行成功
} finally {
db.endTransaction();
}
db.close();
}
}