android Sqlite数据库操作简介

今天药忘吃喽~ 2022-05-27 03:21 220阅读 0赞

import android.database.Cursor;
    import android.database.sqlite.SQLiteDatabase;
    
            //创建数据库
            SQLiteDatabase db = SQLiteDatabase.openOrCreateDatabase("/sdcard/ss.db",null);
    
            ContentValues cvalues = new ContentValues();
    
            //创建表
            String CREATE_EMPLOYEE = "create table employeeInfo ("
                    + "id integer primary key autoincrement, "
                    + "name text, "
                    + "sex text, "
                    + "age integer,"
                    + "addr text)";
            db.execSQL(CREATE_EMPLOYEE);
    
            //插入数据
            cvalues.put("name","王二小");
            cvalues.put("sex","男");
            cvalues.put("age",10);
            cvalues.put("addr","山西");
            db.insert("employeeInfo",null,cvalues);
            cvalues.clear();
    
            //删除
            String sql = "delete from employeeInfo where _id = 6";
            db.execSQL(sql);
            
            //修改
            String update = "update employeeInfo set name = 葫芦娃 where id = 1";
            db.execSQL(update);
    
            //查询
            Cursor cursor = db.query("employeeInfo",null,null,null,null,null,null,null);
            if(cursor.getCount() > 0)
            {
                //移动到首位
                cursor.moveToFirst();
                for (int i = 0; i < cursor.getCount(); i++) {
    
                    int id = cursor.getInt(cursor.getColumnIndex("id"));
                    String name = cursor.getString(cursor.getColumnIndex("name"));
    
                    Logger.e("name   =  %s",name);
    
                    //移动到下一位
                    cursor.moveToNext();
                }
            }
            cursor.close();
    
    
            //关闭
            db.close();
    为了确保操作成功，加上事务处理