package p1;

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.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class addstu extends HttpServlet {

    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        try (PrintWriter out = response.getWriter()) {
            
            String driver="com.mysql.cj.jdbc.Driver";
            String url="jdbc:mysql://localhost:3306/edu?characterEncoding=utf-8"
                    + "&serverTimezone=UTC";
            String usr="root";
            String password="1234";
            try{
                Class.forName(driver);
                Connection conn=DriverManager.getConnection(url,usr,password);
                String sqlString="INSERT INTO manager1(count,name,gender,telephone,mailbox,age,department)"
                        + "VALUES ( ?, ?, ?, ?, ?, ? ,?)";
                PreparedStatement pstmt=conn.prepareStatement(sqlString);
                String count = request.getParameter("count");
                String name = request.getParameter("name");
                String gender = request.getParameter("gender");
                String telephone = request.getParameter("telephone");
                String mailbox = request.getParameter("mailbox");
                String age = request.getParameter("age");
                String department = request.getParameter("department");
                pstmt.setString(1, count);
                pstmt.setString(2, name);
                pstmt.setString(3,gender);
                pstmt.setString(4, telephone);
                pstmt.setString(5, mailbox);
                pstmt.setString(6, age);
                pstmt.setString(7, department);
                 
                pstmt.execute();
            }catch(Exception e){ 
                System.err.println("error:"+e);
            }
            response.sendRedirect("pages/display.jsp");
        }
    }

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

   @Override
    public String getServletInfo() {
        return "Short description";
    }

}