articledel.jsp

来自「一个练习JAVA的例子程序 一个练习JAVA的例子程序」· JSP 代码 · 共 52 行

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="jasp.buildin.*, jasp.vbs.*, jasp.util.*" %>
<%@ page extends="jasp.servlet.JspBase" %>
<% 
 try {
    jspinit(request,response,application,out,"jasp0");
%>

<% 
    Session.setCodePage(936);
    String articleid = "";
    jasp.adodb.Recordset rs = null;
    String sql = "";
    jasp.adodb.Recordset rs1 = null;
%>

<%@ include file="../include/connect.jsp" %>
<%
    articleid = checkstr(new variant(Request.QueryString("articleid")));
    rs = new jasp.adodb.Recordset();
    sql = "select * from iisALLArticle where ArticleID=" + articleid + "";
    rs.Open(sql, cn, 1, 1);
    if (rs.getEOF() || rs.getBOF()) {
        Response.Write("<script>alert('找不到此文章！');history.back(-1);</script>");
        Response.End();
    } else if (rs.getItem("Username").getValue().unequals(Session.getItem("username"))){
        Response.Write("<script>alert('您没有权限！');window.location.replace('articlelist.jsp?Username=" + rs.getItem("Username").getValue() + "');</script>");
        rs.Close();
        rs = (jasp.adodb.Recordset)null;
        Response.End();
    }
    cn.Execute("delete from iisALLArticle where ArticleID=" + articleid + "");
    cn.Execute("delete from iisArticlecomment where ArticleID=" + articleid + "");
    rs1 = new jasp.adodb.Recordset();
    sql = "select * from iisArticleSysGroup where GroupID=" + rs.getItem("SysGroupID").getValue() + "";
    rs1.Open(sql, cn, 1, 3);
    rs1.setItem("ArticleNum", rs1.getItem("ArticleNum").getValue().toDouble() - 1.0);
    rs1.Update();
    rs1.Close();
    rs1 = (jasp.adodb.Recordset)null;
    Response.Write("<script>alert('成功删除文章！');window.location.replace('articlelist.jsp?Username=" + rs.getItem("Username").getValue() + "');</script>");
    rs.Close();
    rs = (jasp.adodb.Recordset)null;
%>


<%
    End();
    } catch(Exception ex) { 
        printStackTrace(ex);
    } 
%>