public class Sqlite extends SQLiteOpenHelper {
public Sqlite(Context context) {
super(context, "bw.db", null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table show (id integer primary key autoincrement ,name varchar(50),imageUrl varchar(100))");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
public class Dao {
private final SQLiteDatabase db;
public Dao(Context context) {
Sqlite sql = new Sqlite(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);
}
}