struts hibernate 查询分页问题！
出现的错误：java.lang.ClassCastException: java.lang.Long
at com.ls.dao.SiteDAO.getPetsCount(SiteDAO.java:300)
at com.ls.struts.action.SearchSiteAction.execute(SearchSiteAction.java:56)
我的jsp页面分页代码：
<script type="text/javascript">
function setPageSize()
{
if(${pageResult.recordCount} < ${pageResult.pageSize})
{
document.forms[0].elements["pageResult.pageSize"].value = ${pageResult.recordCount};
}
}
window.document.body.onload = setPageSize;
</script>
共${pageResult.recordCount}条记录
每页显示<input name="pageResult.pageSize" value="${pageResult.pageSize}" size="3" />条
第<input name="pageResult.pageNo" value="${pageResult.pageNo}" size="3" />页
/ 共${pageResult.pageCount}页
<a href="javascript:page_first();">第一页</a>
<a href="javascript:page_pre();">上一页</a>
<a href="javascript:page_next();">下一页</a>
<a href="javascript:page_last();">最后一页</a>
<button onClick="javascript:page_go();">GO</button>
<script>
function page_go()
{
page_validate();
document.forms[0].submit();
}
function page_first()
{
document.forms[0].elements["pageResult.pageNo"].value = 1;
document.forms[0].submit();
}
function page_pre()
{
var pageNo = document.forms[0].elements["pageResult.pageNo"].value;
document.forms[0].elements["pageResult.pageNo"].value = parseInt(pageNo) - 1;
page_validate();
document.forms[0].submit();
}
function page_next()
{
var pageNo = document.forms[0].elements["pageResult.pageNo"].value;
document.forms[0].elements["pageResult.pageNo"].value = parseInt(pageNo) + 1;
page_validate();
document.forms[0].submit();
}
function page_last()
{
document.forms[0].elements["pageResult.pageNo"].value = ${pageResult.pageCount};
document.forms[0].submit();
}
function page_validate()
{
var pageTotal = ${pageResult.pageCount};
var pageNo = document.forms[0].elements["pageResult.pageNo"].value;
if (pageNo<1)pageNo=1;
if (pageNo>pageTotal)pageNo=pageTotal;
document.forms[0].elements["pageResult.pageNo"].value = pageNo;
var recTotal = ${pageResult.recordCount};
var pageSize = document.forms[0].elements["pageResult.pageSize"].value;
if (pageSize<1)pageSize=10;
if(pageSize>recTotal)pageSize=recTotal;
document.forms[0].elements["pageResult.pageSize"].value = pageSize;
}
</script>
Action里的代码：Integer petsCount = siteDAO.getPetsCount(site);
pageResult.setRecordCount(petsCount);
Integer pageCount = null;
if (petsCount % pageResult.getPageSize() == 0) {
pageCount = petsCount / pageResult.getPageSize();
} else {
pageCount = petsCount / pageResult.getPageSize() + 1;
}
pageResult.setPageCount(pageCount);
DAO里的代码:public Integer getPetsCount(Site site )
{
Integer petsCount = null;
Session session = super.getSession();
String hql = "select count(*) from Site site where 1=1";
Map params = null;
try
{
if(site != null)
{
params = new HashMap();
if(site.getName()!= null && !site.getName().equals(""))
{
hql += " and site.name like :name";
params.put("name", site.getName());
}
if(!site.getType().equals("vvv"))
{
hql += " and site.type = :type";
params.put("type", site.getType());
}
}
Query query = session.createQuery(hql);
Iterator iter = params.entrySet().iterator();
while(iter.hasNext())
{
Map.Entry entry = (Map.Entry)iter.next();
query.setParameter(entry.getKey().toString(), entry.getValue());
}
petsCount = (Integer)query.uniqueResult();
}catch(Exception ex)
{
ex.printStackTrace();
}finally
{
super.closeSession();
}
return petsCount;
}
通过查询把查询后的结构返回到Jsp页面，在分页显示。我有个PageResult类对分页进行了封装，但老是抛出上述异常，请高手指点！
[解决办法]
com.ls.dao.SiteDAO.getPetsCount(SiteDAO.java:300)
这行类型转换有问题
[解决办法]
