package com.jspdev.servlet;

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

/**
 *發布新的主題
 */
public class NewTopicServlet extends javax.servlet.http.HttpServlet
{
	public void doGet(HttpServletRequest request,HttpServletResponse response)
		throws javax.servlet.ServletException,java.io.IOException
	{
	    response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        try
        {
        	/**
        	 *獲得請求中的參數
        	 */
        	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 topic values('"+new java.util.Date().getTime()+"','"+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);
	}
}