addmessageservlet.java

来自「guestbook用户意见留言簿,在线博客系统插件,」· Java 代码 · 共 88 行

JAVA
88 行
字号 
package webbook.guestbook;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
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 webbook.util.StringUtil;

public class AddMessageServlet extends HttpServlet {

	private static final long serialVersionUID = -8349454122547148005L;

	public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
		String username = "linximing";
		String password = "lin6782";

		String sql = "insert into guestbook (id,name,email,phone,title,content,time) values(gb_seq.nextval,?,?,?,?,?,?)";
		int result = 0;
		Connection conn = null;

		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("<html>");
		out.println("<head><title>guestbook input page</title></head>");
		out.println("<body>");

		if (StringUtil.validateNull(name)) {
			out.println("对不起,姓名不能为空,请重新输入!<br>");
			out.println("<a href=\""+request.getContextPath()+"/addMessage.htm\">添加的留言</a><br>");
		} else if (StringUtil.validateNull(title)) {
			out.println("对不起,主题不能为空,请重新输入!<br>");
			out.println("<a href=\""+request.getContextPath()+"/addMessage.htm\">添加新的留言</a><br>");
		} else {
			try {
				Class.forName("oracle.jdbc.driver.OracleDriver");
				conn = DriverManager.getConnection(url, username, password);

				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, request.getParameter("content"));

				SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
				pstmt.setString(6, sdf.format(new java.util.Date()));
				result = pstmt.executeUpdate();
				pstmt.close();
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			} catch (SQLException e) {
				e.printStackTrace();
			} finally {
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			if (result == 0) {
				out.println("对不起,添加留言不成功,请您重新输入!<br>");
				out.println("<a href=\""+request.getContextPath()+"/addMessage.htm\">添加新的留言</a><br>");
			} else {
				out.println("祝贺您,成功添加留言<br>");
				out.println("<a href=\""+request.getContextPath()+"/servlet/getMessages\">查看所有留言内容</a><br>");
			}
			out.println("</body>");
			out.println("</html>");
			out.flush();
			out.close();
		}
	}
}

addmessageservlet.java - 源码说明

本页面展示了「guestbook用户意见留言簿,在线博客系统插件,」中的 addmessageservlet.java 源码文件，采用 Java 编程语言编写，共 88 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫开发者社区收录了大量与Guestbook相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?