Android的：在Android数据库选择查询 [英] Android: select query in android database

问题描述

我需要得到相应的键列儿童列的值作为形象。什么是它的select语句中的android源码。

感谢

我使用以下code吧：

 公共光标fetchChildren（字符串键_）{
            光标C = db.rawQuery（选择儿童+ DATABASE_TABLE_NAVIGATION
                    +WHERE键=+ KEY_ +，NULL）;
                       返回℃;
 

但它给我的异常：

  android.database.sqlite.SQLiteException：没有这样的列：家：，在编译：选择儿童导航键WHERE家=           }
 

解决方案

我怀疑你只是错过报价

    

  SELECT儿童导航键WHERE ='家'
 

I need to get the values of children column corresponding to key column as in the image. What would be the select statement for it in android sqlite.

Thanks

I am using following code for it:

 public Cursor fetchChildren(String KEY_){
            Cursor c = db.rawQuery("SELECT children FROM " + DATABASE_TABLE_NAVIGATION
                    + " WHERE key =" + KEY_+ "", null);
                       return c;

But it is giving me exception:

android.database.sqlite.SQLiteException: no such column: home: , while compiling: SELECT children FROM navigation WHERE key =home

           }

解决方案

I suspect you just missed quotes

SELECT children FROM navigation WHERE key='home'

这篇关于Android的：在Android数据库选择查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！