android SQLite的简单封装

自定义：SQLiteOpenHelper

public class SQliteDBHelper extends SQLiteOpenHelper {
    private String sql;

    public SQliteDBHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version,String sql) {
        //指定数据库名和版本号
        super(context, name, factory, version);
        this.sql = sql;
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        //db.execSQL执行创建需要的表
        db.execSQL(sql);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        //升级数据库
        switch (oldVersion){
            case 1:
                //do sth
                break;
            default:
                break;
        }
    }
}

封装方法：

public class NewsDBApi {
    private SQliteDBHelper dbHelper;
    private Context context;
    private static final String DB_NAME &#