使用JSON读取和显示数据

public String getModules(int todo, int offset, int pageSize, int total, int moduleNo) { total = getAllModules(todo, 0, 1, moduleNo).getTotal(); int maxPage = total % pageSize == 0 ? total / pageSize : total / pageSize + 1; if (offset < 0) { offset = 0; } else if (offset >= maxPage) { offset = maxPage - 1; } PageModel pm = getAllModules(todo, offset * pageSize, pageSize, moduleNo); List<Menu> list = pm.getDatas(); JSONObject json = new JSONObject();// json父对象 try { // json集合,用来存储json对象 JSONArray members = new JSONArray(); if (list != null && list.size() > 0) { for (int i = 0; i < list.size(); i++) { // json子对象 JSONObject member = new JSONObject(); member.put("menuId", list.get(i).getMenuId()); member.put("menuNo", list.get(i).getMenuNo()); member.put("parentNo", list.get(i).getParentNo()); member.put("menuName", list.get(i).getMenuName()); member.put("linkURL", list.get(i).getLinkURL()); member.put("description", list.get(i).getDescription()); members.add(i, member); } json.put("offset", offset);// 存储当前页===从0开始 json.put("maxPage", maxPage - 1);// 存储最大页数 json.put("total", total);// 存储所有显示条数 json.put("menus", members);// 存储数据 } } catch (Exception e) { e.printStackTrace(); } return json.toString(); }

以上代码方法为从数据库查询，并用json进行封装。

下面代码介绍json的显示：

function jsonview() { var total = $("total1").innerHTML; var offset = $("offset1").value; var pageSize = 5; menuDao.getModules(1,offset, pageSize, total, wirteHtml); } function wirteHtml(data) { var data = eval("(" + data + ")");// 使用eval函数 var continents = data.menus; $("offset1").value = data.offset; $("maxPage1").value = data.maxPage; $("maxPage2").innerHTML = data.maxPage + 1; $("total1").innerHTML = data.total; $("curpage").innerHTML = data.offset + 1; var tab = $("mytables"); var num = tab.rows.length; for ( var i = 0; i < num; i++) { if (tab.rows.length != 2) { tab.deleteRow(tab.rows.length - 2); } } for ( var i = 0; i < continents.length; i++) { var newLine = tab.rows.length; var row = tab.insertRow(newLine - 1); if (i % 2 != 0) { row.className = "odd";// 奇数行 row.onmouseout = function() { this.className = "odd"; } } else { row.className = "even";// 偶数行 row.onmouseout = function() { this.className = "even"; } } row.onmouseover = function() { this.className = "alt"; } row.insertCell(0).innerHTML = "<input style=\"width:20px;\" type=\"radio\" name=\"rdoId\" value=\"" + continents[i].menuNo+ "\" title=\""+ continents[i].menuName+ "\" />"; row.insertCell(1).innerHTML = continents[i].menuNo; row.insertCell(2).innerHTML = continents[i].menuName + ""; if(continents[i].description==''){ row.insertCell(3).innerHTML = '暂无说明'; } else{ row.insertCell(3).innerHTML = continents[i].description; } } }