数据存储传值

最新推荐文章于 2022-07-19 10:37:59 发布

umbrella_419

最新推荐文章于 2022-07-19 10:37:59 发布

阅读量236

点赞数

本文链接：https://blog.csdn.net/umbrella_419/article/details/74852688

版权

private DBHelper dbHelper;
private SQLiteDatabase sqLiteDatabase;

dbHelper = new DBHelper(this,"subject.db",null,3);
sqLiteDatabase = dbHelper.getWritableDatabase();

public void getCollect(){
    DBHelper dbHelper = new DBHelper(this,"subject.db",null,3);
    SQLiteDatabase sqLiteDatabase=dbHelper.getWritableDatabase();
    Cursor cursor= sqLiteDatabase.rawQuery("select * from Subject where collect ='1' ",null);
    while (cursor.moveToNext()){
        Log.i("test","bbbbbbbbbbbbb");
        int uid=cursor.getInt(cursor.getColumnIndex("uid"));
        String title=cursor.getString(cursor.getColumnIndex("title"));
        String option1=cursor.getString(cursor.getColumnIndex("option1"));
        String option2=cursor.getString(cursor.getColumnIndex("option2"));
        String option3=cursor.getString(cursor.getColumnIndex("option3"));
        String option4=cursor.getString(cursor.getColumnIndex("option4"));
        String choose=cursor.getString(cursor.getColumnIndex("choose"));
        String result=cursor.getString(cursor.getColumnIndex("result"));
        String analysis=cursor.getString(cursor.getColumnIndex("analysis"));
        int collect=cursor.getInt(cursor.getColumnIndex("collect"));
        int errors=cursor.getInt(cursor.getColumnIndex("errors"));
        int classify=cursor.getInt(cursor.getColumnIndex("classify"));
        String wrong=cursor.getString(cursor.getColumnIndex("wrong"));
        Subject subject =new Subject(uid,title,option1,option2,option3,option4,choose,result,analysis,collect,errors,classify,wrong);
        Log.i("test",subject+"");
        collectActivity = new CollectFragment(subject);
        fragments.add(collectActivity);
    }
    viewPager.setAdapter(new Myadapter(getSupportFragmentManager()));
}

class Myadapter extends FragmentStatePagerAdapter {

    @Override
    public int getItemPosition(Object object) {
        return super.getItemPosition(object);
    }

    public Myadapter(FragmentManager fm) {
        super(fm);
    }

    @Override
    public Fragment getItem(int position) {

        return fragments.get(position);
    }
    @Override
    public int getCount() {
        return fragments.size();
    }
}