android - 如何使用 ID 从 sqlite 中获取值?
解决方案
您需要单独查询在单击的特定位置获取原始数据LisView
。
int id = 0; // id of clicked item
StringBuilder query = new StringBuilder("SELECT * FROM table_name WHERE id = ").append(id);
Cursor cursor = db.rawQuery(query.toString(), null);
if (cursor.moveToFirst()) {
Intent intent = new Intent(context, IntentClass.class);
intent.putExtra("id",id);
intent.putExtra("link",cursor.getString(4));
intent.putExtra("lid",cursor.getString(5));
intent.putExtra("lpass",cursor.getString(6));
intent.putExtra("laddInfo",cursor.getString(7));
context.startActivity(intent);
}
cursor.close();