Android SQLite(5)商品展示案例

运行程序时，有一个“添加”按钮和1两个EditText分别用来输入姓名和金额，单击“添加”按钮能将内容，添加至数据库并显示到ListView中。点击上下增加数量，点击删除的图片会执行删除。

      运行效果如下:

AccountDao类

import edu.bzu.cn.shop.entity.Account;

/**
 * Created by Administrator on 2017/4/17.
 */

public class AccountDao {
    private  DBhelper dBhelper;

    public AccountDao(Context context) {
        dBhelper =new DBhelper(context);
    }
    public void insert(Account account) {
        SQLiteDatabase db = dBhelper.getWritableDatabase();
        ContentValues values = new ContentValues();
        values.put("name", account.getName());
        values.put("balance", account.getBalance());
        long id = db.insert("account", "null", values);
        account.setId(id);
        db.close();
    }
        public int delete(long id) {
            SQLiteDatabase db = dBhelper.getWritableDatabase();
            int count=db.delete("account","_id=?",new String[]{ id+"" });
            db.close();
            return count;
    }
      public int update(Account account){
         SQLiteDatabase db=dBhelper.getWritableDatabase();
         ContentValues values=new ContentValues();
         values.put("name",account.getName());
         values.put("balance",account.getBalance());
         int count=db.update("account",values,"_id=?",new String[]{account.getId()+""});
         db.close();
         return count;
     }
    public List<Account>queryAll(){
         SQLiteDatabase db=dBhelper.getWritableDatabase();
         Cursor c=db.query("account",null,null,null,null,null,"balance DESC");
         List<Account> list=new ArrayList<Account>();
         while(c.moveToNext()){
             long id=c.getLong(c.getColumnIndex（"_id"）);
             String name=c.getString(1);
             int balance=c.getInt(2);
             list.add(new Account(id,name,balance));
         }
         c.close();
         db.close();
         return list;
    }
}
DBhelper//创建数据库
package edu.bzu.cn.shop.dao;

import andr