package?com.java1234.action;

import?java.sql.Connection;
import?java.sql.ResultSet;

import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?org.apache.struts2.ServletActionContext;

import?net.sf.json.JSONArray;
import?net.sf.json.JSONobject;

import?com.java1234.dao.DepartmentDao;
import?com.java1234.dao.EmployeeDao;
import?com.java1234.model.Department;
import?com.java1234.model.PageBean;
import?com.java1234.util.DbUtil;
import?com.java1234.util.JsonUtil;
import?com.java1234.util.ResponseUtil;
import?com.java1234.util.StringUtil;
import?com.opensymphony.xwork2.ActionSupport;

public?class?DepartmentAction?extends?ActionSupport{
	
	private?Department?department;
	private?String?s_departmentName=““;
	private?String?page;
	private?String?rows;
	private?String?id;
	private?String?delIds;
	
	public?Department?getDepartment（）?{
		return?department;
	}
	public?void?setDepartment（Department?department）?{
		this.department?=?department;
	}
	
	public?String?getS_departmentName（）?{
		return?s_departmentName;
	}
	public?void?setS_departmentName（String?s_departmentName）?{
		this.s_departmentName?=?s_departmentName;
	}

	public?String?getPage（）?{
		return?page;
	}
	public?void?setPage（String?page）?{
		this.page?=?page;
	}
	public?String?getRows（）?{
		return?rows;
	}
	public?void?setRows（String?rows）?{
		this.rows?=?rows;
	}


	public?String?getDelIds（）?{
		return?delIds;
	}
	public?void?setDelIds（String?delIds）?{
		this.delIds?=?delIds;
	}
	public?String?getId（）?{
		return?id;
	}
	public?void?setId（String?id）?{
		this.id?=?id;
	}

	DbUtil?dbUtil=new?DbUtil（）;
	DepartmentDao?departmentDao=new?DepartmentDao（）;
	EmployeeDao?employeeDao=new?EmployeeDao（）;
	@Override
	public?String?execute（）?throws?Exception?{
		Connection?con=null;
		PageBean?pageBean=new?PageBean（Integer.parseInt（page）Integer.parseInt（rows））;
		try?{
			if（department==null）{
				department=new?Department（）;
			}
			department.setDepartmentName（s_departmentName）;
			
			con=dbUtil.getCon（）;
			JSONobject?result=new?JSONobject（）;
			ResultSet?rs=departmentDao.departmentList（conpageBeandepartment）;
			JSONArray?jsonArray=JsonUtil.formatRsToJsonArray（rs）;
			int?total=departmentDao.departmentCount（con）;
			result.put（“rows“?jsonArray）;
			result.put（“total“?total）;
			HttpServletResponse?response=ServletActionContext.getResponse（）;
			ResponseUtil.write（response?result）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}finally{
			try?{
				dbUtil.closeCon（con）;
			}?catch?（Exception?e）?{
				e.printStackTrace（）;
			}
		}
		return?null;
	}
	
	public?String?delete（）throws?Exception{
		Connection?con=null;
		try?{
			con=dbUtil.getCon（）;
			JSONobject?result=new?JSONobject（）;
			String?str[]=delIds.split（““）;
			for（int?i=0;i				boolean?f=employeeDao.getEmployeeByDepartmentId（con?str[i]）;
				if（f）{
					result

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????3483??2013-07-24?16:22??人事管理系統(tǒng)\db_personmanage.sql

?????文件????????833??2013-07-04?09:54??人事管理系統(tǒng)\PersonManage\.classpath

?????文件???????1045??2013-07-04?10:02??人事管理系統(tǒng)\PersonManage\.project

?????文件????????503??2013-07-04?09:54??人事管理系統(tǒng)\PersonManage\.settings\.jsdtscope

?????文件????????395??2013-07-04?09:54??人事管理系統(tǒng)\PersonManage\.settings\org.eclipse.jdt.core.prefs

?????文件????????465??2013-07-04?10:02??人事管理系統(tǒng)\PersonManage\.settings\org.eclipse.wst.common.component

?????文件????????345??2013-07-04?09:54??人事管理系統(tǒng)\PersonManage\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2013-07-04?09:54??人事管理系統(tǒng)\PersonManage\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2013-07-04?09:54??人事管理系統(tǒng)\PersonManage\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????6708??2013-07-23?08:30??人事管理系統(tǒng)\PersonManage\build\classes\com\java1234\action\DepartmentAction.class

?????文件??????11142??2013-07-24?15:36??人事管理系統(tǒng)\PersonManage\build\classes\com\java1234\action\EmployeeAction.class

?????文件???????2777??2013-07-23?08:30??人事管理系統(tǒng)\PersonManage\build\classes\com\java1234\action\UserAction.class

?????文件???????3336??2013-07-23?08:30??人事管理系統(tǒng)\PersonManage\build\classes\com\java1234\dao\DepartmentDao.class

?????文件???????8274??2013-07-24?15:34??人事管理系統(tǒng)\PersonManage\build\classes\com\java1234\dao\EmployeeDao.class

?????文件???????1517??2013-07-23?08:30??人事管理系統(tǒng)\PersonManage\build\classes\com\java1234\dao\UserDao.class

?????文件???????1008??2013-07-23?08:30??人事管理系統(tǒng)\PersonManage\build\classes\com\java1234\model\Department.class

?????文件???????3774??2013-07-24?15:33??人事管理系統(tǒng)\PersonManage\build\classes\com\java1234\model\Employee.class

?????文件????????878??2013-07-23?08:30??人事管理系統(tǒng)\PersonManage\build\classes\com\java1234\model\PageBean.class

?????文件????????936??2013-07-23?08:30??人事管理系統(tǒng)\PersonManage\build\classes\com\java1234\model\User.class

?????文件???????1037??2013-07-23?08:30??人事管理系統(tǒng)\PersonManage\build\classes\com\java1234\util\DateUtil.class

?????文件???????1948??2013-07-23?08:30??人事管理系統(tǒng)\PersonManage\build\classes\com\java1234\util\DbUtil.class

?????文件???????1533??2013-07-23?08:30??人事管理系統(tǒng)\PersonManage\build\classes\com\java1234\util\JsonUtil.class

?????文件????????951??2013-07-23?08:30??人事管理系統(tǒng)\PersonManage\build\classes\com\java1234\util\ResponseUtil.class

?????文件????????633??2013-07-23?08:30??人事管理系統(tǒng)\PersonManage\build\classes\com\java1234\util\StringUtil.class

?????文件????????713??2013-07-23?08:49??人事管理系統(tǒng)\PersonManage\build\classes\struts.xml

?????文件???????5150??2013-07-17?19:07??人事管理系統(tǒng)\PersonManage\src\com\java1234\action\DepartmentAction.java

?????文件???????9608??2013-07-24?15:36??人事管理系統(tǒng)\PersonManage\src\com\java1234\action\EmployeeAction.java

?????文件???????1688??2013-07-06?21:11??人事管理系統(tǒng)\PersonManage\src\com\java1234\action\UserAction.java

?????文件???????2172??2013-07-13?14:34??人事管理系統(tǒng)\PersonManage\src\com\java1234\dao\DepartmentDao.java

?????文件???????8590??2013-07-24?15:34??人事管理系統(tǒng)\PersonManage\src\com\java1234\dao\EmployeeDao.java

............此處省略631個(gè)文件信息