find.jsp

来自「用jsp语言自己做的一个网站bookshot的全套程序以及一些样例。完全属于原创」· JSP 代码 · 共 19 行

<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %>

<%-- 
  Execute query, with wildcard characters added to the
  parameter values used in the search criteria
--%>
<sql:query var="empList" scope="request">
  SELECT * FROM Employee 
    WHERE FirstName LIKE ?
      AND LastName LIKE ?
      AND Dept LIKE ?
    ORDER BY LastName
  <sql:param value="%${param.firstName}%" />
  <sql:param value="%${param.lastName}%" />
  <sql:param value="%${param.dept}%" />
</sql:query>

<jsp:forward page="list.jsp" />