This is due very soon and I can't figure out this error. Hope there are some JSP gurus out there...
Code:
CODE
<%-- C:\Program Files\Apache Software Foundation\Tomcat 6.0\work\Catalina\localhost\myjspapp\org\apache\jsp --%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<head>
<title>Assignment 5</title>
</head>
<body>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.net.*" %>
<%@ page import="proj3131.*" %>
<%
String mine= request.getParameter("action");
if(mine.equals("login")){
String id = request.getParameter("id");
String p = request.getParameter("passwd");
String doit = "SELECT * FROM customer WHERE id='"+id+"' AND passwd='"+ p +"'";
String cast = "";
Connection con = null;
Statement stm = null;
ResultSet rs = null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:DB1");
stm = con.createStatement();
rs = stm.executeQuery(doit);
if(!rs.next() ){
request.setAttribute("loginMessage", "Invalid ID or Password");
%>
<jsp:forward page="login.jsp" />
<%
}
else {
cast = rs.getString("firstName");
request.setAttribute("custHomeMessage", "<h2>Welcome to Your Homepage, " + cast + "</h2>");
%>
<jsp:forward page="custHome.jsp" />
<%
}
rs.close();
stm.close();
con.close();
}
%>
<%
if(mine.equals("search")){
String inp = request.getParameter("input");
String sel = request.getParameter("select");
String doit ="SELECT * FROM product WHERE ("+sel+" LIKE '%"+ inp +"%')";
Vector v = new Vector();
String fwd="";
Connection con = null;
Statement stm = null;
ResultSet rs = null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:DB1");
stm = con.createStatement();
rs = stm.executeQuery(doit);
while(rs.next()){
v.add(new Product(rs.getString("id"), rs.getString("prodName"), rs.getString("price")));
}
session.setAttribute("productList", v);
%>
<jsp:forward page="list.jsp" />
<%
rs.close();
stm.close();
con.close();
}
%>
<%if(mine.equals("addCustomer")){%>
<jsp:useBean id="c" class="proj3131.Customer"/>
<jsp:setProperty name="c" property="*"/>
<%String record= c.addRecord();
session.setAttribute("loginMessage",record);%>
<jsp:forward page="login.jsp"/>
<%
}
%>
<%if(mine.equals("updateCustomer")){%>
<jsp:useBean id="c1" class="proj3131.Customer"/>
<jsp:setProperty name="c1" property="*"/>
<% String record = c1.updateRecord();
session.setAttribute("custHomeMessage", record);%>
<jsp:forward page="custHome.jsp"/>
<%
}
%>
</body>
</html>
Error:
CODE
org.apache.jasper.JasperException: An exception occurred processing JSP page /midLayer.jsp at line 14
11: <%@ page import="proj3131.*" %>
12: <%
13: String mine= request.getParameter("action");
14: if(mine.equals("login")){
15: String id = request.getParameter("id");
16: String p = request.getParameter("passwd");
17: String doit = "SELECT * FROM customer WHERE id='"+id+"' AND passwd='"+ p +"'";
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:416)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
java.lang.NullPointerException
org.apache.jsp.midLayer_jsp._jspService(midLayer_jsp.java:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note
I've looked at line 14 until I'm blue in the face. This makes no sense to me...
Forum Index:
Programming Help |
C and C++ |
VB6 |
Java |
VB.NET |
C# |
ASP.NET |
PHP |
ColdFusion |
Perl and Python |
Ruby |
Databases |
Other Languages |
Game Programming |
Mobile Development |
Software Development |
Computer Science |
Industry News |
Programming Tutorials |
C++ Tutorials |
Visual Basic Tutorials |
Java Tutorials |
VB.NET Tutorials |
C# Tutorials |
Linux Tutorials |
PHP Tutorials |
ColdFusion Tutorials |
Windows Tutorials |
HTML/JavaScript Tutorials |
CSS Tutorials |
Flash Tutorials |
Web Promotion Tutorials |
Graphic Design & Photoshop Tutorials |
Software Development Tutorials |
Database Tutorials |
Other Language Tutorials |
ASP.NET Tutorials |
Game Programming Tutorials |
WPF & Silverlight Tutorials |
| 
