数据库

<!==================Sql页面===============!>




package com.handmark.pulltorefresh.library.sql;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.support.annotation.Nullable;

public class MySql extends SQLiteOpenHelper {
    public MySql(@Nullable Context context) {
        super(context, "bw.db", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table show (id integer primary key autoincrement ,title varchar(50),name varchar(50),img varchar(100))");

    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

    }
}

<!==================Dao层页面===============!>


package com.handmark.pulltorefresh.library.sql;

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



public class Dao
{
    private final SQLiteDatabase db;
    public Dao(Context context)
    {
        MySql sql = new MySql(context);
        db = sql.getWritableDatabase();
    }
    public long insert(String table, String nullColumnHack, ContentValues values)
    {
        return db.insert(table,nullColumnHack,values);

    }
    public Cursor query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy)
    {
        return db.query(table,columns,selection,selectionArgs,null,null,null);
    }

}