Hibernate实现分页和综合查询详解.doc

Hibernate实现分页和综合查询详解 ??现如今，在webhibernate实现的通用分页及综合查询。当然我这里所属的通用并不似绝对的，每到一个不同的场合，前台页面和数据接收还是稍微的要改一下： 首先我们先来看一下列表的jsplist.jsp： [html]?view plaincopyprint? span?style=font-size:?18px;?color:?rgb(0,?128,?128);?body?? !--?综合查询操作层?--?? div?id=selectDiv?? s:form?action=CourseListAction.action?theme=simple?target=mainFrame??? fieldset?style=width:80%??? legend查询条件/legend?? s:hidden?name=flag?value=1/s:hidden?? 课程名:s:textfield?name=course.name?cssClass=textStyle/?? 课程号:s:textfield?name=course.id?cssClass=textStyle/?? 开课学期:s:textfield?name=course.lessonTime?cssClass=textStyle/?? 课时:?从s:textfield?name=startHour??cssClass=textStyle/至s:textfield?name=endHour?cssClass=textStyle?/课时br/?? 课程学分:s:textfield?name=course.lessonPoints?cssClass=textStyle/?? s:submit?value=查??询?cssClass=buStyle/?? /fieldset?? /s:form?? /div?? table?class=ta?? tr?? th?colspan=2操作/th?? th课程号/th?? th课程名/th?? th开课学期/th?? th课时/th?? th学分/th?? /tr?? c:forEach?items=${sessionScope.list?}?var=cour?varStatus=status?? tr?bgColor=${status.index%2==0?#e5fee2:#d6fdd0?}?? tdimg?src=${path?}/images/edit2.png?alt=编辑?onclick=showDialogForEdit(${cour.id})//td?? tda?href=CourseAction!deleCourse?cour.id=${cour.id?}img?src=${path?}/images/delete.png?alt=课程删除//a/td?? td${cour.id}/td?? td${cour.name?}/td?? td${cour.lessonTime?}/td?? td${cour.lessonHour}/td?? td${cour.lessonPoints?}/td?? /tr?? /c:forEach?? /table?? br/?? center?? div?id=pageDir?? ????c:set?var=pageCount?value=${(coucount-1)/10+1?}/?? fmt:formatNumber?var=lastIndex?value=${pageCount}?pattern=#/?? ul?? li?style=margin-left:25%;?? 第${sessionScope.thisindex?}/${lastIndex?}页?? /li?? li?style=margin-left:40px;?? a?href=CourseListAction.action?index=1?target=mainFrame首页/a?? !--?? c:set?var=pageCount?value=${fn:length(userList)%10==0?fn:length(userList)/10:fn:length(userList)/10+1?}/? --?? ????c:forEach?var=i??begin=1?step=1?end=${lastIndex}?? a?href=CourseListAction.action?index=${i?}??target=mainFramec:out?value=${i?}//a?? /c:forEach?? a?href=CourseListAction.action?in