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 UpdateRecord extends HttpServlet {
	
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		out.println("<h1><center>Registeration Sucessfully</center><h1>");
		
		String sIdNo = request.getParameter("SID");
		String sRollNo = request.getParameter("SRNO");
		String sName = request.getParameter("SNAME");
		
		Connection con;
		PreparedStatement pst;
		ResultSet rs;
		
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
			con = DriverManager.getConnection("jdbc:mysql://localhost:3306/firstDBPractice","root","nisum123");
			pst = con.prepareStatement("update student set student_RNo=?, student_name=? where student_id=?");
			pst.setString(1, sRollNo);
			pst.setString(2, sName);
			pst.setString(3, sIdNo);
			pst.executeUpdate(); 
			response.sendRedirect("student_record.jsp");
			
		} catch(Exception e) {
			e.printStackTrace();
			out.println(e.getMessage());
		}
		
	}

}