Need simple SQLite database example

Question

Possible Duplicate:
sqlite example program in android

I need to open a database where I know the path/name, I need to read a known value, and write a value. I don't want to write 100 line "helper classes," I simply want to use the classes/functions that already exist. Can anybody provide a a simple example for this? It really shouldn't be more than a few lines of code.

1: Open database:

maybe this? openDatabase(String path, SQLiteDatabase.CursorFactory factory, int flags)

2: Execute SQL to display value (in a Toast perhaps)

3: Close database

Once I understand this basic functionality I will then worry about helper classes etc. Thanks in advance.

EDIT:

Fascinating that every single answer so far links to articles that do EXACTLY what I asked not to do. I just want a simple 3 line example of how to directly open a database and read from it.

you can learn android sqlite database tutorial from here. http://techlovejump.com/android-sqlite-database-tutorial/ — rajat ghai, Oct 26 '14 at 07:15

score 9 · Accepted Answer · answered Sep 30 '11 at 14:15

9

A very good SQLite tutorial.

answered Sep 30 '11 at 14:15

Vineet Shukla

23,865
10
55
63

+1 - Just about to link to this one myself. :) – Ricky Sep 30 '11 at 14:15

score 3 · Answer 2 · answered Sep 30 '11 at 14:49

3

Run through the notepad tutorial

answered Sep 30 '11 at 14:49

f20k

3,106
3
23
32

your link is dead now – Ranjithkumar Mar 05 '16 at 04:20

Need simple SQLite database example

2 Answers2

Linked