Advertisement
GameNCode

SQL UsersDB

Feb 3rd, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. <%@ page language="java" contentType="text/html; charset=windows-1255"
  2. pageEncoding="windows-1255"%>
  3. <%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
  4. <%@ page import="java.sql.*"%>
  5. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
  6. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  7. <html>
  8. <head>
  9. <meta http-equiv="Content-Type"
  10. content="text/html; charset=windows-1255">
  11. <title>Just Cause</title>
  12. </head>
  13. <body>
  14. <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver"
  15. url="jdbc:mysql://localhost:3306/homework" user="root"
  16. password="Royboy007" />
  17.  
  18. <sql:query dataSource="${snapshot}" var="result">
  19. SELECT * from users;
  20. </sql:query>
  21.  
  22. <table border="1" width="100%">
  23. <tr>
  24. <th>#</th>
  25. <th>Username</th>
  26. <th>Password</th>
  27. </tr>
  28. <c:forEach var="row" items="${result.rows}">
  29. <tr>
  30. <td><c:out value="${row.id}" /></td>
  31. <td><c:out value="${row.user}" /></td>
  32. <td><c:out value="${row.password}" /></td>
  33. </tr>
  34. </c:forEach>
  35. </body>
  36. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement