1,页面基于easyui的表格(自带的分页效果)
<div data-options="region:'center'">
<table id="tt" style="width: 100%; height: 90%;"></table>
</div>
2,JS
var tabl = null, table = null;
$(function() {
tabl = $('#tt').width();// 加载完成后再获取宽度
table = $('#tt');
initGrid();// 初始化表格
});
function initGrid(){
table.datagrid({
type:"post",
url : '.',
striped: true,
pagination: true, //分页栏
rownumbers: true, //行号
fitColumns: true, //拖动框
columns:[[
{field: 'name', title: '配置项名称 ', align: 'center',width:150 },
{field: 'cfgvalue', title: '节点名称', align: 'center',width:150},
{field: 'remark', title: '备注 ', align: 'center',width:150 }
]]
});
}
3,Controller层
@Autowired
@Qualifier("configService")
private ConfigServiceI configService;
@RequestMapping("/listConfig")
@ResponseBody
public Map<String, Object> listConfig(HttpServletRequest request){
List<DmsConfig> list = configService.find();
Map<String, Object> result = new HashMap<String, Object>();
result.put("rows", list);
result.put("total", list.size());
return result;
}
4,service层
4.1,接口
public List<DmsConfig> find( );
4.2,实现类
@Resource
private DmsConfigMapper dmsConfigMapper;
public List<DmsConfig> find() {
return dmsConfigMapper.find();
}
5,DAO层和Mapping
List<DmsConfig> find();
<select id="find" resultMap="BaseResultMap">
select
<include refid="Column_List" />
from dms_config
</select>