Android中SQLite的增删改查

Android中SQLite的增删改查

 public void createTest(){
        Sqlite sqlite = new Sqlite(MainActivity.this,1);
        SQLiteDatabase readableDatabase = sqlite.getReadableDatabase();
        sqlite.getWritableDatabase();
    }

    /**
     * 插入方法
     */
    public void insertTest(){
        Sqlite sqlite = new Sqlite(MainActivity.this,1);
        SQLiteDatabase database =sqlite.getReadableDatabase();
        //使用android自带API进行增加数据
        /*ContentValues values = new ContentValues();
        values.put("username","user1");
        values.put("password","456d666888");
        database.insert("User88",null,values);*/

        //使用sql语句的第二种方法，自己写sql语句，不带返回值
        database.execSQL("insert into User88 (username,password) values('insert1','123')");
    }

    /**
     * 删除方法
     */
    public void deleteTest(){
        Sqlite sqlite = new Sqlite(MainActivity.this,1);
        SQLiteDatabase database = sqlite.getReadableDatabase();
        final int deleteResult = database.delete("User88", "id=?", new String[]{"4"});
        Log.e("DeleteResult=====>",String.valueOf(deleteResult));
    }

    /**
     * 修改方法
     */
    public void updataTest(){
        Sqlite sqlite = new Sqlite(MainActivity.this,1);
        SQLiteDatabase database = sqlite.getReadableDatabase();
        ContentValues values = new ContentValues();
        values.put("password","updatepwd");
        int updateResult = database.update("User88", values, "id=?", new String[]{"3"});
        Log.e("UpdataResult====>",String.valueOf(updateResult));
    }

    /**
     * 查询方法
     */
    public void selectTest(){
        Sqlite sqlite = new Sqlite(MainActivity.this,1);
        SQLiteDatabase database = sqlite.getReadableDatabase();
        //第一种遍历查询到数据的方法
//        Cursor selectResult = database.query("User88", new String[]{"id", "username", "password"}, null, null, null, null, null);
//        while (selectResult.moveToNext()){
//            int id=selectResult.getInt(0);
//            String username = selectResult.getString(1);
//            String password = selectResult.getString(2);
//            Log.e("selectResult===>","id:"+id+" username:"+username+" password:"+password);
//        }
        //自己写sql语句来查询数据并带的返回值
        Cursor Rawcursor = database.rawQuery("select * from User88 where id=?", new String[]{"6"});
        //第二种遍历查询到数据的方法
        while (Rawcursor.moveToNext()){
            int id = Rawcursor.getInt(Rawcursor.getColumnIndex("id"));
            String username =Rawcursor.getString(Rawcursor.getColumnIndex("username"));
            String password = Rawcursor.getString(Rawcursor.getColumnIndex("password"));
            Log.e("selectResult===>","id:"+id+" username:"+username+" password:"+password);
        }
    }