sysusermodifyinit.java

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

package com.chis.model.user;

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 zxh
 * 
 */
public class SysUserModifyInit extends ActionInstance {

	public int execute(ActionForm af) throws Exception {
		String hbdwbh = (String) af.getHttpSession().getAttribute("HBDWBH");
		DataForm userdf = new DataForm("SYS_USER", "ID");
		String userid = af.getHttpRequest().getParameter("id");

		String usersql = "SELECT [CORP_ID],[ID],[LOGON_NAME],[PASSWORD],[E_MAIL],[NAME],[REG_DATE],[STATUS]\n"
				+ ",[REMARKS],isnull([DEPARTMENT_ID],'') as DEPARTMENT_ID,[CREATE_DATE],[CREATE_USER_NAME]\n"
				+ ",[UPDATE_DATE],[UPDATE_USER_NAME] FROM SYS_USER WHERE ID='"
				+ userid + "'";
		List userlist = DaoUtil.select(af.getConnection(), usersql, userdf);

		// 用户角色
		DataForm userroledf = new DataForm("SYS_USER_ROLE", "ID");
		String userrolesql = "SELECT a.* FROM SYS_USER_ROLE  a right join SYS_ROLE b \n"
				+ "on a.role_id=b.id where a.user_id='" + userid + "'";
		List userrolelist = DaoUtil.select(af.getConnection(), userrolesql,
				userroledf);

		// 用户群组
		DataForm usergroupdf = new DataForm("SYS_USER_GROUP", "ID");
		String usergroupsql = "SELECT a.* FROM SYS_USER_GROUP a right join SYS_GROUP b \n"
				+ "on a.group_id=b.id where a.user_id='" + userid + "'";
		List usergrouplist = DaoUtil.select(af.getConnection(), usergroupsql,
				usergroupdf);

		// 用户所属部门
		DataForm user = (DataForm) userlist.get(0);
		String bmid = null;
		if (!user.get("DEPARTMENT_ID").equals("")) {
			bmid = user.get("DEPARTMENT_ID").toString();
		}

		af.getHttpRequest()
				.setAttribute("userinfo", (DataForm) userlist.get(0));
		af.getHttpRequest().setAttribute("userrolelist", userrolelist);
		af.getHttpRequest().setAttribute("usergrouplist", usergrouplist);
		af.getHttpRequest().setAttribute("bmid", bmid);
		return 1;
	}

}