package web;

import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.servlet.*;

import java.io.*;
import java.sql.*;
import java.util.*;

public class BBSPostServlet extends HttpServlet {

	@Override
	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		HttpSession session = request.getSession();
		String id =(String) session.getAttribute("LOGIN_ID");
		if(id == null){
			throw new ServletException("°Ô½Ã±ÛÀ» µî·ÏÇÏ·Á¸é ¸ÕÀú ·Î±×ÀÎÀ» ÇؾßÇÕ´Ï´Ù");
			
		}
		String title = request.getParameter("TITLE");
		String content = request.getParameter("CONTENT");
		if(title == null || content ==null){
			throw new ServletException("µ¥ÀÌÅ͸¦ ÀÔ·ÂÇϽʽÿÀ");
		}
		int seqNo = 1;
		GregorianCalendar now = new GregorianCalendar();
		Connection conn = null;
		Statement stmt = null;
		try{
			Class.forName("org.apache.commons.dbcp.PoolingDriver"); 
			conn = DriverManager.getConnection("jdbc:apache:commons:dbcp:/wdbpool");
			if(conn == null)
				throw new ServletException("µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇÒ ¼ö ¾ø½À´Ï´Ù");
			stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery("select max(seqno) as max_seqno from bbs");
			if(rs.next())
				seqNo = rs.getInt("max_seqno") +1;
			
			String command = String.format("insert into bbs(seqno,title,content,writer,wdate,wtime) value"+
					 "(%d, '%s', '%s', '%s', '%TF', '%TT'),(seqno,title,content,id,now,now);");
			int rowNum = stmt.executeUpdate(command);
			if(rowNum < 1)
				throw new ServletException("µ¥ÀÌÅ͸¦ db¿¡ ÀÔ·Â ÇÒ ¼ö ¾ø½À´Ï´Ù ");
		}catch(ClassNotFoundException cnfe){
			throw new ServletException(cnfe);
		}catch(SQLException se){
			throw new ServletException(se);
		}finally{
			try{
				stmt.close();
			}catch(Exception ignored){
				
			}try{
				conn.close();
			}catch(Exception ignored){
				
			}
		}
		response.sendRedirect("bbs-list");
		
	}

}