Sqlite 数据库增删改查

实现增删改查按钮 布局

<Button
        android:id="@+id/buttonAdd"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="增"
        />
    <Button
        android:id="@+id/buttonRemove"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="删"
        />
    <Button
        android:id="@+id/buttonReplace"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="改"
        />
    <Button
        android:id="@+id/buttonSelect"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="查"
        />

MySqlHelp

public class MySqlHelp extends SQLiteOpenHelper {
    /**
     * @param context 上下文
     * @param name  库名
     * @param factory 创建方式（工厂）
     * @param version （数据库版本）
     */
    public MySqlHelp(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
    }
    //创建表
    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
        sqLiteDatabase.execSQL("create table user (id integer primary key autoincrement , name varchar(20) , address varchar(30))");
        sqLiteDatabase.beginTransaction();
        for (int i = 0; i < 100; i++) {
            sqLiteDatabase.execSQL("insert into user values(null,'卤蛋','阿晴')");
        }
        sqLiteDatabase.setTransactionSuccessful();

    }
    //更新表
    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

    }

Sqlite 语句实现功能

public class MainActivity extends AppCompatActivity implements View.OnClickListener {

    private Button buttonAdd;
    private Button buttonRemove;
    private Button buttonReplace;
    private Button buttonSelect;

    private SQLiteDatabase db;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        initView();

        MySqlHelp mySqlHelp = new MySqlHelp(this, "user.db", null, 1);
        //可读可写（如果"user.db"存在就打开，不存在就创建，如果磁盘满了就重新打开）
        db = mySqlHelp.getReadableDatabase();
        //可读可写（如果"user.db"存在就打开，不存在就创建，如果磁盘满了直接报错）
        //mySqlHelp.getWritableDatabase();

        ContentValues values = new ContentValues();
        values.put("name","小红");
        values.put("address","嗯哼");
        db.insert("user", null, values);


    }

    private void initView() {
        buttonAdd = (Button) findViewById(R.id.buttonAdd);
        buttonRemove = (Button) findViewById(R.id.buttonRemove);
        buttonReplace = (Button) findViewById(R.id.buttonReplace);
        buttonSelect = (Button) findViewById(R.id.buttonSelect);

        buttonAdd.setOnClickListener(this);
        buttonRemove.setOnClickListener(this);
        buttonReplace.setOnClickListener(this);
        buttonSelect.setOnClickListener(this);
    }

    @Override
    public void onClick(View v) {
        switch (v.getId()) {
            case R.id.buttonAdd:
                ContentValues values = new ContentValues();
                values.put("id",2);
                values.put("name","小明");
                values.put("address","啊哈");
                db.insert("user",null,values);

//                String sql = "insert into user(name,address) values(?,?)";
//                db.execSQL(sql,new Object[]{"小小","嗯呐"});
                break;
            case R.id.buttonRemove:
//                String sql2 = "delete from user where id = ?";
//                db.execSQL(sql2,new Object[]{5});

                db.delete("user","id = ?",new String[]{"5"});

                break;
            case R.id.buttonReplace:
//                String sql3 = "update user set name = ? and address = ? where id = ? ";
//                db.execSQL(sql3,new Object[]{"大大","木马","3"});

                ContentValues value = new ContentValues();
                value.put("name","大大");
                value.put("address","木马");
                db.update("user",value,"id = ?",new String[]{"3"});


                break;
            case R.id.buttonSelect:

                String sql4 = "select * from user where id = ?";
                Cursor cursor1 = db.rawQuery(sql4, new String[]{"3"});
                if (cursor1 != null){
                    while (cursor1.moveToNext()){
                        int id = cursor1.getInt(cursor1.getColumnIndex("id"));
                        String name = cursor1.getString(cursor1.getColumnIndex("name"));
                        String address = cursor1.getString(cursor1.getColumnIndex("address"));
                        Toast.makeText(this, id+"-"+name+"-"+address, Toast.LENGTH_SHORT).show();
                    }
                }
                cursor1.close();

//                Cursor cursor = db.query("user", null, null, null, null, null, null);
//                if (cursor != null){
//                    while (cursor.moveToNext()){
//                        int id = cursor.getInt(cursor.getColumnIndex("id"));
//                        String name = cursor.getString(cursor.getColumnIndex("name"));
//                        String address = cursor.getString(cursor.getColumnIndex("address"));
//                        Toast.makeText(this, id+"-"+name+"-"+address, Toast.LENGTH_SHORT).show();
//                    }
//                }
//                cursor.close();
                break;
        }
    }