who can help me ?
i need some sample program search in JSP

Here is a sample program.

sample.jsp

<%@ page language="java"%>

<%
    String cmd=request.getParameter("cmd");
    String search=request.getParameter("cmd");
    String result="No Result";
    if(cmd==null) cmd="";
    if(cmd.equals("Submit")) {
              String sql="select * from table where colname like '%" + search + "%'";

              .... Sql Api ...
              ....
              Connection cn = ......
              Statement st=cn.createStatement();
              ResultSet rs=st.executeQuery(sql);
 
              while(rs.next()) {
                   result=result + "<br/>" +   rs.getString(1)  +  " " + rs.getString(2));             
                }

              rs.close();
              st.close();
              cn.close();
     }  
%>
    <html>
           <head><title>Sample</title></head>
            <body>
                 <form method="post" action="sample.jsp">
                       Search <input type="text" name="search"/> 
                                   <input type="submit" name="cmd" value="Submit"/>
                 </form>
                <hr/>
                 <%=res%>
           </body>
    </html>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.