/*
 * Calendar.java
 *
 * Created on August 3, 2001, 2:35 PM
 */

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import com.javaexchange.dbConnectionBroker.*;
/** 
 *
 * @author  alieberman
 * @version 
 */
public class DateFormLogic extends HttpServletJXGB  {
  
     private String sql;
     private String sqlArgs;
     Connection conn = null;
     private PrintWriter out = null;

  

    /** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
    * @param request servlet request
    * @param response servlet response
    */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, java.io.IOException {
    HttpSession session = request.getSession();
        sessionInfo info = (sessionInfo)session.getAttribute("Attribute");   



	response.setContentType("text/html");
        out = response.getWriter();
	//ServletOutputStream out = response.getOutputStream();
        conn = myBroker.getConnection();
        sqlArgs= request.getParameter("Title");
        out.println(sqlArgs);
        insertData(sqlArgs, info.getYear(), info.getMonth_String(), info.getDay(), info.getTime(), info.getUserID(), response);
        out.println("data Inserted");
       // out.println("Connection" + myBroker.idOfConnection(conn));
        myBroker.freeConnection(conn) ; 
        //out.println("Connection freed"); 
        //out.println(info.getMonth());
       out.flush();
       sql = null;
      
       response.sendRedirect("SearchLogic");


       } 


public void forward(HttpServletRequest request, HttpServletResponse response) throws ServletException, java.io.IOException {
    String calendar = "SearchLogic";
    RequestDispatcher dispatcher1 = request.getRequestDispatcher(calendar);
    dispatcher1.include(request, response);
}



  public void insertData(String ttl, int y, String m, int d, int t, int id, HttpServletResponse response) throws ServletException, java.io.IOException {
   sql = "Insert into EVENT (Event_Description, Event_Title, Event_Year, Event_Month, Event_Day, Event_Time, Person_ID) Values('test','" + ttl + "'," + y +",'" + m + "'," + d + "," + t +"," + id + ")"; 
  System.out.println(sql);
   int sr = 0;
   //while (sr < 3000){
   try {
     sr ++;
     
     Statement stmt = conn.createStatement();
     

   stmt.execute(sql);                
   System.out.println("executed");

       
   stmt.close();    
   System.out.println("stmt close");
   conn.close();
   response.sendRedirect("SearchLogic");
      
   }
   
 catch (SQLException e) {
      out.println("</TABLE><H1>ERROReee:</H1> " + e.getMessage());
         }     
//}  

      
}











    /** Handles the HTTP <code>GET</code> method.
    * @param request servlet request
    * @param response servlet response
    */
    public void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, java.io.IOException {
        processRequest(request, response);
        
       
    } 

    /** Handles the HTTP <code>POST</code> method.
    * @param request servlet request
    * @param response servlet response
    */
    public void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, java.io.IOException {
        processRequest(request, response);
    }

    /** Returns a short description of the servlet.
    */
    public String getServletInfo() {
        return "Short description";
    }

}