Guest User

Untitled

a guest
Feb 28th, 2018
36
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.08 KB | None | 0 0
  1. java
  2.  
  3. package com.servlet;
  4.  
  5. import java.io.IOException;
  6. import java.io.PrintWriter;
  7. import java.sql.Connection;
  8. import java.sql.DriverManager;
  9. import java.sql.Statement;
  10.  
  11. import javax.servlet.ServletException;
  12. import javax.servlet.http.HttpServlet;
  13. import javax.servlet.http.HttpServletRequest;
  14. import javax.servlet.http.HttpServletResponse;
  15.  
  16.  
  17. public class Insertion extends HttpServlet
  18. {
  19.  
  20.  
  21.  
  22. protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  23.  
  24. }
  25.  
  26.  
  27. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  28. String regno=request.getParameter("regno");
  29. String name=request.getParameter("name");
  30. String age=request.getParameter("age");
  31. String gender=request.getParameter("gender");
  32. PrintWriter out=response.getWriter();
  33. out.println("sdfad");
  34. try{
  35. Class.forName("com.mysql.jdbc.Driver");
  36. Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/std","root","");
  37. Statement stmt=con.createStatement();
  38.  
  39. int a=stmt.executeUpdate("insert into stdinto values('"+regno+"','"+name+"','"+age+"','"+gender+"')");
  40. out.println("value inserted");
  41. }
  42. catch(Exception e)
  43. {
  44. out.println("error"+e);
  45. }
  46. }
  47. }
  48.  
  49. html
  50. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  51. <html>
  52. <head>
  53. <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
  54. <title>Insert title here</title>
  55. </head>
  56. <body>
  57. <form action="Insertion" method="post">
  58. <center><h1>student info</h1><br></center>
  59. <center>
  60. <table border="1">
  61. <tr>
  62. <td>REG_NO:</td>
  63. <td><input type="text" name="regno"></td>
  64. </tr>
  65. <tr>
  66. <td>Name:</td>
  67. <td><Input type="text" name="name"> </td>
  68. </tr>
  69. <tr>
  70. <td>Age:</td>
  71. <td><Input type="text" name="age"> </td>
  72. </tr>
  73. <tr>
  74. <td>Gender:</td>
  75. <td><Input type="text" name="gender"> </td>
  76. </tr>
  77. <tr>
  78. <td></td><td><input type="submit" value="submit"></td>
  79. </tr>
  80. </table>
  81. </center>
  82. </form>
  83. </body>
  84. </html>
Add Comment
Please, Sign In to add comment