SQLite 查询未返回真值 [英] SQLite query is not returning true value

问题描述

我输入了以下代码，用于将记录与数据库记录进行比较.它正在执行，但它显示每个输入记录都已存在(可能是旧记录或新记录.)

I entered the following code for comparing the records with the database records. It is executing but it shows already exists for every entering record (it may be an old or new record.)

boolean ifExisting() {
      //Cursor c = db.rawQuery("SELECT * FROM  sharelist  WHERE  category='"+str1+"'",null);

Cursor c = db.rawQuery("SELECT * FROM  sharelist  WHERE"  + "category" + "=" + category,null);


        Integer a=new Integer(c.getCount());

      Log.e("getcount",a.toString());
         if(c.getCount()>-1)
        { return false;} 
    else{
         return true;
    }

请帮帮我.

推荐答案

在 WHERE: 后面放一个空格

put a space after WHERE:

 "SELECT * FROM  sharelist  WHERE "  + "category" + "=" + category,null

应该可以.

这篇关于SQLite 查询未返回真值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！