savepopedomuseraction.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 SavePopedomUserAction 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());
		
		Properties dbBase = new Properties();
        dbBase.setProperty("dsJndiName", Constants.ARCHIVE_DBSOURCE_KEY);
        STPoolDataSet data = new STPoolDataSet();
        
        String enterName = req.getParameter("enterName");
        System.out.println(enterName);
        
        String delSql = "DELETE FROM fUserRole WHERE EnterName='" + enterName + "'";
        data.executeSQL(delSql, dbBase);
       
        String[] strValues = req.getParameterValues("roleids");
        if( (strValues != null) && (strValues.length > 0) )
        {        	
        	System.out.println(strValues.length);
        	int iLeng = strValues.length;
        	for(int i=0; i<iLeng; i++)
        	{
        		String addSql = "INSERT INTO fUserRole(EnterName, RoleID) VALUES('" + enterName + "'," + Integer.parseInt(strValues[i]) + ")";
        		data.executeSQL(addSql, dbBase);
        	}
        }

		CommonSql comsql = new CommonSql();
 		comsql.ToUserManager(form, req);
/**        
        //----------------------------------------------------------------------------------------
        String sql = "SELECT * FROM fUserName ORDER BY EnterName";
        STResultSet rs = data.getSTResult(sql, dbBase);
        
        UserList userList = new UserList();
        
        while(rs!=null && rs.next()) 
        {
        	User user = new User();
        	
        	user.setEnterName(rs.getString("EnterName"));
        	user.setUserName(rs.getString("UserName"));
        	user.setDepartment(rs.getString("Department"));
            
            userList.addUser(user);
        }
        
        // Save our logged-in user in the session
		HttpSession session = req.getSession();
        session.setAttribute(Constants.USER_MANAGE_KEY, userList);
        //========================================================================================
*/		
		System.out.println("保存用户权限完成");
        return mapping.findForward("success");
	}
}