Advertisement
Guest User

Untitled

a guest
Jan 25th, 2019
228
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. @WebServlet(value = "/sqlu")
  2. public class MySQLServletUpdate extends HttpServlet {
  3.  
  4. protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  5. response.setContentType("text/plain; charset=utf-8");
  6.  
  7. try{
  8. Driver driver = new com.mysql.cj.jdbc.Driver();
  9. DriverManager.registerDriver(driver);
  10. Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/AppJEE?useSSL=false&characterEncoding=utf8&useJDBCCompianttimezoneShift=true&useLegacyDatetimecode=false&serverTimezone=UTC", "root", "password");
  11.  
  12. PreparedStatement pstmt = connection.prepareStatement("INSERT INTO uzytkownik VALUES (null, ?, ?, ?)");
  13. pstmt.setString(1, "Zenon");
  14. pstmt.setString(2, "Zenonowy");
  15. pstmt.setString(3, "Zen");
  16.  
  17. if (pstmt.executeUpdate() > 0) {
  18. response.getWriter().println("Rekord zostaƂ dodany");
  19. }
  20.  
  21.  
  22. } catch (SQLException e) {
  23. e.printStackTrace();
  24. }
  25. }
  26.  
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement