jsp模糊查询不全面

<%@ page import="java.sql.*" %>
<%
    String searchName = request.getParameter("searchName");
    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
        String sql = "SELECT * FROM users WHERE username LIKE ?";
        pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, "%" + searchName + "%");
        rs = pstmt.executeQuery();
%>
<table border="1">
    <tr>
        <th>ID</th>
        <th>Username</th>
    </tr>
<%
        while (rs.next()) {
%>
    <tr>
        <td><%= rs.getInt("id") %></td>
        <td><%= rs.getString("username") %></td>
    </tr>
<%
        }
%>
</table>
<%
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        try { rs.close(); } catch (Exception e) {}
        try { pstmt.close(); } catch (Exception e) {}
        try { conn.close(); } catch (Exception e) {}
    }
%>