1. 控制层
private SqlSessionFactoryBean sqlSessionFactory ; @ResponseBody @RequestMapping(value = "f3") public String f3( @RequestBody SearchMap searchMap,HttpServletRequest request, HttpServletResponse response) { SqlSession session = null; try { SqlSessionFactory object = sqlSessionFactory.getObject(); String sqlId = request.getParameter("sqlId"); Pagepage = new Page (request, response);// 相互插入 searchMap.setPage(page); session = object.openSession(); List listMap = session.selectList(sqlId, searchMap); page.setList(listMap); return JsonMapper.toJsonString(page); // 查询结果为0,则返回page为0的记录 }catch(Exception e){ Result resultError = new Result(); resultError.setCode("false"); resultError.setMessage(e.toString());// // log4j.输出信息! return JsonMapper.toJsonString(resultError); // 如果查询语句不存在,则抛出异常! } finally { session.close(); } } 接受的参数类似public class SearchMap extends HashMap { /** * 当前实体分页对象 */ protected Page page; public Page getPage() { return page; } public void setPage(Page page) { this.page = page; }}sql语句 返回错误代码 public class Result{ private String message; private String code; public String getMessage() { return message; } public void setMessage(String message) { this.message = message; } public String getCode() { return code; } public void setCode(String code) { this.code = code; }
2. 前端代码
function page(n,s){ // 下一页 $.ajax({ url :'${ctx}/test/testData/f3?sqlId=test.get2&pageNo='+n+'&pageSize='+s, type: 'post', dataType : "json", contentType:'application/json;charset=UTF-8',//关键是要加上这行 data : JSON.stringify( {id:'22',remarks:'aaa'}), async : false, // 同步请求 success : function(data) { if(data.code=='false'){ alert("代码错误!"); console.log("错误代码是:"+data.message); }else{ $('#pageId').html(data.html); } } }); }初始化页面$.ajax({ url :'${ctx}/test/testData/f3?sqlId=test.get2', type: 'post', dataType : "json", contentType:'application/json;charset=UTF-8',//关键是要加上这行 data : JSON.stringify( {id:'222',remarks:'aaa'}), async : false, // 同步请求 success : function(data) { if(data.code=='false'){ alert("代码错误!"); console.log("错误代码是:"+data.message); }else{ $('#pageId').html(data.html); } } });