Creating and connecting to an SQLite DB in Android

Question

I am trying to create an SQLite Db for my android application, I have tried a lot of online tutorials and none of them work for me! I have posted my code below:

public class DatabaseHandler extends SQLiteOpenHelper {

    // All Static variables
    // Database Version
    private static final int DATABASE_VERSION = 1;

    // Database Name
    private static final String DATABASE_NAME = "usersManager";

    // Contacts table name
    private static final String TABLE_CONTACTS = "users";

    // Contacts Table Columns names
    private static final String KEY_ID = "id";
    private static final String KEY_NAME = "name";

    public DatabaseHandler(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    // Creating Tables
    @Override
    public void onCreate(SQLiteDatabase db) {
        String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + "("
                + KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT," + ")";
        db.execSQL(CREATE_CONTACTS_TABLE);
    }

    // Upgrading database
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // Drop older table if existed
        db.execSQL("DROP TABLE IF EXISTS " + TABLE_CONTACTS);

        // Create tables again
        onCreate(db);
    }



import java.util.List;
import android.app.Activity;
import android.os.Bundle;
import android.util.Log;


public class MainActivity extends Activity {
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);

        DatabaseHandler db = new DatabaseHandler(this);

I cant see error in my code but when I check in the location were db should be created nothing is there.

Thank u everyone for ur help, it worked for me!

user1877082
– user1877082

2013-02-03 18:18:17 +00:00
Commented Feb 3, 2013 at 18:18 — user1877082
– user1877082, Commented Feb 3, 2013 at 18:18

s.d · Accepted Answer · 2013-02-03 17:55:35Z

4

Apart from avoiding long one lined concatenated strings:

@Override
public void onCreate(SQLiteDatabase db) {
    String CREATE_CONTACTS_TABLE = 
            "CREATE TABLE " + TABLE_CONTACTS + 
            "(" + 
                KEY_ID   + " INTEGER PRIMARY KEY," + 
                KEY_NAME + " TEXT" + //--last value has no comma--
            ")";

    db.execSQL(CREATE_CONTACTS_TABLE);
}

Call getWritableDataBase() to open database, it will be created if it is not already there.

answered Feb 3, 2013 at 17:55

s.d

29.4k3 gold badges82 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marcos Aguayo · Accepted Answer · 2013-02-03 23:10:02Z

3

Try this

public class DataBase extends SQLiteOpenHelper{


    static String createBDSQL = "CREATE TABLE Notas (id integer primary key autoincrement, title TEXT)";

    public DataBase(Context context, String name, CursorFactory factory, int version) {
        super(context, name, factory, version);
    }

    @Override
        public void onCreate(SQLiteDatabase db) {
            db.execSQL(createBDSQL);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
            db.execSQL("DROP TABLE IF EXISTS Notas");
            db.execSQL(createBDSQL);
    }
}

In MainActivity.java

DataBase notasdb = new DataBase(this, "DBSample.db", null, 1);
SQLiteDatabase db = notasdb.getWritableDatabase();

answered Feb 3, 2013 at 23:10

Marcos Aguayo

7,2509 gold badges33 silver badges62 bronze badges

1 Comment

Dragos Rachieru Over a year ago

i think it's better to keep final Strings in the database class

Dan · Accepted Answer · 2013-02-03 17:49:11Z

1

The SQLiteOpenHelper is lazy. It will not perform any action until necessary. Thus, your DB will only be created when you try to access data in it (or insert new data).

answered Feb 3, 2013 at 17:49

Dan

1,54712 silver badges23 bronze badges

Comments

StarsSky · Accepted Answer · 2013-02-03 17:50:37Z

0

You have to be carefull when creating a query for to execute.. in particular with spaces and commas.

change this line

String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + "(" + KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT," + ")";
        db.execSQL(CREATE_CONTACTS_TABLE);

whit:

String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + " (" + KEY_ID + " INTEGER PRIMARY KEY, " + KEY_NAME + " TEXT)";
        db.execSQL(CREATE_CONTACTS_TABLE);

answered Feb 3, 2013 at 17:50

StarsSky

6,7016 gold badges40 silver badges63 bronze badges

Comments

saravana · Accepted Answer · 2013-02-03 18:03:51Z

0

You really didn't created database, you only create instance of your SQLiteOpenHelper but for create or open database you have to use getWritableDatabase() or getReadableDatabase() method.

SQLiteDatabase db = new DataBaseHandler(this).getWritableDatabase();

answered Feb 3, 2013 at 18:03

saravana

5741 gold badge9 silver badges29 bronze badges

Comments

Eslam Youssef · Accepted Answer · 2014-02-09 16:42:35Z

0

in your main activity

SQLiteDatabase sql;
sql=db.getWritableDatabase(); (where db is DB Handler)

answered Feb 9, 2014 at 16:42

Eslam Youssef

1

Collectives™ on Stack Overflow

Creating and connecting to an SQLite DB in Android

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related