aspose file tools*
The moose likes JDBC and the fly likes Servlet and JSP search box Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Servlet and JSP search box" Watch "Servlet and JSP search box" New topic
Author

Servlet and JSP search box

Darragh Power
Greenhorn

Joined: Jul 24, 2014
Posts: 1
I am trying to display results from my books table in my database. I am using a search box in my index.jsp to input the author name. I want to display all results from my db that match the author's name. The SearchQuery.java and SearchServlet.java both worked when all I wanted to do was display all records from my db, but now I've changed it around by adding a search box and trying to search by author.

index.jsp


SearchQuery.java


SearchServlet.java


Search.jsp


When I try to run I get this error:


HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error that prevented it from fulfilling this request.

exception

java.lang.NullPointerException
dbhelpers.SearchQuery.getHTMLTable(SearchQuery.java:64)
controller.SearchServlet.doPost(SearchServlet.java:46)
javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

I'd really appreciate help.

Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61206
    
  66

This is the important part of the error:
ava.lang.NullPointerException
dbhelpers.SearchQuery.getHTMLTable(SearchQuery.java:64)


What does inspecting that tell you?


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Anindya Roy
Ranch Hand

Joined: May 11, 2014
Posts: 76
You can try with instead of

Also check for . You are not setting value for
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Servlet and JSP search box