sqlite本地保存数据

package com.cesecsh.ics.database;

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

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

/**
 * Created by fans on 2016/12/22.
 */

public class OrderSearchHistoryDbHelp extends SQLiteOpenHelper {
    /**
     * 创建数据库
     *
     * @param context
     */
    public OrderSearchHistoryDbHelp(Context context) {
        super(context, "myorder.db", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String schema = "create table myorder("
                + "_id integer primary key autoincrement,"
                + "keyword)";
        // 执行SQL语句
        db.execSQL(schema);

    }

    /**
     * 增
     *
     * @param keyword
     */
    public void insert(String keyword) {
        String sql = "insert into myorder(keyword)" +
                " values(?)";
        SQLiteDatabase db = this.getWritableDatabase();
        db.execSQL(sql, new String[]{keyword});
        db.close();
    }

    /**
     * 清空记录
     */
    public void clearRecord() {
        String sql = "delete from myorder";
        SQLiteDatabase db = this.getWritableDatabase();
        db.execSQL(sql);
        db.close();
    }

    /**
     * 查
     *
     * @return
     */
    public Cursor select() {
        String sql = "select * from myorder order by _id asc";
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor c = db.rawQuery(sql, null);
        return c;
    }

    /**
     * 获得keyword
     *
     * @return
     */
    public List<String> getKeyWord() {
        String sql = "select * from myorder order by _id asc";
        SQLiteDatabase db = this.getReadableDatabase();
        Cursor c = db.rawQuery(sql, null);

        List<String> list = new ArrayList<>();
        while (c.moveToNext()) {
            String keyword = c.getString(c.getColumnIndex("keyword"));
            list.add(keyword);
        }
        c.close();
        db.close();

        return list;
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}