sql

Mysql数据库

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

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table aaa(id integer primary key autoincrement,name text,pass text)");
    }

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

    }
}

Dao层

public class Dao {

    private Context context;
    private final SQLiteDatabase db;

    public Dao(Context context) {
        this.context = context;
        MySql mySql = new MySql(context);
        db = mySql.getWritableDatabase();
    }

    public long insert(String table, String nullColumnHack, ContentValues values) {

        return db.insert(table,nullColumnHack,values);
    }

    public long delete(String table, String whereClause, String[] whereArgs) {
        return db.delete(table,whereClause,whereArgs);
    }

    public long update(String table, ContentValues values, String whereClause, String[] whereArgs) {
        return db.update(table,values,whereClause,whereArgs);
    }

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

}