android studio sqlite一个基本操作

public class DB extends SQLiteOpenHelper {
    public DB(Context context) {
        super(context, "user.db", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
        sqLiteDatabase.execSQL("create table user("+"_id INTEGER PRIMARY KEY AUTOINCREMENT,"+
        "name TEXT DEFAULT NULL,"+"sex TEXT DEFAULT NULL)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

    }
}
public class Main2Activity extends ListActivity{
    private SimpleCursorAdapter adapter;
    EditText editText1,editText2;
    SQLiteDatabase dbwrite,dbread;
    Button button;
    DB db;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main2);
        editText1=(EditText)findViewById(R.id.etname);
        editText2=(EditText)findViewById(R.id.etsex);
        button=(Button)findViewById(R.id.add);
        db=new DB(this);
        dbwrite=db.getWritableDatabase();
        dbread=db.getReadableDatabase();
        button.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {

                ContentValues values=new ContentValues();
                values.put("name",editText1.getText().toString());
                values.put("sex",editText2.getText().toString());
                dbwrite.insert("user",null,values);
                refresh();
            }
        });
        adapter=new SimpleCursorAdapter(this,R.layout.cell,null,new String[]{"name","sex"},new int[]{R.id.name,R.id.sex});
        setListAdapter(adapter);
        refresh();
        getListView().setOnItemLongClickListener(new AdapterView.OnItemLongClickListener() {
            @Override
            public boolean onItemLongClick(AdapterView<?> adapterView, View view, final int position, long l) {
                new AlertDialog.Builder(Main2Activity.this).setTitle("delete").setMessage("delete item from db?").setPositiveButton("sure", new DialogInterface.OnClickListener() {
                    @Override
                    public void onClick(DialogInterface dialogInterface, int i) {
                        Cursor cursor=adapter.getCursor();
                        cursor.moveToPosition(position);
                        int itemid=cursor.getInt(cursor.getColumnIndex("_id"));
                        dbwrite.delete("user","_id=?",new String[]{itemid+""});
                        refresh();
                    }
                }).setNegativeButton("cancel",null).show();

                return true;
            }
        });
    }
    private void refresh() {
        Cursor cursor=dbread.query("user",null,null,null,null,null,null);
        adapter.changeCursor(cursor);
    }
}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值