Advertisement
Guest User

Untitled

a guest
Jun 14th, 2016
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.06 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="ISO-8859-1">
  5. <title>Employee form</title>
  6. </head>
  7. <body>
  8. <h1>Add Employee</h1><br><br>
  9. <form action = "servlet/EmpDetails" method = "post">
  10.  
  11. Employee Name : <input type ="text" name = "employee_name"><br><br>
  12. Employee Designation : <input type = "text" name = "employee_Designation"><br><br>
  13. Reporting Manager : <input type = "text" name = "manager_name"><br><br>
  14. <input type = "submit">
  15.  
  16. </form>
  17.  
  18. </body>
  19. </html>
  20.  
  21. import java.io.IOException;
  22. import java.io.PrintWriter;
  23. import java.sql.Connection;
  24. import java.sql.DriverManager;
  25. import java.sql.PreparedStatement;
  26.  
  27. import javax.servlet.ServletException;
  28. import javax.servlet.annotation.WebServlet;
  29. import javax.servlet.http.HttpServlet;
  30. import javax.servlet.http.HttpServletRequest;
  31. import javax.servlet.http.HttpServletResponse;
  32.  
  33. /**
  34. * Servlet implementation class EmpDetails
  35. */
  36. @WebServlet("/EmpDetails")
  37. public class EmpDetails extends HttpServlet {
  38. private static final long serialVersionUID = 1L;
  39.  
  40. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  41. response.setContentType("text/html");
  42. PrintWriter out = response.getWriter();
  43.  
  44. String empName = request.getParameter("employee_name");
  45. String empDesignation = request.getParameter("employee_Designation");
  46. String manager = request.getParameter("manager_name");
  47.  
  48. try {
  49. Class.forName("com.mysql.jdbc.Driver");
  50. System.out.println("registered");
  51. Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/hirarchy_check","root","root@123");
  52. PreparedStatement ps = connection.prepareStatement("insert into employee_details values(?,?,?)");
  53. ps.setString(1, empName);
  54. ps.setString(2, empDesignation);
  55. ps.setString(3, manager);
  56.  
  57. int i=ps.executeUpdate();
  58. if(i>0)
  59. out.print("You are successfully registered...");
  60.  
  61. }catch(Exception e){System.out.println(e);}
  62. }
  63. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement