how to display?

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









Related Tutorials/Questions & Answers:
ModuleNotFoundError: No module named 'displays'
ModuleNotFoundError: No module named 'displays'
Advertisements
ModuleNotFoundError: No module named 'displays'
ModuleNotFoundError: No module named 'rpi-displays'
jtable displays search results
Flex - Call JavaScript Function And Open a Popup Window that Displays Data
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?
How to make Spring web Login form?
MySQL by
Calculation Example
How to display date in JSP?
Comparing XML with HTML
how to write this program
Combobox in HTML
JavaScript for beginners
How to display gridview details to labels dynamically?
TextArea Frame in Java
SQL OR Operators
How to get current logged in Windows username? - Struts
Java How to Program
how to write tis java programming - Java Beginners
How to display image in Swing?
How to display image in Swing?
How to create Link in SWT
How to format number in Java?
How to convert String to int in Java
How to convert String to int in Java
How to convert String to int in Java
How to convert String to int in Java
how to code
how to update
how to display?
how to display?
how to display?
Flex Accordion Menu
How to include?
How to connect
how to solve
how to make following pyramid using loop
How to create file from input values in Jframe ?
How to add
how to do this?
how to solve this..
how to solve this..
How to? - IoC
how to retrive
how to display?

Ads