How to create database application for Android? [closed]

Question

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

Answer 1

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/