SQLite简单增删改查

首先我们需要一个MySQLite的类去实现SQLiteOpenHelper接口

package com.example.part_seven;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class MyHelper extends SQLiteOpenHelper {
//实现SQLite的构造 创建数据库 xx.db;

public MyHelper(Context context) {
  //上下文 库名 null ,版本号
    super(context, "student.db", null,1);
}

//onCreate是创建表和添加表数据
@Override
public void onCreate(SQLiteDatabase db) {

    db.execSQL("create table user(stu_id integer primary key autoincrement,name varchar(20),age integer)");
    db.execSQL("insert into user values(null,'武帝',10)");
}

//这个方法是更新版本操作
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}

}

主类实现:

有两中方法可以实现 一个是实现我们自定义的MySQLite

MyHelper myHelper = new MyHelper(this);
myHelper.getWritableDatabase();

另外一种是

ContemtView
new 对象
put(“列明”,“值”)；

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.ArrayAdapter;
import android.widget.ListView;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

public class MainActivity extends AppCompatActivity {

SQLiteDatabase db;
ListView listView;
@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    listView=findViewById(R.id.list);

    MyHelper myHelper = new MyHelper(this);
     db = myHelper.getWritableDatabase();


}

public void insert_data(View view){
    db.execSQL("insert into user values(null,'狠人大帝',20)");

    find_data();

// ContentValues contentValues = new ContentValues();
// contentValues.put(“name”,“狠人大帝”);
// contentValues.put(“age”,10);
// db.insert(“User”,null,contentValues);

}
public void delete_data(View view){

// db.execSQL(“delete from user where age = 20”);

    db.delete("user","name=?",new String[]{"狠人大帝"});
    find_data();


}
public void update_data(View view){

    db.execSQL("update user set name='无始大帝' where name='狠人大帝'");

    find_data();

// ContentValues contentValues = new ContentValues();
// contentValues.put(“age”,40);
// db.update(“User”,contentValues,“age=? or name=?”,new String[]{“10”,“狠人大帝”});
}
public void find_data(){

    Cursor cursor = db.rawQuery("select * from user", null);
    List<HashMap<String,Object>>mapList=new ArrayList<>();
    MyAdapter myAdapter;
    while(cursor.moveToNext()){
        String name = cursor.getString(cursor.getColumnIndex("name"));
        int stu_id = cursor.getInt(cursor.getColumnIndex("stu_id"));
        int age = cursor.getInt(cursor.getColumnIndex("age"));
        Uu uu = new Uu();

            uu.name=name;
            uu.id=stu_id;
            uu.age=age;


        HashMap<String, Object> map = new HashMap<>();
        map.put("user",uu.toString());
        Log.e("##",map.toString());
        mapList.add(map);

        Log.e("##",uu.toString());
    }

    myAdapter= new MyAdapter(MainActivity.this, mapList);
    myAdapter.notifyDataSetChanged();
    listView.setAdapter(myAdapter);

// db.query(“User”,null,“name=?”,new String[]{“富贵”},null,null,null);
// Cursor query = db.query(“User”, new String[]{“name”}, “age=?”, new String[]{“10”}, “name”, “id=29”, “age”);
// ArrayList arr = new ArrayList<>();
// while (query.moveToNext()){
// String name = query.getString(query.getColumnIndex(“name”));
//
// Uu u=new Uu();
// u.name=name;
// arr.add(u);
// }

}
class Uu{
    String name;
    int id;
    int age;

    @Override
    public String toString() {
        return "Uu{" +
                "name='" + name + '\'' +
                ", id=" + id +
                ", age=" + age +
                '}';
    }
}

}

实现效果: