Guest User

Untitled

a guest
Jul 13th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. <%@ page import="java.sql.ResultSet" %>
  2. <%@ page import="java.sql.Statement" %>
  3. <%@ page import="java.sql.Connection" %>
  4. <%@ page import="java.sql.DriverManager" %>
  5.  
  6. <div class="col-lg-2">
  7. <form method="post">
  8.  
  9. TEXTO DONDE QUISIERA QUE INCREMENTE AL HACER CLICK.
  10.  
  11. <%
  12. try {
  13. Class.forName("com.mysql.jdbc.Driver");
  14. String url = "jdbc:mysql://localhost:3306/likes";
  15. String username = "root";
  16. String password = "rootpass";
  17. String query = "SELECT Like1 from Likes";
  18. Connection conn = DriverManager.getConnection(url, username,
  19. password);
  20. Statement stmt = conn.createStatement();
  21. ResultSet rs = stmt.executeQuery(query);
  22. while (rs.next()) {
  23. %>
  24.  
  25. <%out.println(rs.getInt("Like1")); %>
  26. <%rs.getInt("Like1"); %></b>
  27.  
  28. <%
  29. }
  30. %>
  31.  
  32. <%
  33. rs.close();
  34. stmt.close();
  35. conn.close();
  36. } catch (Exception e) {
  37. e.printStackTrace();
  38. }
  39. %>
  40.  
  41. </form>
  42. </div>
Add Comment
Please, Sign In to add comment