java server programming : servlet

Expert:lizhengchen
hi all,
can you help check what's wrong with my servlet that i have a null pointer exception.Thanks

ERROR:
java.lang.NullPointerException
shop.member.memberloginservlet.processRequest(memberloginservlet.java:63)
shop.member.memberloginservlet.doGet(memberloginservlet.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)

Codes:
package shop.member;
import java.io.*;
import java.net.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import shop.dbconnection.*;

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
*
* @author p0757823
*/
public class memberloginservlet extends HttpServlet {
private Connection conn;
private Statement stmt;
private ResultSet rs;
private String sqlStr;
private int rowCount;

public void init(){
dbconnection.loadDriver();
}
/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

conn = dbconnection.getConnection();
stmt = dbconnection.getStatement(conn);

response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();

String passport = request.getParameter("passport");
String password = request.getParameter("password");

out.println("<html>");
out.println("<head>");
out.println("<title>Servlet LoginServlet</title>");
out.println("</head>");
out.println("<body>");

try {
sqlStr = "SELECT count(*) from member where passport='"+ passport +"' and password='"+ password +"'";
rs = stmt.executeQuery(sqlStr);

int Count = 0;
String name="";
String address="";
while (rs.next()) {
Count = rs.getInt(1);
}

}catch (SQLException ex){
out.println("Error executing stmt :" + ex);
}finally{
dbconnection.closeConnection(conn);
}

out.println("</body>");
out.println("</html>");

out.close();
}

// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}

/**
* Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}

/**
* Returns a short description of the servlet.
*/
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}

Answers

Hi friend,

We check your code :

You import the "import shop.dbconnection.*;"

Give details of "shop.dbconnection" with source code .

Thanks

More Questions

Post Answers

Ask Question Facing Programming Problem?