Android Studio SQLite增删改查功能

**

创建好Activity，再新建一个Java Class。

**

**

**

之后按提示引入相关包 差不多像这样：：

**

**

在第二个构造方法写sql语句

**

 String sql=" create table Onesjk(id integer primary key autoincrement,  name varchar(55),zz varchar(55) ,jj varchar(110))";
        sqLiteDatabase.execSQL(sql);

**

页面布局就不说了，注意按钮，和文本框

**

在外面声明，注意SQLiteDatabase，MyHelper，Cursor，这三个

    private EditText etyym,etzz,etjj,etcx,etsc;
    private Button btcjsjk,bttj,btxg,btsc,btcx;
    
    private  SQLiteDatabase sqLiteDatabase;
    private  MyHelper myHelper;
    
    private TextView textViewssjg;
    
    private Cursor cursor=null;
    private  String strSC="";

**这没什么好说的。最后一个需要注意一下。

MyHelper，创建数据库的时候要调用， 那个‘MM1’是数据库名**

        etyym=findViewById(R.id.editText_yym);
        etzz=findViewById(R.id.editText_zz);
        etjj=findViewById(R.id.editText_jj);
        etcx=findViewById(R.id.editText_cx);
        etsc=findViewById(R.id.editText_sc);

        textViewssjg=findViewById(R.id.textView_ssjg);

        btcjsjk=findViewById(R.id.button_cjsjk);
        btcjsjk.setOnClickListener(this);

        bttj=findViewById(R.id.button_tj);
        bttj.setOnClickListener(this);

        btxg=findViewById(R.id.button_xg);
        btxg.setOnClickListener(this);

        btsc=findViewById(R.id.button_sc);
        btsc.setOnClickListener(this);

        btcx=findViewById(R.id.button_cx);
        btcx.setOnClickListener(this);

        myHelper=new MyHelper(getApplicationContext(),"MM1",null,1);

这里用的是外部OnClickListener

switch (v.getId()){
            case R.id.button_cjsjk://创建数据库
                sqLiteDatabase=myHelper.getWritableDatabase();
                break;
            case R.id.button_tj://添加
                sqLiteDatabase=myHelper.getWritableDatabase();

                ContentValues contentValues=new ContentValues();
                contentValues.put("name",etyym.getText().toString());
                contentValues.put("zz",etzz.getText().toString());
                contentValues.put("jj",etjj.getText().toString());

                sqLiteDatabase.insert("onesjk",null,contentValues);

                sqLiteDatabase.close();
                Toast.makeText(getApplicationContext(),etyym.getText().toString()+"添加成功",Toast.LENGTH_LONG).show();
                break;

            case R.id.button_xg://修改
                sqLiteDatabase=myHelper.getWritableDatabase();
                ContentValues contentValues1=new ContentValues();
                contentValues1.put("zz",etzz.getText().toString());
                contentValues1.put("jj",etjj.getText().toString());
                if (sqLiteDatabase.update("onesjk",contentValues1,"name=?",new String[]{etyym.getText().toString()} )>0){
                    Toast.makeText(getApplicationContext(),"作者名："+etzz.getText().toString()+"修改成功"+"\n"+"简介："+etjj.getText().toString()+"修改成功",Toast.LENGTH_LONG).show();
                }else{
                    Toast.makeText(getApplicationContext(),"修改失败",Toast.LENGTH_LONG).show();
                };
                break;

            case R.id.button_sc://删除
                sqLiteDatabase=myHelper.getWritableDatabase();
                if (
                        sqLiteDatabase.delete("onesjk","name=?",new String[]{etsc.getText().toString()})>0)
                {

                    Toast.makeText(getApplicationContext(),"删除"+etsc.getText().toString()+"成功",Toast.LENGTH_LONG).show();
                }else{
                    Toast.makeText(getApplicationContext(),"删除失败，没有选定",Toast.LENGTH_LONG).show();
                };
                break;

                case R.id.button_cx://查询
                sqLiteDatabase=myHelper.getWritableDatabase();



                cursor=sqLiteDatabase.query("onesjk",null,"name=?",new String[]{etcx.getText().toString()},null,null,null);
                     while (cursor.moveToNext()) {
                        String strName = cursor.getString(cursor.getColumnIndex("name"));
                        String strZz = cursor.getString(cursor.getColumnIndex("zz"));
                        String strJj = cursor.getString(cursor.getColumnIndex("jj"));
                        strSC += "音乐名:" + strName + "作者:" + strZz + "简介" + strJj + "\n";
                    }

                    cursor.close();
                    textViewssjg.setText(strSC);

                   //Toast.makeText(getApplicationContext(),"不存在",Toast.LENGTH_LONG).show();

                strSC="";
                break;
        }

**

差不多就这样。基本上，能写出一个，之后的就都容易写了。

**

END.

**

**