android studio 数据库操作

public MyDatabaseHelper dbHelper;

dbHelper=new MyDatabaseHelper(this,"aaa.db",null,1);


SQLiteDatabase db1=dbHelper.getWritableDatabase();

增

                        ContentValues values = new ContentValues();
                        values.put("day",textView.getText().toString());
                        values.put("time",textView2.getText().toString());
                        values.put("content",editText.getText().toString());
                        values.put("idd",(int)(time2/1000/60));
                        db1.insert("bbb",null,values);
                        db1.closel();

删

 db1.delete("aaa", "idd=?", new String[]{id});

改

                            ContentValues values=new ContentValues();
                            values.put("day",jday);
                            values.put("time",jtime);
                            values.put("content",editText.getText().toString());
                            values.put("idd",jid);
                            db1.update("bbb",values,"idd=?",new String[]{String.valueOf(jid)});
                            db1.close();

查

        Cursor cursor = db.query("bbb", null, null, null, null, null, null);
        String [] floor = new String[10];
        int i=0;int q;
        if (cursor.moveToFirst()) {
            do {
                a.add(new Cont(cursor.getString(cursor.getColumnIndex("day"))
                        ,cursor.getString(cursor.getColumnIndex("time"))
                        ,cursor.getString(cursor.getColumnIndex("content"))
                        ,cursor.getInt(cursor.getColumnIndex("idd"))));
            } while (cursor.moveToNext());
        }
        cursor.close();