以下是代码: 把request那句话去掉,就好使,加上就不好用,问各位大虾那句话有什么错误吗? <%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="db.ConnectionToSqlserver"%><html>
<head><title>俺刚学jsp</title></head>
<body><jsp:useBean id="girl" class="db.ConnectionToSqlserver" scope="page">
</jsp:useBean> <%
int ipage=10; //分页单位
int allpage=3; //总页数
int pages; //接受的页码变量
int cpage=1; //当前页
int spage; //起始记录 if(request.getParameter("pages")==null)
{
pages=1;
}
else
{
//这句就有问题啊,后面加上intvalue()也错误
pages = request.getParameter("pages");
} //判断当前页
if(pages > allpage){
cpage=1;
} else {
cpage=pages;
} //判断起始记录
spage=(cpage-1)*ipage;
%><table width="200" border="1" align="center">
<%
//取部门的所有信息
String sql = "SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP "+cpage*ipage+" * FROM t_dep) A ORDER BY depid DESC) B ORDER BY depid";
ResultSet rs = girl.executeQuery(sql);
while(rs.next()) {%>
<tr>
<td><%=rs.getString("depid")%></td>
<td><%=rs.getString("depname")%></td>
</tr>
<%}
rs.close();
%>
</table><a href=x.jsp?pages=<%=pages-1%>>上一页</a>
<a href=x.jsp?pages=<%=pages+1%>>下一页</a></body>
</html>
<%@ page import="java.sql.*"%>
<%@ page import="db.ConnectionToSqlserver"%><html>
<head><title>俺刚学jsp</title></head>
<body><jsp:useBean id="girl" class="db.ConnectionToSqlserver" scope="page">
</jsp:useBean> <%
int ipage=10; //分页单位
int allpage=3; //总页数
int pages; //接受的页码变量
int cpage=1; //当前页
int spage; //起始记录 if(request.getParameter("pages")==null)
{
pages=1;
}
else
{
//这句就有问题啊,后面加上intvalue()也错误
pages = request.getParameter("pages");
} //判断当前页
if(pages > allpage){
cpage=1;
} else {
cpage=pages;
} //判断起始记录
spage=(cpage-1)*ipage;
%><table width="200" border="1" align="center">
<%
//取部门的所有信息
String sql = "SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP "+cpage*ipage+" * FROM t_dep) A ORDER BY depid DESC) B ORDER BY depid";
ResultSet rs = girl.executeQuery(sql);
while(rs.next()) {%>
<tr>
<td><%=rs.getString("depid")%></td>
<td><%=rs.getString("depname")%></td>
</tr>
<%}
rs.close();
%>
</table><a href=x.jsp?pages=<%=pages-1%>>上一页</a>
<a href=x.jsp?pages=<%=pages+1%>>下一页</a></body>
</html>
解决方案 »
- 客户端访问只显示主页多址,不显示详细地址,怎么做?
- JSP中的变量为什么在JavaScript中不能用?
- 如何取得数据库操作的错误序号,从而能够更具不同的序号进行判断,处理!
- ant的简单问题 100分赠送
- 第一次用微软的jdbc驱动就没成功 大家来帮忙哦
- 如何处理这个问题...谢谢
- ■■高分请教代码,带有2个分割符的split函数怎么写■■
- jsp的问题让人纳闷啊,我倒
- mongodb的执行语句全部都记录在日志当中了,一会的功夫就两个G多了,如何不记录mongdb的执行语句?急急急
- 求高手将这段解密的JS转为java代码
- 一个关于AJAX的问题,谁能帮我解决
- Spring Weblogic 集成问题
<%@ page import="java.sql.*"%>
<%@ page import="db.ConnectionToSqlserver"%><html>
<head><title>俺刚学jsp</title></head>
<body><jsp:useBean id="girl" class="db.ConnectionToSqlserver" scope="page">
</jsp:useBean> <%
int ipage=10; //分页单位
int allpage=3; //总页数
int pages; //接受的页码变量
int cpage=1; //当前页
int spage; //起始记录 if(request.getParameter("pages")==null)
{
pages=1;
}
else
{
//这句就有问题啊,后面加上intvalue()也错误
pages = Integer.parse(request.getParameter("pages")) ;
} //判断当前页
if(pages > allpage){
cpage=1;
} else {
cpage=pages;
} //判断起始记录
spage=(cpage-1)*ipage;
%><table width="200" border="1" align="center">
<%
//取部门的所有信息
String sql = "SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 20 * FROM t_dep) A ORDER BY depid DESC) B ORDER BY depid";
ResultSet rs = girl.executeQuery(sql);
while(rs.next()) {%>
<tr>
<td><%=rs.getString("depid")%></td>
<td><%=rs.getString("depname")%></td>
</tr>
<%}
rs.close();
%>
</table><a href=v.jsp?pages=<%=pages-1%>>上一页</a>
<a href=v.jsp?pages=<%=pages+1%>>下一页</a></body>
</html>
错误信息如下:type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 12 in the jsp file: /test/v.jsp
Generated servlet error:
The method parse(String) is undefined for the type Integer
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:512)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 12 in the jsp file: /test/v.jsp
Generated servlet error:
The method parse(String) is undefined for the type Integer
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:328)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:414)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:297)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:276)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:264)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:563)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:305)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
刚才写错了