diff options
| author | Scott Jackson <daneren2005@gmail.com> | 2012-07-02 21:24:02 -0700 |
|---|---|---|
| committer | Scott Jackson <daneren2005@gmail.com> | 2012-07-02 21:24:02 -0700 |
| commit | a1a18f77a50804e0127dfa4b0f5240c49c541184 (patch) | |
| tree | 19a38880afe505beddb5590379a8134d7730a277 /subsonic-main/src/main/webapp/WEB-INF/jsp/db.jsp | |
| parent | b61d787706979e7e20f4c3c4f93c1f129d92273f (diff) | |
| download | dsub-a1a18f77a50804e0127dfa4b0f5240c49c541184.tar.gz dsub-a1a18f77a50804e0127dfa4b0f5240c49c541184.tar.bz2 dsub-a1a18f77a50804e0127dfa4b0f5240c49c541184.zip | |
Initial Commit
Diffstat (limited to 'subsonic-main/src/main/webapp/WEB-INF/jsp/db.jsp')
| -rw-r--r-- | subsonic-main/src/main/webapp/WEB-INF/jsp/db.jsp | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/subsonic-main/src/main/webapp/WEB-INF/jsp/db.jsp b/subsonic-main/src/main/webapp/WEB-INF/jsp/db.jsp new file mode 100644 index 00000000..52918ab1 --- /dev/null +++ b/subsonic-main/src/main/webapp/WEB-INF/jsp/db.jsp @@ -0,0 +1,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>
\ No newline at end of file |