dimanche 12 juillet 2015

Reading existing Sqlite database

I hava a ListView that fill from existing database,when user clicked on each items,one of other columns,should be displayed on second Activity (Like dictionary App)
But i can't execute any quaries on Second Activity
I'm using SqliteAssetHelper library

database Class:

public class MyDatabase extends SQLiteAssetHelper {

private static final String DATABASE_NAME    = "database.db";
private static final int    DATABASE_VERSION = 1;


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

}

On the first Activity,listView filled from database:

 private void fillFromDb() {
    G.itemLists.clear();
    Cursor cursor = mydb.rawQuery("select * from test order by title limit 0,50 ", null);
    while (cursor.moveToNext()) {
        StructNote test1 = new StructNote();
        test1.title = cursor.getString(cursor.getColumnIndex("title"));
        G.itemLists.add(test1);
    }
    cursor.close();
    mydb.close();
    adapter.notifyDataSetChanged();
    }

but the problam is on Second Activity:
i can't execute any quaries!

public class ActivityResult extends Activity {

private MyDatabase    MyDataBase;
public SQLiteDatabase mydb;


@Override
protected void onResume() {
    G.currentActivity = this;
    super.onResume();
}


@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.result);

    Cursor cursor = mydb.rawQuery("SELECT * FROM test ", null);
    while (cursor.moveToNext()) {
        try {
            Log.i("LOG", cursor.getString(cursor.getColumnIndex("title")));
        }
        catch (Exception e) {}
    }
    cursor.close();
    mydb.close();

}

 }

Many thanks...

Aucun commentaire:

Enregistrer un commentaire