jinyongaction.java

Bug管理系统

package tmp;

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 db.Db;
import  java.sql.*;
import gerenxinxi.*;
import javax.servlet.http.HttpSession;

public class jinyongAction extends Action {
    public ActionForward execute(ActionMapping actionMapping,
                                 ActionForm actionForm,
                                 HttpServletRequest servletRequest,
                                 HttpServletResponse servletResponse)throws Exception {
        jinyongActionForm f = (jinyongActionForm) actionForm;
        //获取用户id 和 操作值 以及系统权限
        String jinyongzhi=f.getJinyongzhi();
        String yonghuid=f.getYonghuid();
        String xitongquanxian=f.getXitongquanxian();

        jinyongzhi = new String(jinyongzhi.getBytes("ISO-8859-1"), "gbk");
        yonghuid = new String(yonghuid.getBytes("ISO-8859-1"), "gbk");
        xitongquanxian = new String(xitongquanxian.getBytes("ISO-8859-1"), "gbk");

        //得到个人信息
        HttpSession session = servletRequest.getSession();
        gerenxinxi yonghu1 = (gerenxinxi) session.getAttribute("yonghu1");

        //提示信息
        String xinxi="";

        if(yonghu1.getXitongquanxian().equals("用户管理员")&&(xitongquanxian.equals("项目管理员")||xitongquanxian.equals("系统管理员")))
        {
            xinxi="修改用户失败，您无权限修改过大权限用户！";
         }
        else
        {
        //连接数据库
        Db db1 = new Db();
        db1.getCon("bugBarrier");

        String s="";
        if(jinyongzhi.equals("禁用该帐户"))
            s="update yonghu set jinyong=0 where yonghuid='"+yonghuid+"'";
        else
            s="update yonghu set jinyong=1 where yonghuid='"+yonghuid+"'";
        //禁用修改
        Statement stmt = db1.conn.createStatement();
        stmt.execute(s); //执行
        db1.closeConnection();

        xinxi="用户id:"+yonghuid+"   现在状态："+jinyongzhi;
        }
        servletRequest.setAttribute("xinxi",xinxi);
        return actionMapping.findForward("tishixinxi");
    }
}