📄 datasourcetest.jsp
字号:
<%-- * Licensed under the GPL License. You may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://probe.jstripe.com/d/license.shtml * * THIS PACKAGE IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR * IMPLIED WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED * WARRANTIES OF MERCHANTIBILITY AND FITNESS FOR A PARTICULAR PURPOSE. --%><%@ page contentType="text/html;charset=UTF-8" language="java" session="false" %><%@ taglib uri='http://java.sun.com/jsp/jstl/core' prefix='c' %><%@ taglib uri="http://www.springframework.org/tags" prefix="spring" %><%@ taglib uri="http://displaytag.sf.net" prefix="display" %><html><head> <title><spring:message code="probe.jsp.title.testDataSource" arguments="${param.webapp},${param.resource}"/></title> <link rel="stylesheet" href="${pageContext.request.contextPath}<spring:theme code="datasourcetest.css"/>" type="text/css"/> <link rel="stylesheet" href="${pageContext.request.contextPath}<spring:theme code="scroller.css"/>" type="text/css"/></head><%-- Provides GUI for datasource connectivity testing. Allows a user to enter an SQL query and displays results returned by the query. Author: Andy Shapoval, Vlad Ilyushchenko--%><body><script type="text/javascript" language="javascript" src="<c:url value="/js/prototype.js"/>"></script><script type="text/javascript" language="javascript" src="<c:url value="/js/behaviour.js"/>"></script><script type="text/javascript" language="javascript" src="<c:url value="/js/scriptaculous.js"/>"></script><script type="text/javascript" language="javascript" src="<c:url value="/js/func.js"/>"></script><script type="text/javascript" language="javascript" src="<c:url value="/js/areascroller.js"/>"></script><script type="text/javascript" language="javascript" src="<c:url value="/js/datasourcetest.js"/>"></script><c:set var="navTabDatasources" value="active" scope="request"/><div class="dataSourceTestMenu"> <ul class="options"> <c:if test="${! empty backURL}"> <li id="back"> <a href="${backURL}"><spring:message code="probe.jsp.dataSourceTest.menu.back"/></a> </li> </c:if> <li id="connect"> <a href=""><spring:message code="probe.jsp.dataSourceTest.menu.connect"/></a> </li> <li id="executeSql"> <a href=""><spring:message code="probe.jsp.dataSourceTest.menu.execute"/></a> </li> <li id="showHistory"> <a href=""><spring:message code="probe.jsp.dataSourceTest.menu.showHistory"/></a> </li> <li id="hideHistory" style="display: none;"> <a href=""><spring:message code="probe.jsp.dataSourceTest.menu.hideHistory"/></a> </li> <li id="showOptions"> <a href=""><spring:message code="probe.jsp.dataSourceTest.menu.showOptions"/></a> </li> <li id="hideOptions" style="display: none;"> <a href=""><spring:message code="probe.jsp.dataSourceTest.menu.hideOptions"/></a> </li> <li id="abbreviations"> <a href=""><spring:message code="probe.jsp.dataSourceTest.menu.abbreviations"/></a> </li> </ul></div><div class="dataSourceTestContent"> <div id="help" class="helpMessage" style="display: none;"> <div class="ajax_activity"></div> </div> <form id="sqlForm" action="" method="post"> <input type="hidden" name="webapp" value="${param.webapp}"/> <input type="hidden" name="resource" value="${param.resource}"/> <dl id="sqlDL"> <dt><label for="sql"><spring:message code="probe.jsp.dataSourceTest.sqlForm.sql.label"/></label></dt> <dd id="sqlContainer"> <textarea id="sql" name="sql" rows="5" cols="80"></textarea> <div id="sqlDragHandle"> </div> </dd> </dl> <dl id="optionsDL" style="display: none;"> <dt><label for="maxRows"><spring:message code="probe.jsp.dataSourceTest.sqlForm.maxRows.label"/></label></dt> <dd><input type="text" id="maxRows" name="maxRows" class="txtInput" value="${maxRows}" size="6"/></dd> <dt><label for="rowsPerPage"><spring:message code="probe.jsp.dataSourceTest.sqlForm.rowsPerPage.label"/></label></dt> <dd><input type="text" id="rowsPerPage" name="rowsPerPage" class="txtInput" value="${rowsPerPage}" size="6"/></dd> <dt><label for="historySize"><spring:message code="probe.jsp.dataSourceTest.sqlForm.historySize.label"/></label></dt> <dd><input type="text" id="historySize" name="historySize" class="txtInput" value="${historySize}" size="6"/></dd> </dl> </form> <div id="queryHistoryContainer" style="display: none;"> <h3 id="queryHistoryH3"><spring:message code="probe.jsp.dataSourceTest.h3.queryHistory"/></h3> <ul class="options"> <li id="wrap"> <a href=""><spring:message code="probe.jsp.dataSourceTest.menu.wrap"/></a> </li> <li id="nowrap" style="display: none;"> <a href=""><spring:message code="probe.jsp.dataSourceTest.menu.nowrap"/></a> </li> </ul> <div id="queryHistoryBorder"> <div id="queryHistoryHolder"></div> <div id="historyDragHandle"> </div> </div> </div> <div id="sqlResultsHeader"> <h3 id="metaDataH3" style="display: none;"><spring:message code="probe.jsp.dataSourceTest.h3.metaData"/></h3> <h3 id="resultsH3" style="display: none;"><spring:message code="probe.jsp.dataSourceTest.h3.results"/></h3> <div id="ajaxActivity" class="ajax_activity" style="display: none;"></div> </div> <div id="sqlResultsWrapper" style="display: none;"> <div> <span id="rowsAffected"></span><span id="pagebanner"></span><span id="pagelinks"></span> </div> <table id="resultsTable" cellspacing="0"> <tr> <td id="left_scroller" class="scroller" style="display: none;"> </td> <td id="separator" width="1%" style="display: none;"> </td> <td><div id="outputHolder"></div></td> <td id="right_scroller" class="scroller" style="display: none;"> </td> </tr> </table> </div></div><script type="text/javascript"> setupAjaxActions( '<c:url value="/sql/connection.ajax"/>', '<c:url value="/sql/recordset.ajax"/>', '<c:url value="/sql/queryHistory.ajax"/>'); setupShortcuts(); setupHelpToggle('<c:url value="/datasourcetest.help.ajax"/>'); new Draggable('sqlDragHandle', {constraint: 'vertical', change: resizeTextArea, revert: revertDragHandle}); new Draggable('historyDragHandle', {constraint: 'vertical', change: resizeQueryHistory, revert: revertDragHandle}); setupScrollers('sqlResultsContainer'); $('sql').focus();</script></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -