我从几个小时以来搜索如何选择整数列(作为布尔值(,并且知道是插入的,还是插入了1个。
我尝试过这样的尝试:
public boolean getLucide(){
SQLiteDatabase db = this.getReadableDatabase();
String query = "SELECT luciditeCarnetreve FROM Carnetreve WHERE luciditeCarnetreve = ?";
db.rawQuery(query, null);
return true;
}
但是我的代码中的问题是方法返回始终是正确的,所以总是1。我该如何使用光标?
public boolean getLucide()
{
int integervalue = 0;
SQLiteDatabase db = this.getReadableDatabase();
Cursor c = db.rawQuery("select luciditeCarnetreve from Carnetreve where luciditeCarnetreve = '"+somevalue+"' ",null);
while(c.moveToNext())
{
integervalue = c.getInt(0);//put the number of coloumn nunbering start from 0
}
c.close();
return integervalue > 0 ? true : false ;
}