安卓:使用方法增删改查

增:db.insert();

删:db.delete();

改:db.update();

查:db.query();

一:.xml文件编写对应按钮及方法 

二:新建数据库 

三:返回MainActivity,实例化数据库

public class MainActivity extends AppCompatActivity {
    SQLiteDatabase sqlDataException;
    MySql mySql;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        mySql = new MySql(this, "cxk.db", null, 1);
        sqlDataException = mySql.getWritableDatabase();
    }

    public void insert(View view) {
        ContentValues contentValues = new ContentValues();
        contentValues.put("name","蔡徐坤");
        contentValues.put("age",250);
        sqlDataException.insert("mc",null,contentValues);
    }

    public void query(View view) {
        Cursor cursor = sqlDataException.query("mc",null,null,null,null,null,null);
        if (cursor != null) {
            while (cursor.moveToNext()) {
                @SuppressLint("Range") String name = cursor.getString(cursor.getColumnIndex("name"));
                @SuppressLint("Range") int age = cursor.getInt(cursor.getColumnIndex("age"));
                Log.i("a", "query:" + name + age);
            }
        }

    }

    public void update(View view) {
        //sqlDataException.execSQL("update mc set age=? where name=?",new String[]{"80","111"});
        ContentValues contentValues = new ContentValues();
        contentValues.put("age","50");
        sqlDataException.update("mc",contentValues,"name=?",new String[]{"蔡徐坤"});
    }

    public void delete(View view) {

      sqlDataException.delete("mc","name=?",new String[]{"蔡徐坤"});
    }

    public void insertall(View view) {
        sqlDataException.beginTransaction();
        for (int i=0;i<20;i++){
            ContentValues contentValues = new ContentValues();
            contentValues.put("name","ikun"+i);
            contentValues.put("age","10"+i);
            sqlDataException.insert("mc",null,contentValues);
        }
        sqlDataException.setTransactionSuccessful();
        sqlDataException.endTransaction();
    }
}