listview动态添加数据，使用sqlite对本地数据库增删改查

对数据库使用不太熟悉，记录一下，方便自己查看

package com.simon.listdemo;

import android.app.Activity;
import android.app.AlertDialog;
import android.content.Context;
import android.content.DialogInterface;
import android.os.AsyncTask;
import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.AdapterView;
import android.widget.BaseAdapter;
import android.widget.EditText;
import android.widget.ImageView;
import android.widget.ListView;
import android.widget.TextView;
import android.widget.Toast;

import java.util.ArrayList;
import java.util.List;


public class MainActivity extends Activity {
   

    private Context mContext = this;
    private ImageView addView;
    private ListView listView;

    private MyAdapter adapter;

    private List<DataBean> mList;

    private Handler mHandler = new Handler() {
        @Override
        public void handleMessage(Message msg) {
            super.handleMessage(msg);
            switch (msg.what){
                case 0:
                    new MyTask().execute();
                    break;
            }
        }
    };


    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        DBManager.getInstance(mContext).createDatebase(mContext);

        addView = (ImageView) this.findViewById(R.id.main_add);
        listView = (ListView) this.findViewById(R.id.main_list);
        mList = new ArrayList<DataBean>();
        mHandler.sendMessage(Message.obtain(mHandler, 0));


        listView.setOnItemClickListener(new AdapterView.OnItemClickListener() {
            @Override
            public void onItemClick(AdapterView<?> parent, View view, final int position, long id) {
                AlertDialog.Builder builder = new AlertDialog.Builder(mContext);
                builder.setCancelable(false);
                AlertDialog dialog = null;
                builder.setTitle("提示");
                builder.setMessage("确定要删除吗");

                builder.setPositiveButton("确定", new DialogInterface.OnClickListener() {
                    @Override
                    public void onClick(DialogInterface dialog, int which) {
                        boolean isOK = DBManager.getInstance(mContext).delete_download(mList.get(position).getName());
                        if (isOK) {
                            Toast.makeText(mContext, "删除成功", Toast.LENGTH_LONG).show();
                            mHandler.sendMessage(Message.obtain(mHandler, 0));
                        } else {
                            Toast.makeText(mContext, "删除失败了", Toast.LENGTH_LONG).show();
                        }
                        dialog.dismiss();
                    }
                });

                builder.setNegativeButton("取消", new DialogInterface.OnClickListener() {
                    @Override
                    public void onClick(DialogInterface dialog, int which) {
                        dialog.dismiss();
                    }
                });

                dialog = builder.create();
                dialog.show();