Guest User

Untitled

a guest
Mar 10th, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. public class reg extends HttpServlet {
  2. static String name;
  3. static String password;
  4. static String age;
  5. static String login;
  6. Connection connection;
  7. PreparedStatement pst;
  8. static String pass = "1234";
  9. static String root = "root";
  10. static String connectionURL="jdbc:mysql://localhost:3306/mysql";
  11.  
  12. @Override
  13. protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  14. name=req.getParameter("name");
  15. password=req.getParameter("password");
  16. age=req.getParameter("age");
  17. login=req.getParameter("login");
  18. System.out.println(name);
  19. System.out.println(age);
  20. System.out.println(login);
  21. System.out.println(password);
  22. try{
  23. //Class.forName("com.mysql.jdbc.Driver");
  24. DriverManager.registerDriver(new com.mysql.jdbc.Driver());
  25. connection= DriverManager.getConnection(connectionURL, root,pass);
  26. pst=connection.prepareStatement("INSERT INTO users (NAME, AGE, LOGIN, PASSWORD) VALUES (?,?,?,?)");
  27. pst.setString(1, name);
  28. pst.setString(2,age);
  29. pst.setString(3,login);
  30. pst.setString(4,password);
  31. pst.execute();
  32. }
  33. catch (Exception e){e.printStackTrace();System.out.println("Ooops!");}
  34. }
Add Comment
Please, Sign In to add comment