近来做一新闻信息系统: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>
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>
解决方案 »
- jsp初级:实现一个数据库版计数器出现异常了,大家来找错~~
- 关于Oracle 数据库
- 求一个HQL语句
- 搞了servlet 2天,一直被这个错误卡死,The server encountered an internal error () that prevented it from fulfilling this request
- 求一个FileUpload上传照片的例子,大家帮忙啊
- C 标签怎么取dom值
- 想要学习如何使用apache
- 添加,删除,修改等按钮当我点击按钮,希望有相应的反应,
- 如何方便地让整个页面都使用同一种字体?
- 我下载的"apache"没有"setup"似乎下到了源代码。。。怎么办。。。。?
- ####xPdf来解析PDF,是我差劲还是XPDF差劲?中文乱码,速度底下,多多请教了####
- [求助!]数据源问题
<div align="center">
<table width="560" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<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();
%>
<web-app>
<directory-servlet id='false'/>
</web-app>
<%@ 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(""))