Guest User

Untitled

a guest
Aug 7th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.98 KB | None | 0 0
  1. <%@ page import ="java.sql.*" %>
  2. <h1>hello saurabh</h1>
  3. <%
  4.  
  5. String s1 = request.getParameter("uname");
  6. String s2="saurabh";
  7.  
  8. String driver ="com.mysql.jdbc.Driver";
  9.  
  10. String url ="jdbc:mysql://localhost:3306/amber";
  11.  
  12. String userName = "root";
  13.  
  14. String password = "sameer0207";
  15.  
  16. Connection conn = null;
  17.  
  18. Statement st = null;
  19. out.println(s2);
  20.  
  21. try {
  22. out.println("Enterd in try");
  23.  
  24. Class.forName(driver);
  25. out.println(driver);
  26.  
  27. conn = DriverManager.getConnection(url,userName,password);
  28. out.println("Connected to the database");
  29.  
  30. String query="INSERT INTO quote VALUES (garima, 8588803860, 'tyagi619@gmail.com', 'kuchb bhi');";
  31. st = conn.createStatement();
  32.  
  33. ResultSet rs = st.executeQuery(query);
  34. if(rs.next())
  35. {out.println("success");
  36. conn.close();}
  37. else
  38. {out.println("not success");}
  39.  
  40. }catch(Exception e){
  41. System.out.println("Exception occured! "+e.getMessage()+" "+e.getStackTrace());
  42. }
  43.  
  44.  
  45. %>
Add Comment
Please, Sign In to add comment