读取数据库的内容用easyui数据表格输出角色列表

来源：互联网发布：三菱plc编程电缆编辑：程序博客网时间：2024/05/22 07:55

rolelist.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<!DOCTYPE html>
<html>
<head>
<title>userlist</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE9" />
<meta name="keywords" content="keyword1,keyword2,keyword3">
<link rel="stylesheet" type="text/css" href="css/themes/icon.css">
<link rel="stylesheet" type="text/css" href="css/themes/metro/easyui.css" />
<link rel="stylesheet" type="text/css" href="css/base.css">
<script type="text/javascript" src="js/jquery-1.9.1.js"></script>
<script type="text/javascript" src="js/jquery.json-2.4.js"></script>
<script type="text/javascript" src="js/json2.js"></script>
<script type="text/javascript" src="js/jquery.easyui.min.js"></script>
<script type="text/javascript" src="js/locale/easyui-lang-zh_CN.js"></script>
<style type="text/css">
* {
margin: 0px;
padding: 0px;
}
</style>
</head>

<body>
<table id="examineUserList" fit="true" pagination="true"></table>
</body>
<script type="text/javascript">
$(function(){
function columnWidth(){
return 200;
}
var columns = [[{
field: "ck",
checkbox: "true"
}, {
field: 'id',
title: 'ID',
width: columnWidth(),
sortable: true,
align: 'center',
}, {
field: 'name',
title: '角色名字',
width: columnWidth(),
sortable: true,
align: 'center',
}]];
function columnWidth() {
var width = $(window).width()-39;
return parseInt(width / 2);
}
// 加载全部数据
$('#examineUserList').datagrid({
url: 'Users_getroleList.do',
columns: columns,
pageSize: 20,
showFooter:true,
});
// 设置分页控件
var p = $('#examineUserList').datagrid('getPager');
$(p).pagination({
// 每页显示的记录条数，默认为10
pageList: [20, 50, 100],
// 可以设置每页记录条数的列表
beforePageText: '第',
// 页数文本框前显示的汉字
afterPageText: '页共 {pages} 页',
displayMsg: '当前显示 {from} - {to} 条记录共 {total} 条记录',
});
});
</script>
</html>

action方法

/**
* 获取角色列表
* @return
*/
public void getroleList() {
try {
Map<String, Object> jsonMap = new HashMap<String, Object>();
List<Roles> rolesList = new ArrayList<Roles>();
rolesList=rolesService.getListForPage(null,null,pageNumber, pageSize, order, sort);
jsonMap.put("total", rolesService.getCount());
jsonMap.put("rows", rolesList);
out.write(JsonUtil.object2Json(jsonMap));
jsonMap = null;
} catch (Exception e) {
e.printStackTrace();
}
}

0 0