listsalary.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 times = request.getParameter("times");
	//String id = request.getParameter("id");
	String str = "select * from Salary";
	
	if(times!=null&&!times.equals("")){
		str = str +" where times='"+times+"'";
	}
	//if(id!=null&&!id.equals("")){
		//str = str +" where id='"+id+"'";
	//}
	String json = "";
	UtilsServiceImpl utilsControl = new UtilsServiceImpl();
	List it = utilsControl.checkSalary(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){
			Salary salary = (Salary)it.get(it.size()-1);
			json = json + "{id:'"+salary.getId()+"',personName:'"+salary.getPersonName()+"',salary:"+salary.getSalary()+",times:'"+salary.getTimes()+"',leave:"+salary.getLeave()+",overtime:"+salary.getOvertime()+"}]}";
		}else{
			int length = 0;
			for(int i=start;i<it.size()-1&&i<start+limit-1;i++){
				Salary salary = (Salary)it.get(i);
				length = i;
				json = json + "{id:'"+salary.getId()+"',personName:'"+salary.getPersonName()+"',salary:"+salary.getSalary()+",times:'"+salary.getTimes()+"',leave:"+salary.getLeave()+",overtime:"+salary.getOvertime()+"},";
			}
			Salary salary = (Salary)it.get(length+1);
			json = json + "{id:'"+salary.getId()+"',personName:'"+salary.getPersonName()+"',salary:"+salary.getSalary()+",times:'"+salary.getTimes()+"',leave:"+salary.getLeave()+",overtime:"+salary.getOvertime()+"}]}";
		}
	}
	
	//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);
%>