跪求,各位帮忙解决JSP出错问题,100分相送!提出解决大大给分!

bujifeng 2005-12-26 02:32:00

近来做一新闻信息系统:JSP+JavaBean+Resin+Acess2000,老是出现以下问题,
Directory of /fengshu/admin/
.view_news.jsp
.image
.admin_bottom.htm
.admin_left.htm
.admin_main.htm
.admin.htm
.login.jsp
.login.htm
困惑好久啦,请帮忙呀!分不够,可以发另帖加分!
---------------------
系统用login.htm,.login.jsp 的登录后台没问题,之后访问新闻列表,如上的问题就来了!
---------------------
JavaBean如下:
package fengshu;
import java.io.*;
import java.sql.*;

public class dbconct
{
private Connection con = null;
public Statement stmt = null;

public void getcon()
throws Exception
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:fengshu");
stmt = con.createStatement();
}

public void close()
throws Exception
{
stmt.close();
con.close();
}
}

-----------------
新闻列表查看:view_news.jsp如下:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新闻列表</title>

<jsp:useBean id = "view" scope = "page" class = "fengshu.dbconct"/>
<%

int intPage; //指向的页数
//(totalRecord+PageNumbers)/PageNumbers //总共页数
//(intPage-1)*PageNumbers //当前页首记录
//intPage*PageNumbers //当前页尾记录
int currentPage = 1; //当前页数
int PageNumbers = 10; //每页显示
if(request.getParameter("page")!=null && request.getParameter("page")!="")
intPage = Integer.parseInt(request.getParameter("page"));
else
intPage = 1;
int totalRecord = 0; //新闻总数

view.getcon();
ResultSet counters = view.stmt.executeQuery("select count(*) as cnt from Acticel where TopicID='1'");
if(counters.next())
{
totalRecord = counters.getInt("cnt");
}
%>

</head>

...全文

91 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

yugona 2005-12-26

打赏
举报

把你的view_news.jsp中的
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
errorPage=""删除掉，估计是你的这个view_news.jsp出错了，然后被定位到""，所以才显示那些文件列表。你先把那个errorPage=""删除，看看view_news.jsp有什么错误。

还有if(request.getParameter("page")!=null && request.getParameter("page")!="")这句是不对的，应该改为
if(request.getParameter("page")!=null && !request.getParameter("page").equals(""))

OnlyFor_love 2005-12-26

打赏
举报

在web.xml中加入
<web-app>
<directory-servlet id='false'/>
</web-app>

bujifeng 2005-12-26

打赏
举报

<body>
<div align="center">

<table width="560" border="0" cellpadding="0" cellspacing="0">

<tr>
<td width="560" height="28"> </td>
</tr>
</table>
</div>
<div align="center">
<table width="560" border="0" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">

<tr>
<td width="80" height="31" align="center" bgcolor="#A4C4EE">序号</td>
<td width="367" align="center" bgcolor="#A4C4EE">新闻标题</td>
<td width="53" align="center" bgcolor="#A4C4EE">删除</td>
<td width="55" align="center" bgcolor="#A4C4EE">编辑</td>
</tr>
</table>
<%
String strsql = "select ArticelID,Title from Articel order by ArticelID desc";

ResultSet rs = view.stmt.executeQuery(strsql);
int i=0;
while(rs.next())
{

if(i >= (intPage-1)*PageNumbers && i < intPage*PageNumbers)
{

%>
<table width="560" border="0" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">

<tr>
<td width="80" height="31" align="center" bgcolor="#D6E7FA"><%=rs.getString("ArticelID")%></td>
<td width="367" align="left" bgcolor="#D6E7FA"><%=rs.getString("Title")%></td>
<td width="53" align="center" bgcolor="#D6E7FA">删</td>
<td width="55" align="center" bgcolor="#D6E7FA">编</td>
</tr>
</table>
<%
}
i++;
}
%>
</table>
<%
rs.close();
%>
<br>
<div align="center" >
新闻总数：<%= totalRecord %> 当前页数：<%=currentPage%> 每页显示<%=PageNumbers%>条
共<%=(totalRecord+PageNumbers)/PageNumbers%>页 <a href="view_news.jsp?page=1">首页</a>
<%
if(intPage>1 && intPage<((totalRecord+PageNumbers)/PageNumbers))
{
out.print("<a href='view_news.jsp?page=" + (intPage-1) + "'>上一页  </a>");
out.print("<a href='view_news.jsp?page=" + (intPage+1) +"'>下一页  </a>");
out.print("<a href='view_news.jsp?page=" + ((totalRecord+PageNumbers)/PageNumbers) + "'>最后一页</a>");
}
if(intPage ==((totalRecord+PageNumbers)/PageNumbers))
out.print("<a href='view_news.jsp?page=" + (intPage-1) + "'>上一页  </a>");
if(intPage == 1)
{
out.print("<a href='view_news.jsp?page=" + (intPage+1) +"'>下一页  </a>");
out.print("<a href='view_news.jsp?page=" + ((totalRecord+PageNumbers)/PageNumbers) + "'>最后一页</a>");
}
%>
</div>
</div>
</body>
</html>
<%
rs.close();
counters.close();
view.close();
%>