articlewrite_save.jsp

一个练习JAVA的例子程序 一个练习JAVA的例子程序

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

<%@ include file="../include/connect.jsp" %>
<%
    username = checkstr(new variant(Request.QueryString("Username")));
    if (username.equals("")) {
        Response.End();
    }
    rs = new jasp.adodb.Recordset();
    sql = "select * from iisALLArticle where ArticleID is null";
    rs.Open(sql, cn, 1, 3);
    rs.AddNew();
    rs.setItem("Username", username);
    rs.setItem("Topic", Request.Form("topic").getValue());
    rs.setItem("SysGroupID", Request.Form("articlesysgroup").getValue());
    rs.setItem("GroupID", Request.Form("articlegroup").getValue());
    rs.setItem("Content", Request.Form("content").getValue());
    rs.Update();
    rs.Close();
    rs = (jasp.adodb.Recordset)null;
    rs = new jasp.adodb.Recordset();
    sql = "select * from iisArticleSysGroup where GroupID=" + Request.Form("articlesysgroup").getValue() + "";
    rs.Open(sql, cn, 1, 3);
    rs.setItem("ArticleNum", rs.getItem("ArticleNum").getValue().add(new variant(1)));
    rs.Update();
    rs.Close();
    rs = (jasp.adodb.Recordset)null;
    Response.Redirect("articlelist.jsp?Username=" + username + "");
%>


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