listleave.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 personName = request.getParameter("personName");
	String beginTime = request.getParameter("beginTime");
	String id = request.getParameter("id");
	String str = "select * from EmployeerService where type='"+type+"'";
	
	if(personName!=null&&!personName.equals("")){
		str = str +" and personName='"+new String((personName).getBytes("ISO-8859-1"),"gb2312")+"'";
	}
	if(beginTime!=null&&!beginTime.equals("")){
		str = str +" and beginTime='"+beginTime+"'";
	}
	if(id!=null&&!id.equals("")){
		str = str +" and id='"+id+"'";
	}
	String json = "";
	UtilsServiceImpl utilsControl = new UtilsServiceImpl();
	List it = utilsControl.checkSubsidies(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){
			Subsidies sub = (Subsidies)it.get(it.size()-1);
			json = json + "{id:'"+sub.getId()+"',personName:'"+sub.getPersonName()+"',beginTime:'"+sub.getBeginTime()+"',days:"+sub.getDays()+",salary:"+sub.getSalary()+",course:'"+sub.getCourse()+"'}]}";
		}else{
			int length = 0;
			for(int i=start;i<it.size()-1&&i<start+limit-1;i++){
				Subsidies sub = (Subsidies)it.get(i);
				length = i;
				json = json + "{id:'"+sub.getId()+"',personName:'"+sub.getPersonName()+"',beginTime:'"+sub.getBeginTime()+"',days:"+sub.getDays()+",salary:"+sub.getSalary()+",course:'"+sub.getCourse()+"'},";
			}
			Subsidies sub = (Subsidies)it.get(length+1);
			json = json + "{id:'"+sub.getId()+"',personName:'"+sub.getPersonName()+"',beginTime:'"+sub.getBeginTime()+"',days:"+sub.getDays()+",salary:"+sub.getSalary()+",course:'"+sub.getCourse()+"'}]}";
		}
	}
	
	//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);
%>