[24] | 1 | <?xml version="1.0" encoding="UTF-8"?> |
---|
| 2 | <jsp:root xmlns:jsp="http://java.sun.com/JSP/Page" |
---|
| 3 | xmlns:fmt="http://java.sun.com/jsp/jstl/fmt" |
---|
[27] | 4 | xmlns:fn="http://java.sun.com/jsp/jstl/functions" |
---|
[24] | 5 | xmlns:c="http://java.sun.com/jsp/jstl/core" |
---|
| 6 | version="2.0"> |
---|
| 7 | <jsp:directive.page contentType="text/html" pageEncoding="UTF-8"/> |
---|
| 8 | <fmt:setBundle basename="cz.frantovo.sql.vyuka.preklady" scope="application"/> |
---|
| 9 | <jsp:useBean id="ajax" class="cz.frantovo.sql.vyuka.web.Ajax" scope="request"/> |
---|
| 10 | |
---|
| 11 | <jsp:scriptlet> |
---|
| 12 | request.setCharacterEncoding("UTF-8"); |
---|
| 13 | ajax.setKlient(request.getRemoteAddr(), request.getHeader("x-forwarded-for"), request.getRequestedSessionId()); |
---|
| 14 | </jsp:scriptlet> |
---|
| 15 | |
---|
| 16 | <c:choose> |
---|
| 17 | <!-- Akce: Historie a vykonání SQL příkazu --> |
---|
| 18 | <c:when test="${param.akce == 'historie' || param.akce == 'vykonat'}"> |
---|
| 19 | <c:choose> |
---|
| 20 | <c:when test="${param.akce == 'historie'}"> |
---|
| 21 | <c:set var="vysledek" value="${ajax.historie}" scope="request"/> |
---|
| 22 | </c:when> |
---|
| 23 | <c:when test="${param.akce == 'vykonat'}"> |
---|
| 24 | <jsp:setProperty name="ajax" property="sqlPrikaz" value="${param.sql}"/> |
---|
| 25 | <c:set var="vysledek" value="${ajax.SQLVysledek}" scope="request"/> |
---|
| 26 | </c:when> |
---|
| 27 | </c:choose> |
---|
| 28 | |
---|
| 29 | <!-- Tabulky --> |
---|
| 30 | <c:forEach var="tabulka" items="${vysledek.tabulky}"> |
---|
[26] | 31 | <!-- <lokalizace> --> |
---|
| 32 | <c:choose> |
---|
| 33 | <c:when test="${tabulka.lokalizovat}"> |
---|
| 34 | <fmt:message key="${tabulka.zahlaviTip}" var="zahlaviTip"/> |
---|
| 35 | </c:when> |
---|
| 36 | <c:otherwise> |
---|
| 37 | <c:set value="${tabulka.zahlaviTip}" var="zahlaviTip"/> |
---|
| 38 | </c:otherwise> |
---|
| 39 | </c:choose> |
---|
| 40 | <!-- </lokalizace> --> |
---|
[24] | 41 | <table> |
---|
[26] | 42 | <thead title="${zahlaviTip}"> |
---|
[24] | 43 | <tr> |
---|
| 44 | <c:forEach var="zahlavi" items="${tabulka.zahlavi}"> |
---|
[26] | 45 | <td> |
---|
| 46 | <!-- <lokalizace> --> |
---|
| 47 | <c:if test="${tabulka.lokalizovat}"> |
---|
| 48 | <fmt:message key="${zahlavi}" var="zahlavi"/> |
---|
| 49 | </c:if> |
---|
| 50 | <!-- </lokalizace> --> |
---|
| 51 | <c:out value="${zahlavi}"/> |
---|
| 52 | </td> |
---|
[24] | 53 | </c:forEach> |
---|
| 54 | </tr> |
---|
| 55 | </thead> |
---|
| 56 | <tbody> |
---|
| 57 | <c:forEach var="radek" items="${tabulka.hodnoty}"> |
---|
| 58 | <tr> |
---|
| 59 | <c:forEach var="bunka" items="${radek}"> |
---|
[27] | 60 | <!-- <formátováníPodleDatovýchTypů> --> |
---|
| 61 | <c:choose> |
---|
| 62 | <c:when test="${bunka.class == 'class java.sql.Timestamp'}"> |
---|
| 63 | <td> |
---|
| 64 | <fmt:formatDate value="${bunka}" pattern="dd.MM.yyyy HH:mm:ss"/> |
---|
| 65 | </td> |
---|
| 66 | </c:when> |
---|
| 67 | <c:when test="${bunka.class == 'class java.sql.Date'}"> |
---|
| 68 | <td> |
---|
| 69 | <fmt:formatDate value="${bunka}" pattern="dd.MM.yyyy"/> |
---|
| 70 | </td> |
---|
| 71 | </c:when> |
---|
| 72 | <c:when test="${bunka.class == 'class java.lang.Integer' || bunka.class == 'class java.math.BigDecimal'}"> |
---|
| 73 | <td class="cislo"> |
---|
| 74 | <fmt:formatNumber value="${bunka}" pattern="###,###.###"/> |
---|
| 75 | </td> |
---|
| 76 | </c:when> |
---|
| 77 | <c:otherwise> |
---|
| 78 | <td> |
---|
| 79 | <c:out value="${bunka}" /> |
---|
| 80 | </td> |
---|
| 81 | </c:otherwise> |
---|
| 82 | </c:choose> |
---|
| 83 | <!-- </formátováníPodleDatovýchTypů> --> |
---|
[24] | 84 | </c:forEach> |
---|
| 85 | </tr> |
---|
| 86 | </c:forEach> |
---|
| 87 | </tbody> |
---|
| 88 | </table> |
---|
| 89 | </c:forEach> |
---|
| 90 | |
---|
| 91 | <!-- Hlášky --> |
---|
| 92 | <c:forEach var="hlaska" items="${vysledek.hlasky}"> |
---|
| 93 | <p class="vysledek${hlaska.typ}"> |
---|
| 94 | <c:out value="${hlaska.text}" escapeXml="${hlaska.escapovat}" /> |
---|
| 95 | </p> |
---|
| 96 | </c:forEach> |
---|
| 97 | </c:when> |
---|
| 98 | |
---|
| 99 | <!-- Akce: Nápověda --> |
---|
| 100 | <c:when test="${param.akce == 'napoveda'}"> |
---|
| 101 | <p>TODO: nápověda.</p> |
---|
| 102 | </c:when> |
---|
| 103 | </c:choose> |
---|
| 104 | </jsp:root> |
---|