ligerGrid简单例子--通过后台转数据

最新推荐文章于 2023-09-10 11:05:57 发布

weixin_30736301

最新推荐文章于 2023-09-10 11:05:57 发布

阅读量229

点赞数

文章标签： json javascript java ViewUI

原文链接：http://www.cnblogs.com/rdchen/p/11050129.html

版权

jsp页面如下：

<c:set var="ctx" value="${pageContext.request.contextPath}" />
<%@include file="/commons/include/html_doctype.html" %>
<%@taglib prefix="f" uri="http://www.jee-soft.cn/functions" %>
<html>
<head>
<title>注入信息提示</title>
<%-- <%@include file="/commons/include/get.jsp" %> --%>
<f:link href="Aqua/css/ligerui-all.css"></f:link>
<script type="text/javascript" src="${ctx}/oms/js/jquery/jquery.js"></script>
<script type="text/javascript" src="${ctx}/oms/js/lg/ligerui.min.js"></script>
<script type="text/javascript" src="${ctx}/oms/js/lg/plugins/ligerGrid.js"></script>

var columns =
        [
            { display: '登录时间', name: 'dlsj'},
            { display: '登录人', name: 'dlr' },
            { display: '登录IP', name: 'dlIP' }
         ];

$(function() {
$("#maingrid").ligerGrid({
width:1000,
dataAction:'server',
columns:columns,
// data:jsonObj,
url:"${ctx}/oms/appCrd/appCrd/zdhzbdatecount/zdhzbdatecount.ht",
//向后台提交的数据根据systemId来进行排序
sortName: 'dlsj',
//向后台提交的数据排序方向为升序
sortorder:'asc',
//后台提交的数据每页显示的记录数
pageSize: 10,
usePager:true, //数据书否分页，默认为true
pageSizeOptions:[10,50,100],//可指定每页页面大小
onSelectRow: function (rowdata, rowindex, rowobj) {
//选中行事件。。。
//alert($(rowobj).val());
},
checkbox: false,
height: '100%',
rownumbers: true
});

});

</script>
</head>
<body>
<div id="maingrid"></div>
</body>
</html>

java代码：

@RequestMapping("zdhzbdatecount")
public @ResponseBody
JSONObject zdhzbdatecount(HttpServletRequest request, HttpServletResponse response) throws Exception {
List<Zdhzbdatecount> list = new ArrayList<Zdhzbdatecount>();

SysAuditService sysAuditService = AppUtil.getBean(SysAuditService.class);
List<SysAudit> listSys = sysAuditService.getAll(new QueryFilter(request, "sysAuditItem"));

for (SysAudit e : listSys) {
Zdhzbdatecount entity = new Zdhzbdatecount();
entity.setDlIP(e.getFromIp());
if(e.getExecutor()==null){
entity.setDlr("无");
}else {
entity.setDlr(e.getExecutor());
}
entity.setDlsj(e.getExeTime());
list.add(entity);
}
String jsonstring = JSON.toJSONString(list);
JSONObject object = new JSONObject();

JSON.DEFFAULT_DATE_FORMAT = "yyyy-MM-dd";
String format = JSON.toJSONString(list, SerializerFeature.WriteDateUseDateFormat);

// object.put("Rows", JSON.parseArray(jsonstring));
object.put("Rows", JSON.parseArray(format));
object.put("Total", list.size());
return object;
}