org.apache.jasper.JasperException: Cannot find any information on property 'qpag
各位大神帮帮忙，我采用useBean时出现错误
org.apache.jasper.JasperException: Cannot find any information on property 'qpageallcount' in a bean of type 'done.showrecordbypage'
package done;
import java.sql.*;
import com.sun.rowset.*;
public class showrecordbypage
{
int pagesize=10;
int qpageallcount=0;
int showpage=1;
StringBuffer presentpageresult;
CachedRowSetImpl rowset;
String databasename="";
String tablename="";
String user="";
String password="";
String 字段[]=new String[100];
int 字段个数=0;
public showrecordbypage()
{
presentpageresult=new StringBuffer();
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
}
catch(Exception e){}
}
public void setpagesize(int size)
{
pagesize=size;
字段个数=0;
String uri="jdbc:sqlserver://127.0.0.1:1433;DatabaseName="+databasename;
try{
Connection con=DriverManager.getConnection(uri,user,password);
DatabaseMetaData metadata=con.getMetaData();
ResultSet rsl=metadata.getColumns(null, null, tablename, null);
int k=0;
while(rsl.next()){
字段个数++;
字段[k]=rsl.getString(1);//获得字段的名字
k++;
}
Statement sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=sql.executeQuery("select* from"+tablename);
rowset=new CachedRowSetImpl();//创建行集对象
rowset.populate(rs);
con.close();
rowset.last();//关闭连接
int m=rowset.getRow();//总行数
int n =pagesize;
qpageallcount=((m%n)==0)?(m/n):(m/n+1);
}
catch(Exception exp){}
}
public int getpagesize()
{
return pagesize;
}
public int getpageAllCount()
{
return qpageallcount;
}
public void setshowpage(int n)
{
showpage=n;
}
public int getshowpage()
{
return showpage;
}
public StringBuffer getPresentPageResult()
{
if(showpage>qpageallcount)
showpage=1;
if(showpage<=0)
showpage=qpageallcount;
presentpageresult=show(showpage);
return presentpageresult;
}
public StringBuffer show(int page)
{
StringBuffer str=new StringBuffer();
str.append("<table border=1>");
str.append("<tr>");
for(int i=0;i<字段个数;i++)
{
str.append("<th>"+字段[i]+"</th>");
}
str.append("</tr>");
try{rowset.absolute((page-1)*pagesize+1);
for(int i=1;i<pagesize;i++){
str.append("<tr>");
for(int k=1;k<字段个数;k++){
str.append("<td>"+rowset.getString(k)+"</td>");
}
str.append("</tr>");
}
}
catch(SQLException exp){}
str.append("</table>");
return str;
}
public void setDatabaseName(String s)
{
databasename=s.trim();
}
public String getDatabaseName()
{
return databasename;
}
public void setTableName(String s)
{
tablename=s.trim();
}
public String getTableName()
{
return tablename;
}
public void setPassword(String s)
{
password=s.trim();
}
public void setUser(String s)
{
user=s.trim();
}
public String getUser()
{
return user;
}
}
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.* "%>
<%@ page import="done.*" %>
<jsp:useBean id="look" class="done.showrecordbypage" scope="session"/>
<jsp:setProperty name="look" property="databasename" value="bysj"/>
<jsp:setProperty name="look" property="tablename" value="worker_table"/>
<jsp:setProperty name="look" property="user" value="sa"/>
<jsp:setProperty name="look" property="password" value="sa"/>
<jsp:setProperty name="look" property="pagesize" value="3"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>000000</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body bgcolor="cyan">
<jsp:include page="head.jsp" />
<table border=1 width=990><tr><td>
人力资源管理>人员档案管理>员工基本信息维护<br></td></tr></table>
<table><tr><td><jsp:include page="left_dangan.jsp"/></td>
<td>
员工基本信息共有<jsp:getProperty name="look" property="qpageallcount"/>页。每页显示<jsp:getProperty name="look" property="pagesize"/>条记录信息。
<br><jsp:getProperty name="look" property="showpage"/>
<jsp:getProperty name="look" property="presentpageresult"/>
<br>当前显示<jsp:getProperty name="look" property="showpage"/>页。
<table><tr><td><from action="">
<input type=hidden name="showpage" value="<%=look.getshowpage()-1 %>">
<input type=submit name="g" value="前一页">
</form>
</td>
<td><form action="">
<input type=hidden name="showpage" value="<%=look.getshowpage()+1 %>">
<input type=submit name="g" value="后一页">
</form>
</td>
<td><form action="">
输入页码：<input type=text name="showpage" size=5>
<input type=submit name="g" value="提交">
</form>
</td>
</tr>
</table>
</td>
</tr></table>
</body>
</html>
[解决办法]
showrecordbypage- 修改成大写开头的
属性：qpageallcount 提供set方法
试试
