数据库整合（1）

package com.bawei.channelmanager.bean;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

import com.bawei.channelmanager.db.DBOpenHelper;

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

public class ChannelDao {

    private Context context;
    private DBOpenHelper helper;
    private SQLiteDatabase database;

    public ChannelDao(Context context) {
        helper = new DBOpenHelper(context);
        database = helper.getWritableDatabase();
    }

    /**
     * 鎻掑叆鎿嶄綔
     *
     * @param bean
     */
    public void insert(ChannelBean bean) {
        database.execSQL("insert into channel(channel, sort) values(?, ?)", new String[]{bean.getChannel(), String.valueOf(bean.getSort())});
    }

    public void update(ChannelBean bean) {
        database.execSQL("update channel set channel = ?, sort = ? where _id = ?", new String[]{bean.getChannel(), String.valueOf(bean.getSort()), String.valueOf(bean.get_id())});
    }

    public List<ChannelBean> query() {
        List<ChannelBean> beans = new ArrayList<>();
        ChannelBean bean1;
        Cursor cursor = database.rawQuery("select * from channel", null);
        while (cursor.moveToNext()) {
            // String isMore = cursor.getString(cursor.getColumnIndex("isMore"));
            bean1 = new ChannelBean(
                    cursor.getString(cursor.getColumnIndex("channel")),
                    cursor.getInt(cursor.getColumnIndex("sort")),
                    true
            );
            beans.add(bean1);
        }

        return beans;
    }
}