这个程序有什么错误？我很急，大家帮帮忙。（在线）

hoget 2003-06-15 05:55:26

<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page language="java" %>
<%@ include file="P.jsp" %>
<HTML>
<HEAD>
<TITLE>发文信息查看</TITLE>
</HEAD>
<BODY>
<CENTER>
分页显示
</CENTER>
 
<HR>
 
<CENTER>
<%
String ToPage = request.getParameter("ToPage");
if(ToPage != null)
{
ShowPage = Integer.parseInt(ToPage);
if(ShowPage > PageCount)
{
ShowPage = PageCount;
}
else if(ShowPage <= 0)
{
ShowPage = 1;
}
}
rs.absolute((ShowPage - 1) * PageSize + 1);
%>
<H3>当前在第
<%= ShowPage %>页, 共

<%= PageCount %>页</H3>
 
<%
for(int i = 1; i <= PageSize; i++)
{
%>
<TABLE border=1 bordercolor=RoyalBlue bgcolor=LightBlue>
<TR><TD bgcolor=LightYellow width= 100>
顺号</TD>
<TD width= 100><%= rs.getString("sh") %>
</TD>
<TD bgcolor=LightYellow width= 100>
文件号</TD>
<TD width= 100><%= rs.getDate("wjh") %>
</TD>
<TD bgcolor=LightYellow width= 100>
公文名称</TD>
<TD width= 100><%= rs.getString("gwmc") %>
</TD>
<TD bgcolor=LightYellow width= 100>
发文机关</TD>
<TD width= 100><%= rs.getString("fwjg") %>
</TD>
<TD bgcolor=LightYellow width= 100>
联发机关</TD>
<TD width= 100><%= rs.getString("lfjg") %>
</TD>
<TD bgcolor=LightYellow width= 100>
保存月份</TD>
<TD width= 100><%= rs.getString("bcyf") %>
</TD>
<TD bgcolor=LightYellow width= 100>
文件内容</TD>
<TD width= 100><%= rs.getString("wjnr") %>
</TD>
<TD bgcolor=LightYellow width= 100>
输入人</TD>
<TD width= 100><%= rs.getString("srr") %>
</TD>
<TD bgcolor=LightYellow width= 100>
输入日期</TD>
<TD width= 100><%= rs.getString("srrq") %>
</TD>
<TD bgcolor=LightYellow width= 100>
保密级别</TD>
<TD width= 100><%= rs.getString("bmjb") %>
</TD>
</TR>
</TABLE> 
<%
if(!rs.next())
break;
}
%>
<TABLE>
<TR valign=baseline align=center>
<%
if(ShowPage != 1)
{
%>
<TD Width=150>
<A Href=gw_index.jsp?ToPage=<%= 1 %>>到第一页</A>
</TD>
<TD Width=150>
<A Href=gw_index.jsp?ToPage=<%= ShowPage - 1 %>>到上一页</A>
</TD>
<%
}
if(ShowPage != PageCount)
{
%>
<TD Width=150>
<A Href=gw_index.jsp?ToPage=<%= ShowPage + 1%>>到下一页</A>
</TD>
<TD Width=150>
<A Href=gw_index.jsp?ToPage=<%= PageCount %>>到最后一页</A>
</TD>
<%
}
%>
<TD Width=150>
<FORM action=gw_index.jsp method=POST>
到
<INPUT type="text" name=ToPage style="HEIGHT: 25px; WIDTH: 40px"
value=<%= ShowPage%> > 页
</FORM></TD></TR>
</TABLE>
</CENTER>
</BODY>
</HTML>

...全文

24 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

hoget 2003-06-15

打赏
举报

厉害，给分。

naxin 2003-06-15

打赏
举报

把p.jsp写成一个javabeans,再用jsp调用.(当然最好是用连接池的实现方法)

例子如下(你可以参考，改一下就成了):

JSP和Java Bean的方法:

<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<HEAD>
<TITLE> </TITLE>
<META NAME="Generator" CONTENT="EditPlus2.11">
<META NAME="Author" CONTENT="naxin">
</HEAD>
<BODY>
<jsp:useBean id="sybase" scope="page" class="test.sybconn" />
<%
ResultSet rs=sybase.Query("select * from tjck_dh");
while(rs.next()) {
out.print("|"+rs.getString("name")+"|");
out.print(rs.getString("card_no")+"|");
out.print(rs.getString("amount")+"|");
out.print(rs.getString("home_call")+"|");
out.print(rs.getString("office_call")+"| ");
}
rs.close();
%>

<HR>

Bean的代码:

package test;
import java.sql.*;

public class sybconn {
// String sDBDriver = "com.sybase.jdbc2.jdbc.SybDriver";
String sConnStr = "jdbc:sybase:Tds:localhost:2638";
// String user="dba";
// String passwd="sql";
Connection conn = null;
ResultSet rs = null;

public ResultSet Query(String sql) throws SQLException,Exception {
Class.forName("com.sybase.jdbc2.jdbc.SybDriver").newInstance();
conn = DriverManager.getConnection(sConnStr,"dba","sql");
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
return rs;
}
}

hoget 2003-06-15

打赏
举报

怎么用mvc方式？我不会啊

naxin 2003-06-15

打赏
举报

最好用mvc方式，不要全用JSP

hoget 2003-06-15

打赏
举报

在p.jsp文件的头部也加上
<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page language="java" %>
吗？可是还有错误啊。也是一大堆。

naxin 2003-06-15

打赏
举报

p.jsp找不到java.sql.*

hoget 2003-06-15

打赏
举报

以下是它包含的那个p.jsp文件。及错误信息。
<%!
int PageSize = 3;
int ShowPage = 1;
int RowCount = 0;
int PageCount = 0;
//Connection con = null;
//Statement stmt = null;
//ResultSet rs = null;
public void jspInit()
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = Connection(DriverManager.getConnection("jdbc:odbc:newbg","sa",""));
Statement stmt = Statement(con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY));
ResultSet rs = ResultSet(stmt.executeQuery("SELECT * FROM bg_fwzd"));
rs.last();
RowCount = rs.getRow();
PageCount = ((RowCount % PageSize) == 0 ?
(RowCount/PageSize) : (RowCount/PageSize)+1);
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
}
public void jspDestroy()
{
try{
rs.close();
stmt.close();
con.close();
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
}
%>
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
错误一大堆啊。这只是一条。第一条错误是从上第一个文件的13行那个 开始的
"gw_index.jsp": Error #: 300 : method Connection(java.sql.Connection) not found in class gw_0005findex_0002ejsp_jsp at line 13