- ListActivity.java
public class ListActivity extends Activity {
private SQLiteDatabase db;
private ListView list;
@Override
protected void onCreate(@Nullable Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_list);
db = openOrCreateDatabase("examDB", MODE_PRIVATE, null);
list = findViewById(R.id.list);
showList();
}
private void showList(){
String [] from = {"goods", "money", "remark"};
int [] to = {R.id.text_goods, R.id.text_money, R.id.text_remark};
Cursor c = db.rawQuery("select * from account", null);
if (c != null) {
String[] goods = new String[c.getCount()];
double[] money = new double[c.getCount()];
String[] remark = new String[c.getCount()];
int[] id = new int[c.getCount()];
int len = 0;
ArrayList> data = new ArrayList<>();
while(c.moveToNext()) {
id[len] = c.getInt(0);
goods[len] = c.getString(1);
money[len] = c.getDouble(2);
remark[len] = c.getString(3);
++len;
}
for(int i = 0; i < len; ++i) {
HashMap m = new HashMap();
m.put("id", id[i]);
m.put(from[0], goods[i]);
m.put(from[1], money[i]);
m.put(from[2], remark[i]);
data.add(m);
}
SimpleAdapter adapter = new MyAdapter(this, data, R.layout.item, from, to);
list.setAdapter(adapter);
}
}
} - LoginActivity.java
public class LoginActivity extends Activity implements View.OnClickListener{
private EditText edt_uname;
private EditText edt_upass;
private Button btn_login;
@Override
protected void onCreate(@Nullable Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_login);
register();
}
private void register(){
edt_uname = findViewById(R.id.edt_uname);
edt_upass = findViewById(R.id.edt_upass);
btn_login = findViewById(R.id.btn_login);
btn_login.setOnClickListener(this);
}
@Override
public void onClick(View view) {
if(view.getId() == R.id.btn_login) {
String uname = edt_uname.getText().toString();
String upass = edt_upass.getText().toString();
if("aaa".equals(uname) && "123".equals(upass)) {
Intent it = new Intent(this, MainActivity.class);
startActivity(it);
this.finish();
}
else{
Toast.makeText(this, "用名或密码错误", Toast.LENGTH_LONG).show();
edt_upass.setText("");
edt_upass.setText("");
}
}
}
} - MainActivity.java
public class MainActivity extends AppCompatActivity implements View.OnClickListener{
private EditText edt_goods;
private EditText edt_money;
private EditText edt_remark;
private Button btn_ji;
private Button btn_look;
private SQLiteDatabase db;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
register();
InitDB();
}
private void register(){
edt_goods = findViewById(R.id.goods);
edt_money = findViewById(R.id.edt_money);
edt_remark = findViewById(R.id.remark);
btn_ji = findViewById(R.id.btn_ji);
btn_look = findViewById(R.id.btn_look);
btn_ji.setOnClickListener(this);
btn_look.setOnClickListener(this);
}
private void InitDB() {
db = openOrCreateDatabase("examDB", MODE_PRIVATE, null);
db.execSQL("create table if not exists account(_id Integer primary key autoincrement, goods varchar, money double, remark varchar)");
}
@Override
public void onClick(View view) {
if(view.getId() == R.id.btn_ji) {
ji();
}
else{
look();
}
}
private void ji() {
String insertSql = "insert into account(goods, money, remark)values(?,?,?)";
String goods = edt_goods.getText().toString();
double money = Double.valueOf(edt_money.getText().toString());
String remark = edt_remark.getText().toString();
Object[] ob = new Object[]{
goods,
money,
remark
};
db.execSQL(insertSql, ob);
Toast.makeText(this, "记录成功", Toast.LENGTH_LONG).show();
edt_goods.setText("");
edt_remark.setText("");
edt_money.setText("");
}
private void look() {
Intent it = new Intent(this, ListActivity.class);
startActivity(it);
}
} - MyAdapter.java
public class MyAdapter extends SimpleAdapter{
private LayoutInflater inflater;
private Context context;
private ArrayList> mData;
int p;
private SQLiteDatabase db;
public MyAdapter(Context context, List extends Map> data, int resource, String[] from, int[] to) {
super(context, data, resource, from, to);
this.context = context;
mData = (ArrayList>) data;
this.db = context.openOrCreateDatabase("examDB", Context.MODE_PRIVATE, null);
}
@Override
public View getView(int position, View convertView, ViewGroup parent) {
View v= super.getView(position, convertView, parent);
Button btn_delete = (Button)v.findViewById(R.id.btn_delete);
Button btn_update = (Button)v.findViewById(R.id.btn_update);
p = position;
btn_delete.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
new AlertDialog.Builder(context).setTitle("提示消息").setMessage("是否删除记录").setPositiveButton("确定", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialogInterface, int i) {
int id = (int) mData.get(p).get("id");
mData.remove(p);
Toast.makeText(context, "删除"+Integer.toString(p),Toast.LENGTH_LONG).show();
String sql = "delete from account where _id = ?";
Object[] ob = new Object[]{id};
db.execSQL(sql, ob);
MyAdapter.this.notifyDataSetChanged();
}
}).setNegativeButton("取消", null).show();
}
});
btn_update.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
int id = (int) mData.get(p).get("id");
String goods = (String)mData.get(p).get("goods");
double money = (double)mData.get(p).get("money");
String remark = (String)mData.get(p).get("remark");
Intent it = new Intent(context, UpdateActivity.class);
it.putExtra("goods", goods);
it.putExtra("money", money);
it.putExtra("remark", remark);
it.putExtra("id", id);
context.startActivity(it);
}
});
return v;
}
} - UpdateActivity.java
public class UpdateActivity extends Activity implements View.OnClickListener{
private Button btn_update;
private TextView goods;
private TextView money;
private TextView remark;
private int id;
@Override
protected void onCreate(@Nullable Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_update);
Init();
}
public void Init() {
Intent it = getIntent();
goods = findViewById(R.id.goods);
money = findViewById(R.id.money);
remark = findViewById(R.id.remark);
goods.setText(it.getStringExtra("goods"));
money.setText(String.valueOf(it.getDoubleExtra("money", 0)));
remark.setText(it.getStringExtra("remark"));
id = it.getIntExtra("id", 0);
btn_update = findViewById(R.id.btn_update);
btn_update.setOnClickListener(this);
}
@Override
public void onClick(View view) {
Intent it = new Intent(this, ListActivity.class);
SQLiteDatabase db = openOrCreateDatabase("examDB", MODE_PRIVATE, null);
String sql = "update account set goods=?,money=?, remark=? where _id=?";
Object[] obj = new Object[]{
goods.getText().toString(),
Double.valueOf(money.getText().toString()),
remark.getText().toString(),
id
};
db.execSQL(sql, obj);
startActivity(it);
this.finish();
}
}