How to get data from database in Android ? by Cursor c= db.query?
THis is myDB Class //Please take a look at public Cursor getplaces() --- Am i right or wrong? and How to code in main Activity class if i want to setListAdapter. Thank you for your help.
public class MyDB { protected static final String TAG = "TAG"; private final Context mContext; private SQLiteDatabase mDb; private MyDBhelper mDbHelper; public MyDB(Context context){ this.mContext = context; mDbHelper = new MyDBhelper(mContext); } public MyDB createDatabase() throws SQLException { try { mDbHelper.createDataBase(); } catch (IOException mIOException) { Log.e(TAG, mIOException.toString() + " UnableToCreateDatabase"); throw new Error("UnableToCreateDatabase"); } return this; } public MyDB open() throws SQLException { try { mDbHelper.openDataBase(); mDbHelper.close(); mDb = mDbHelper.getReadableDatabase(); } catch (SQLException mSQLException) { Log.e(TAG, mSQLException.toString()); throw mSQLException; } return this; } public Cursor getplaces() { Cursor c = mDb.query(Constants.DATABASE_NAME, null, null, null, null, null, null); return c; } public void close() { mDbHelper.close(); } }
ListplaceActivity Class
public ListplaceActivity extends ListActivity { private static MyDB mDbHelper; String[] from = new String[] { Constants.TITLE_NAME }; int[] to = new int[] {R.id.place_title}; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); mDbHelper = new MyDB(this); Cursor c = mDbHelper.getplaces(); setListAdapter(new SimpleCursorAdapter(this, R.layout.list_place, c, from, to)); final ListView lv = getListView(); lv.setOnItemClickListener(new OnItemClickListener() { public void onItemClick(AdapterView parent, View view,int position, long id) { Intent newActivity = new Intent(view.getContext(), Place.class); startActivity(newActivity); } }); } }
in LogCat show like this after i click to go to ListplacesActivity page it occur "Stopped Unexpectedly" and didn't show any list :
05-30 21:49:21.543: INFO/Process(17605): Sending signal. PID: 17605 SIG: 9 05-30 21:49:21.583: INFO/ActivityManager(59): Process com.ctg (pid 17605) has died. 05-30 21:49:21.593: INFO/WindowManager(59): WIN DEATH: Window{44de90a0 com.ctg/com.ctg.CTG paused=false} 05-30 21:49:21.674: INFO/ActivityManager(59): Start proc com.ctg for activity com.ctg/.CTG: pid=27207 uid=10028 gids={} 05-30 21:49:21.733: ERROR/gralloc(59): [unregister] handle 0x5fe9d8 still locked (state=40000001) 05-30 21:49:22.103: DEBUG/ddm-heap(27207): Got feature list request 05-30 21:49:22.265: INFO/UsageStats(59): Unexpected resume of com.ctg while already resumed in com.ctg 05-30 21:49:23.084: DEBUG/dalvikvm(27207): GC freed 801 objects / 58520 bytes in 216ms 05-30 21:49:23.433: DEBUG/dalvikvm(27207): GC freed 93 objects / 3632 bytes in 129ms 05-30 21:49:23.623: WARN/PhoneWindow(27207): Previously focused view reported id 16908298 during save, but can't be found during restore. 05-30 21:49:23.843: WARN/InputManagerService(59): Got RemoteException sending setActive(false) notification to pid 17605 uid 10028 05-30 21:49:24.103: INFO/ActivityManager(59): Displayed activity com.ctg/.CTG: 2489 ms (total 33589 ms) 05-30 21:49:29.013: INFO/ActivityManager(59): Starting activity: Intent { cmp=com.ctg/.AttractionsListActivity } 05-30 21:49:29.085: DEBUG/AndroidRuntime(27207): Shutting down VM 05-30 21:49:29.085: WARN/dalvikvm(27207): threadid=3: thread exiting with uncaught exception (group=0x4001b188) 05-30 21:49:29.094: ERROR/AndroidRuntime(27207): Uncaught handler: thread main exiting due to uncaught exception 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.ctg/com.ctg.AttractionsListActivity}: java.lang.NullPointerException 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2496) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2512) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at android.app.ActivityThread.access$2200(ActivityThread.java:119) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1863) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at android.os.Handler.dispatchMessage(Handler.java:99) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at android.os.Looper.loop(Looper.java:123) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at android.app.ActivityThread.main(ActivityThread.java:4363) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at java.lang.reflect.Method.invokeNative(Native Method) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at java.lang.reflect.Method.invoke(Method.java:521) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(Zygo开发者_如何学编程teInit.java:860) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at dalvik.system.NativeStart.main(Native Method) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): Caused by: java.lang.NullPointerException 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at com.ctg.data.MyDB.getplaces(MyDB.java:82) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at com.ctg.AttractionsListActivity.onCreate(AttractionsListActivity.java:32) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2459) 05-30 21:49:29.114: ERROR/AndroidRuntime(27207): ... 11 more 05-30 21:49:29.144: INFO/Process(59): Sending signal. PID: 27207 SIG: 3 05-30 21:49:29.144: INFO/dalvikvm(27207): threadid=7: reacting to signal 3 05-30 21:49:29.174: INFO/dalvikvm(27207): Wrote stack trace to '/data/anr/traces.txt' 05-30 21:49:39.039: WARN/ActivityManager(59): Launch timeout has expired, giving up wake lock! 05-30 21:49:39.057: WARN/ActivityManager(59): Activity idle timeout for HistoryRecord{44eae320 com.ctg/.AttractionsListActivity}
You didn't call MDbHelper.open()
, so the variable mDb
inside getPlaces()
is null.
精彩评论