replytopicservlet.java

《电子商店管理系统》——采用JSP、Servlet和JavaBean开发,实现了商品管理、 商品分类、订单处理、会员管理等功能

package com.jspdev.servlet;

import com.jspdev.business.*;
import javax.servlet.http.*;
import com.jspdev.util.DatabaseConn;
import java.sql.*;
import java.io.*;

/**
  *回复某个主题的Servlet
  */
public class ReplyTopicServlet extends javax.servlet.http.HttpServlet
{
	public void doGet(HttpServletRequest request,HttpServletResponse response)
		throws javax.servlet.ServletException,java.io.IOException
	{

        try
        {
        	/**
        	 *获得请求中的参数
        	 */
        	String topicId=request.getParameter("topicId");
        	String title=request.getParameter("title");
        	String author=request.getParameter("author");
        	String email=request.getParameter("email");
        	String content=request.getParameter("content");
        	Connection con=DatabaseConn.getConnection();
        	Statement stmt=con.createStatement();
            /**
             *执行数据库更新操作，把回复的信息保存到数据库中
             */
        	stmt.executeUpdate("insert into reply values('"+new java.util.Date().getTime()+"','"+topicId+"','"+title+"','"+author+"','"+email+"','"+content+"',getdate())");
        	stmt.close();
        	con.close();
        	PageBusiness pb=new ForumBean();
        	PageBean  pageCtl = pb.listData("1");
        	request.setAttribute("pageCtl",pageCtl);
        }
        catch(Exception e)
        {
        	e.printStackTrace();
        }
        
		/**
         *把视图派发到viewForum.jsp
         */        
        javax.servlet.RequestDispatcher dis=request.getRequestDispatcher("/forum/viewForum.jsp");
        dis.forward(request,response);
    }
    public void doPost(HttpServletRequest request,HttpServletResponse response)
		throws javax.servlet.ServletException,java.io.IOException
	{
		doGet(request,response);
	}
}