compuseraction.java

hibernate应用测试,初学hibernate 的会员可以看看.

package com.action;

import org.apache.struts.action.*;
import java.io.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.util.List;
import java.sql.SQLException;

import com.bean.CompUser;
import com.bean.LogTable;
import com.dao.*;
import com.tool.pagetool.*;
import com.tool.QueryStrCreator;
import com.tool.LogTableWriter;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class CompUserAction extends Action {
    public ActionForward execute(ActionMapping mapping,
                                 ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response) throws Exception {
        request.setCharacterEncoding("gb2312");
        response.setContentType("text/html;charset=gb2312");

        CompUser compuser = (CompUser) form;
        String flag = request.getParameter("flag");
        ActionErrors actionErrors = new ActionErrors();
        String target = "";

        //添加用户
        if (flag.equals("forA")) {
            try {
                //判断用户是否已存在系统
                String whereStr = "where real_name='"+compuser.getRealName()+"'  and department='"+compuser.getDepartment()+"' and sex='"+compuser.getSex()+"'";
                if(CompUserDAO.isHasCompuser(whereStr)){
                    ActionError actionError = new ActionError(
                        "errors.generally.failed","用户名重复");
                    actionErrors.add("addCUserSuccese", actionError);
                    saveErrors(request, actionErrors);
                    target = "addCUser";
                    return mapping.findForward(target);
                }
                CompUserDAO.startTransation();
                int lastId = CompUserDAO.getLastId();
                compuser.setCompUserId(lastId + 1);
                compuser.setDelFlag(0);
                CompUserDAO.insertCompUser(compuser);
                CompUserDAO.commit();
                ActionError actionError = new ActionError(
                        "errors.addSuccese");
                actionErrors.add("addCUserSuccese", actionError);
                saveErrors(request, actionErrors);
                target = "addCUser";
                //写入日志
                String operatorType = "增";
                String sql = "insert into COMP_USER (comp_user_id," +
                             "real_name,department,position,sex,del_flag)" +
                             " values (" + compuser.getCompUserId() + "," +
                             compuser.getRealName()
                             + "," + compuser.getDepartment() + "," +
                             compuser.getPosition() + "," + compuser.getSex() +
                             "," + compuser.getDelFlag() + ")";

                LogTableWriter.write(request, operatorType, sql);
            } catch (SQLException e) {
                e.printStackTrace();
                ActionError actionError = new ActionError("errors.generally.failed",e.getMessage());
                actionErrors.add("addCUserFeiled", actionError);
                saveErrors(request, actionErrors);
                target = "addCUser";
            } finally {
                CompUserDAO.rollback();
            }
        }

        //列出用户修改或删除列表
        if (!flag.equals("forA")) {
            initPage(request); //初始化分页数据并放于request中
            if (flag.equals("forM")) target = "listForMCUser"; //重定向到用户修改例表
            if (flag.equals("forD")) target = "deleteCUser"; //重定向到用户删除列表
        }

        //删除用户,只作标记不物理删除
        if (flag.equals("delete")) {
            String compUserIdStr = request.getParameter("compUserId");
            int compUserId = -1;
            if (compUserIdStr != null) {
                try {
                    compUserId = Integer.parseInt(compUserIdStr);
                    CompUser compUser2 = CompUserDAO.selectCompUserBycompUserId(
                            compUserId);
                    boolean tmp = false;
                    tmp= CompUserDAO.isHasReferCompUser(compUser2);
                    System.out.println("compUser2.getCompUserId()="+compUser2.getCompUserId());
                    if (tmp) {
                        ActionError actionError = new ActionError(
                                "errors.generally.failed", "用户已被引用不能删除");
                        actionErrors.add("deleteCUserSuccese", actionError);
                        saveErrors(request, actionErrors);
                        target = "deleteCUser";
                        initPage(request); //初始化分页数据并放于request中
                        return mapping.findForward(target);
                    }
                    compUser2.setDelFlag(1);
                    CompUserDAO.updateCompUser(compUser2);
                    ActionError actionError = new ActionError(
                            "errors.deleteSuccese");
                    actionErrors.add("deleteCUserSuccese", actionError);
                    saveErrors(request, actionErrors);
                    target = "deleteCUser";
                    initPage(request); //初始化分页数据并放于request中
                    //写入日志
                    String operatorType = "删";
                    String sql = "update COMP_USER set " +
                                 "COMP_USER_ID=" + compUser2.getCompUserId() +
                                 ",REAL_NAME=" + compUser2.getRealName() + "," +
                                 "DEPARTMENT=" + compUser2.getDepartment() +
                                 ",POSITION=" + compUser2.getPosition() +
                                 ",SEX=" + compUser2.getSex() + "," +
                                 "DEL_FLAG=" + compUser2.getDelFlag() +
                                 " where COMP_USER_ID = " +
                                 compUser2.getCompUserId();

                    LogTableWriter.write(request, operatorType, sql);

                } catch (Exception e) {
                    e.printStackTrace();
                    ActionError actionError = new ActionError(
                            "errors.deleteFeiled");
                    actionErrors.add("deleteCUserFeiled", actionError);
                    saveErrors(request, actionErrors);
                    target = "deleteCUser";
                } finally {
                    CompUserDAO.rollback();
                }
            }
        }

        //修改用户
        if (flag.equals("modify")) {
            if (compuser.getRealName() == null && compuser.getCompUserId() != 0) { //跳转到信息修改页面
                try {
                    CompUser userTmp = CompUserDAO.selectCompUserBycompUserId(
                            compuser.getCompUserId());
                    request.setAttribute("forMCUser", userTmp);
                } catch (Exception e) {
                    e.printStackTrace();
                } finally {
                    CompUserDAO.rollback();
                }
                target = "mofifyUser";
            }
            if (compuser.getRealName() != null & compuser.getCompUserId() != 0) { //执行修改
                try {
                        //判断用户是否已存在系统
                   String whereStr = "where real_name='"+compuser.getRealName()+"'  and department='"+compuser.getDepartment()+"' and sex='"+compuser.getSex()+"' and comp_user_id<>"+compuser.getCompUserId();
                   if(CompUserDAO.isHasCompuser(whereStr)){
                       ActionError actionError = new ActionError(
                           "errors.generally.failed","用户名重复");
                       actionErrors.add("addCUserSuccese", actionError);
                       saveErrors(request, actionErrors);
                       target = "mofifyUser";
                      request.setAttribute("forMCUser", compuser);
                       return mapping.findForward(target);
                   }
                    CompUserDAO.updateCompUser(compuser);
                    request.setAttribute("forMCUser", compuser);
                    ActionError actionError = new ActionError(
                            "errors.modifyUserInfoSuccese");
                    actionErrors.add("modifyCUserSuccese", actionError);
                    saveErrors(request, actionErrors);
                    //写入日志
                    String operatorType = "改";
                    String sql = "update COMP_USER set " +
                                 "COMP_USER_ID=" + compuser.getCompUserId() +
                                 ",REAL_NAME=" + compuser.getRealName() + "," +
                                 "DEPARTMENT=" + compuser.getDepartment() +
                                 ",POSITION=" + compuser.getPosition() +
                                 ",SEX=" + compuser.getSex() + "," +
                                 "DEL_FLAG=" + compuser.getDelFlag() +
                                 " where COMP_USER_ID = " +
                                 compuser.getCompUserId();

                    LogTableWriter.write(request, operatorType, sql);

                } catch (Exception e) {
                    e.printStackTrace();
                    ActionError actionError = new ActionError(
                            "errors.modifyUserInfoFailed");
                    actionErrors.add("modifyCUserFeiled", actionError);
                    saveErrors(request, actionErrors);
                } finally {
                    CompUserDAO.rollback();
                }
                target = "mofifyUser";
            }
        }
        //查询用户
        if (flag.equals("query")) {
            initPage(request); //初始化分页数据并放于request中
            target = "queryCompUser";
        }
        if(flag.equals("queryForImport")){
            initPage(request); //初始化分页数据并放于request中
            target = "importCompUserForAddAccount";
        }
        return mapping.findForward(target);
    }

    //初始化并获得分页
    private Page initPage(HttpServletRequest request) {
        String currentPageStr = request.getParameter("currentPage");
        String queryStr = QueryStrCreator.create("compUser", request);
        System.out.println(queryStr);
        int currentPage = 1; //当前页码
        int size = 20; //每页的记录数

        try { //防止从地址栏直接输入非法页码
            if (currentPageStr != null) currentPage = new Integer(
                    currentPageStr).intValue();
        } catch (Exception e) {
            e.printStackTrace();
        }

        //处理分页
        //会话中是否已有分页生成工具
        PageTool pageTool = null;
        HttpSession session = request.getSession();
        pageTool = (PageTool) session.getAttribute("compUserPageTool"); //有，则直接拿来用
        if (pageTool == null) { //没有，则新建，并放进会话中，以备下次用
            pageTool = PageToolBuilder.builder(new CompUserDAO());
            session.setAttribute("compUserPageTool", pageTool);
        }
        //由分页工具生成分页
        Page page = null;
        try {
            String flag = request.getParameter("flag");
            if (flag.equals("query")||flag.equals("queryForImport")) //查询时的分页
                page = pageTool.createPage(currentPage, size, queryStr);
            else //其它非查询的分页
                page = pageTool.createPage(currentPage, size);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        //将分页放进请求中，分发到下一个页面显示
        request.setAttribute("allCompUserPage", page);
        return page;
    }
}