/**
* 查询数据库中的总条数.
* @return
*/
public long allCaseNum( ){
String sql = "select count(*) from info";
Cursor cursor = db.rawQuery(sql, null);
cursor.moveToFirst();
long count = cursor.getLong(0);
cursor.close();
return count;
}
<span style="white-space:pre"> </span>/**
<span style="white-space:pre"> </span> * 查询数据库中的没有解决的条数.
<span style="white-space:pre"> </span> * @return
<span style="white-space:pre"> </span> */
<span style="white-space:pre"> </span>public long queryUndisposeCase( ){
<span style="white-space:pre"> </span>String sql = "select count(*) from info where handleStatus not in (?)";
<span style="white-space:pre"> </span>Cursor cursor = db.rawQuery(sql, new String []{"1"});
<span style="white-space:pre"> </span>cursor.moveToFirst();
<span style="white-space:pre"> </span>//获得某一列的长度
<span style="white-space:pre"> </span>long count = cursor.getLong(0);
<span style="white-space:pre"> </span>cursor.close();
<span style="white-space:pre"> </span>return count;
<span style="white-space:pre"> </span>}