用javabean分页显示从数据库中查找的信息报错

成一粒 2011-10-19 09:38:35
page_sep.jsp:

<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.util.Vector" %>
<%@ page import="java.lang.*" %>
<%@ page import="wu.bean.BeanArticlePage" %>
<%@ page import="wu.bean.article" %>
<jsp:useBean id="page_sep" class=wu.bean.BeanArticlePage scope="session"></jsp:useBean>
<%
int intPageSize=4; //每页显示的记录数
int currPageBegin=0; //起始记录的索引
int intPageConut=0; //总页数
int intPage=0; //待显示页码
String strPage=null; //用户请求页码
%>

<%
article art=new article();

Vector<article> vector=new Vector<article>();

vector=page_sep.getResultSet();

strPage=request.getParameter("pagenumber");//pagenumber

if(strPage==null){

intPage=1;

}else{

intPage=Integer.parseInt(strPage);

if(intPage<1)

intPage=1;
}

//
intPageConut=(vector.size()+intPageSize-1)/intPageSize;

//调整带显示的页码
if(intPage>intPageConut)

intPage=intPageConut;

//计算每一页的起始记录索引

currPageBegin=intPage*intPageSize-intPageSize;

%>
<table align=center border=1 cellspacing=0 width=90%>

<tr>
<td align=center>作者</td>
<td align=center>标题</td>
<td align=center>类容</td>
</tr>
<%
for(int i=currPageBegin;i<intPage*intPageSize&&i<vector.size();i++)
{

art=(article)vector.elementAt(i);
%>
<tr bgcolor="#f0ffff">
<td align=center><font size=2><%=art.getUsername() %></font></td>
<td align=center><font size=2><%=art.getTitle() %></font></td>
<td align=center><font size=2><%=art.getContent() %></font></td>
</tr>
<%
}
%>
</table>

BeanArticlePage.java
:
package wu.bean;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import wu.JDBC.ContantFinal;
import wu.JDBC.LoginAccess;
import wu.JDBC.SqlServerConn;

public class BeanArticlePage {

public Vector<article> getResultSet(){

LoginAccess la=new LoginAccess(new SqlServerConn());//SQLServer数据库的链接

try {

ResultSet rs=la.SetAll(new ContantFinal().artcle);//从表artcle中查找所有信息

Vector<article> vector=new Vector<article>();


while(rs.next()){

article ar=new article();

ar.setArticleID(rs.getInt("articleID"));

ar.setUsername(rs.getString("username"));

ar.setTitle(rs.getString("title"));

ar.setContent(rs.getString("content"));

vector.addElement(ar);

System.out.println("success");
}

System.out.println("success");

return vector;


} catch (SQLException e) {

e.printStackTrace();

la.Close();
}

return null;

}

}

article.java

package wu.bean;

public class article {

public int articleID=0;

public String username=null;

public String title=null;

public String content=null;



public int getArticleID() {
return articleID;
}

public void setArticleID(int articleID) {
this.articleID = articleID;
}

public String getUsername() {
return username;
}

public void setUsername(String username) {
this.username = username;
}

public String getTitle() {
return title;
}

public void setTitle(String title) {
this.title = title;
}

public String getContent() {
return content;
}

public void setContent(String content) {
this.content = content;
}



}


...全文
73 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
成一粒 2011-10-19
  • 打赏
  • 举报
回复
谢谢,我的javabean中class引用没加“”
dzr1990 2011-10-19
  • 打赏
  • 举报
回复
test.jsp(6,34),这个jsp的第六行第34列需要引号,你的没有引号所以报这个错误了,仔细检查检查。
成一粒 2011-10-19
  • 打赏
  • 举报
回复
大侠们勇气点看下去啊!
给点意见
成一粒 2011-10-19
  • 打赏
  • 举报
回复
错误信息:
2011-10-19 21:42:11 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet jsp threw exception
org.apache.jasper.JasperException: /test.jsp(6,34) quote symbol expected
at org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:40)
at org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:407)
at org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:88)
at org.apache.jasper.compiler.Parser.parseAttribute(Parser.java:200)
at org.apache.jasper.compiler.Parser.parseAttributes(Parser.java:150)
at org.apache.jasper.compiler.Parser.parseUseBean(Parser.java:955)
at org.apache.jasper.compiler.Parser.parseStandardAction(Parser.java:1138)
at org.apache.jasper.compiler.Parser.parseElements(Parser.java:1448)
at org.apache.jasper.compiler.Parser.parse(Parser.java:133)
at org.apache.jasper.compiler.ParserController.doParse(ParserController.java:216)
at org.apache.jasper.compiler.ParserController.parse(ParserController.java:103)
at org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:167)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:306)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:581)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)

81,092

社区成员

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧