SQLite数据库

public sqliteHelper(Context context) {
    super(context, "Base.db", null, 1);
}

@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
    sqLiteDatabase.execSQL("create table user(id integer primary key autoincrement," +
            "text name)");

}

@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

}

-------------------------------------------------------------------------------

private SQLiteDatabase database;
private sqliteHelper helper;

public void UserBean(Context context){

   helper= new sqliteHelper(context);
   database = helper.getReadableDatabase();

}

//添加
public void insert(String name){

    ContentValues values= new ContentValues();
    values.put("name",name);
    database.insert("user",null,values);
}
//查询
public List<User> select(){
    Cursor query = database.query("select * from user", null, null, null, null, null, null);
    List<User> list =new ArrayList<>();
    while (query.moveToNext()){
        String name = query.getString(query.getColumnIndex("name"));

        User user = new User(name);
        list.add(user);
    }

    return list;
}