e代劍客——溫柔一刀

?1 < sqlMap? namespace ="Y_wjlx" > ?
?2
?3 ???????? < resultMap? class ="com.ctgusec.model.Y_wjlx" ?id ="y_wjlx" > ?
?4 ???????????????? < result? property ="wjbh" ?column ="wjbh" ? /> ?
?5 ???????????????? < result? property ="wjmc" ?column ="wjmc" ? /> ?
?6 ???????? </ resultMap > ?
?7 ???????? < select? id ="getAllY_wjlx" ?resultMap ="y_wjlx" > ?
?8 ???????????????? <![CDATA[ ????????????????????????
?9 ????????????????SELECT?wjbh,wjmc?FROM?(SELECT?row_.*,?rownum?rownum_?FROM?(select?wjbh,wjmc,rownum?rn?from?y_wjlx)?row_?WHERE?rownum?<=?#end#)?WHERE?rownum_?>?#start#?
10 ???????????????? ]]> ?
11 ???????? </ select > ?
12
13 </ sqlMap > ?

public ? class ?BaseModel? {?

???????? private ?Integer?start? = ? 0 ;?

???????? private ?Integer?end? = ? 30 ;?

???????? private ?Integer?size? = ? 30 ;?

???????? private ?Integer?currentPage;?

???????? private ?Integer?priviousPage;?

???????? private ?Integer?nextPage;?

???????? public ?BaseModel()? {?
????????????????
????????} ?
???????? public ?BaseModel(Integer?currentPage)? {?
???????????????? if ?(currentPage? > ? 0 )? {?
???????????????????????? this .currentPage? = ?currentPage;?
???????????????????????? this .priviousPage? = ?currentPage? - ? 1 ;?
???????????????????????? this .nextPage? = ?currentPage? + ? 1 ;?
???????????????????????? this .start? = ?priviousPage? * ?size;?
???????????????????????? this .end? = ?currentPage? * ?size;?
????????????????} ?
????????} ?

???????? // 省略geter、serter方法?
} ?

?1 public ? class ?Y_wjlxListAllController? extends ?AbstractController? {?
?2
?3 ????????Integer?currentPage?;?
?4 ????????
?5 ???????? // y_wjlx類繼承BaseModel類?
?6 ????????Y_wjlx?y_wjlx;?
?7
?8 ????????@Override?
?9 ???????? protected ?ModelAndView?handleRequestInternal(HttpServletRequest?request,?
10 ????????????????????????HttpServletResponse?response)? throws ?Exception? {?
11 ????????????????String?page? = ?request.getParameter( " page " );?
12 ???????????????? if ?(page? == ? null ? || ?page.equals( " head " ))? {?
13 ????????????????????????currentPage = 1 ;?
14 ????????????????????????y_wjlx? = ? new ?Y_wjlx(currentPage);?
15 ????????????????????????request.getSession().setAttribute( " currentPage " ,?currentPage);?
16 ????????????????} ?
17 ???????????????? if ?( " privious " .equals(page))? {?
18 ????????????????????????currentPage? = ?(Integer)?request.getSession().getAttribute( " currentPage " );?
19 ???????????????????????? if (currentPage > 1 )?currentPage? -= ? 1 ;?
20 ????????????????????????y_wjlx? = ? new ?Y_wjlx(currentPage);?
21 ????????????????????????request.getSession().setAttribute( " currentPage " ,?currentPage);?
22 ????????????????} ? else ? if ?( " next " .equals(page))? {?
23 ????????????????????????currentPage? = ?(Integer)?request.getSession().getAttribute( " currentPage " );?
24 ????????????????????????currentPage? += ? 1 ;?
25 ????????????????????????y_wjlx? = ? new ?Y_wjlx(currentPage);?
26 ????????????????????????request.getSession().setAttribute( " currentPage " ,?currentPage);?
27 ????????????????} ?
28 ????????????????List?list? = ? this .drv_Manager.getAllY_wjlx(y_wjlx);?
29 ???????????????? return ? new ?ModelAndView( " y_wjlxList " ,? " list " ,?list);?
30 ????????} ?
31
32 ???????? private ?IDrv_Manager?drv_Manager;?
33
34 ???????? public ? void ?setDrv_Manager(IDrv_Manager?drv_Manager)? {?
35 ???????????????? this .drv_Manager? = ?drv_Manager;?
36 ????????} ?
37 }

1 < button? onclick ="location.href??=??'y_wjlxList.shtml?page=head'" > 首&&頁 </ button > ????
2 &&?
3 < button? onclick ="location.href??=??'y_wjlxList.shtml?page=privious'" > 上一頁 </ button > ????
4 &&?
5 < button??? onclick ="location.href='y_wjlxList.shtml?page=next'" > 下一頁 </ button >