Android从rawQuery获取数据到另一个表格

Question

我想从0123.表格中获得Id表格，但没有得到任何结果。这是我的代码：

public class EmployeeList extends ListActivity { 
    protected EditText searchText; 
    protected SQLiteDatabase db; 
    protected Cursor cursor; 
    protected ListAdapter adapter; 
/** Called when the activity is first created. */ 
    @Override 
    public void onCreate(Bundle savedInstanceState) { 
     super.onCreate(savedInstanceState); 
     setContentView(R.layout.main); 
     db = (new DatabaseHelper(this)).getWritableDatabase(); 
     searchText = (EditText) findViewById (R.id.searchText); 
    } 
    public void search(View view) { 
// || is the concatenation operation in SQLite 
     cursor = db.rawQuery("SELECT _id FROM employee WHERE firstName=?", 
      new String[]{searchText.getText().toString()}); 
     Intent intent = new Intent(this, EmployeeDetails.class); 
     long id = cursor.getLong(cursor.getColumnIndex("_id")); 
     intent.putExtra("EMPLOYEE_ID", id); 
     startActivity(intent); 
    } 
} 

Answer 1

对于从游标对象获取记录值，您需要遍历并从中检索数据...

if(c.getCount()>0){ if (c.moveToFirst()){ c.getLong(0); }} 

其中C是你的光标对象...另外检查游标是否不为空...

Answer 2

如果firstName是String，则使用firstName类似'XYZ'