Guest User

JDBC Connectivity

a guest
Feb 26th, 2020
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.31 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <meta charset="UTF-8">
  5. <title>Insert title here</title>
  6. </head>
  7. <body>
  8. <form name="myform" action="http://localhost:8080/connectivity/databaseconn" method="post">
  9. Username<input type = "text" name="username">
  10. Password<input type = "text" name="password">
  11. <input type = "submit" name="action" value="Insert">
  12. <input type = "submit" name="action" value="Update">
  13. <input type = "submit" name="action" value="Delete">
  14. <input type = "submit" name="action" value="Select">
  15. </form>
  16. </body>
  17. </html>
  18.  
  19.  
  20. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  21.  
  22.  
  23.  
  24. import java.io.IOException;
  25. import java.io.PrintWriter;
  26. import java.sql.*;
  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 databaseconn
  35. */
  36. @WebServlet("/databaseconn")
  37. public class databaseconn extends HttpServlet {
  38. private static final long serialVersionUID = 1L;
  39.  
  40.  
  41. //String url1="jdbc:mysql://localhost:3306";
  42. String url="jdbc:mysql://localhost:3306/a1";
  43. String username1="root";
  44. String password1="mysql";
  45. /**
  46. * @see HttpServlet#HttpServlet()
  47. */
  48.  
  49.  
  50. public databaseconn() {
  51. super();
  52. // TODO Auto-generated constructor stub
  53. }
  54.  
  55. /**
  56. * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  57. */
  58. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  59. // TODO Auto-generated method stub
  60.  
  61. PrintWriter out = response.getWriter();
  62. String input=request.getParameter("action");
  63.  
  64. String name=request.getParameter("username");
  65.  
  66. String password=request.getParameter("password");
  67.  
  68.  
  69.  
  70.  
  71. try
  72. {
  73. Class.forName("com.mysql.jdbc.Driver");
  74. /*
  75. java.sql.Connection con1=DriverManager.getConnection(url1,username1,password1);
  76.  
  77. out.println("Connection successful");
  78.  
  79. Statement st1=con1.createStatement();
  80.  
  81. int k=st1.executeUpdate("create table vwt(username varchar(20),password varchar(20));");
  82.  
  83. if(k>0)
  84. {
  85. out.println("Database Created Successful");
  86. }
  87.  
  88. */
  89.  
  90. java.sql.Connection con=DriverManager.getConnection(url,username1,password1);
  91.  
  92. out.println("Connection successful");
  93.  
  94. Statement st=con.createStatement();
  95.  
  96.  
  97. if(input.equals("Insert"))
  98. {
  99. int i=st.executeUpdate("insert into vwt values('"+name+"','"+password+"')");
  100. if(i>0)
  101. {
  102. out.println("inserted successfully");
  103. }
  104. }
  105. else if(input.equals("Select"))
  106. {
  107. ResultSet rs = st.executeQuery("select * from vwt ;");
  108. while(rs.next()){
  109. //Retrieve by column name
  110. String username1 = rs.getString("username");
  111. String password1 = rs.getString("password");
  112. //Display values
  113. //System.out.print(", Username: " + username);
  114. //System.out.println(", Password: " + password1);
  115. out.println(username1);
  116. out.println(password1);
  117.  
  118. }
  119. rs.close();
  120. }
  121. }catch(Exception e)
  122. {
  123.  
  124. }
  125.  
  126.  
  127.  
  128.  
  129.  
  130. }
  131.  
  132. }
Add Comment
Please, Sign In to add comment