package javawebapplication;
import java.io.IOException;

import java.io.PrintWriter;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.PreparedStatement;

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

public class DeleteRecord extends HttpServlet{
	
	private static final long serialVersionUID = -9115080876652271692L;
	Connection con;
	Statement stat;
	PreparedStatement pst;
	ResultSet rs;
	int row;
	
	 public void doPost(HttpServletRequest req, HttpServletResponse res)throws ServletException, IOException{
	    	
	    	res.setContentType("text/html");
			PrintWriter out = res.getWriter();
			out.println("<h1><center>Record Delete Successfull</center><h1>");			
	          String sId = req.getParameter("d");  
              Integer studentId = Integer.parseInt(sId);
             out.println(sId);
             out.println(studentId);
             
	        try {
	        	
	        	Class.forName("com.mysql.jdbc.Driver").newInstance();
	        	Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/firstDBPractice", "root", "nisum123");
	        	Statement  stat = conn.createStatement();
	        	stat.executeUpdate("delete from student where student_id='"+studentId+"'");
	        	 res.sendRedirect("student_record.jsp");
	      	   
		}catch(Exception e) {
			e.printStackTrace();
			out.println(e.getMessage());
		}	
		
	 }
}