listorder.jsp

一个简单的Ext例子

<%@ page language="java" contentType="text/html; charset=GBK"
    pageEncoding="GBK"%>
<%@ page import="com.utils.service.Impl.*" %>
<%@ page import="com.utils.model.*" %>
<%@ page import="java.util.*" %>
<%
	System.out.println("执行查询页面");
	int start = Integer.parseInt(request.getParameter("start"));
	int limit = Integer.parseInt(request.getParameter("limit"));
	//查询条件
	String type = request.getParameter("type");
	String goodsName = request.getParameter("goodsName");
	String times = request.getParameter("times");
	String id = request.getParameter("id");
	String str = "select * from Orders where type='"+type+"'";
	
	if(goodsName!=null&&!goodsName.equals("")){
		str = str +" and goodsName='"+new String((goodsName).getBytes("ISO-8859-1"),"gb2312")+"'";
	}
	if(times!=null&&!times.equals("")){
		str = str +" and times='"+times+"'";
	}
	if(id!=null&&!id.equals("")){
		str = str +" and id='"+id+"'";
	}
	String json = "";
	UtilsServiceImpl utilsControl = new UtilsServiceImpl();
	List it = utilsControl.checkOrder(str);
	if(it==null||it.size()==0){
		json = "{totalProperty:0,'user':[]}";
		//json = json + "{id:'03101114',personName:'周俊',personDept:'aaaaa',personPost:'职员',personNational:'汉族',personNarriage:'未婚',personSex:'男',"+
		//"personBirthday:'1985-3-18',personCulture:'本科',personProfessional:'计算机',personYear:'2年',personLanguage:'4级',personSalary:'4500',personAddress:'柳洲',personIDCard:'111',personSocialID:'111',personAge:25,personTel:'111'}"+
		//"]}";
	}else{
		json = "{totalProperty:"+it.size()+",'user':[";
	}
	if(it!=null&&it.size()>0){
		if(it.size()==1){
			Order o = (Order)it.get(it.size()-1);
			json = json + "{id:'"+o.getId()+"',customerName:'"+o.getCustomerName()+"',goodsName:'"+o.getGoodsName()+"',count:"+o.getCount()+",times:'"+o.getTimes()+"',prices:"+o.getPrices()+",goodsNote:'"+o.getGoodsNote()+"'}]}";
		}else{
			int length = 0;
			for(int i=start;i<it.size()-1&&i<start+limit-1;i++){
				Order o = (Order)it.get(i);
				length = i;
				json = json + "{id:'"+o.getId()+"',customerName:'"+o.getCustomerName()+"',goodsName:'"+o.getGoodsName()+"',count:"+o.getCount()+",times:'"+o.getTimes()+"',prices:"+o.getPrices()+",goodsNote:'"+o.getGoodsNote()+"'},";
			}
			Order o = (Order)it.get(length+1);
			json = json + "{id:'"+o.getId()+"',customerName:'"+o.getCustomerName()+"',goodsName:'"+o.getGoodsName()+"',count:"+o.getCount()+",times:'"+o.getTimes()+"',prices:"+o.getPrices()+",goodsNote:'"+o.getGoodsNote()+"'}]}";
		}
	}
	
	//String json = "";
	//json = "{totalProperty:2,'user':["+
		//"{id:'03101058',personName:'刘建明',personDept:'开发一部',personPost:'Java程序员',personNational:'汉族',personNarriage:'未婚',personSex:'男',"+
		//"personBirthday:'1984-4-1',personCulture:'本科',personProfessional:'计算机',personYear:'2年',personLanguage:'4级',personSalary:'3500',personAddress:'茂名',personIDCard:'111',personSocialID:'111',personAge:25,personTel:'111'},"+
		//"{id:'03101114',personName:'周俊',personDept:'aaaaa',personPost:'职员',personNational:'汉族',personNarriage:'未婚',personSex:'男',"+
		//"personBirthday:'1985-3-18',personCulture:'本科',personProfessional:'计算机',personYear:'2年',personLanguage:'4级',personSalary:'4500',personAddress:'柳洲',personIDCard:'111',personSocialID:'111',personAge:25,personTel:'111'}"+
		//"]}";
	response.getWriter().write(json);
%>