B1E8LQA5

1SQLiteDatabase db = getWritableDatabase();
2	
3package com.example.hismartversearch;
4
5import android.content.Context;
6import android.database.Cursor;
7import android.database.SQLException;
8import android.database.sqlite.SQLiteDatabase;
9import android.database.sqlite.SQLiteOpenHelper;
10
11public class Db extends SQLiteOpenHelper {
12    public Db(Context context) {
13        super(context, "Db.sqlite", null, 1);
14    }
15
16    @Override
17    public void onCreate(SQLiteDatabase db) {
18    }
19
20    public Cursor getdata(String sql) {
21        // error at this line below
22        SQLiteDatabase db = getWritableDatabase();
23        Cursor c = db.rawQuery(sql, null);
24        return c;
25    }
26
27    public void querydata(String sql) {
28        SQLiteDatabase db = getWritableDatabase();
29        db.execSQL(sql);
30    }
31
32    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
33    }
34
35    public void delete_table(String table_name) {
36        SQLiteDatabase db = getWritableDatabase();
37        db.execSQL("delete from " + table_name);
38    }
39
40    public void delete_row(String tenbang, String tencot, String giatri) {
41        SQLiteDatabase db = getWritableDatabase();
42        db.delete(tenbang, tencot + "=" + giatri, null);
43       }
44    }
45	
46public class TabOneFragment extends Fragment implements SearchView.OnQueryTextListener {
47Db db = new Db(getActivity());
48    @Override
49    public void onCreate(Bundle savedInstanceState) {
50        super.onCreate(savedInstanceState);
51    }
52
53    @Override
54    public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
55        View view = inflater.inflate(R.layout.tab_one_fragment, container, false);
56        recyclerView = (RecyclerView) view.findViewById(R.id.recyclerview);
57 final RecyclerView.LayoutManager mLayoutManager = new GridLayoutManager(getActivity(), 2);
58        recyclerView.setLayoutManager(mLayoutManager);
59        recyclerView.addItemDecoration(new GridSpacingItemDecoration(2, dpToPx(5), true));
60        recyclerView.setItemAnimator(new DefaultItemAnimator());
61        recyclerView.setAdapter(adapter);
62   return view;
63    }
64
65    @Override
66    public boolean onQueryTextSubmit(String query) {
67        return false;
68    }
69
70    @Override
71    public boolean onQueryTextChange(String newText) {
72        return false;
73    }
74
75// error at line in logcat when I create table. 
76
77 public void LoadDtaWeb() {
78      db.querydata("Create table if not exists tbl_mon_app (_ID integer primary key, IDMon integer not null, IDCH integer not null, TenMon text not null, Gia text not null, ImgUrl text not null, ImgLocal text)");
79    }
80}
81//some text hidden to save space display
82	
83public class TabOneFragment extends Fragment implements SearchView.OnQueryTextListener {
84public Db db ;
85
86   @Override
87    public void onCreate(Bundle savedInstanceState) 
88    {
89        super.onCreate(savedInstanceState);
90    }
91
92    @Override
93    public View onCreateView(LayoutInflater inflater, ViewGroup container,
94                             Bundle savedInstanceState) {
95
96        View view = inflater.inflate(R.layout.tab_one_fragment, container, false);
97        db = new Db(getActivity());
98	
99@Override
100    public void onCreate(SQLiteDatabase db) {
101        db.execSQL(CREATE_TABLE_STATEMENT);
102    }
103	
104public static final String TABLE_NAME = "table_name";   
105
106 String CREATE_TABLE_SAMPLE = "create table " + TABLE_NAME + " (" + COLUMN_XXX_ID + " UNIQUE,"
107                + COLUMN_XXX_NAME + "," + COLUMN_XXXX +
108                "," + COLUMN_XXXXX + ");";
109
110
111        @Override
112        public void onCreate(SQLiteDatabase db) {
113            db.execSQL(CREATE_TABLE_SAMPLE);
114        }
115
116        @Override
117        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
118            db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
119            onCreate(db);
120        }