**DAO**
public class ShopDao {
private final SQLiteDatabase writableDatabase;
public ShopDao(Context context) {
MyHelper helper = new MyHelper(context);
writableDatabase = helper.getWritableDatabase();
}
public List<ShopBean> cha(String url) {
List<ShopBean> list = new ArrayList<>();
Cursor cursor = writableDatabase.rawQuery("select * from shop where url = ?", new String[]{url});
while(cursor.moveToNext()){
String url1 = cursor.getString(cursor.getColumnIndex("url"));
String json = cursor.getString(cursor.getColumnIndex("json"));
list.add(new ShopBean(url1,json));
}
return list;
}
public void add(String url,String json){
ContentValues values = new ContentValues();
values.put("url",url);
values.put("json",json);
writableDatabase.replace("shop",null,values);
}
}
DAO
最新推荐文章于 2024-06-30 20:26:49 发布