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

}