/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package input;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;//sql header file

/**
 *
 * @author Dark Slayer
 */
public class detail extends HttpServlet {

    /**
     * Processes requests for both HTTP
     * <code>GET</code> and
     * <code>POST</code> methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
           String name=request.getParameter("t1");
            String email=request.getParameter("t2");
            String pass1=request.getParameter("t3");
            String pass2=request.getParameter("t4");
            String phno=request.getParameter("t5");
            String gender=request.getParameter("t6");
            String nationality=request.getParameter("t7");
            String education=request.getParameter("t8");
            String year=request.getParameter("t9");
            String college=request.getParameter("t10");
            String occup=request.getParameter("t11");
            
            
                Class.forName("com.mysql.jdbc.Driver").newInstance();//MAIN CLASS
                Connection con=DriverManager.getConnection("jdbc:mysql://localhost/input?" + "user=root&password=");//main connection
                PreparedStatement pre=con.prepareStatement("insert into detail values(?,?,?,?,?,?,?,?,?,?,?);");//sql command
                pre.setString(1, name);
                pre.setString(2, email);
                pre.setString(3, pass1);
                pre.setString(4, pass2);
                pre.setString(5, phno);
                pre.setString(6, gender);
                pre.setString(7, nationality);
                pre.setString(8, education);
                pre.setString(9, year);
                pre.setString(10, college);
                pre.setString(11, occup);
               
                pre.executeUpdate();
                
               
            }catch(ClassNotFoundException | InstantiationException | IllegalAccessException | SQLException ex)
            {
               System.out.println(ex);
            } finally {            
            String site = new String("login.jsp");

      response.setStatus(response.SC_MOVED_TEMPORARILY);
      response.setHeader("Location", site);    
        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP
     * <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP
     * <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}