android sqlite 查询数据库的总条数,androidsqlite
/**
* 查询数据库中的总条数.
* @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 > </span>/**
<span > </span> * 查询数据库中的没有解决的条数.
<span > </span> * @return
<span > </span> */
<span > </span>public long queryUndisposeCase( ){
<span > </span>String sql = "select count(*) from info where handleStatus not in (?)";
<span > </span>Cursor cursor = db.rawQuery(sql, new String []{"1"});
<span > </span>cursor.moveToFirst();
<span > </span>//获得某一列的长度
<span > </span>long count = cursor.getLong(0);
<span > </span>cursor.close();
<span > </span>return count;
<span > </span>}
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。