Closed 8 years ago.
- Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.
- We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.
I am developing an Android application where I want to make a database.
I have extended the SQLiteOpenHelper
class but it's not working for me. Can anybody tell me how to make database through it or any other syntax or code? Please provide me some good tutorial or example to study the database creation and implementation in the application.
Here is my logcat file from an attempt to follow a vogella.de
tutorial:
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): FATAL EXCEPTION: main
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): java.lang.RuntimeException: Unable to instantiate activity ComponentInfo{de.vogella.android.todos.database/de.vogella.android.todos.database.TodoDatabaseHelper}: java.lang.InstantiationException: de.vogella.android.todos.database.TodoDatabaseHelper
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1544)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1638)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at android.app.ActivityThread.access$1500(ActivityThread.java:117)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:928)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at android.os.Handler.dispatchMessage(Handler.java:99)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at android.os.Looper.loop(Loope开发者_StackOverflow社区r.java:123)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at android.app.ActivityThread.main(ActivityThread.java:3647)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at java.lang.reflect.Method.invokeNative(Native Method)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at java.lang.reflect.Method.invoke(Method.java:507)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at dalvik.system.NativeStart.main(Native Method)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): Caused by: java.lang.InstantiationException: de.vogella.android.todos.database.TodoDatabaseHelper
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at java.lang.Class.newInstanceImpl(Native Method)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at java.lang.Class.newInstance(Class.java:1409)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at android.app.Instrumentation.newActivity(Instrumentation.java:1021)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1536)
06-17 13:20:11.883: ERROR/AndroidRuntime(1474): ... 11 more
06-17 13:20:12.004: WARN/ActivityManager(68): Force finishing activity de.vogella.android.todos.database/.TodoDatabaseHelper
Here is a nice tutorial on Android + Database usage that interests you.
http://www.anotherandroidblog.com/2010/08/04/android-database-tutorial/
A very detailed explanation here:
http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/
Here is some tutorial for you.
http://www.vogella.de/articles/AndroidSQLite/article.html
http://sree.cc/google/android/creating-sqlite-database-tables-in-android
If you googling with "SQLite Tutorial for Android", there will be about 3,620,000 results in less than 1 second.
i Suggest the Android Notepad tutorial about making a content provider.
Sample
Tutorial
精彩评论