tianjiakaifarenyuanaction.java~4~

来自「Bug管理系统」· JAVA~4~ 代码 · 共 58 行

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

public class tianjiakaifarenyuanAction extends Action {
    public ActionForward execute(ActionMapping actionMapping,
                                 ActionForm actionForm,
                                 HttpServletRequest servletRequest,
                                 HttpServletResponse servletResponse) throws Exception{

        tianjiakaifarenyuanActionForm f = (tianjiakaifarenyuanActionForm) actionForm;
        String yonghuId=f.getYonghu2();
                yonghuId = new String(yonghuId.getBytes("ISO-8859-1"), "gbk");

                //得到对象
                HttpSession session = servletRequest.getSession();
                gerenxinxi yonghu1 = new gerenxinxi();
                yonghu1=(gerenxinxi) session.getAttribute("yonghu1");
                String xiangmuid=yonghu1.getSuochuxiangmu().getXiangmuId();

                if(!yonghuId.equals(""))
                {
                        //连接数据库
                        Db db1 = new Db();
                        db1.getCon("bugBarrier");
                        String s="";
                        //先看项目中是否有此用户
                        Statement stmt = db1.conn.createStatement();
                        s="select * from ceshirenyuan where xiangmuid='"+xiangmuid+"' and yonghuid='"+yonghuId+"'";
                        ResultSet rs=stmt.executeQuery(s);
                        int n=0;
                        while(rs.next())
                        {
                            n++;
                        }
                        if(n==0)
                        {
                                //先看项目中是否有此用户
                                Statement stmt2 = db1.conn.createStatement();
                                s="insert into ceshirenyuan values('"+xiangmuid+"','"+yonghuId+"')";
                                stmt.execute(s);
                        }
                        db1.closeConnection();
                }

    }
}