listemployeer.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.*" %>
<%
	int start = Integer.parseInt(request.getParameter("start"));
	int limit = Integer.parseInt(request.getParameter("limit"));
	//查询条件
	String personName = request.getParameter("personName");
	String personIDCard = request.getParameter("personIDCard");
	String personTel = request.getParameter("personTel");
	String id = request.getParameter("id");
	String str = "select * from Employeer";
	if(personName!=null&&!personName.equals("")){
		str = str +" where personName='"+new String((personName).getBytes("ISO-8859-1"),"gb2312")+"'";
	}
	if(personIDCard!=null&&!personIDCard.equals("")){
		str = str +" and personIDCard='"+personIDCard+"'";
	}
	if(personTel!=null&&!personTel.equals("")){
		str = str +" and personTel='"+personTel+"'";
	}
	if(id!=null&&!id.equals("")){
		str = str +" where id='"+id+"'";
	}
	String json = "";
	UtilsServiceImpl utilsControl = new UtilsServiceImpl();
	List it = utilsControl.checkEmployeer(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()+1+",'user':[";
	}
	if(it!=null&&it.size()>0){
		if(it.size()==1){
			Employeer em = (Employeer)it.get(it.size()-1);
			json = json + "{id:'"+em.getId()+"',personName:'"+em.getPersonName()+"',personDept:'"+em.getPersonDept()+"',personPost:'"+em.getPersonPost()+"',personNational:'"+em.getPersonNational()+"',personNarriage:'"+em.getPersonNarriage()+"',personSex:'"+em.getPersonSex()+"',"+
				"personBirthday:'"+em.getPersonBirthday()+"',personCulture:'"+em.getPersonCulture()+"',personProfessional:'"+em.getPersonProfessional()+"',personYear:'"+em.getPersonYear()+"',personLanguage:'"+em.getPersonLanguage()+"',personSalary:'"+
				em.getPersonSalary()+"',personAddress:'"+em.getPersonAddress()+"',personIDCard:'"+em.getPersonIDCard()+"',personSocialID:'"+em.getPersonSocialID()+"',personAge:"+em.getPersonAge()+",personTel:'"+em.getPersonTel()+"'}]}";
		}else{
			int length = 0;
			for(int i=start;i<it.size()-1&&i<start+limit-1;i++){
				Employeer em = (Employeer)it.get(i);
				length = i;
				json = json + "{id:'"+em.getId()+"',personName:'"+em.getPersonName()+"',personDept:'"+em.getPersonDept()+"',personPost:'"+em.getPersonPost()+"',personNational:'"+em.getPersonNational()+"',personNarriage:'"+em.getPersonNarriage()+"',personSex:'"+em.getPersonSex()+"',"+
					"personBirthday:'"+em.getPersonBirthday()+"',personCulture:'"+em.getPersonCulture()+"',personProfessional:'"+em.getPersonProfessional()+"',personYear:'"+em.getPersonYear()+"',personLanguage:'"+em.getPersonLanguage()+"',personSalary:'"+
					em.getPersonSalary()+"',personAddress:'"+em.getPersonAddress()+"',personIDCard:'"+em.getPersonIDCard()+"',personSocialID:'"+em.getPersonSocialID()+"',personAge:"+em.getPersonAge()+",personTel:'"+em.getPersonTel()+"'},";
			}
			Employeer em = (Employeer)it.get(length+1);
			json = json + "{id:'"+em.getId()+"',personName:'"+em.getPersonName()+"',personDept:'"+em.getPersonDept()+"',personPost:'"+em.getPersonPost()+"',personNational:'"+em.getPersonNational()+"',personNarriage:'"+em.getPersonNarriage()+"',personSex:'"+em.getPersonSex()+"',"+
				"personBirthday:'"+em.getPersonBirthday()+"',personCulture:'"+em.getPersonCulture()+"',personProfessional:'"+em.getPersonProfessional()+"',personYear:'"+em.getPersonYear()+"',personLanguage:'"+em.getPersonLanguage()+"',personSalary:'"+
				em.getPersonSalary()+"',personAddress:'"+em.getPersonAddress()+"',personIDCard:'"+em.getPersonIDCard()+"',personSocialID:'"+em.getPersonSocialID()+"',personAge:"+em.getPersonAge()+",personTel:'"+em.getPersonTel()+"'}]}";
		}
	}
	
	//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);
%>