ibatis_ECside数据库分页

mikzhang

浏览: 664658 次
性别:
来自: 北京

最近访客更多访客>>

hui963966800

poterliu

ABuFan

auhenzh

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

JSP:

<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%>

<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core_rt"%>

<%@ taglib prefix="ec" uri="http://www.ecside.org" %>

<%@ page isELIgnored="false"%>

<html>

<head>

<title>test ECtable 数据库分页</title>

</head>

<body>

<tr>

<ec:table items="list" var="list"

retrieveRowsCallback="limit"

sortRowsCallback="limit"

filterRowsCallback="limit"

action="XXX.action"

editable="false"

width="100%"

listWidth="100%"

classic="true"

doPreload="false"

useAjax="true"

resizeColWidth="false"

batchUpdate="true"

nearPageNum="0"

toolbarLocation="top"

pageSizeList="10,20,50"

xlsFileName="table1.xls"

showPrint="true"

filterable="false"

<ec:row style="text-align:center">

<ec:column width="5%" property="_0" title="序号" value="${GLOBALROWCOUNT}" style="text-algin:center" editable="false"/>

<ec:column width="40%" property="userid" title="用户标识" style="text-align:center" editable="false" sortable="true"/>

<ec:column width="40%" property="username" title="用户姓名" style="text-align:center" editable="false" sortable="true"/>

</ec:row>

<c:if test="${msg != null}">

<ec:extendrow>

</ec:extendrow>

</c:if>

</ec:table><br>

</td>

</tr>

</table>

</body>

function myrefresh()

{

ECSideUtil.reload('ec');

setTimeout('myrefresh()',10000); //指定1秒刷新一次 1000=1秒

}

setTimeout('myrefresh()',1000); //指定1秒刷新一次 1000=1秒

</script>

</html>

POJO:

public class TestVO {

private String userid;//用户标识

private String username;//用户姓名

//分页用

private int startRow;

private int endRow;

private String order;

private String sort;

public int getEndRow() {

return endRow;

}

public void setEndRow(int endRow) {

this.endRow = endRow;

}

public String getOrder() {

return order;

}

public void setOrder(String order) {

this.order = order;

}

public String getSort() {

return sort;

}

public void setSort(String sort) {

this.sort = sort;

}

public int getStartRow() {

return startRow;

}

public void setStartRow(int startRow) {

this.startRow = startRow;

}

public String getUserid() {

return userid;

}

public void setUserid(String userid) {

this.userid = userid;

}

public String getUsername() {

return username;

}

public void setUsername(String username) {

this.username = username;

}

ACTION:

public class TestAction extends ActionSupport {

private MailService mailService;

public TestService getTestService() {

return testService;

}

public void setTestService testService;{

this.testService;= testService;

}

public String searchTestList() throws Exception {

HttpServletRequest request = ServletActionContext.getRequest();

TestVO vo=new TestVO();

Limit limit = RequestUtils.getLimit(request);

String sort=limit.getSort().getProperty();

String order=limit.getSort().getSortOrder();

int totalRows = RequestUtils.getTotalRowsFromRequest(request);

if (totalRows < 0) {

totalRows = mailService.countGetTestList(vo);

}

limit.setRowAttributes(totalRows, 20);

int offset = 0;

int[] rowStartEnd = new int[] { limit.getRowStart() + offset,limit.getRowEnd() + offset };

if (rowStartEnd[1] == 0) {

rowStartEnd[1] = 20;

}

vo.setStartRow(rowStartEnd[0]);

vo.setEndRow(rowStartEnd[1]);

vo.setOrder(order);

vo.setSort(sort);

List list = testService.getTestList(vo);

if(!list.isEmpty()){

request.setAttribute("list", list);

}else{

request.setAttribute("msg", "没有符合条件的记录！");

}

return SUCCESS;

}

IBATIS XML:

<?xml version="1.0" encoding="utf-8"?>

<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"

"http://ibatis.apache.org/dtd/sql-map-2.dtd">

<![CDATA[

SELECT * FROM (SELECT pagetable.*,ROWNUM AS rowcounter FROM (

SELECT userid,username FROM users where trunc(rksj)=trunc(sysdate)

) pagetable) subt WHERE subt.rowcounter>#startRow#

AND subt.rowcounter<=#endRow#

]]>

</select>

SELECT count(userid) users where trunc(rksj)=trunc(sysdate)

</select>

</sqlMap>

分享到：

cmd_中文转换为ascii | 页面表格导出Excel(无插件)

2013-01-02 14:42
浏览 1091
评论(0)
分类:企业架构
查看更多

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论