android得sq语句

最新推荐文章于 2023-03-24 19:02:18 发布

（.俗人.）

最新推荐文章于 2023-03-24 19:02:18 发布

阅读量69

点赞数

文章标签： android java 开发语言 Powered by 金山文档

本文链接：https://blog.csdn.net/m0_63719900/article/details/129306542

版权

继承sq类然后进行创建

之后就是增删改查

/* sqLiteDatabase.execSQL("insert into stu values(?,?,?)",new String[]{null,"bwc11","20"});
        sqLiteDatabase.execSQL("insert into stu values(?,?,?)",new String[]{null,"bwc12","30"});
        sqLiteDatabase.execSQL("insert into stu values(?,?,?)",new String[]{null,"bwc123","40"});*/

        ContentValues contentValues=new ContentValues();
        contentValues.put("name","nihao");
        contentValues.put("age","88");
        sqLiteDatabase.insert("stu",null,contentValues);

//Cursor cursor=sqLiteDatabase.rawQuery("select * from stu",null);
        Cursor cursor=sqLiteDatabase.query("stu",null,null,null,null,null,null);
        while (cursor.moveToNext()){
            int id=cursor.getInt(cursor.getColumnIndex("id"));
            String name=cursor.getString(cursor.getColumnIndex("name"));
            int age=cursor.getInt(cursor.getColumnIndex("age"));
            Log.i("---c", "querydate: "+id+name+age);

//sqLiteDatabase.execSQL("update stu set age=? where name=?",new String[]{"100","bwc11"});
        ContentValues contentValues=new ContentValues();
        contentValues.put("age",100);
        sqLiteDatabase.update("stu",contentValues,"name=?",new String[]{"bwc12"});

sqLiteDatabase.delete("stu","name=?",new String[]{"nihao"});
        //sqLiteDatabase.execSQL("delete from stu where name=?",new String[]{"bwc11"});

事务处理

 sqLiteDatabase.beginTransaction();
        for (int i=0;i<20;i++){
            ContentValues contentValues=new ContentValues();
            contentValues.put("name","bwc0"+i);
            contentValues.put("age","20"+i);
            sqLiteDatabase.insert("stu",null,contentValues);
        }
        sqLiteDatabase.setTransactionSuccessful();
        sqLiteDatabase.endTransaction();