viewpopedomaction.java

一套完整的档案管理系统

package com.stsc.archive.manage;

import javax.servlet.http.*;
import org.apache.struts.action.*;
import java.util.Properties;

import org.apache.struts.util.MessageResources;
import com.stsc.util.STPoolDataSet;
import com.stsc.util.STResultSet;

public final class ViewPopedomAction extends Action
{
	public ActionForward perform(ActionMapping mapping,
		ActionForm form, HttpServletRequest req,
		HttpServletResponse res)
	{
		System.out.println("mapping.getAttribute(): = " + mapping.getAttribute());
		System.out.println("mapping.getScope(): = " + mapping.getScope());
		
		String roleId = req.getParameter("roleId");
		int iRoleId = Integer.parseInt(roleId);
		System.out.println(roleId);
/**		
		Properties dbBase = new Properties();
        dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
        
        STPoolDataSet data = new STPoolDataSet();
        String sql = "SELECT EnterName,UserName FROM fUserName where EnterName IN (SELECT EnterName from fUserRole WHERE RoleID=" + iRoleId + ")";
        System.out.println("begin viewPopedomAction db...");
        STResultSet rs = data.getSTResult(sql, dbBase);
        System.out.println("viewPopedomAction db end");
        
        PopedomUserList users = new PopedomUserList();
        
        while(rs!=null && rs.next()) 
        {
        	User user = new User();
        	
        	user.setEnterName(rs.getString("EnterName"));
        	user.setUserName(rs.getString("UserName"));
        	
        	users.addUser(user);
        }
        users.setRoleid(iRoleId);
        
        HttpSession session = req.getSession();
        session.setAttribute("popedomUsers", users);
        
        //--------为隐藏域所用------------------------
        RoleUser roleuser = new RoleUser();
        roleuser.setRoleid(iRoleId);
        session.setAttribute("ROLEID", roleuser);
        //============================================
        
        String strRole = "";
        sql = "SELECT Role FROM fRole WHERE RoleID=" + iRoleId;
        rs = data.getSTResult(sql, dbBase);
        while(rs!=null && rs.next()) 
        {
        	strRole = rs.getString("Role");
        }
        session.setAttribute("role", strRole);
        System.out.println(strRole);
 */
 		CommonSql comsql = new CommonSql();
 		comsql.ToViewPopedom(form, req, iRoleId);
        
        return mapping.findForward("success");
	}
}