jsp搜索功能

<form action="SearchServlet" method="get">
    <input type="text" name="keyword" placeholder="请输入搜索关键词">
    <input type="submit" value="搜索">
</form>

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class SearchServlet extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        String keyword = request.getParameter("keyword");
        // 连接数据库并执行查询
        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM articles WHERE title LIKE '%" + keyword + "%'");
            request.setAttribute("results", rs);
            RequestDispatcher dispatcher = request.getRequestDispatcher("results.jsp");
            dispatcher.forward(request, response);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

<%@ page import="java.sql.*" %>
<html>
<body>
    <h2>搜索结果：</h2>
    <% ResultSet rs = (ResultSet) request.getAttribute("results");
       while (rs.next()) { %>
          <div><%= rs.getString("title") %></div>
    <% } %>
</body>
</html>