public class Dao { Mysqlite ms; public Dao(Context con) { ms= new Mysqlite(con); } public List<User> show(){ List<User> list=new ArrayList<>(); SQLiteDatabase database = ms.getWritableDatabase(); Cursor cursor = database.rawQuery("select * from resou", null); while (cursor.moveToNext()){ int id = cursor.getInt(0); String name = cursor.getString(1); User u=new User(name,id); list.add(u); } return list; } public List<User> show2(){ List<User> list=new ArrayList<>(); SQLiteDatabase database = ms.getWritableDatabase(); Cursor cursor = database.rawQuery("select * from lishiresou", null); while (cursor.moveToNext()){ int id = cursor.getInt(0); String name = cursor.getString(1); User u=new User(name,id); list.add(0,u); } return list; } public void add(User u){ SQLiteDatabase database = ms.getWritableDatabase(); ContentValues cv=new ContentValues(); cv.put("name",u.getName()); database.insert("lishiresou",null,cv); //db.execSQL("insert into resou (id,name) values (null,'android')"); } public void dele(){ SQLiteDatabase database = ms.getWritableDatabase(); database.execSQL("delete from lishiresou"); } }
Sqlite增删改查
最新推荐文章于 2024-08-18 16:29:49 发布