addcomment_a.jsp

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

<%@ 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 = "";
    String username = "";
    String groupid = "";
    jasp.adodb.Recordset rs = null;
    String sql = "";
%>

<%@ include file="../include/connect.jsp" %>
<%
    articleid = checkstr(new variant(Request.QueryString("ArticleID")));
    username = checkstr(new variant(Request.QueryString("Username")));
    groupid = checkstr(new variant(Request.QueryString("GroupID")));
    if (articleid.equals("") || username.equals("") || groupid.equals("")) {
        Response.End();
    } else {
        rs = new jasp.adodb.Recordset();
        sql = "select * from iisArticlecomment where CommentID is null";
        rs.Open(sql, cn, 1, 3);
        rs.AddNew();
        rs.setItem("Personaconid", Request.Form("personaconid").getValue());
        rs.setItem("ArticleID", articleid);
        rs.setItem("Commentuser", Request.Form("commentuser").getValue());
        rs.setItem("Comment", Request.Form("comment").getValue());
        rs.Update();
        rs.Close();
        rs = (jasp.adodb.Recordset)null;
        rs = new jasp.adodb.Recordset();
        sql = "select * from iisALLArticle where ArticleID=" + articleid + "";
        rs.Open(sql, cn, 1, 3);
        rs.setItem("Commentnum", rs.getItem("Commentnum").getValue().add(new variant(1)));
        rs.Update();
        rs.Close();
        rs = (jasp.adodb.Recordset)null;
        Response.Redirect("articleview.jsp?articleid=" + articleid + "&username=" + username + "&groupID=" + groupid + "&seq=#comment");
    }
%>


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