sqlife查询报错及关键字加粗方式

最新推荐文章于 2022-04-07 19:01:13 发布

原创最新推荐文章于 2022-04-07 19:01:13 发布 · 221 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

android 专栏收录该内容

96 篇文章

订阅专栏

本文介绍了一个SQLite查询示例，展示了如何通过SQL语句搜索知识点，并实现了搜索关键字在返回结果中加粗显示的功能。

sqlife查询报错及关键字加粗的实现示例简单记录如下:

/**
	 * 搜索知识点
	 * @param query
	 * @return
	 */
	public List<KnowledgePoint> searchKnowledgePoints(String query , String subjectId) {
		
		if(query == null){
			return null;
		}
		
		KnowledgePoint kp = null;
		List<KnowledgePoint> kpList = new ArrayList<KnowledgePoint>();
		
		/**
		 * 防止用户输入'号引起崩溃
		 */
		query = query.replace("'", "''");
		
        String sql = "select * from " + TABLE_NAME_KNOWLEDGE_POINT + " where subject_id=? and point_name like ?";
		SQLiteDatabase db = this.getReadableDatabase();
		String[] argv = new String[] {subjectId , "%" + query + "%"};
        Cursor cursor = db.rawQuery(sql, argv);
        while (cursor.moveToNext()) {
        	
        	kp = new KnowledgePoint();
        	
        	kp.setSubjectId(cursor.getString(0));
        	kp.setKid(cursor.getString(2));
        	kp.setParentId(cursor.getString(3));
        	/**
        	 * 搜索关键字变粗
        	 */
        	kp.setName(cursor.getString(4).replace(query , "<strong>"+query+"</strong>"));
        	kp.setIcon(cursor.getInt(5));
        	
        	kpList.add(kp);
        }
        
        cursor.close();
        this.closeDB();
        return kpList;
	}