Advertisement
Guest User

Untitled

a guest
May 31st, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. Connection con = null;
  2. Statement stmt = null;
  3.  
  4. try {
  5.  
  6. String name = request.getParameter("fullName");
  7. String bday = request.getParameter("birthday");
  8. String address = request.getParameter("address");
  9. String gender = request.getParameter("gender");
  10. String school = request.getParameter("school");
  11.  
  12.  
  13. Class.forName("com.mysql.jdbc.Driver");
  14. con = DriverManager.getConnection(
  15. "jdbc:mysql://localhost:3306/profile", "root", "");
  16.  
  17. stmt = con.createStatement();
  18.  
  19. int i = stmt.executeUpdate("INSERT INTO person VALUES ('"
  20. + name + "','" + bday + "','" + address + "', '"
  21. + gender + "','" + school + "')");
  22.  
  23.  
  24.  
  25.  
  26. }
  27.  
  28. catch (SQLException e) {
  29.  
  30. }
  31.  
  32. finally {
  33. stmt.close();
  34. con.close();
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement