NewsDao

package com.bwie.topnewsnormal.database;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.widget.Toast;

import com.andy.library.ChannelBean;
import com.bwie.topnewsnormal.bean.ChannelList;

import java.util.ArrayList;
import java.util.List;

/**
* Created by Shadow on 2017/8/16.
*/

public class NewsDao {

private static final String TABLE_NAME = "newsinfo";
private SQLiteDatabase db;

public NewsDao(Context context) {
    db = new MySqliteOpenHelper(context).getWritableDatabase();
}

public void add(List<ChannelBean> list) {

    for (int i = 0; i < list.size(); i++) {
        ContentValues values = new ContentValues();
        values.put("name", list.get(i).getName());
        if (list.get(i).isSelect()) {
            values.put("isSelect", "0");
        } else {
            values.put("isSelect", "1");
        }

        db.insert(TABLE_NAME, null, values);
    }

}

public ArrayList<ChannelBean> queryUser() {
    Cursor cursor = db.query(TABLE_NAME, null, "isSelect=?", new String[]{"0"}, null, null, null);

    ArrayList<ChannelBean> list = new ArrayList<ChannelBean>();
    ChannelBean channelBean;
    while (cursor.moveToNext()) {

        String name = cursor.getString(cursor.getColumnIndex("name"));
        int isSelect = cursor.getInt(cursor.getColumnIndex("isSelect"));
        channelBean = new ChannelBean(name, isSelect == 0 ? true : false);
        list.add(channelBean);
    }
    return list;

}

public ArrayList<ChannelBean> queryAll() {
    Cursor cursor = db.query(TABLE_NAME, null, null, null, null, null, null);

    ArrayList<ChannelBean> list = new ArrayList<ChannelBean>();
    ChannelBean channelBean;
    while (cursor.moveToNext()) {
        String name = cursor.getString(cursor.getColumnIndex("name"));
        int isSelect = cursor.getInt(cursor.getColumnIndex("isSelect"));
        channelBean = new ChannelBean(name, isSelect == 0 ? true : false);
        list.add(channelBean);
    }
    return list;

}

public void delete() {
    db.delete(TABLE_NAME, null, null);
}

}