数据库传值

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);

    }

 

 

}