如何从数据库SQLite中检索多个数据(行)

Question

这就是我现在所做的。

我的桌子是这样的：

JAPANESEALPHA            ENGLISH          JAPANESECHAR
kiro                     kilo            \u30ad\u30ed
guramu                   gram            \u30b0\u30e9\u30e0
migi                     right           \u307f\u304e
mijikai                  short           \u307f\u3058\u304b\u3044

内部数据库(示例)：

mDbHelper.createCrv("kiro","kilo","\u30ad\u30ed");
mDbHelper.createCrv("guramu","gram","\u30b0\u30e9\u30e0");
mDbHelper.createCrv("mijikai","short","\u307f\u3058\u304b\u3044");
mDbHelper.createCrv("minami","south","\u307f\u306a\u307f");
mDbHelper.createCrv("miru","watch","\u307f\u308b");

查询：

 String query = "SELECT docid as _id," + 
    KEY_ENGLISH + "," +
    KEY_JAPANESEALPHA + "," +
    KEY_JAPANESECHAR+ 
    " from " + FTS_VIRTUAL_TABLE +
    " where " +  KEY_JAPANESEALPHA + " = '" + inputText + "';";

我还有光标：

 private void showResults(String query) {

        Cursor cursor = mDbHelper.searchCrvJapanesechar((query != null ? query.toString() : "@@@@"));
        if (cursor == null) {
            Toast.makeText(getApplicationContext(), 
                    "No Search Found!", Toast.LENGTH_LONG).show();

        } else {

            // Specify the columns we want to display in the result 
            String[] from = new String[] {
                    DBAdapter.KEY_JAPANESECHAR,
                   DBAdapter.KEY_JAPANESEALPHA,
                   DBAdapter.KEY_ENGLISH
                   };
                    //DBAdapter.KEY_TAGALOG};


            // Specify the Corresponding layout elements where we want the columns to go
            int[] to = new int[] {     R.id.sjapanesechar,
                   R.id.sjapanesealpha,
                    R.id.senglish};
                   // R.id.stagalog};

对于复合词，我需要最小化我的数据库，以便当

Input: kiroguramu

我可以把克如的英语术语和古鲁的英语术语连起来。这将导致

Result: kilogram

对不起，我不能粘贴我的样本图像，因为我是新手。我在http://www.mysamplecode.com/2011/11/android-searchview-using-sqlite-fts3.html获得了检索数据，这是一个很大的帮助。谢谢你。

Answer 1

嗨，我想您应该在这里阅读一些JSON解析的基本知识，http://www.androidhive.info/2012/01/android-json-parsing-tutorial/