Hey friends,
I'm trying to do a online library system using jsp, servlet, java and mysql. In my system im tring to enter a book id through a text box and search the book then display the name of the box in next text box.my problem is how to display a db column value in a text box. values are passing to jsp->servlet->service->dao and vice versa. but did not display the name in the 2nd text box.
here my code of my system.
<div id="page">
<form name="input" action="book" method="post">
Book Id : <input type="text" name="txtBid" class="resizedTextbox"><br><br>
<input type="submit" value="Search Book" onclick= <a href="main/Servelet"</a>
<input type="hidden" name="operation" value="searchBookbtn"><br><br>
Book Name : <input type="text" name="txtName" class="resizedTextbox"><br><br>
<input type="submit" value="Delete Book" onclick= <a href="main/Servelet"</a>
<input type="hidden" name="operation" value="deleteBookbtn">
<input type="submit" value="Cancel/Clear" onclick= <a href="main/Servelet"</a>
<p><%=request.getAttribute("deleteBookMsg") %></p>
</form>
<br><br><br><br><br><br><br><br><br><br><br>
</div>
servlet
private void searchBook(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
System.out.println("Inside searchBook");
book b =new book();
bookService bs = new bookServiceImpl();
String b_id=request.getParameter("txtBid");
String b_name=request.getParameter("txtName");
b.setB_id(b_id);
b.setB_title(b_name);
System.out.println(b_id);
if(bs.searchbook(b)){
String message = "Click Delete button to delete the book detail";
request.setAttribute("deleteBookMsg", message);
request.setAttribute("txtName",b);
}else{
String message = "Book does not Exist";
request.setAttribute("deleteBookMsg", message);
}
RequestDispatcher rd = getServletContext().getRequestDispatcher("/deleteBook.jsp");
rd.forward(request, response);
}
service layer
public boolean searchbook(book b) {
System.out.println("Inside bs.searchbook");
boolean book_result=true;
bookDAO bd = new bookDAOImpl();
System.out.println("===Inside bs.searchbook");
book bk =bd.search(b);
if(bk==null){
System.out.println("....");
System.out.println(book_result);
book_result=false;
}return book_result;
}
dao
public book search(book b) {
System.out.println("Inside book search");
book b_result = null;
Connection conn= null;
PreparedStatement ptmt= null;
ResultSet rset = null;
try{
conn= getConnection();
String queryString = "SELECT * FROM book WHERE b_id=?";
ptmt = conn.prepareStatement(queryString);
ptmt.setString(1, b.getB_id());
System.out.println(b.getB_id());
rset = ptmt.executeQuery();
System.out.println(rset.first());
if (rset.first()){
System.out.println(rset.first());
b_result = new book();
b_result.setB_title(rset.getString(String.valueOf("b_title")));
b_result.setB_suplier(rset.getString(String.valueOf("b_supplier")));
b_result.setB_publisher(rset.getString(String.valueOf("b_publisher")));
return b_result;
}
} catch (SQLException ex) {
ex.printStackTrace();
}
finally {
try {
ptmt.close();
conn.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}System.out.println("======");
System.out.println(b_result);
return b_result;
}