how to search for string using LIKE operator instead of integer?

dear sir, i have 3 jsp files, first "index.jsp", "dbtable.jsp", and "table2.jsp". what my code does is goes to the "index.jsp" file and let the user enters an ID to search for itemid, then it shows "dbtable.jsp" file with 3 columns of itemid, itemname, and description. the itemid is in hyperlink so when the user click on of them it'll go to the third file which is "table2.jsp" which will show the details of that hyperlink. note that "dbtable" and "table2" have relations in itemid. however, what i want to do is i want the user to search for the itemname instead of the itemid, and i want the itemname column to be in hyperlink not itemid. and do the same thing by clicking on the hyperlink on itemname column and show "table2" details. in other words, my "dbtable.jsp" query should be like this (select * from items where itemname LIKE '"+id). and my detail file "table2.jsp" should be (select * from itemdetails where item_id ='"+id"') or something like that. but as you see, first query needs integer and second one needs string. i hope you get the picture.

there are the codes:

***"index.jsp"***

    <html>
    <form method="post" action="dbtable.jsp">
    Enter id: <input type="text" name="id">
    <input type="submit" value="Search">
    </form>
    </html>

***"dbtable.jsp"***

    <%@page import="java.sql.*"%>
    <html>
    <table border="1">
    <%
    try{
    String v=request.getParameter("id");
    int id=Integer.parseInt(v);
    Class.forName("com.mysql.jdbc.Driver").newInstance();  
     Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");  
    Statement st=con.createStatement();
    ResultSet rs=st.executeQuery("Select * from items where itemid="+id+"");
    while(rs.next()){
        %>
    <tr>
<td><a href="table2.jsp?id=<%=rs.getString("itemid")%>"><%=rs.getString("itemid")</a></td>
<td><%=rs.getString("item")%></td>
<td><%=rs.getString("description")%></td></tr>
    <%
    }
    }
    catch(Exception e){
        System.out.println(e);
    }
    %>
    </table>
    </html>

***"table2.jsp"***

    <%@page import="java.sql.*"%>
    <html>
    <table border="1">
    <%
    String v=request.getParameter("id");
    int id=Integer.parseInt(v);
    Class.forName("com.mysql.jdbc.Driver").newInstance();  
     Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");  
    Statement st=con.createStatement();
    ResultSet rs=st.executeQuery("Select * from subinventory where itemid="+id+"");
    while(rs.next()){
        %>
    <tr>
<td><%=rs.getInt("itemid")%></td>
<td><%=rs.getInt("subinventoryid")%></td>
<td><%=rs.getInt("quantity")%></td></tr>
    <%
    }
    %>
    </table>
    </html>

View Answers

June 5, 2011 at 4:19 PM

modify "table2.jsp"

<%@page import="java.sql.*"%>
        <html>
        <table border="1">
        <%
        try{
        String v=request.getParameter("id");
        int id=Integer.parseInt(v);
        Class.forName("com.mysql.jdbc.Driver").newInstance();  
         Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");  
        Statement st=con.createStatement();
        ResultSet rs=st.executeQuery("Select * from items where itemid="+id+"");
        while(rs.next()){
            %>
        <tr>
    <td><a href="table2.jsp?id=<%=rs.getString("itemid")%>"><%=rs.getString("itemid")%></a></td><td><%=rs.getString("item")%></td>
    <td><%=rs.getString("description")%></td></tr>
        <%
        }
        }
        catch(Exception e){
            System.out.println(e);
        }
        %>
        </table>
        </html>

how to search for string using LIKE operator instead of integer?

Questions by Category