android - 从 SQLite Android 获取单个记录

Question

我有一个EditText，我在上面写下了我想在单击按钮后出现在TextView中的记录

所以我需要从我的数据库和特定列中检索行记录我想要检索的是字符串类型**这是我的查询，但它对我不起作用**

 public String getCountryCode(String cc) {

 Cursor cursor = null;
 String Code = "";
 try{
     String selectQuery = "SELECT  * FROM " + SQLITE_TABLE + " WHERE "
            + KEY_CODE + " = " + cc;
     cursor = mDb.rawQuery(selectQuery, null);


     if(cursor.getCount() > 0) {

         cursor.moveToFirst();
         Code = cursor.getString(cursor.getColumnIndex("KEY_CODE"));
     }

     return Code;
 }finally {

     cursor.close();
 }
 }

主要 Activity

b.setOnClickListener(new OnClickListener() {

public void onClick(View arg0) {
// TODO Auto-generated method stub
    try{
String in   =codeinput.getText().toString();
String c    = dbHelper.getCountryCode(in);
CountryShow.setText(c);
}
catch(Exception e ){
    Toast.makeText(listViewDisplay.this, e.getMessage(),      Toast.LENGTH_LONG).show();
}


}
});

Answer 1

将查询字符串替换为该字符串

String selectQuery = "SELECT  * FROM " + SQLITE_TABLE + " WHERE "
        + KEY_CODE + " = '" + cc+"'";

当您要将通用值添加到查询字符串中时，您需要在其周围添加单个 qouts