public class DBUtils {
private final MyOpenHelpersqlite helpersqlite;
private final SQLiteDatabase db;
//有参
public DBUtils(Context context) {
helpersqlite = new MyOpenHelpersqlite(context);
db = helpersqlite.getWritableDatabase();
}
public void saveChnnels(List<ChannelBean> channelBeanList) {
if (channelBeanList == null || channelBeanList.size() < 0)
{
return;
}
for (ChannelBean channelBean : channelBeanList) {
ContentValues values = new ContentValues();
values.put("name", channelBean.getName());
values.put("selected", channelBean.isSelect());
db.insert("channels", null, values);
}
}
public List<ChannelBean> getAllChannels() {
Cursor cursor = db.query("channels", null, null, null, null, null, null);
List<ChannelBean> channelBeen = new ArrayList<>();
while (cursor.moveToNext()) {
String name = cursor.getString(cursor.getColumnIndex("name"));
int selected = cursor.getInt(cursor.getColumnIndex("selected"));
channelBeen.add(new ChannelBean(name, selected == 0 ? false : true));
}
cursor.close();
return channelBeen;
}
public List<ChannelBean> getUserChannels() {
Cursor cursor = db.query("channels", null, "selected=?", new String[]{"1"}, null, null, null);
List<ChannelBean> channelBeanList = new ArrayList<>();
while (cursor.moveToNext())
{
String name = cursor.getString(cursor.getColumnIndex("name"));
int selected = cursor.getInt(cursor.getColumnIndex("selected"));
channelBeanList.add(new ChannelBean(name, selected == 0 ? false : true));
}
cursor.close();
return channelBeanList;
}
public void clearChannels() {
db.delete("channels", null, null);
}
}