连接Android Studio中选项卡活动中的片段与SQLite数据库。

huangapple 未分类评论49阅读模式
英文:

connection with sqlite database from fragments in the tabbed activity of android studio

问题

我已成功将数据插入到SQLite数据库中。但无法在片段中显示,请帮忙……

这是我的片段代码。

public class abpos extends Fragment {

    DataBaseHelper myDb;

    @Override
    public View onCreateView(LayoutInflater inflater, ViewGroup container,
                             Bundle savedInstanceState) {

        View rootView = inflater.inflate(R.layout.abpos, container, false);

        return rootView;
    }
}

这是我的数据库连接器文件。

public class DataBaseHelper extends SQLiteOpenHelper {

    public static final String DATABASE_NAME = "bbloodd.db";
    public static final String TABLE_NAME = "bbloodstablee";

    public static final String COL_1 = "NAME";
    public static final String COL_2 = "GROOUP";
    public static final String COL_3 = "mob";

    public DataBaseHelper(Context context) {
        super(context, DATABASE_NAME, null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE "+TABLE_NAME+" (NAME TEXT, GROOUP TEXT, mob TEXT PRIMARY KEY)");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " +TABLE_NAME);
        onCreate(db);
    }

    public boolean insertData(String names, String groupss, String mobs) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(COL_1, names);
        contentValues.put(COL_2, groupss);
        contentValues.put(COL_3, mobs);
        long result = db.insert(TABLE_NAME, null, contentValues);
        return result != -1;
    }

    public Cursor getAllData() {
        SQLiteDatabase db = this.getWritableDatabase();
        Cursor res = db.rawQuery("SELECT * FROM "+TABLE_NAME, null);
        return res;
    }
}
英文:

I have successfully inserted data into sqlite database. But unable to display it in fragment, pls help....

This is my fragment code.

public class abpos extends Fragment{

    DataBaseHelper myDb;

    @Override
    public View onCreateView(LayoutInflater inflater, ViewGroup container,
                             Bundle savedInstanceState) {

        View rootView = inflater.inflate(R.layout.abpos, container, false);

        return rootView;
    }
}

This is my database connector file.

public class DataBaseHelper extends SQLiteOpenHelper {

    public static final String DATABASE_NAME = "bbloodd.db";
    public static final String TABLE_NAME = "bbloodstablee";


     public static final String COL_1 = "NAME";
    public static final String COL_2 = "GROOUP";
    public static final String COL_3 = "mob";


    public DataBaseHelper(Context context) {
        super(context, DATABASE_NAME, null, 1);

    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE "+TABLE_NAME+" (NAME TEXT,GROOUP TEXT,mob TEXT PRIMARY KEY)");

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " +TABLE_NAME);


        onCreate(db);


    }

    public boolean insertData(String names,String groupss,String mobs) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(COL_1,names);
        contentValues.put(COL_2,groupss);
        contentValues.put(COL_3,mobs);

        long result = db.insert(TABLE_NAME,null ,contentValues);
        return result != -1;
    }




    public Cursor getAllData() {
        SQLiteDatabase db = this.getWritableDatabase();
        Cursor res = db.rawQuery("select * from "+TABLE_NAME,null);
        return res;
    }
}

huangapple
  • 本文由 发表于 2020年4月4日 15:35:43
  • 转载请务必保留本文链接:https://java.coder-hub.com/61025080.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定