Android - local storage & UserTable sample

最新推荐文章于 2021-06-19 23:43:49 发布

_iorilan

最新推荐文章于 2021-06-19 23:43:49 发布

阅读量6.4k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： android 文章标签： android

本文链接：https://blog.csdn.net/lan_liang/article/details/52270204

android 专栏收录该内容

36 篇文章

订阅专栏

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;
    }
}