findback

<%@ page import = "java.io.*,java.util.*,java.sql.*"%>
<%@ page import = "javax.servlet.http.*,javax.servlet.*" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix = "c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix = "sql"%>

<html>
   <body>
      <sql:setDataSource var = "snapshot" driver = "com.mysql.jdbc.Driver"
         url = "jdbc:mysql://localhost/dictionary"
         user = "root"  password = "toor"/>
      <sql:query dataSource = "${snapshot}" var = "result">
         SELECT * from dictionary WHERE word="<%=request.getParameter("word")%>";
      </sql:query>
      <c:choose>
        <c:when test="${result.rowCount == 0}">
            <jsp:forward page="find.jsp" >
            <jsp:param name="flag" value="0" />
            </jsp:forward>
        </c:when>
        <c:otherwise>
            <c:forEach var = "row" items = "${result.rows}">
                <c:set var="wrd" scope="application" value="${row.word}"/>
                <c:set var="dsc" scope="application" value="${row.desc}"/>
                </c:forEach>
            <jsp:forward page="find.jsp" >
         <jsp:param name="flag" value="1" />
         <jsp:param name="word" value="${wrd}" />
         <jsp:param name="desc" value="${dsc}" />
         </jsp:forward>
        </c:otherwise>
    </c:choose>


   </body>
</html>