groupadminhandler.java~7~

一个自己做的公司网站和办公职员管理系统。

package ws.woa.handler;

import java.io.PrintWriter;
import java.sql.Connection;

import ws.woa.core.AbstractModuleHandler;
import ws.woa.core.ApplicationException;
import ws.woa.core.Constants;
import ws.woa.core.GroupDBAccessor;
import ws.woa.core.GroupInfo;
import ws.woa.core.GroupType;
import ws.woa.core.Request;
import ws.woa.core.Response;
import ws.woa.util.ValidatorSet;
import ws.woa.util.DefaultValidator;


/**
 * 僌儖乕僾娗棟婡擻偺僴儞僪儔丅
 *
 * @author Wang
 */
public class GroupAdminHandler extends AbstractModuleHandler {

    /**
     * @see ws.woa.core.ModuleHandler#doProcess(Request, Response)
     */
    public void doProcess(Request request, Response response) throws Exception {

        PrintWriter out = response.getWriter();
        out.println("<H2>僌儖乕僾娗棟</H2>");

        if(request.getParameter("INSERT_FORM")!=null){
            insertForm(request,response);
            return;
        } else if(request.getParameter("UPDATE_FORM")!=null){
            updateForm(request,response);
            return;
        } else if(request.getParameter("INSERT_EXEC")!=null){
            insertExec(request,response);
        } else if(request.getParameter("UPDATE_EXEC")!=null){
            updateExec(request,response);
//        } else if(request.getParameter("DELETE_EXEC")!=null){
//            deleteExec(request,response);
        }
        listGroup(request,response);
    }

    /**
     * 僌儖乕僾堦棗
     */
    private void listGroup(Request request, Response response) throws Exception {
        Connection conn = getSystemContext().getConnection("system");
        try {
            GroupInfo[] groups = GroupDBAccessor.getAllGroupInfo(conn);
            request.setAttribute("groups",groups);
            includeJSP(Constants.JSP_GROUPLIST,request,response);
        } catch(Exception ex){
            throw ex;
        } finally {
            //conn.close();
            getSystemContext().releaseConnection("system", conn);
        }
    }

    /**
     * 捛壛僼僅乕儉
     */
    private void insertForm(Request request, Response response) throws Exception {
        GroupInfo group = new GroupInfo();
        request.setAttribute("group",group);
        includeJSP(Constants.JSP_GROUPFORM,request,response);
    }

    /**
     * 峏怴僼僅乕儉
     */
    private void updateForm(Request request, Response response) throws Exception {

        // 擖椡僠僃僢僋
        ValidatorSet validator = new ValidatorSet();
        validator.add(new DefaultValidator(DefaultValidator.NUMERIC,10,true),
                      request.getParameter("UPDATE_FORM"));
        validator.doValidate();

        Connection conn = getSystemContext().getConnection("system");
        try {
            long groupID = Long.parseLong(request.getParameter("UPDATE_FORM"));
            GroupInfo group = GroupDBAccessor.getGroupInfo(conn,groupID);
            request.setAttribute("group",group);
            includeJSP(Constants.JSP_GROUPFORM,request,response);
        } catch(Exception ex){
            throw ex;
        } finally {
            conn.close();
        }
    }

    /**
     * 僌儖乕僾搊榐/峏怴僼僅乕儉偺擖椡僠僃僢僋丅
     */
    private void inputCheck(Request request) throws ApplicationException {

        String groupID   = request.getParameter("GroupID");
        String groupName = request.getParameter("GroupName");
        String groupType = request.getParameter("GroupType");
        String useFlag   = request.getParameter("UseFlag");

        ValidatorSet validator = new ValidatorSet();
        if(request.getParameter("UPDATE_EXEC")!=null){
            // 峏怴帪偼僌儖乕僾ID偑昁恵
            validator.add(new DefaultValidator(DefaultValidator.STRING , 20,true),groupID);
        }
        validator.add(new DefaultValidator(DefaultValidator.STRING ,100,true),groupName);
        validator.add(new DefaultValidator(DefaultValidator.NUMERIC,  1,true),groupType);
        validator.add(new DefaultValidator(DefaultValidator.NUMERIC,  1,true),useFlag);

        validator.doValidate();
    }

    /**
     * 僌儖乕僾捛壛幚峴
     */
    private void insertExec(Request request, Response response) throws Exception {

        // 擖椡僠僃僢僋
        inputCheck(request);

        // 僷儔儊乕僞偺庢摼
        //long   groupID   = Long.parseLong(request.getParameter("GroupID"));
        String groupName = request.getParameter("GroupName");
        int    groupType = Integer.parseInt(request.getParameter("GroupType"));
        int    use       = Integer.parseInt(request.getParameter("UseFlag"));

        boolean useFlag = false;
        if(use==1){ useFlag = true; }

        // DB傊偺搊榐
        Connection conn = getSystemContext().getConnection("system");
        try {
            GroupDBAccessor.insertGroup(conn,groupName,groupType,useFlag);
        } catch(Exception ex){
            throw ex;
        } finally {
            conn.close();
        }
    }

    /**
     * 僌儖乕僾忣曬峏怴幚峴
     */
    private void updateExec(Request request, Response response) throws Exception {

        // 擖椡僠僃僢僋
        inputCheck(request);

        // 僷儔儊乕僞偺庢摼
        long   groupID   = Long.parseLong(request.getParameter("GroupID"));
        String groupName = request.getParameter("GroupName");
        int    groupType = Integer.parseInt(request.getParameter("GroupType"));
        int    use       = Integer.parseInt(request.getParameter("UseFlag"));

        boolean useFlag = false;
        if(use==1){ useFlag = true; }

        // DB傊偺搊榐
        Connection conn = getSystemContext().getConnection("system");
        try {
            GroupDBAccessor.updateGroup(conn,groupID,groupName,groupType,useFlag);
        } catch(Exception ex){
            throw ex;
        } finally {
            conn.close();
        }
    }

    /**
     * 僌儖乕僾忣曬嶍彍幚峴
     */
//    private void deleteExec(Request request, Response response) throws Exception {
//        Connection conn = getSystemContext().getConnection("system");
//        try {
//            DBAccessor.deleteGroup(conn,request.getParameter("DELETE_EXEC"));
//        } catch(Exception ex){
//            throw ex;
//        } finally {
//            conn.close();
//        }
//    }
}