Day9Sqlite数据库存储+增删改查

获取权限

    <uses-permission android:name="android.permission.INTERNET" />
    <uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" />
    <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />

1.创建数据库

       private SQLiteDatabase readableDatabase;
    //TODO:建立连接
        MySqlHelper mySqlHelper = new MySqlHelper(this, "user.db", null, 1);

        //TODO:打开数据库 如果没有创建并打开
         readableDatabase = mySqlHelper.getReadableDatabase();

2.创建表

    //TODO:创建表
    public void createTable(View view) {
        String sql = "create table student (id integer primary key autoincrement,name varchar(20))";
        readableDatabase.execSQL(sql);
    }

3.插入数据

  //TODO:插入一条数据
    public void insert(View view) {

//       String sql = "insert into student values(null,?)";
//       readableDatabase.execSQL(sql,new Object[]{"李四"});

        ContentValues contentValues = new ContentValues();

        contentValues.put("name","哈哈哈");

        readableDatabase.insert("student",null,contentValues);
    }

4.查询数据

  //TODO:查询
    public void query(View view) {

//        String sql = "select * from student where id = ?";
//        Cursor cursor = readableDatabase.rawQuery(sql, new String[]{"6"});
//        if (cursor!=null){
//            while (cursor.moveToNext()){
//                String name = cursor.getString(cursor.getColumnIndex("name"));
//                Toast.makeText(this, name, Toast.LENGTH_SHORT).show();
//            }
//            cursor.close();
//        }

        Cursor cursor = readableDatabase.query("student", null,null,null,null,null,null);
        if (cursor!=null){
            while (cursor.moveToNext()){
                String name = cursor.getString(cursor.getColumnIndex("name"));
                Toast.makeText(this, name, Toast.LENGTH_SHORT).show();
            }
            cursor.close();
        }
    }

5.删除数据

   public void del(View view) {
//        String sql = "delete from student where id = ?";
//        readableDatabase.execSQL(sql,new Object[]{5});
        readableDatabase.delete("student","id=?",new String[]{"6"});
    }

6.修改数据

   public void upd(View view) {
//        String sql = "update student set name = ? where id = ?";
//        readableDatabase.execSQL(sql,new Object[]{"张三",6});

        ContentValues contentValues = new ContentValues();
        contentValues.put("name","呵呵");

        readableDatabase.update("student",contentValues,"id=?",new String[]{"6"});
    }