Display database column value in a text box

See more:

Java

MySQL

JSP

servlet

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 {
        //throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
        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) {
        //throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
        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) {
        //throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
        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;	
    }