android实现关键字搜索功能
//以关键字查找日记为例,主要是Sql语句
public ArrayList
if (keywords != null) {
ArrayList
//查询日记标题或内容含有关键字的记录
Cursor cusror = mDb.query(true, DATABASE_TABLE, new String[] { ROWID,
TITLE, BODY, CREATED, MOOD, WEATHER, COLOR, BACKGROUND, SIZE },
"TITLE like '%" + keywords + "%'"+" or BODY like '%" + keywords +"%'" , null, null, null, null, null);
while (cusror.moveToNext()) {
DiaryBean bean = new DiaryBean();
bean.setTitle(cusror.getString(cusror.getColumnIndex(TITLE)));
bean.setBody(cusror.getString(cusror.getColumnIndex(BODY)));
bean.setColor(cusror.getInt(cusror.getColumnIndex(COLOR)));
bean.setMood(cusror.getInt(cusror.getColumnIndex(MOOD)));
bean.setId(cusror.getInt(cusror.getColumnIndex(ROWID)));
bean.setTime(cusror.getString(cusror.getColumnIndex(CREATED)));
bean.setWeather(cusror.getInt(cusror.getColumnIndex(WEATHER)));
bean.setSize(cusror.getInt(cusror.getColumnIndex(SIZE)));
bean.setBackground(cusror.getInt(cusror
.getColumnIndex(BACKGROUND)));
dList.add(bean);
}
cusror.close();
return dList;
} else {
return null;
}
更多相关文章
- python list.sort()根据多个关键字排序的方法实现
- 淘宝(阿里百川)手机客户端开发日记第一篇 android 主框架搭建(三
- Android学习日记(一)
- 我的android 第14天 - 使用SQLiteDatabase操作SQLite数据库
- Android(安卓)编码规范
- Android学习日记
- android学习日记之broadcast
- 学习日记-- Android写文件到SDCard的代码
- Android(安卓)搜索到的关键字改变颜色