addmessageservlet.java

一个简单的BBS系统 适用于初学者用JSP和连接池 开发系统

package webbook.guestbook;

import java.io.IOException;
import java.text.SimpleDateFormat;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import webbook.util.*;

public class AddMessageServlet extends HttpServlet {
	private static final long serialVersionUID = -8349454122547148005L;

	public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String sql = "insert into guestbook (id,name,email,phone,title,content,time) values(gb_seq.nextval,?,?,?,?,?,?)";
		int result = 0;
		String message = "";
		String name = request.getParameter("name");
		String title = request.getParameter("title");

		if (StringUtil.validateNull(name)) {
			message = "对不起，姓名不能为空，请您重新输入！<br>";
		} else if (StringUtil.validateNull(title)) {
			message = "对不起，主题不能为空，请您重新输入！<br>";
		} else {
			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			String param[] = { StringUtil.filterHtml(name), StringUtil.filterHtml(request.getParameter("email")),
					StringUtil.filterHtml(request.getParameter("phone")), StringUtil.filterHtml(title),
					request.getParameter("content"), sdf.format(new java.util.Date()) };
			OracleUtil db = new OracleUtil("java:/comp/env/jdbc/oracleds");
			db.init();
			result = db.update(sql, param);
			if (result == 0) {
				message = "对不起，添加留言不成功，请您重新输入！";
			} else {
				message = "祝贺您，成功添加留言。";
			}
		}
		request.setAttribute("message", message);
		request.getRequestDispatcher("/addResult.jsp").forward(request, response);
	}
}