Advertisement
Guest User

Untitled

a guest
Jan 15th, 2016
155
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. try {
  2. String name = request.getParameter("name");
  3. String pass = request.getParameter("pass");
  4. Class.forName("com.mysql.jdbc.Driver").newInstance();
  5. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dimple?zeroDateTimeBehavior=convertToNull", "root", "password");
  6. PreparedStatement ps = con.prepareStatement("Insert Into data Values(? ,? )");
  7. ps.setString(1, name);
  8. ps.setString(2, pass);
  9. int f = ps.executeUpdate();
  10. if(f>0)
  11. {
  12. out.println("Successfuly inserted");
  13. RequestDispatcher rd = request.getRequestDispatcher("index.html");
  14. rd.forward(request, response);
  15. }
  16. else
  17. out.println("Not inserted");
  18.  
  19. }
  20. catch(Exception e)
  21. {
  22. out.println(e);
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement