Guest User

jdbc with servlets

a guest
Feb 26th, 2020
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.39 KB | None | 0 0
  1.  
  2. import java.sql.*;
  3. import java.io.IOException;
  4. import java.io.PrintWriter;
  5.  
  6. import javax.servlet.ServletException;
  7. import javax.servlet.annotation.WebServlet;
  8. import javax.servlet.http.HttpServlet;
  9. import javax.servlet.http.HttpServletRequest;
  10. import javax.servlet.http.HttpServletResponse;
  11.  
  12. /**
  13. * Servlet implementation class mohit
  14. */
  15. @WebServlet("/mohit")
  16. public class mohit extends HttpServlet {
  17. private static final long serialVersionUID = 1L;
  18. String url="jdbc:mysql://localhost:3306/MOHIT";
  19. String username1="root";
  20. String password1="mysql";
  21. /**
  22. * @see HttpServlet#HttpServlet()
  23. */
  24. public mohit() {
  25. super();
  26. // TODO Auto-generated constructor stub
  27. }
  28.  
  29. /**
  30. * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
  31. */
  32. protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  33. // TODO Auto-generated method stub
  34. response.getWriter().append("Served at: ").append(request.getContextPath());
  35. try {
  36. Class.forName("com.mysql.jdbc.Driver");
  37.  
  38. PrintWriter out = response.getWriter();
  39. String input=request.getParameter("action");
  40. String name=request.getParameter("user");
  41. String password=request.getParameter("pass");
  42. String age=request.getParameter("age");
  43. java.sql.Connection con=DriverManager.getConnection(url,username1,password1);
  44. out.println("Connection successful");
  45. Statement st=con.createStatement();
  46.  
  47. if(input.equals("insert"))
  48. {
  49. int i=st.executeUpdate("insert into data values('"+name+"','"+password+"','"+age+"')");
  50. if(i>0)
  51. {
  52. out.println("inserted successfully");
  53. }
  54. }
  55. else if(input.equals("Select"))
  56. {
  57. ResultSet rs = st.executeQuery("select * from register;");
  58. while(rs.next()){
  59. //Retrieve by column name
  60. String username1 = rs.getString("username");
  61. String password1 = rs.getString("password");
  62. //Display values
  63. //System.out.print(", Username: " + username);
  64. //System.out.println(", Password: " + password1);
  65. out.println(username1);
  66. out.println(password1);
  67.  
  68. }
  69. rs.close();
  70. }
  71.  
  72. } catch (ClassNotFoundException e) {
  73. // TODO Auto-generated catch block
  74. e.printStackTrace();
  75. } catch (SQLException e) {
  76. // TODO Auto-generated catch block
  77. e.printStackTrace();
  78. }
  79.  
  80. }
  81.  
  82. /**
  83. * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  84. */
  85. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  86. // TODO Auto-generated method stub
  87. doGet(request, response);
  88. }
  89.  
  90. }
  91.  
  92. -----------------------------------------------------------------------------
  93. <!DOCTYPE html>
  94. <html>
  95. <head>
  96. <meta charset="UTF-8">
  97. <title>Insert title here</title>
  98. </head>
  99. <body>
  100. <form method='post' action='http://localhost:8080/connectdb/mohit'>
  101. User <input type='text' name='user'>
  102. Password<input type='text' name='pass'>
  103. <input type='submit' name='action' value='insert'>
  104. </form>
  105. </body>
  106. </html>
Add Comment
Please, Sign In to add comment