sysdeptmodifyinit.java

用JSP JAVA 做的 系统 只是初来扎到还望西黄！别乱来哦！

package com.chis.model.user;

import java.util.ArrayList;
import java.util.List;

import com.stframe.dao.DaoUtil;
import com.stframe.form.ActionForm;
import com.stframe.form.DataForm;
import com.stframe.servlet.ActionInstance;
/**
 * 修改部门初始化
 * @author baobao
 *
 */
public class SysDeptModifyInit extends ActionInstance{

	public int execute(ActionForm af) throws Exception {
		String shbdwbh =af.getHttpSession().getAttribute("HBDWBH").toString();
		String id = af.getHttpRequest().getParameter("id");
		DataForm deptdf = new DataForm("DEPT");
		/*String deptsql = "SELECT * FROM DEPT WHERE ID='"+id+"'";*/
		//部门信息
		StringBuffer sbsql = new StringBuffer();
		sbsql.append("SELECT D.ID,D.CODE,D.NAME,D.PARENT_ID,D.DIRECTOR ");
		sbsql.append(" FROM DEPT D ");
		sbsql.append("  WHERE D.ID='"+id+"'");
		DataForm deptinfo = (DataForm)DaoUtil.select(af.getConnection(),sbsql.toString(),deptdf).get(0);	
		
		//部门用户
		DataForm udf = new DataForm("SYS_USER","ID");
		String usersql= "SELECT a.* FROM SYS_USER a left join DEPT b on a.DEPARTMENT_ID=b.id  where a.DEPARTMENT_ID='"+id+"' AND A.CORP_ID='"+shbdwbh+"'";
		List deptuserlist = DaoUtil.select(af.getConnection(),usersql,udf);
		
		String uhid = "";
		String ushow = "";
		for(int i = 0;i<deptuserlist.size();i++ )
		{
			DataForm dudf = (DataForm)deptuserlist.get(i);
			if(uhid=="")
			{
				ushow = dudf.get("NAME").toString();
				uhid = dudf.get("ID").toString();
			}
			else{
				ushow = ushow + "," + dudf.get("NAME").toString();
				uhid = uhid + "," + dudf.get("ID").toString();
			}	
		}
		if(uhid!="")
		{
			 uhid = uhid + ",";
			 ushow = ushow + ",";
		}
		af.getHttpRequest().setAttribute("deptinfo",deptinfo);
//		af.getHttpRequest().setAttribute("deptuserlist",deptuserlist);
		af.getHttpRequest().setAttribute("ushow",ushow);
		af.getHttpRequest().setAttribute("uhid",uhid);
		
		return 1;
	}

}