请教高手给看下这个错误:谢谢~!
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.util.*" import="java.sql.*,beans.*" %>
<jsp:useBean id="connDB" scope="page" class="beans.connDB"/>
<jsp:useBean id="chStr" scope="page" class="beans.chStr"/>
<jsp:include page="safe.jsp"/>
<%
connDB db=new connDB();
String sql="select * from shangpin order by INTime Desc";
ResultSet rs=db.executeQuery(sql);
%><html>
<head>
<title>爱之家超市</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../CSS/style.css" rel="stylesheet">
<script src="../JS/check.jsp"></script>
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0" background="../Images/bg.gif">
<tr>
<td>
<table width="777" height="609" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td valign="top">
<jsp:include page="Top.jsp"/>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableBorder_LTR">
<tr>
<td height="30" align="center" bgcolor="#eeeeee"><font size="5"><span class="word_grey"><a href="shangpin_add.jsp">添加商品信息</a></span></font><br></td>
</tr>
</table>
<table width="100%" height="396" border="0" cellpadding="0" cellspacing="0" class="tableBorder_LBR">
<tr>
<td width="26%" height="395" valign="top"><table width="100%" border="0" cellspacing="-2" cellpadding="-2">
<tr>
<td width="55%" height="82" align="center" class="word_grey"> <img src="../Images/reg.gif" width="84" height="54"></td>
<td width="45%" align="left" class="word_grey">商品管理</td>
</tr>
<tr>
<td height="112" colspan="2" valign="top" class="word_grey"><ul>
<li> 添加商品信息:点击“添加商品信息”超链接可以进行商品信息的添加。</li>
<li>修改商品信息:点击每条商品信息后面的“修改”按钮可以修改商品信息。</li>
<li>删除商品信息:点击每条商品信息后面的“删除”按钮可以删除商品信息。</li>
<li>推荐商品:如果想推荐商品,可以点击指定商品后的“修改”按钮。</li>
<li>是否新品:如果想将商品信息发布到新品展示中,可以点击指定商品后的“修改”按钮。</li>
</ul></td>
</tr>
<tr align="center">
<td colspan="2" valign="middle" class="word_grey"></td>
</tr>
</table></td>
<td width="5" valign="top" background="../Images/Cen_separate.gif"></td>
<td width="73%" valign="top"><table width="100%" height="14" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="13" align="center"> </td>
</tr>
</table>
<table width="100%" height="48" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolordark="#CCCCCC" bordercolorlight="#FFFFFF">
<tr>
<td width="18%" height="27" align="center">商品序列号</td>
<td width="36%" align="center">名称</td>
<td width="20%" align="center">厂商</td>
<td width="8%" align="center">新品否</td>
<td width="8%" align="center">推荐否</td>
<td width="5%" align="center">修改</td>
<td width="5%" align="center">删除</td>
</tr>
<%
//if(!rs.next())
//{out.print("jjsjsjsj");}
String str=(String)request.getParameter("Page");
if(str==null){
str="0";
}
int pagesize=10;
rs.last();
int RecordCount=rs.getRow();
int maxPage=0;
maxPage=(RecordCount%pagesize==0)?(RecordCount/pagesize):(RecordCount/pagesize+1);
int Page=Integer.parseInt(str);
if(Page<1){
Page=1;
}else{
if(Page>maxPage){
Page=maxPage;
}
}
//rs.absolute((Page-1)*pagesize+1);
for(int i=1;i<=pagesize;i++){
// String ISBN=rs.getString("ISBN");
// String SPName=rs.getString("SPName");
// String producer=rs.getString("producer");
// String newgoods=rs.getInt("newgoods")==0 ? "否":"是";
// String commend=rs.getInt("commend")==0 ? "否":"是";
%> <tr style="padding:5px;">
<td height="24" align="center"></td>
<td align="center"><a href="shangpin_detail.jsp?ISBN="></a></td>
<td align="center"></td>
<td align="center"></td>
<td align="center"></td>
<td align="center"><a href="shangpin_modify.jsp?ISBN="><img src="../Images/modify.gif" width="15" height="15"></a></td>
<td align="center"><a href="shangpin_del.jsp?ISBN="><img src="../Images/del.gif" width="16" height="16"></a></td>
</tr>
<%
// try{
// if(!rs.next()){break;}
// }catch(Exception e){}
}
%>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right">当前页数:[<%=Page%>/<%=maxPage%>]
<%if(Page>1){%>
<a href="index.jsp?Page=1">第一页</a> <a href="index.jsp?Page=<%=Page-1%>">上一页</a>
<%
}
if(Page<maxPage){
%>
<a href="index.jsp?Page=<%=Page+1%>">下一页</a> <a href="index.jsp?Page=<%=maxPage%>">最后一页 </a>
<%}
%>
</td>
</tr>
</table>
</td>
</tr>
</table>
<jsp:include page="copyright.jsp"/>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
运行后在IE浏览器里的错误提示:
HTTP Status 500 -
________________________________________
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.lang.NullPointerException
org.apache.jsp.index_jsp._jspService(index_jsp.java:143)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
________________________________________
Apache Tomcat/5.0.28
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.util.*" import="java.sql.*,beans.*" %>
<jsp:useBean id="connDB" scope="page" class="beans.connDB"/>
<jsp:useBean id="chStr" scope="page" class="beans.chStr"/>
<jsp:include page="safe.jsp"/>
<%
connDB db=new connDB();
String sql="select * from shangpin order by INTime Desc";
ResultSet rs=db.executeQuery(sql);
%><html>
<head>
<title>爱之家超市</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../CSS/style.css" rel="stylesheet">
<script src="../JS/check.jsp"></script>
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0" background="../Images/bg.gif">
<tr>
<td>
<table width="777" height="609" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td valign="top">
<jsp:include page="Top.jsp"/>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="tableBorder_LTR">
<tr>
<td height="30" align="center" bgcolor="#eeeeee"><font size="5"><span class="word_grey"><a href="shangpin_add.jsp">添加商品信息</a></span></font><br></td>
</tr>
</table>
<table width="100%" height="396" border="0" cellpadding="0" cellspacing="0" class="tableBorder_LBR">
<tr>
<td width="26%" height="395" valign="top"><table width="100%" border="0" cellspacing="-2" cellpadding="-2">
<tr>
<td width="55%" height="82" align="center" class="word_grey"> <img src="../Images/reg.gif" width="84" height="54"></td>
<td width="45%" align="left" class="word_grey">商品管理</td>
</tr>
<tr>
<td height="112" colspan="2" valign="top" class="word_grey"><ul>
<li> 添加商品信息:点击“添加商品信息”超链接可以进行商品信息的添加。</li>
<li>修改商品信息:点击每条商品信息后面的“修改”按钮可以修改商品信息。</li>
<li>删除商品信息:点击每条商品信息后面的“删除”按钮可以删除商品信息。</li>
<li>推荐商品:如果想推荐商品,可以点击指定商品后的“修改”按钮。</li>
<li>是否新品:如果想将商品信息发布到新品展示中,可以点击指定商品后的“修改”按钮。</li>
</ul></td>
</tr>
<tr align="center">
<td colspan="2" valign="middle" class="word_grey"></td>
</tr>
</table></td>
<td width="5" valign="top" background="../Images/Cen_separate.gif"></td>
<td width="73%" valign="top"><table width="100%" height="14" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="13" align="center"> </td>
</tr>
</table>
<table width="100%" height="48" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolordark="#CCCCCC" bordercolorlight="#FFFFFF">
<tr>
<td width="18%" height="27" align="center">商品序列号</td>
<td width="36%" align="center">名称</td>
<td width="20%" align="center">厂商</td>
<td width="8%" align="center">新品否</td>
<td width="8%" align="center">推荐否</td>
<td width="5%" align="center">修改</td>
<td width="5%" align="center">删除</td>
</tr>
<%
//if(!rs.next())
//{out.print("jjsjsjsj");}
String str=(String)request.getParameter("Page");
if(str==null){
str="0";
}
int pagesize=10;
rs.last();
int RecordCount=rs.getRow();
int maxPage=0;
maxPage=(RecordCount%pagesize==0)?(RecordCount/pagesize):(RecordCount/pagesize+1);
int Page=Integer.parseInt(str);
if(Page<1){
Page=1;
}else{
if(Page>maxPage){
Page=maxPage;
}
}
//rs.absolute((Page-1)*pagesize+1);
for(int i=1;i<=pagesize;i++){
// String ISBN=rs.getString("ISBN");
// String SPName=rs.getString("SPName");
// String producer=rs.getString("producer");
// String newgoods=rs.getInt("newgoods")==0 ? "否":"是";
// String commend=rs.getInt("commend")==0 ? "否":"是";
%> <tr style="padding:5px;">
<td height="24" align="center"></td>
<td align="center"><a href="shangpin_detail.jsp?ISBN="></a></td>
<td align="center"></td>
<td align="center"></td>
<td align="center"></td>
<td align="center"><a href="shangpin_modify.jsp?ISBN="><img src="../Images/modify.gif" width="15" height="15"></a></td>
<td align="center"><a href="shangpin_del.jsp?ISBN="><img src="../Images/del.gif" width="16" height="16"></a></td>
</tr>
<%
// try{
// if(!rs.next()){break;}
// }catch(Exception e){}
}
%>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right">当前页数:[<%=Page%>/<%=maxPage%>]
<%if(Page>1){%>
<a href="index.jsp?Page=1">第一页</a> <a href="index.jsp?Page=<%=Page-1%>">上一页</a>
<%
}
if(Page<maxPage){
%>
<a href="index.jsp?Page=<%=Page+1%>">下一页</a> <a href="index.jsp?Page=<%=maxPage%>">最后一页 </a>
<%}
%>
</td>
</tr>
</table>
</td>
</tr>
</table>
<jsp:include page="copyright.jsp"/>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
运行后在IE浏览器里的错误提示:
HTTP Status 500 -
________________________________________
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.lang.NullPointerException
org.apache.jsp.index_jsp._jspService(index_jsp.java:143)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
________________________________________
Apache Tomcat/5.0.28
数据库操作放到JSP里啊,晕的很。
有需要的朋友可以去看看
int PageSize = 10; //没一页显10条记录
int Page = 1;//设置成第一页
int maxPage = 1; //设置最大页为 1 ,假如没有10条记录,也会显示1页。
if(rs.next())
{
rs.last();
int RecordCount = rs.getRow();
rs.first();
}
maxPage = (RecordCount % PageSize == 0) ? (RecordCount/PageSize):(int)(Math.floor (RecordCount/PageSize+1));
if(maxPage == 0)
maxPage = 1;
if(request.getParameter("Page") == null || request.getParameter("Page").equals(""))
Page = 1;
else
try
{
Page = Integer.parseInt(request.getParameter("Page"));
}
catch(java.lang.NumberFormatException e)
{
Page = 1; // 捕获用户从浏览器地址栏直接输入Page = sdfsdfsdf所造成的异常
}
if(Page < 1)
Page = 1;
if(Page > maxPage)
Page = maxPage;
rs.absolute((Page-1)*PageSize+1);
for(int i=1;i <=pagesize;i++){
// String ISBN=rs.getString("ISBN");
// String SPName=rs.getString("SPName");
// String producer=rs.getString("producer");
// String newgoods=rs.getInt("newgoods")==0 ? "否":"是";
// String commend=rs.getInt("commend")==0 ? "否":"是";
%> <tr>
<td align="right">当前页数:[ <%=Page%>/ <%=maxPage%>]
<%
if(Page != 1)
{
%>
<a href="index.jsp?Page=1">第一页 </a>
<a href="index.jsp?Page= <%=Page-1%>">上一页 </a>
<%
}
if(Page != maxPage)
{
%>
<a href="index.jsp?Page= <%=Page+1%>">下一页 </a>
<a href="index.jsp?Page= <%=maxPage%>">最后一页 </a>
<%
}
%>
</td>
</tr>
//可能有些地方写错啦,但希望正确的地方能对你有点点帮助....!