android - 我无法从 sqlite 获取特定数据？请帮我

Question

![这是我在 DBHelper 中查找方法的代码].class[1]

public StringBuilder findData(String find)
{    
    StringBuilder output = new StringBuilder("Our data is:\n");
    Cursor c = ourHelper.getReadableDatabase().rawQuery("SELECT abbrevaition FROM        abbrtab WHERE acronym"+" =  ?  ;", new String[]{find});
    String remarks=" ";
    int iRemarks = c.getColumnIndex(KEY_ABBR);
    if( c.moveToFirst() && c.getCount()>0 )
    {
        remarks= c.getString(iRemarks);
    if(remarks.isEmpty())
        {
            Toast.makeText(ourContext, "not", Toast.LENGTH_LONG).show();
        }
    output.append(remarks); 
    }
    c.close();
    return output;
}

![这是 Main.java 中用于从 SQLite3 获取数据的代码。当我给出查询 select * from abbrtab 然后它执行。并应用 where 条件然后我什么也得不到。 ][1]

@Override
public void onClick(View v) 
{
    Toast.makeText(getApplicationContext(), String.valueOf("Hi"),Toast.LENGTH_LONG).show();
    // TODO Auto-generated method stub
    ASNDBAdapter info = new ASNDBAdapter(AllBranches.this);
    info.open();
    String data = et.getText().toString();
    String result = info.findData(data).toString();
    Intent i = new Intent(AllBranches.this, ViewData.class);
    i.putExtra("my_data", result);
    startActivity(i);
    Toast.makeText(getApplicationContext(), String.valueOf(result),
                            Toast.LENGTH_LONG).show();
    info.close();

}

Answer 1

public StringBuilder findData(String find)
    {    
        StringBuilder output = new StringBuilder("Our data is:\n");
        Cursor c = ourHelper.getReadableDatabase().query("abbrtab", new String[] {"abbrevaition"},"acronym" +"="+find, null, null, null, null);
        String remarks=" ";
        int iRemarks = c.getColumnIndex(KEY_ABBR);
        if( c.moveToFirst() && c.getCount()>0 )
        {
            remarks= c.getString(iRemarks);
        if(remarks.isEmpty())
            {
                Toast.makeText(ourContext, "not", Toast.LENGTH_LONG).show();
            }
        output.append(remarks); 
        }
        c.close();
        return output;
    }

这里“abbrtab”是表名，“abbrevaition”是字段名。