<%@page contentType="text/html;charset=GB2312" %>
<html>
<head>
<title>商品搜索</title>
<style type="text/css">
<!--
.style1 {font-size: 12px}
.style2 {color: #FF0000}
-->
</style>
</head>
<body>
<form name="form1" onsubmit="return check()" method="post" action="search_result.jsp">
<table width="80%" border="0" align="center" bgcolor="#0099FF">
<tr bgcolor="#FFFFFF">
<th height="39" scope="row"><div align="left">
<span style="font-weight: 400"><font size="2">查询项目:</font></span></div></th>
<td><select name="item" size=1>
<option value="">请选择</option>
<option value="姓名">username</option>
<option value="学号">id</option>
</select>
</td>
<td><font size="2">查询内容:</font></td>
<td><input type="text" name="content"></td>
<td><input type="submit" name="submit" value="查询">
</tr>
</table>
</form>
</body>
</html>
<%@page contentType="text/html;charset=GB2312" import="java.sql.*" %>
<html>
<head>
<title>成绩查询结果</title>
<style type="text/css">
<!--
.style1 {font-size: 12px}
.style2 {color: #FF0000}
-->
</style>
</head>
<body>
<jsp:include page="search.jsp"/>
<%@ include file="convert.jsp" %>
<center><h3>成绩查询结果</h3></center>
<%
Connection conn=null;
ResultSet rsAll=null;
Statement stmt=null;
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String strConn="jdbc:sqlserver://localhost:1433;DatabaseName=stsystem";
String strUser="sa";
String strPassword="123456";
conn=DriverManager.getConnection(strConn,strUser,strPassword);
stmt=conn.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String strItem=request.getParameter("item");
String strContent=Bytes(request.getParameter("content"));
String strSql="";
if (strItem==null || strItem=="")
{
strSql="SELECT id,username,jsp,javaweb,sql FROM users";
}
else
{
strSql="SELECT id,username,jsp,javaweb,sql FROM users WHERE "+strItem.trim()+" LIKE '%"+strContent.trim()+"%'";
}
rsAll=stmt.executeQuery(strSql);
}
catch(Exception e)
{
e.printStackTrace();
}
%>
<table width="80%" border=1 cellspacing="0" align="center">
<tr>
<td><font size="2" color="#0000FF">学生号</font></td>
<td><font size="2" color="#0000FF">姓名</font></td>
<td><font size="2" color="#0000FF">jsp</font></td>
<td><font size="2" color="#0000FF">javaweb</font></td>
<td><font size="2" color="#0000FF">sql</font></td>
</tr>
<%
String str=(String)request.getParameter("page");
if(str==null)
{
str="0";
}
int pagesize=5;
rsAll.last();
int recordCount=rsAll.getRow();
int maxPage=0;
maxPage=(recordCount%pagesize==0)?(recordCount/pagesize):(recordCount/pagesize+1);
int currentPage=Integer.parseInt(str);
if(currentPage<1)
{
currentPage=1;
}
else
{
if(currentPage>maxPage)
{
currentPage=maxPage;
}
}
rsAll.absolute((currentPage-1)*pagesize+1);
for(int i=1;i<=pagesize;i++)
{
%>
<tr>
<td><font size="2"><%= rsAll.getString("id") %></font></td>
<td><font size="2"><%= rsAll.getString("username") %></font></td>
<td><font size="2"><%= rsAll.getString("jsp") %></font></td>
<td><font size="2"><%= rsAll.getString("javaweb") %></font></td>
<td><font size="2"><%= rsAll.getString("sql") %></font></td>
<td><a href="exam.html"><font size="2">返回</font></a></td>
</tr>
<%
try
{
if(!rsAll.next()){break;}
}catch(Exception e){}
}
%>
</table>
<p align="center"><font size="2">跳转到:<input type="text" name="page" size="3">当前页数：[<%=currentPage%>/<%=maxPage%>]
<%
if(currentPage>1)
{
%>
<a href="search_result.jsp?page=1">第一页</a> <a href="search_result.jsp?page=<%=currentPage-1%>">上一页</a>
<%
}
if(currentPage<maxPage)
{
%>
<a href="search_result.jsp?page=<%=currentPage+1%>">下一页</a> <a href="search_result.jsp?page=<%=maxPage%>">最后一页 </a>
<%
}
rsAll.close();
stmt.close();
conn.close();
%>
</font></p>
</body>
</html>
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /search_result.jsp at line 62 59: str="0"; 60: } 61: int pagesize=5; 62: rsAll.last(); 63: int recordCount=rsAll.getRow(); 64: int maxPage=0; 65: maxPage=(recordCount%pagesize==0)?(recordCount/pagesize):(recordCount/pagesize+1); Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:435) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause
java.lang.NullPointerException org.apache.jsp.search_005fresult_jsp._jspService(search_005fresult_jsp.java:137) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:803) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.13 logs.
空指针异常问题，看下控制台显示你自己的哪句代码空指针了