type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Exception in JSP: /update.jsp:42
39: <td>修改</td>
40: </tr>
41: <%
42: while (rs.next()){//获取学生数据表中的记录
43: %>
44: <tr align="left" class="style1">
45: <td><%=rs.getString("id")%></td>
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:489)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:411)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause
java.lang.NullPointerException
org.apache.jsp.update_jsp._jspService(update_jsp.java:94)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
这是我的update.jsp
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*"%>
<jsp:useBean id="dbconn" scope="page" class="ShuJu.DBconn"/>
<html>
<head>
<title>修改客户信息</title>
<style type="text/css">
<!--
.style1 {
font-size: 12px;
color: #000000;
}
.style2 {
font-size: 12px;
color: #0033FF;
}
body {
background-color: #FFFFCC;
}
-->
</style>
</head>
<body>
<%
//TestBean.DBconn dbconn=new TestBean.DBconn();//获取数据库访问对象DBconn实例dbconn
dbconn.getConnection();//调用DBconn数据库连接方法
String sql="select * from student";//设置查询SQL语句
ResultSet rs=dbconn.selectRecord(sql);//调用DBconn数据查询方法
%>
<p align="center" class="style1">客户信息一览表</p>
<hr>
<table border=0 width="750">
<tr align="center" bgcolor="#CCFF22" class="style2">
<td>编号</td>
<td>姓名</td>
<td>性别</td>
<td>电话话吗</td>
<td>购买日期</td>
<td>修改</td>
</tr>
<%
while (rs.next()){//获取学生数据表中的记录
%>
<tr align="left" class="style1">
<td><%=rs.getString("id")%></td>
<td><%=rs.getString("name")%></td>
<td><%=rs.getString("sex")%></td>
<td><%=rs.getString("phonenmber")%></td>
<td><%=rs.getString("date")%></td>
<td><a href="update1.jsp?id=<%=rs.getObject(1)%>">修改</a></td>
</tr>
<%}
dbconn.closeConn();
%>
</table>
</body>
</html>