如何为Android创建数据库应用程序？

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.

我正在开发一个Android应用程序,我想创建一个数据库。我已经扩展了SQLiteOpenHelper类,但它不适用于我。任何人都可以告诉我如何通过它或任何其他语法或代码创建数据库?请提供一些很好的教程或示例来研究应用程序中的数据库创建和实现。

Here is my logcat file from an attempt to follow a vogella.de tutorial:

这是我尝试遵循vogella.de教程的logcat文件:

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(Looper.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

3 个解决方案

#1

Here is a nice tutorial on Android + Database usage that interests you.

这是一个关于Android +数据库使用的很好的教程,你感兴趣。

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/

#2

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.

如果您使用“SQLite Tutorial for Android”进行Google搜索,那么在不到1秒的时间内将会有大约3,620,000个结果。

#3

i Suggest the Android Notepad tutorial about making a content provider.

i建议有关制作内容提供商的Android Notepad教程。

Sample

Tutorial

#1