how to display?

Ads
 

how to display?

I have to write a code for searcing books in library and i have written but it is not displaying the result.I don't know where i have gone wrong.Also i want to know if there is any better idea then this and what type of validations i can give.I have written code as shown below.

search.html

<body>

<form name="search" action="http://localhost:8080/examples/jsp/searchbook.jsp" method="post">
<table align="center">
<tr> <td> Select any field </td> <td> <select name="keyfield" > <option> title</option> <option> author </option> <option> category </option>    <option>pub_year</option> </select> </td> </tr>
<tr> <td> Enter the keyword: </td> <td><input type="text" name="keyword" /> </td> </tr>
<tr> <td> <input type="submit" value="Search" /> </td> <td> <input type="reset" value="reset" /></td></tr>
</table>
</form>

</body>
<strong>search.jsp</strong>

<body>
<table border=2>
<tr> <th>acc<em>no  </th><th>title</th>  <th>category</th><th> no</em>of<em>copies </th>  <th> edition </th>    <th> pub</em>year</th>  <th> price </th>  </tr>
&lt;%
   String keyfield=request.getParameter("keyfield");
   String keyword=request.getParameter("keyword");
   try
    {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    Connection con=DriverManager.getConnection("jdbc:odbc:dms"," smartlib","smartlib");
    Statement stmt1=con.createStatement();
    ResultSet rs=stmt1.executeQuery("SELECT a.accno,a.title,a.category,a.no_of_copies,b.edition,c.pub_year,d.price from book_det a,edition b,publication c,price d where (a.accno=b.accno and a.accno=c.accno and a.accno=d.accno) and ('"+keyfield+"'='"+keyword+"')");
    while (rs.next())
    {
        %&gt;
         &lt;tr&gt; &lt;td&gt; &lt;%=rs.getString(1)%&gt; &lt;/td&gt; &lt;td&gt; &lt;%=rs.getString(2)%&gt; &lt;/td&gt; &lt;td&gt; &lt;%=rs.getString(3)%&gt; &lt;/td&gt; &lt;td&gt; &lt;%=rs.getString(4)%&gt; &lt;/td&gt; &lt;td&gt; &lt;%=rs.getString(5)%&gt; &lt;/td&gt; &lt;td&gt; &lt;%=rs.getString(6)%&gt; &lt;td&gt; &lt;%=rs.getString(7)%&gt; &lt;/td&gt; &lt;/tr&gt;

     &lt;%}
     rs.close();
     stmt1.close();
     con.close();
}
catch(ClassNotFoundException cnfe){out.println(cnfe.getMessage());}
catch(java.sql.SQLException sqle){out.println(sqle.getMessage());}
     %&gt;

</body>
</html>

Thank u in advance
View Answers

Ads









Related Tutorials/Questions & Answers:
jtable displays search results
Flex - Call JavaScript Function And Open a Popup Window that Displays Data
Advertisements
Write a program in JAVA which accepts a sentence & displays the longest word in the sentence alongn with it length of the word.
Q6 Write a java applet that displays 9 squares, one below the other. Every third square must be filled in black?
i want to create an application with only a button which on click displays table from database using struts2 and hibernate on eclipse
How to display date in JSP?
Calculation Example
MySQL by
How to display date in JSP?
How to make Spring web Login form?
how to code
how to update
how to display?
how to display?
how to display?
how to write this program
How to connect
How to include?
how to solve
Comparing XML with HTML
How to get current logged in Windows username? - Struts
How to add
How to display gridview details to labels dynamically?
how to solve this..
how to solve this..
how to do this?
How to? - IoC
how to retrive
how to display?
how to reset JFrame
Combobox in HTML

Ads