jeesite mybatis sql 调用

2019独角兽企业重金招聘Python工程师标准>>>

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");
			Page<SearchMap> page = new Page<SearchMap>(request, response);// 相互插入
			searchMap.setPage(page);
			session = object.openSession();
			List<SearchMap>	 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<String, String>{
	/**
	 * 当前实体分页对象
	 */
	protected Page<SearchMap> page;
	public Page<SearchMap> getPage() {
		return page;
	}
	public void setPage(Page<SearchMap> page) {
		this.page = page;
	}
}
sql语句
<select id="get2" resultType="map">
		SELECT 
			<include refid="testDataColumns"/>
		FROM test_data a
	</select>
返回错误代码
	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);
			        	}
			        }
			    });

 

转载于:https://my.oschina.net/u/1760858/blog/856980