import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class Complete
 */
@WebServlet("/Complete")
public class Complete extends HttpServlet {
	private static final long serialVersionUID = 1L;

    /**
     * @see HttpServlet#HttpServlet()
     */

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */



	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub



		PrintWriter printWriter = response.getWriter();

		int StatusID = Integer.parseInt(request.getParameter("ID"));
		String complete = "Completed";




		try
		{



			Class.forName("com.mysql.jdbc.Driver");

			Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");

			PreparedStatement preparedStatement = connection.prepareStatement("update helpdeskinsert set Status = ? where ID = ?" );

			preparedStatement.setString(1,complete);
			preparedStatement.setInt(2,StatusID);



			int iterator =  preparedStatement.executeUpdate();


			if(iterator>0)
			{
				   printWriter.println("<script type=\"text/javascript\">");
		    	   printWriter.println("alert('Marked Completed');");
		    	   printWriter.println("location='HelpDeskPanel.jsp';");
		    	   printWriter.println("</script>");

			}

			else
			{
				   printWriter.println("<script type=\"text/javascript\">");
		    	   printWriter.println("alert('Unable to add');");
		    	   printWriter.println("location='HelpDeskPanel.jsp';");
		    	   printWriter.println("</script>");



			}










		}


		catch(Exception e)
		{
			printWriter.println("Not possible");
		}


	}

}