[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> |
---|
[29] | 17 | <!-- <Akce: Historie a vykonání SQL příkazu> --> |
---|
[24] | 18 | <c:when test="${param.akce == 'historie' || param.akce == 'vykonat'}"> |
---|
[29] | 19 | <!-- <Načteme výsledek z beany> --> |
---|
[24] | 20 | <c:choose> |
---|
| 21 | <c:when test="${param.akce == 'historie'}"> |
---|
| 22 | <c:set var="vysledek" value="${ajax.historie}" scope="request"/> |
---|
| 23 | </c:when> |
---|
| 24 | <c:when test="${param.akce == 'vykonat'}"> |
---|
| 25 | <jsp:setProperty name="ajax" property="sqlPrikaz" value="${param.sql}"/> |
---|
| 26 | <c:set var="vysledek" value="${ajax.SQLVysledek}" scope="request"/> |
---|
| 27 | </c:when> |
---|
| 28 | </c:choose> |
---|
[29] | 29 | <!-- </Načteme výsledek z beany> --> |
---|
[24] | 30 | |
---|
[29] | 31 | <!-- <Tabulky> --> |
---|
[24] | 32 | <c:forEach var="tabulka" items="${vysledek.tabulky}"> |
---|
[26] | 33 | <!-- <lokalizace> --> |
---|
| 34 | <c:choose> |
---|
| 35 | <c:when test="${tabulka.lokalizovat}"> |
---|
| 36 | <fmt:message key="${tabulka.zahlaviTip}" var="zahlaviTip"/> |
---|
| 37 | </c:when> |
---|
| 38 | <c:otherwise> |
---|
| 39 | <c:set value="${tabulka.zahlaviTip}" var="zahlaviTip"/> |
---|
| 40 | </c:otherwise> |
---|
| 41 | </c:choose> |
---|
| 42 | <!-- </lokalizace> --> |
---|
[24] | 43 | <table> |
---|
[26] | 44 | <thead title="${zahlaviTip}"> |
---|
[24] | 45 | <tr> |
---|
| 46 | <c:forEach var="zahlavi" items="${tabulka.zahlavi}"> |
---|
[26] | 47 | <td> |
---|
| 48 | <!-- <lokalizace> --> |
---|
| 49 | <c:if test="${tabulka.lokalizovat}"> |
---|
| 50 | <fmt:message key="${zahlavi}" var="zahlavi"/> |
---|
| 51 | </c:if> |
---|
| 52 | <!-- </lokalizace> --> |
---|
| 53 | <c:out value="${zahlavi}"/> |
---|
| 54 | </td> |
---|
[24] | 55 | </c:forEach> |
---|
| 56 | </tr> |
---|
| 57 | </thead> |
---|
| 58 | <tbody> |
---|
| 59 | <c:forEach var="radek" items="${tabulka.hodnoty}"> |
---|
| 60 | <tr> |
---|
| 61 | <c:forEach var="bunka" items="${radek}"> |
---|
[27] | 62 | <!-- <formátováníPodleDatovýchTypů> --> |
---|
| 63 | <c:choose> |
---|
| 64 | <c:when test="${bunka.class == 'class java.sql.Timestamp'}"> |
---|
| 65 | <td> |
---|
| 66 | <fmt:formatDate value="${bunka}" pattern="dd.MM.yyyy HH:mm:ss"/> |
---|
[29] | 67 | <!-- uvnitř vzoru je nedělitelná mezera --> |
---|
[27] | 68 | </td> |
---|
| 69 | </c:when> |
---|
| 70 | <c:when test="${bunka.class == 'class java.sql.Date'}"> |
---|
| 71 | <td> |
---|
| 72 | <fmt:formatDate value="${bunka}" pattern="dd.MM.yyyy"/> |
---|
| 73 | </td> |
---|
| 74 | </c:when> |
---|
| 75 | <c:when test="${bunka.class == 'class java.lang.Integer' || bunka.class == 'class java.math.BigDecimal'}"> |
---|
| 76 | <td class="cislo"> |
---|
| 77 | <fmt:formatNumber value="${bunka}" pattern="###,###.###"/> |
---|
| 78 | </td> |
---|
| 79 | </c:when> |
---|
[31] | 80 | <c:when test="${bunka.class == 'class java.lang.Boolean'}"> |
---|
| 81 | <td> |
---|
| 82 | <c:choose> |
---|
| 83 | <c:when test="${bunka}"> |
---|
| 84 | <fmt:message key="boolean.pravda.tip" var="pravda"/> |
---|
| 85 | <abbr title="${pravda}"><fmt:message key="boolean.pravda"/></abbr> |
---|
| 86 | </c:when> |
---|
| 87 | <c:otherwise> |
---|
| 88 | <fmt:message key="boolean.nepravda.tip" var="nepravda"/> |
---|
| 89 | <abbr title="${nepravda}"><fmt:message key="boolean.nepravda"/></abbr> |
---|
| 90 | </c:otherwise> |
---|
| 91 | </c:choose> |
---|
| 92 | </td> |
---|
| 93 | </c:when> |
---|
[27] | 94 | <c:otherwise> |
---|
| 95 | <td> |
---|
| 96 | <c:out value="${bunka}" /> |
---|
| 97 | </td> |
---|
| 98 | </c:otherwise> |
---|
| 99 | </c:choose> |
---|
| 100 | <!-- </formátováníPodleDatovýchTypů> --> |
---|
[24] | 101 | </c:forEach> |
---|
| 102 | </tr> |
---|
| 103 | </c:forEach> |
---|
| 104 | </tbody> |
---|
| 105 | </table> |
---|
| 106 | </c:forEach> |
---|
[29] | 107 | <!-- </Tabulky> --> |
---|
[24] | 108 | |
---|
[29] | 109 | <!-- <Hlášky> --> |
---|
[24] | 110 | <c:forEach var="hlaska" items="${vysledek.hlasky}"> |
---|
| 111 | <p class="vysledek${hlaska.typ}"> |
---|
| 112 | <c:out value="${hlaska.text}" escapeXml="${hlaska.escapovat}" /> |
---|
| 113 | </p> |
---|
| 114 | </c:forEach> |
---|
[29] | 115 | <!-- </Hlášky> --> |
---|
[24] | 116 | </c:when> |
---|
[29] | 117 | <!-- </Akce: Historie a vykonání SQL příkazu> --> |
---|
[24] | 118 | |
---|
[29] | 119 | |
---|
| 120 | <!-- <Akce: Nápověda> --> |
---|
[24] | 121 | <c:when test="${param.akce == 'napoveda'}"> |
---|
| 122 | <p>TODO: nápověda.</p> |
---|
| 123 | </c:when> |
---|
[29] | 124 | <!-- </Akce: Nápověda> --> |
---|
[24] | 125 | </c:choose> |
---|
| 126 | </jsp:root> |
---|