How to access one class database in another class?

Question

I created a database in my class like

public final String CRAZY_ALARM_DB_NAME = "CrazyDb";
public final String CRAZY_ALARM_TABLE_NAME = "CrazyTable";

alarmDB = this.openOrCreateDatabase(
    CRAZY_ALARM_DB_NAME, MODE_PRIVATE, null
);
alarmDB.execSQL("CREATE TABLE IF NOT EXISTS "
    + CRAZY_ALARM_TABLE_NAME
    +" (REQ_CODE INT(3),DAY INT(3),HOUR INT(3)"
    +",MINUTE INT(3),COUNT INT(3),REPEAT INT(3)"
    +",DAYS VARCHAR2(100),SUN INT(3),MON INT(3),"
    +"TUE INT(3),WED INT(3),THU INT(3),FRI INT(3),"
    +"SAT INT(3));"
);
cr = alarmDB.rawQuery("SELECT * FROM "
    +CRAZY_ALARM_TABLE_NAME, null
);

so i want to use this database in another class. I am also do the same thing ,i wrote "openorcreate "code in another class and also cursor.. but it gave an exception like no such table while compiling ... at cursor line..

please help me.

can you post the whole code of both class?

user370305
– user370305

2011-09-02 10:24:47 +00:00
Commented Sep 2, 2011 at 10:24 — user370305
– user370305, Commented Sep 2, 2011 at 10:24

Lukas Knuth · Accepted Answer · 2011-09-02 10:25:33Z

3

You should use an SQLiteOpenHelper-class to access and maintain your Database.

If you do so, you can (in whatever class you like) use the following lines to get a read or writable database:

YourSQliteOpenHelper db_con = new YourSQliteOpenHelper(getApplicationContext());
// Readable:
SQLiteDatabase db = db_con.getReadableDatabase();
// Writeable:
SQLiteDatabase db = db_con.getWritableDatabase();

A tutorial on how to use the SQLiteOpenHelper can be found here.

answered Sep 2, 2011 at 10:25

Lukas Knuth

25.8k16 gold badges88 silver badges114 bronze badges

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

Comments

Dimitris Makris · Accepted Answer · 2011-09-02 10:18:30Z

1

The best you could do is to have a database helper where you could have all these calls and which could be available and accessible by all your activities.

Moreover, you should remove and install again your app in order to be able to create the table. I have this problem sometimes.

answered Sep 2, 2011 at 10:18

Dimitris Makris

5,1832 gold badges36 silver badges54 bronze badges

Collectives™ on Stack Overflow

How to access one class database in another class?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related