package com.proreg;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Date;
import java.sql.Statement;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Test2 extends HttpServlet{

	private PrintWriter out;
	private Statement stmt;
	public void doPost(HttpServletRequest request,HttpServletResponse response)
				throws IOException{
		request.setCharacterEncoding("GB2312");
		out=response.getWriter();
		dbcon db=new dbcon();
		int temp=0;
		try {
			stmt=db.getStmt();
			temp=stmt.executeUpdate("INSERT INTO TEST2(title,name,time,content) VALUES('"
			+request.getParameter("title")+"','"+request.getParameter("name")+"','"
			+new Date().toLocaleString()+"','"+request.getParameter("content")+"')");
			if(temp>0){
				out.println("<script>opener.parent.location.reload();window.close();</script>");
			}else{
				out.println("<script>alert('留言失敗');javascript:window.close();</script>");
			}
			db.close();	
		} catch (Exception e) {
			db.close();	
			e.printStackTrace();
		}
	}
	public void doGet(HttpServletRequest request,HttpServletResponse response)
				throws IOException{
		doPost(request,response);
	}
}