package?com.szz.guestbook;

import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.text.SimpleDateFormat;

import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?com.szz.guestbook.DBUtils;

public?class?AddMessageServlet?extends?HttpServlet?{

	/**
	?*?
	?*/
	private?static?final?long?serialVersionUID?=?1L;


	public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{

		doPost（requestresponse）;
	}


	public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{
			String?sql=“insert?into?guestbook?（nameemailphonetitlecontenttime）?values?（??????）“;			
			int?result=0;
			request.setCharacterEncoding（“utf-8“）;
			String?name=request.getParameter（“name“）;
			String?title=request.getParameter（“title“）;
			response.setContentType（“text/html;charset=utf-8“）;
			PrintWriter?out=response.getWriter（）;
			out.println（““）;
			out.println（“tle>add?massagetle>“）;
			out.println（““）;
			if（StringUtil.validateNull（name））{
				out.println（“對不起，姓名不能為空，請重新輸入！“）;
				out.println（“添加留言內(nèi)容
“）;
			}
			else?if（StringUtil.validateNull（title））{
				out.println（“對不起，主題不能為空，請重新輸入！“）;
				out.println（“添加留言內(nèi)容
“）;
			}
			else{
				try?{
					Connection?conn?=?new?DBUtils（）.getConn（）;
					PreparedStatement?pstmt?=?conn.prepareStatement（sql）;
					pstmt.setString（1?StringUtil.filterHtml（name））;
					pstmt.setString（2?StringUtil.filterHtml（request.getParameter（“email“）））;
					pstmt.setString（3?StringUtil.filterHtml（request.getParameter（“phone“）））;
					pstmt.setString（4?StringUtil.filterHtml（title））;
//					pstmt.setString（5?StringUtil.filterHtml（?request.getParameter（“content“）））;
					pstmt.setString（5?request.getParameter（“content“））;
					//對時間日期進(jìn)行格式化
					SimpleDateFormat?sdf=new?SimpleDateFormat（“yyyy-MM-dd?HH:mm:ss“）;
					pstmt.setString（6?sdf.format（new?java.util.Date（）））;
					result=pstmt.executeUpdate（）;		
					//System.out.println（result）;
					pstmt.close（）;
					conn.close（）;
				}?catch?（Exception?e）?{
					
					e.printStackTrace（）;
				}
				if（result==0）{
					out.println（“對不起，留言添加不成功，請重新輸入！“+“
“）;
					out.println（“添加留言內(nèi)容
“）;
				}
				else{
					out.println（“恭喜，留言添加成功！“+“
“）;
					out.println（“查看留言內(nèi)容
“）;
				}
				out.println（““）;
				out.println（““）;
				out.flush（）;
				out.close（）;
			}
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-11-23?11:47??javaEE-servlet留言板項(xiàng)目\
?????文件??????614525??2018-11-05?16:39??javaEE-servlet留言板項(xiàng)目\fengxiaos.sql
?????目錄???????????0??2018-11-23?11:45??javaEE-servlet留言板項(xiàng)目\guestbook\
?????文件?????????699??2018-11-23?11:42??javaEE-servlet留言板項(xiàng)目\guestbook\.classpath
?????目錄???????????0??2018-10-10?15:23??javaEE-servlet留言板項(xiàng)目\guestbook\.myeclipse\
?????文件?????????300??2010-05-20?20:14??javaEE-servlet留言板項(xiàng)目\guestbook\.mymetadata
?????文件????????1752??2018-10-10?15:30??javaEE-servlet留言板項(xiàng)目\guestbook\.project
?????目錄???????????0??2018-11-23?11:45??javaEE-servlet留言板項(xiàng)目\guestbook\.settings\
?????文件?????????500??2010-05-20?20:14??javaEE-servlet留言板項(xiàng)目\guestbook\.settings\.jsdtscope
?????文件?????????395??2018-10-10?15:34??javaEE-servlet留言板項(xiàng)目\guestbook\.settings\org.eclipse.jdt.core.prefs
?????文件?????????465??2018-10-10?15:34??javaEE-servlet留言板項(xiàng)目\guestbook\.settings\org.eclipse.wst.common.component
?????文件?????????219??2018-10-10?15:34??javaEE-servlet留言板項(xiàng)目\guestbook\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-10-10?15:34??javaEE-servlet留言板項(xiàng)目\guestbook\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-10-10?15:34??javaEE-servlet留言板項(xiàng)目\guestbook\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件??????244064??2018-11-23?11:33??javaEE-servlet留言板項(xiàng)目\guestbook\servlet-api.jar
?????目錄???????????0??2018-11-23?11:45??javaEE-servlet留言板項(xiàng)目\guestbook\src\
?????目錄???????????0??2018-11-23?11:45??javaEE-servlet留言板項(xiàng)目\guestbook\src\com\
?????目錄???????????0??2018-11-23?11:45??javaEE-servlet留言板項(xiàng)目\guestbook\src\com\szz\
?????目錄???????????0??2018-11-23?11:45??javaEE-servlet留言板項(xiàng)目\guestbook\src\com\szz\guestbook\
?????文件????????3033??2018-10-10?16:24??javaEE-servlet留言板項(xiàng)目\guestbook\src\com\szz\guestbook\AddMessageServlet.java
?????文件?????????786??2018-10-10?15:45??javaEE-servlet留言板項(xiàng)目\guestbook\src\com\szz\guestbook\DBUtils.java
?????文件????????2489??2018-10-10?16:11??javaEE-servlet留言板項(xiàng)目\guestbook\src\com\szz\guestbook\getMessageServlet.java
?????文件????????1022??2010-05-21?14:12??javaEE-servlet留言板項(xiàng)目\guestbook\src\com\szz\guestbook\StringUtil.java
?????目錄???????????0??2018-11-23?11:45??javaEE-servlet留言板項(xiàng)目\guestbook\WebContent\
?????文件????????1799??2018-10-10?16:26??javaEE-servlet留言板項(xiàng)目\guestbook\WebContent\addMessage.html
?????目錄???????????0??2018-11-23?11:45??javaEE-servlet留言板項(xiàng)目\guestbook\WebContent\fckeditor\
?????目錄???????????0??2018-11-23?11:45??javaEE-servlet留言板項(xiàng)目\guestbook\WebContent\fckeditor\editor\
?????目錄???????????0??2018-11-23?11:45??javaEE-servlet留言板項(xiàng)目\guestbook\WebContent\fckeditor\editor\css\
?????目錄???????????0??2018-11-23?11:45??javaEE-servlet留言板項(xiàng)目\guestbook\WebContent\fckeditor\editor\css\behaviors\
?????文件?????????236??2010-05-20?20:16??javaEE-servlet留言板項(xiàng)目\guestbook\WebContent\fckeditor\editor\css\behaviors\disablehandles.htc
?????文件?????????822??2010-05-20?20:16??javaEE-servlet留言板項(xiàng)目\guestbook\WebContent\fckeditor\editor\css\behaviors\showtableborders.htc
............此處省略854個文件信息