OA系统

开发平台：
Java

PopegroupAddAction.java~38~：源码内容
							package officeol.mc.actions;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForm;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.Action;
import java.io.UnsupportedEncodingException;
import officeol.mc.tools.*;
public class PopegroupAddAction extends Action {
    public ActionForward execute(ActionMapping mapping, ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response) {
        try {
            request.setCharacterEncoding("GBK");
        } catch (UnsupportedEncodingException ex) {
            ex.printStackTrace();
        }
        try {
            String num = request.getParameter("num");
            String[] ids = new String[Integer.parseInt(num)];
            String pgname = request.getParameter("pgname");
            //System.out.println("pgname "+pgname);
            String[] sql = new String[Integer.parseInt(num)];
            DBConn dbc = new DBConn();
            if (!pgname.equals("")) {
                String[][] chcek = dbc.getArray(
                        "SELECT * FROM popedomgroup WHERE popegroup='" + pgname +
                        "'");
                if (chcek != null) {
                    String msg = "用户组" + pgname + "已经存在，请重新输入新的用户组名！";
                    request.setAttribute("msg", msg);
                    return mapping.findForward("err");
                }
                for (int i = 0; i < ids.length; i++) {
                    ids[i] = request.getParameter("id" + i);
                    if (ids[i] != null) {
                        sql[i] =
                                "insert into popedomgroup (popeid,popegroup) values(" +
                                ids[i] + ",'" + pgname + "')";
                        dbc.executeUpdate(sql[i]);
                    }
                }
                System.out.print("添加新用户" + pgname + "组成功！");
                request.setAttribute("msg", "添加新用户" + pgname + "组成功！");
                return mapping.findForward("succ");
            } else {
                request.setAttribute("msg", "paname is null");
                return mapping.findForward("err");
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
        return mapping.findForward("err");
    }
}

						