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

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

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

问题

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

这是我的片段代码。

  1. public class abpos extends Fragment {
  3.     DataBaseHelper myDb;
  5.     @Override
  6.     public View onCreateView(LayoutInflater inflater, ViewGroup container,
  7.                              Bundle savedInstanceState) {
  9.         View rootView = inflater.inflate(R.layout.abpos, container, false);
  11.         return rootView;
  12.     }
  13. }

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

  1. public class DataBaseHelper extends SQLiteOpenHelper {
  3.     public static final String DATABASE_NAME = "bbloodd.db";
  4.     public static final String TABLE_NAME = "bbloodstablee";
  6.     public static final String COL_1 = "NAME";
  7.     public static final String COL_2 = "GROOUP";
  8.     public static final String COL_3 = "mob";
  10.     public DataBaseHelper(Context context) {
  11.         super(context, DATABASE_NAME, null, 1);
  12.     }
  14.     @Override
  15.     public void onCreate(SQLiteDatabase db) {
  16.         db.execSQL("CREATE TABLE "+TABLE_NAME+" (NAME TEXT, GROOUP TEXT, mob TEXT PRIMARY KEY)");
  17.     }
  19.     @Override
  20.     public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  21.         db.execSQL("DROP TABLE IF EXISTS " +TABLE_NAME);
  22.         onCreate(db);
  23.     }
  25.     public boolean insertData(String names, String groupss, String mobs) {
  26.         SQLiteDatabase db = this.getWritableDatabase();
  27.         ContentValues contentValues = new ContentValues();
  28.         contentValues.put(COL_1, names);
  29.         contentValues.put(COL_2, groupss);
  30.         contentValues.put(COL_3, mobs);
  31.         long result = db.insert(TABLE_NAME, null, contentValues);
  32.         return result != -1;
  33.     }
  35.     public Cursor getAllData() {
  36.         SQLiteDatabase db = this.getWritableDatabase();
  37.         Cursor res = db.rawQuery("SELECT * FROM "+TABLE_NAME, null);
  38.         return res;
  39.     }
  40. }
英文:

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

This is my fragment code.

  1. public class abpos extends Fragment{
  3.     DataBaseHelper myDb;
  5.     @Override
  6.     public View onCreateView(LayoutInflater inflater, ViewGroup container,
  7.                              Bundle savedInstanceState) {
  9.         View rootView = inflater.inflate(R.layout.abpos, container, false);
  11.         return rootView;
  12.     }
  13. }

This is my database connector file.

  1. public class DataBaseHelper extends SQLiteOpenHelper {
  3.     public static final String DATABASE_NAME = "bbloodd.db";
  4.     public static final String TABLE_NAME = "bbloodstablee";
  7.      public static final String COL_1 = "NAME";
  8.     public static final String COL_2 = "GROOUP";
  9.     public static final String COL_3 = "mob";
  12.     public DataBaseHelper(Context context) {
  13.         super(context, DATABASE_NAME, null, 1);
  15.     }
  17.     @Override
  18.     public void onCreate(SQLiteDatabase db) {
  19.         db.execSQL("CREATE TABLE "+TABLE_NAME+" (NAME TEXT,GROOUP TEXT,mob TEXT PRIMARY KEY)");
  21.     }
  23.     @Override
  24.     public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  25.         db.execSQL("DROP TABLE IF EXISTS " +TABLE_NAME);
  28.         onCreate(db);
  31.     }
  33.     public boolean insertData(String names,String groupss,String mobs) {
  34.         SQLiteDatabase db = this.getWritableDatabase();
  35.         ContentValues contentValues = new ContentValues();
  36.         contentValues.put(COL_1,names);
  37.         contentValues.put(COL_2,groupss);
  38.         contentValues.put(COL_3,mobs);
  40.         long result = db.insert(TABLE_NAME,null ,contentValues);
  41.         return result != -1;
  42.     }
  47.     public Cursor getAllData() {
  48.         SQLiteDatabase db = this.getWritableDatabase();
  49.         Cursor res = db.rawQuery("select * from "+TABLE_NAME,null);
  50.         return res;
  51.     }
  52. }

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:

确定