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