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();
}
}