Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Servlet and JSP search box

 
Darragh Power
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 65228
95
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is the important part of the error:
ava.lang.NullPointerException
dbhelpers.SearchQuery.getHTMLTable(SearchQuery.java:64)


What does inspecting that tell you?
 
Anindya Roy
Ranch Hand
Posts: 76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can try with instead of

Also check for . You are not setting value for
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic