代码总结：文本栏关键字搜索功能实现

最新推荐文章于 2022-09-23 10:13:48 发布

yicha_icode

最新推荐文章于 2022-09-23 10:13:48 发布

阅读量3k

点赞数

分类专栏： jsp 文章标签：关键字关键字搜索 jsp

本文链接：https://blog.csdn.net/yicha_i/article/details/82627466

版权

jsp 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

需求：根据关键字搜索功能（%通配符）

<div id="rightquestion">
    <input type="text" placeholder="请输入查询关键字"/>
    <a href="#"><img src="img/ic_search.svg"/></a>
</div>
<script>
    $("#rightquestion").mouseover(function(){
    var keyWord = $("#rightquestion input").val();
    $("#rightquestion a").attr("href","search.jsp?keyWord="+keyWord);//传递关键字
});
</script>

<%
//jsp脚本
String keyWord = request.getParameter("keyWord");
if(keyWord == ""){
    request.setAttribute("schList",null);
}else{
    QuestionService qService = QuestionService.getService();
    List<QuestionShow> schList = qService.searchQuestion(keyWord);
    request.setAttribute("schList",schList);
    request.setAttribute("keyWord",keyWord);
}
%>

//数据库操作
public List<QuestionShow> searchQuestion(String keyWord){
        List<QuestionShow> qList = new ArrayList<QuestionShow>();
        Connection conn = DBHelper.linkToDB();
        PreparedStatement pcmd = null;
        ResultSet rs = null;
        String sql = "SELECT a.qid,a.title,a.tags,a.content,b.nickName,b.photo,a.pubtime,a.votes,a.answers,a.visitors,a.type ";
        sql += "FROM question AS a ";
        sql += "LEFT JOIN USER AS b ";
        sql += "ON a.publisher=b.id ";
        sql += "WHERE title LIKE ? ";
        sql += "OR tags LIKE ? ";
        sql += "OR content LIKE ? ";
        try {
            pcmd = conn.prepareStatement(sql);
            pcmd.setString(1, "%"+keyWord+"%");
            pcmd.setString(2, "%"+keyWord+"%");
            pcmd.setString(3, "%"+keyWord+"%");
            rs = pcmd.executeQuery();
            while(rs.next()){
                int qid = rs.getInt(1);
                String title = rs.getString(2);
                String rsTags = rs.getString(3);
                String[] tags = rsTags.split(",");
                String content = rs.getString(4);
                String publisher = rs.getString(5);
                String photo = rs.getString(6);
                String pubtime = rs.getString(7).substring(0, 16);
                int votes = rs.getInt(8);
                int answers = rs.getInt(9);
                int visitors = rs.getInt(10);
                String type = rs.getString(11);
                qList.add(new QuestionShow(qid,title,tags,content,publisher,photo,pubtime,votes,answers,visitors,type));    
            }

        } catch (SQLException e) {
            e.printStackTrace();
        } finally{
            DBHelper.close(conn, pcmd, rs);
        }
        return qList;
    }