post.jsp

《JSP留言薄》使用MySQL数据库

<%--*****************************************************
*   天地网络--JSP留言薄            www.tiandinet.com    *
*                                                       *
*  你可以使用、修改该软件，但请保留该段文字！           *
*                                                       *
*                                                       *
*                 作者：天地                            *
*                 网址：http://www.tiandinet.com        *
*                 2003年10月                            *
*****************************************************--%>

<%@ page language="java" %>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="td_gb" class="td.guestbook"/>
<%-- 包含配置文件 --%>
<%@ include file="config.jsp" %>
<%
    String title = "天地网络--JSP留言薄";
		String td_bg_message = null;
		String name = td_gb.getStr(request.getParameter("name"));
		String qq = td_gb.getStr(request.getParameter("qq"));
		String email = td_gb.getStr(request.getParameter("email"));
		String homepage = td_gb.getStr(request.getParameter("homepage"));
		String headima = request.getParameter("headima");
		String content = td_gb.HtmlSpecialChars(td_gb.getStr(request.getParameter("content")));

		if(name.length()>20)
		{
        td_bg_message = "<font color=\"#FF0000\">姓名的长度不能大于20个字符！</font><a href=\"#\" onClick=\"JavaScript:history.back()\">请点击这里返回</a>";
		    request.setAttribute("td_bg_message",(Object)(td_bg_message));
			  request.setAttribute("title",(Object)(title));
		}
		else if(qq.length()>20)
		{
        td_bg_message = "<font color=\"#FF0000\">QQ的长度不能大于20个字符！</font><a href=\"#\" onClick=\"JavaScript:history.back()\">请点击这里返回</a>";
		    request.setAttribute("td_bg_message",(Object)(td_bg_message));
			  request.setAttribute("title",(Object)(title));
		}
		else if(email.length()>80)
		{
        td_bg_message = "<font color=\"#FF0000\">E-mail的长度不能大于80个字符！</font><a href=\"#\" onClick=\"JavaScript:history.back()\">请点击这里返回</a>";
		    request.setAttribute("td_bg_message",(Object)(td_bg_message));
			  request.setAttribute("title",(Object)(title));
		}
		else if(homepage.length()>80)
		{
        td_bg_message = "<font color=\"#FF0000\">个人主页的长度不能大于80个字符！</font><a href=\"#\" onClick=\"JavaScript:history.back()\">请点击这里返回</a>";
		    request.setAttribute("td_bg_message",(Object)(td_bg_message));
			  request.setAttribute("title",(Object)(title));
		}
		else if(content.length()>1000)
		{
        td_bg_message = "<font color=\"#FF0000\">留言内容的长度不能大于1000个字符！</font><a href=\"#\" onClick=\"JavaScript:history.back()\">请点击这里返回</a>";
		    request.setAttribute("td_bg_message",(Object)(td_bg_message));
			  request.setAttribute("title",(Object)(title));
		}
		else
		{
		    String[] vals = new String[6];
		    vals[0] = name;
		    vals[1] = qq;
		    vals[2] = email;
		    vals[3] = homepage;
		    vals[4] = headima;
		    vals[5] = content;
		
		    //初始化数据库连接
		    if(td_gb.init(mysqlDriver,mysqlUrl,mysqlUser,mysqlPsw))
		    {
				    if(td_gb.post(vals))
				    {
                td_bg_message = "成功发表文章！<script language=\"JavaScript\" type=\"text/javascript\">setTimeout(\"this.location.href='index.jsp'\",1500);</script>";
				    		request.setAttribute("td_bg_message",(Object)(td_bg_message));
				    		request.setAttribute("title",(Object)(title));
			    	}
			    	else
			    	{
		    		    td_bg_message = "<font color=\"#FF0000\">发表文章失败！</font><a href=\"#\" onClick=\"JavaScript:history.back();\">请点击这里返回重试！</a>";
		    				request.setAttribute("td_bg_message",(Object)(td_bg_message));
		    				request.setAttribute("title",(Object)(title));
		    		}
		    }
		    else
		    {
            td_bg_message = "<font color=\"#FF0000\">连接数据库失败！</font>";
		    		request.setAttribute("td_bg_message",(Object)(td_bg_message));
			    	request.setAttribute("title",(Object)(title));
		    }
		}
%>
<%@ include file="message.jsp" %>