package com.example.qimo;
import android.os.Bundle;
import android.app.Activity;
import android.database.sqlite.SQLiteDatabase;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
public class LoginActivity extends Activity {
private EditText pay_account;
private EditText pay_money;
private EditText receive_name;
private EditText receive_account;
public MyOpenHelper myOpenHelper;
private Button transfer;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_login);
pay_account = (EditText) findViewById(R.id.pay_account);
pay_money = (EditText) findViewById(R.id.pay_money);
receive_account = (EditText) findViewById(R.id.receive_account);
receive_name = (EditText) findViewById(R.id.receive_name);
transfer = (Button) findViewById(R.id.transfer);
// 点击按钮进行转账的逻辑
transfer.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View arg0) {
// TODO Auto-generated method stub
String userpay_account = pay_account.getText().toString();
String userpay_money = pay_money.getText().toString();
String userreceive_account = receive_account.getText()
.toString();
String userreceive_name = receive_name.getText().toString();
MyOpenHelper myOpenHelper = new MyOpenHelper(
getApplicationContext());
SQLiteDatabase db = myOpenHelper.getWritableDatabase();
db.execSQL("insert into login(account,money) value(?,?)",
new String[] { userpay_account, userpay_money });
db.execSQL("insert into login(name,account) value(?,?)",
new String[] { userreceive_name, userreceive_account });
// 使用事物进行转账
db.beginTransaction();// 开启事物
try {
// 实现转账的逻辑,写sql语句
db.execSQL("update login set money=money-100 where name=?",
new String[] { userpay_account, userpay_money, });
db.execSQL(
"update login set money=pay_money+100 where name=?",
new String[] { userreceive_account,
userreceive_name });
// 给当前事物添加成功标志
db.setTransactionSuccessful();
Toast.makeText(getApplicationContext(), "转账成功!", 1).show();
} catch (Exception e) {
// TODO: handle exception
Toast.makeText(getApplicationContext(), "服务器忙!请稍后!", 1)
.show();
} finally {
db.endTransaction();// 关闭事物
}
}
});
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.login, menu);
return true;
}
}