j2eeSSH利用JSON实现异步查询，根据条件查询出结果，实现结果部分局部刷新保留查询结果

柔光的暖阳◎ 2022-08-24 11:24 121阅读 0赞

先来看看我们所要填写的查询条件代码：

JS代码：

function startRequest2(pageNo) {  
    					//根据id取得填写条件的值
    					 var startTime = document.getElementById("startdate").value;	//开始时间
    				   	 var endTime = document.getElementById("enddate").value;	//结束时间
    				   	 var state = document.getElementById("state").value;	//状态
    				   	 var CPhone = document.getElementById("receivePhone").value;	//手机号
    				     xmlHttp2.onreadystatechange = function() {	 //回调函数
    					 	handleStateChange2();
    					 };
    					xmlHttp2.open("POST","pointInOrderAction!findCountAgencyOrders",true);  //请求地址,true表示开启异步
    					xmlHttp2.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
    					xmlHttp2.send("page.currentPage=" + pageNo + "&startTime=" + startTime + "&endTime="+endTime + "&state="+state"+"&CPhone="+CPhone);   //发送请求参数,action中setget即可取到
    				}

JS代码：

java代码：

public void findCountAgencyOrders() throws Exception{
    		HttpServletResponse response = ServletActionContext.getResponse();
    		if(currpage>0)
    		{ 
    			Result res = Service.findOrders(page,CPhone,cbNo, state,startTime, endTime);//根据条件查询数据库
    			 page=res.getPage();	
    			// 如果当前页大于总页数，则当前页减1或当前页设为总页数
    			if(currpage>page.getTotalPage())
    			{
    				page.setCurrentPage(page.getTotalPage());
    			}
    			else
    			{
    				page.setCurrentPage(currpage);
    			}
    			currpage=0;
    		}
    		Result res = Service.findOrders(page,CPhone, cbNo, state,startTime, endTime);
    		page=res.getPage();	
    	    List teams =res.getList();
    		try {
    			response.setContentType("text/html;charset=UTF-8");
    			response.getWriter().println(JsonUtil.JsonPage(teams, page));
    		} catch (IOException e) {
    			e.printStackTrace();
    		}	
    	}

java代码，JosonUtil.JsonPage方法：

public static Object zsAgencyOrderlistToJsonPage(List AgencyOrderList,Page pageInfo) {
    		String jsonStr = null;
    		StringBuffer strBuffer = new StringBuffer();
    		strBuffer.append("{");
    		//strBuffer.append("\"pointRechargeRecordList\":[");
    		strBuffer.append("\"AgencyOrderList\":[");
    		//处理pointRechargeRecordList
    		for(int i=0;i<AgencyOrderList.size();i++)
    		{
    			Object[] temp = (Object[]) AgencyOrderList.get(i); 
    			//temp开始
    			strBuffer.append("{");
    			
    			//处理手机号
    			strBuffer.append("\"piaoCPhone\":\"");
    			strBuffer.append((String)temp[1]);
    			strBuffer.append("\","); 
    			//状态
    			strBuffer.append("\"piosName\":\"");
    			strBuffer.append((String)temp[6]);			 	 
    			strBuffer.append("\",") ;
    					
    			//更新时间
    			strBuffer.append("\"updateTime\":\"");
    			strBuffer.append((String)temp[8]);			 	 
    			strBuffer.append("\"") ;
    			//team结束
    			if(i<AgencyOrderList.size()-1)
    			{
    			strBuffer.append("},");
    			}
    			else
    			{
    				strBuffer.append("}");
    			} 
    		} 
    		//golddetaillist结束
    		strBuffer.append("],"); 
    		//pageInfo开始
    		strBuffer.append("\"pageInfo\":{");
    		//处理pageRows 
    		strBuffer.append("\"pageRows\":");
    		strBuffer.append(pageInfo.getEveryPage());
    		strBuffer.append(",");
    		//处理currentPage
    		strBuffer.append("\"currentPage\":");
    		strBuffer.append(pageInfo.getCurrentPage());
    		strBuffer.append(",");
    		//处理totalCount
    		strBuffer.append("\"totalCount\":");
    		strBuffer.append(pageInfo.getTotalCount());
    		strBuffer.append(",");
    		//处理pageTotal
    		strBuffer.append("\"pageTotal\":");
    		strBuffer.append(pageInfo.getTotalPage());
    	 
    	    //pageInfo结束
    		strBuffer.append("}");
    		//json结束
    		strBuffer.append("}");
    		jsonStr = strBuffer.toString(); 
    		return jsonStr;
    	}

jsp显示结果表头代码：

<table id="teamTable" class="bussiness_center" cellpadding="0" cellspacing="0"> 
    										<tr style="font-weight: bold;"> 
    											
    											<th>
    												收件人手机号
    											</th> 
    											
    											<th>
    												状态
    											</th>
    											<th>
    												类型
    											</th>
    											<th>
    												更新时间
    											</th>
    										</tr>
    						</table>
    						<div id="page"></div>

望加指点。