jsp搜索框模糊查询

<form action="searchServlet" method="get">
    <input type="text" name="keyword" placeholder="请输入搜索关键字">
    <button type="submit">搜索</button>
</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");
        if (keyword != null && !keyword.isEmpty()) {
            try {
                Class.forName("com.mysql.jdbc.Driver");
                Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
                String sql = "SELECT * FROM mytable WHERE column LIKE ?";
                PreparedStatement pstmt = conn.prepareStatement(sql);
                pstmt.setString(1, "%" + keyword + "%");
                ResultSet rs = pstmt.executeQuery();
                
                request.setAttribute("results", rs);
                RequestDispatcher dispatcher = request.getRequestDispatcher("results.jsp");
                dispatcher.forward(request, response);
            } catch (Exception e) {
                e.printStackTrace();
            }
        } else {
            response.sendRedirect("search.jsp");
        }
    }
}

<%@ page import="java.sql.*" %>
<table>
    <tr>
        <th>ID</th>
        <th>Name</th>
    </tr>
    <% ResultSet rs = (ResultSet) request.getAttribute("results");
       while (rs.next()) { %>
    <tr>
        <td><%= rs.getInt("id") %></td>
        <td><%= rs.getString("name") %></td>
    </tr>
    <% } %>
</table>