Android - local storage & UserTable sample

来源：互联网发布：90后网络行为分析编辑：程序博客网时间：2024/06/03 19:13

Android - local storage & UserTable sample

public class UserTableDataAccess extends SQLiteOpenHelper {    public static final int DATABASE_VERSION = 1;    public String CREATE_QUERY = "CREATE TABLE "+ DataTables.UserTable.TABLE_NAME+"("+ DataTables.UserTable.COLUMN_USER_NAME +" TEXT, "+ DataTables.UserTable.COLUMN_PASSWORD +" TEXT);";    public UserTableDataAccess(Context context) {        super(context, DataTables.UserTable.DATABASE_NAME, null, DATABASE_VERSION);        Log.d("Database Operations", "User table Created");    }    @Override    public void onCreate(SQLiteDatabase sdb) {        sdb.execSQL(CREATE_QUERY);        Log.d("Database Operations", "Table Created");    }    @Override    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {    }    public void insert(UserTableDataAccess dop, String userName, String password){        SQLiteDatabase SQ = dop.getWritableDatabase();        ContentValues cv = new ContentValues();        cv.put(DataTables.UserTable.COLUMN_USER_NAME, userName);        cv.put(DataTables.UserTable.COLUMN_PASSWORD, password);        long k = SQ.insert(DataTables.UserTable.TABLE_NAME, null, cv);        //Log.d("Database Operations", "One Row Inserted");    }    public Cursor getIterator(UserTableDataAccess dop){        SQLiteDatabase SQ = dop.getReadableDatabase();        String[] columns = {DataTables.UserTable.COLUMN_USER_NAME, DataTables.UserTable.COLUMN_PASSWORD};        Cursor iterator = SQ.query(DataTables.UserTable.TABLE_NAME,columns,null,null,null,null,null);        return iterator;    }}

1 0