SQLite数据库

最新推荐文章于 2024-10-12 22:16:57 发布

原创最新推荐文章于 2024-10-12 22:16:57 发布 · 218 阅读

CC 4.0 BY-SA版权

本文介绍了一个简单的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;
}