process.jsp

来自「孙鑫的Java Web开发详解一书的源代码」· JSP 代码 · 共 43 行

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*,javax.sql.*,javax.naming.*" %>
<%@ include file="util.jsp" %>

<%
	request.setCharacterEncoding("gb2312");
	
	String name=request.getParameter("name");
	String title=request.getParameter("title");
	String content=request.getParameter("content");
	
	if(null==name || null==title || null==content)
	{
	    response.sendRedirect("index.jsp");
		return;
	}
	
	name=toHtml(name.trim());
	title=toHtml(title.trim());
	if(name.equals("") || title.equals(""))
	{
		response.sendRedirect("say.html");
		return;
	}
	content=toHtml(content.trim());
	String fromIP=request.getRemoteAddr();
	
	Context ctx=new InitialContext();
    DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/bookstore");
    Connection conn=ds.getConnection();
	
	PreparedStatement pstmt=conn.prepareStatement(
		"insert into guestbook(gst_user,gst_title,gst_content,gst_ip) values(?,?,?,?)");
	pstmt.setString(1,name);
	pstmt.setString(2,title);
	pstmt.setString(3,content);
	pstmt.setString(4,fromIP);
	
	pstmt.executeUpdate();
	pstmt.close();
	conn.close();
	response.sendRedirect("index.jsp");
%>