Guest User

tr

a guest
Mar 30th, 2016
29
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
  2. pageEncoding="ISO-8859-1"%>
  3.  
  4. <%@ taglib uri = "http://java.sun.com/jsp/jstl/core" prefix = "c" %>
  5. <%@ taglib uri = "http://java.sun.com/jsp/jstl/sql" prefix = "sql" %>
  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" content="text/html; charset=ISO-8859-1">
  10. <title>View Design</title>
  11. </head>
  12.  
  13. <body bgcolor = "red">
  14.  
  15.  
  16.  
  17.  
  18. <sql:setDataSource var = "myDs"
  19. driver = "com.mysql.jdbc.Driver"
  20. url = "jdbc:mysql://localhost/design"
  21. user = "root"
  22. password = "yellow1"
  23. />
  24.  
  25.  
  26.  
  27.  
  28. <sql:query var ="fetchdata" dataSource = "${myDs}">
  29. SELECT *FROM extra;
  30. </sql:query>
  31.  
  32. <div align = "center">
  33. <table>
  34. <tr style = "font-weight:Bold">
  35. <td>Desgin_Name</td>
  36. <td>Date</td>
  37. <td>Image</td>
  38. </tr>
  39.  
  40.  
  41.  
  42. <c:forEach var = "fetch" items = "${fetchdata.rows}">
  43. <tr>
  44. <td><c:out value = "${fetch.Design_name}"/></td>
  45. <td><c:out value = "${fetch.Date}"/></td>
  46.  
  47. <td><c:out value = "${fetch.Image}.tostring();"/></td>
  48.  
  49. </tr>
  50. </c:forEach>
  51.  
  52.  
  53. </table>
  54. </div>
  55.  
  56.  
  57.  
  58. </body>
  59. </html>
Add Comment
Please, Sign In to add comment