aboutsummaryrefslogtreecommitdiff
path: root/subsonic-main/src/main/webapp/WEB-INF/jsp/db.jsp
blob: 52918ab160e00f1628b07366e1df25650e8d4c8f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="iso-8859-1"%>

<html><head>
    <%@ include file="head.jsp" %>
</head><body class="mainframe bgcolor1">

<h1>Database query</h1>

<form method="post" action="db.view">
    <textarea rows="10" cols="80" name="query" style="margin-top:1em">${model.query}</textarea>
    <input type="submit" value="<fmt:message key="common.ok"/>">
</form>

<c:if test="${not empty model.result}">
    <h1 style="margin-top:2em">Result</h1>

    <table class="indent ruleTable">
        <c:forEach items="${model.result}" var="row" varStatus="loopStatus">

            <c:if test="${loopStatus.count == 1}">
                <tr>
                    <c:forEach items="${row}" var="entry">
                        <td class="ruleTableHeader">${entry.key}</td>
                    </c:forEach>
                </tr>
            </c:if>
            <tr>
                <c:forEach items="${row}" var="entry">
                    <td class="ruleTableCell">${entry.value}</td>
                </c:forEach>
            </tr>
        </c:forEach>

    </table>
</c:if>

<c:if test="${not empty model.error}">
    <h1 style="margin-top:2em">Error</h1>

    <p class="warning">
        ${model.error}
    </p>
</c:if>

</body></html>