newsviewhandler.java~7~

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

package ws.woa.news;

import java.sql.Connection;

import ws.woa.core.AbstractModuleHandler;
import ws.woa.core.ApplicationException;
import ws.woa.core.Constants;
import ws.woa.core.Request;
import ws.woa.core.Response;
import ws.woa.core.UserInfo;
import ws.woa.util.DefaultValidator;
import ws.woa.util.PageLink;
import ws.woa.util.ValidatorSet;

/**
 * 僯儏乕僗墈棗婡擻偺僼傽儞僋僔儑儞僴儞僪儔丅
 * 婰帠偺堦棗婡擻偲丄婰帠偺昞帵婡擻傪採嫙偟傑偡丅
 *
 * @author Wang
 */
public class NewsViewHandler extends AbstractModuleHandler {

    /**
     * @see ws.woa.core.ModuleHandler#doProcess(Request, Response)
     */
    public void doProcess(Request request, Response response) throws Exception {
        if(request.getParameter("NewsID")==null){
            newsList(request,response);
        } else {
            newsView(request,response);
        }
    }

    /**
     * 夁嫀偺僯儏乕僗傪昞帵
     */
    private void newsList(Request request, Response response) throws Exception {

        // 昞帵偡傞儁乕僕斣崋傪庢摼
        int page = 1;
        if(request.getParameter("Page")!=null){
            page = Integer.parseInt(request.getParameter("Page"));
        }
        if(page<1){ page = 1; }

        Connection conn = getSystemContext().getConnection("system");
        try {
            // 僯儏乕僗偺堦棗傪庢摼
            UserInfo userInfo = getSystemContext().getUserInfo();
            NewsBean[] newsList = NewsDBAccessor.getNewsList(userInfo.getGroupID(),
                                  userInfo.getUserID(),
                                  (page-1)*NewsConstants.PAGE_ROW_COUNT,
                                  NewsConstants.PAGE_ROW_COUNT,conn);
            request.setAttribute("newsList",newsList);

            // 儁乕僕張棟梡偺儕儞僋傪嶌惉
            //NewsPageLink pageLink = new NewsPageLink(page,
            //    NewsDBAccessor.getNewsCount(userInfo.getGroupID(),userInfo.getUserID(),conn),
            //    "newsview.module");
            PageLink pageLink = new PageLink("newsview.module",page,
                NewsDBAccessor.getNewsCount(userInfo.getGroupID(),userInfo.getUserID(),conn),
                NewsConstants.PAGE_ROW_COUNT);
            request.setAttribute("pageLink",pageLink);

        } catch(Exception ex){
            throw ex;
        } finally {
            //conn.close();
            getSystemContext().releaseConnection("system", conn);
        }

        includeJSP(NewsConstants.JSP_ALL,request,response);
    }

    /**
     * 僯儏乕僗傪昞帵
     */
    private void newsView(Request request, Response response) throws Exception {

        ValidatorSet validator = new ValidatorSet();
        validator.add(new DefaultValidator(DefaultValidator.NUMERIC,10,true),
                      request.getParameter("NewsID"));
        validator.doValidate();

        Connection conn = getSystemContext().getConnection("system");
        try {
            long newsID = Long.parseLong(request.getParameter("NewsID"));

            // 墈棗尃尷傪僠僃僢僋
            UserInfo userInfo = getSystemContext().getUserInfo();
            if(!NewsDBAccessor.getCanShowNews(conn,newsID,
                              userInfo.getUserID(),userInfo.getGroupID())){
                throw new ApplicationException(Constants.MSG_ERR_PERMISSION);
            }

            NewsBean news = NewsDBAccessor.getNews(newsID,conn);
            request.setAttribute("news",news);
        } catch(Exception ex){
            throw ex;
        } finally {
            //conn.close();
            getSystemContext().releaseConnection("system", conn);
        }

        includeJSP(NewsConstants.JSP_VIEW,request,response);
    }
}