⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 querymodify.jsp

📁 JSP论坛bb 毕业设计 文档加代码
💻 JSP
字号:
🔍 
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"  %>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>

<%! String Is_Edit,Is_Delete,S_UserName,S_UserClass,Edit_Id,Delete_Id,sql,Board_Id,Note_Id,Note_Title,Note_Content,Note_Icon,Note_Sign; %>
<%
Is_Edit="0";
Is_Delete="0";

if (session.getValue("UserName")==null)
{
  response.sendRedirect("err.jsp?id=5");
}else{

   Connection con=yy.getConn();
   Statement  stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
   ResultSet rs=null;
   Board_Id=request.getParameter("fid");
   Edit_Id=request.getParameter("editid");
   Delete_Id=request.getParameter("deleteid");
   Note_Id=request.getParameter("noteid");
   Note_Title=request.getParameter("title");
   Note_Title=yy.ex_chinese(Note_Title);
   Note_Content=request.getParameter("content");
   Note_Content=yy.ex_chinese(Note_Content);
   Note_Icon=request.getParameter("icon");
   Note_Sign=request.getParameter("signid");
   //Note_Sign=yy.ex_chinese(Note_Sign);
   if (session.getValue("UserClass").equals("系统管理员"))
   {
   Is_Edit="1";
   Is_Delete="1";
   }else if(session.getValue("UserClass").equals("斑竹"))
   {
      out.println("OK");
   sql="select 论坛id from 论坛栏目 where 版主姓名='"+session.getValue("UserName")+"'";
   rs=stmt.executeQuery(sql);
   rs.last();
   if (rs.getRow()>0)
   {
     if (Board_Id.equals(rs.getString("论坛栏目")))
     {
       Is_Edit="1";
       Is_Delete="1";
     }
   }
   }else
   {
   sql="select * from 贴子 where 贴子id="+Edit_Id+" and 贴子作者='"+session.getValue("UserName")+"'";
   rs=stmt.executeQuery(sql);
   rs.last();
   if (rs.getRow()>0)
     Is_Edit="1";
   sql="select * from 贴子 where 贴子id="+Delete_Id+" and 贴子作者='"+session.getValue("UserName")+"'";
   rs=stmt.executeQuery(sql);
   rs.last();
   if (rs.getRow()>0)
       Is_Delete="1";
   }


if ((Is_Edit.equals("1")&&(Delete_Id==null)))
{
   
   sql="update 贴子 set 贴子名称='"+Note_Title+"', 贴子内容='"+Note_Content+"', 显示签名="+Note_Sign+", 贴子图片='"+Note_Icon+"' where 贴子id="+Edit_Id;
   stmt.executeUpdate(sql);
   //out.println(sql);
   response.sendRedirect("shownote.jsp?fid="+Board_Id+"&noteid="+Note_Id);
}else if (Is_Delete.equals("0")&&(Edit_Id!=null))
 response.sendRedirect("err.jsp?id=6");

if ((Is_Delete.equals("1")&&(Edit_Id==null)))
{
   sql="Delete From 贴子 Where 贴子id="+Delete_Id;
   //out.println(sql);
    stmt.executeUpdate(sql);
   out.println("<html> <meta http-equiv='refresh' content='1;url=board.jsp?fid="+Board_Id+"'> </html>");
 //response.sendRedirect("board.jsp?fid="+Board_Id);
}
else if(Is_Edit.equals("0")&&(Delete_Id!=null))
    response.sendRedirect("err.jsp?id=7");
}

%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -