且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

rawQuery不是在SQLite的Andr​​oid平台

更新时间:2023-09-26 13:25:10

试试这个,

public String getCategory(int catId){
        Cursor mycursor = myDatabase.rawQuery("SELECT " + COLUMN_CATEGORIES  + " FROM "+ StringCategory_Table +" WHERE " + _ID + " = " + catId, null);
      if(mycursor.moveToFirst()){ //Edited based on suggestion from SAM
          String strCatName = mycursor.getString(mycursor.getColumnIndex(COLUMN_CATEGORIES));
                  return strCatName;
        } else {
        return null;
         }


        }