Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-view.vm URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-view.vm?rev=763970&view=auto ============================================================================== --- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-view.vm (added) +++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-view.vm Fri Apr 10 16:16:18 2009 @@ -0,0 +1,199 @@ +#* +Licensed to the Apache Software Foundation (ASF) under one or more +contributor license agreements. See the NOTICE file distributed with +this work for additional information regarding copyright ownership. +The ASF licenses this file to You under the Apache License, Version 2.0 +(the "License"); you may not use this file except in compliance with +the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, software +distributed under the License is distributed on an "AS IS" BASIS, +WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +See the License for the specific language governing permissions and +limitations under the License. +*# + +#** + +...@author <a href="mailto:[email protected]";>David Sean Taylor</a> +...@version $Id: database-browser-portlet.vm,v 1.14 2004/08/29 22:27:27 jford Exp $ + +*# + +#set ($MESSAGES = $portletConfig.getResourceBundle($renderRequest.Locale)) + +#if ($statusMsg) +#parse ('/WEB-INF/view/status-include.vm') +#end +#set ($xlsLink = $renderResponse.createResourceURL()) +$xlsLink.setParameter("exportType","xlsExport") +#set ($contextPath = $renderRequest.getContextPath()) +#if ($tableSize > 0) +<table> + <tr> + <td><a target="_blank" title="Export to Excel" href="$xlsLink"><img border="0" src="${contextPath}/images/application-vnd.ms-excel.png"></a> </td> + </tr> +</table> +#end +<table cellpadding=0 cellspacing=1 border=0 width="100%"> + <tbody> + <tr> + #foreach ($column in $title) + #set ($columnLink = $renderResponse.createRenderURL()) + $columnLink.setParameter("js_dbcolumn",$column) + $columnLink.setParameter("sortOrder",$sortOrder) + <td align=CENTER class="jetdbHead" width="43" nowrap onClick="window.location.href='$columnLink'"> + <div align="center">$column</div> + </td> + #end + #if ($rowLinks) + #if ($rowLinks.size() > 0) + <td align=CENTER width="43" class="jetdbHead"></td> + #end + #end + </tr> + #foreach ( $row in $table ) + <tr> + #if ($velocityCount % 2 == 0) + #set ($rowstyle = "jetdbEven") + #else + #set ($rowstyle = "jetdbOdd") + #end + #foreach ( $entry in $row ) + #if ($velocityCount == 1) + #set ($rowid = $entry) + #end + <td nowrap class="$rowstyle" width="23"> + <div class="$rowstyle" align="center">$entry</div> + </td> + #end + #if ($rowLinks) + #if ($rowLinks.size() > 0) + <td class="listCell" nowrap width="100"> + #foreach ($rowLink in $rowLinks) + #set ($rName = $MESSAGES.get($rowLink.Name)) + #if($rowLink.Type=="pane") + #set ($link1 = $jslink.setPaneByName($rowLink.Action).addQueryData("js_rowid",$rowid).addQueryData("js_mode",$rName)) + #else + #set ($link1 = $jslink.setPage($rowLink.Page).addQueryData("js_rowid",$rowid).addQueryData("js_mode",$rName)) + #end + <a class="listCell" href='$link1'>$rName</a> + #end + </td> + #end + #end + </tr> + #end + #if ($tableLinks) + #if ($tableLinks.size() > 0) + <tr> + <td> + </td> + </tr> + <tr> + #foreach ($tableLink in $tableLinks) + #set ($tName = $MESSAGES.get($tableLink.Name) ) + #if ($tableLink.Type == "pane") + #set ($link2 = $jslink.setPaneByName($tableLink.Action).addQueryData("js_mode",$tName)) + #else + #set ($link2 = $jslink.setPage($tableLink.Page).addQueryData("js_mode",$tName)) + #end + <td><a href='$link2'>$tName</a></td> + #end + </tr> + #end + #end + </tbody> +</table> +<table width="100%" border="0" cellspacing="0" cellpadding="0"> + <tr bgcolor="#6868AB"> + <td> + </td> + </tr> +</table> +<table width="200" border="0" cellspacing="0" cellpadding="0" align="center"> + <tr> + #if ($prev) + <td valign="middle" height="30"> + <div align="center"> + #set ($actionLink = $renderResponse.createActionURL()) + $actionLink.setParameter("start",'0') + <form action="$actionLink" method="post"> + <input type='hidden' name='db.browser.action' value='first'/> + <input class="jetdbButton" type="submit" value="<<"> + </form> + </div> + </td> + <td valign="middle" height="30"> + <div align="center"> + #set ($actionLink1 = $renderResponse.createActionURL()) + $actionLink1.setParameter("start",$prev) + <form action="$actionLink1" method="post"> + <input type='hidden' name='db.browser.action' value='prev'/> + <input class="jetdbButton" type="submit" value="<"> + </form> + </div> + </td> + #end + #if ($tableSize > 0) + #set ($actionLink = $renderResponse.createActionURL()) + $actionLink.setParameter("start","$start") + <form action="$actionLink" method="post"> + <td valign="middle" height="30"> + <div align="center"> + <input type='hidden' name='db.browser.action' value='change'/> + #set($index = $start + 1) + <input type="input" name='start' size='5' value="$index"> + </div> + </td> + <td valign="middle" height="30"> + <div align="center"> + <input type="input" readonly size='10' value="of $tableSize"> + </div> + </td> + <td valign="middle" height="30"> + <div align="center"> + <input class="jetdbButton" type="submit" value="Go"> + </div> + </td> + + </form> + + + #end + #if ($next) + <td valign="middle"> + <div align="center"> + #set ($actionLink = $renderResponse.createActionURL()) + $actionLink.setParameter("start",$next) + <form action="$actionLink" method="post"> + <input type='hidden' name='db.browser.action' value='next'/> + <input class="jetdbButton" type="submit" value=">"> + </form> + </div> + </td> + <td valign="middle" height="30"> + <div align="center"> + #set ($actionLink = $renderResponse.createActionURL()) + $actionLink.setParameter("start","$tableSize") + <form action="$actionLink" method="post"> + <input type='hidden' name='db.browser.action' value='last'/> + <input class="jetdbButton" type="submit" value=">>"> + </form> + </div> + </td> + #end + #if ($tableSize > 0) + <td valign="middle"> + <div align="center"> + <form action="$renderResponse.createActionURL()" method="post"> + <input type='hidden' name='db.browser.action' value='refresh'/> + <input class="jetdbButton" type="submit" name="eventSubmit_doRefresh" value="$MESSAGES.getString('dbrefresh')" /> + </form> + </div> + </td> + #end + </tr> +</table> \ No newline at end of file
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/status-include.vm URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/status-include.vm?rev=763970&view=auto ============================================================================== --- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/status-include.vm (added) +++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/status-include.vm Fri Apr 10 16:16:18 2009 @@ -0,0 +1,22 @@ +#* +Licensed to the Apache Software Foundation (ASF) under one or more +contributor license agreements. See the NOTICE file distributed with +this work for additional information regarding copyright ownership. +The ASF licenses this file to You under the Apache License, Version 2.0 +(the "License"); you may not use this file except in compliance with +the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, software +distributed under the License is distributed on an "AS IS" BASIS, +WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +See the License for the specific language governing permissions and +limitations under the License. +*# +<br/> +<table width="100%" cellpadding="0" cellspacing="0" border="0"> +<tr> + <div class="$statusMsg.Type">$statusMsg.Text</div> +</tr> +</table> Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/web.xml URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/web.xml?rev=763970&view=auto ============================================================================== --- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/web.xml (added) +++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/web.xml Fri Apr 10 16:16:18 2009 @@ -0,0 +1,63 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + Licensed to the Apache Software Foundation (ASF) under one or more + contributor license agreements. See the NOTICE file distributed with this + work for additional information regarding copyright ownership. The ASF + licenses this file to You under the Apache License, Version 2.0 (the + "License"); you may not use this file except in compliance with the License. + You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law + or agreed to in writing, software distributed under the License is + distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + KIND, either express or implied. See the License for the specific language + governing permissions and limitations under the License. +--> +<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN" + "http://java.sun.com/dtd/web-app_2_3.dtd";> +<web-app> + <display-name>Portals Database Browser application</display-name> + <description>Apache Portals Applications: db-browser portlet application</description> + + <listener> + <listener-class>org.apache.portals.applications.webapp.logging.Log4JConfigurator</listener-class> + </listener> + + <servlet> + <servlet-name>JetspeedContainer</servlet-name> + <display-name>Jetspeed Container</display-name> + <description>MVC Servlet for Jetspeed Portlet Applications</description> + <servlet-class>org.apache.jetspeed.container.JetspeedContainerServlet</servlet-class> + <init-param> + <param-name>contextName</param-name> + <param-value>apa-dbBrowser</param-value> + </init-param> + <load-on-startup>100</load-on-startup> + </servlet> + + <!-- Define Velocity Servlet --> + <servlet> + <servlet-name>velocity</servlet-name> + <servlet-class>org.apache.portals.bridges.velocity.BridgesVelocityViewServlet</servlet-class> + <init-param> + <param-name>org.apache.velocity.toolbox</param-name> + <param-value>/WEB-INF/velocity/toolbox.xml</param-value> + </init-param> + <init-param> + <param-name>org.apache.velocity.properties</param-name> + <param-value>/WEB-INF/velocity/velocity.properties</param-value> + </init-param> + <load-on-startup>10</load-on-startup> + </servlet> + + <!-- Map *.vm files to Velocity --> + <servlet-mapping> + <servlet-name>velocity</servlet-name> + <url-pattern>*.vm</url-pattern> + </servlet-mapping> + + <servlet-mapping> + <servlet-name>JetspeedContainer</servlet-name> + <url-pattern>/container/*</url-pattern> + </servlet-mapping> +</web-app> Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/web.xml ------------------------------------------------------------------------------ svn:mime-type = text/plain Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/images/application-vnd.ms-excel.png URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/images/application-vnd.ms-excel.png?rev=763970&view=auto ============================================================================== Binary file - no diff available. Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/images/application-vnd.ms-excel.png ------------------------------------------------------------------------------ svn:mime-type = application/octet-stream Added: portals/applications/databaseBrowser/trunk/pom.xml URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/pom.xml?rev=763970&view=auto ============================================================================== --- portals/applications/databaseBrowser/trunk/pom.xml (added) +++ portals/applications/databaseBrowser/trunk/pom.xml Fri Apr 10 16:16:18 2009 @@ -0,0 +1,53 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + Licensed to the Apache Software Foundation (ASF) under one or more + contributor license agreements. See the NOTICE file distributed with this + work for additional information regarding copyright ownership. The ASF + licenses this file to You under the Apache License, Version 2.0 (the + "License"); you may not use this file except in compliance with the License. + You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law + or agreed to in writing, software distributed under the License is + distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + KIND, either express or implied. See the License for the specific language + governing permissions and limitations under the License. $Id: +--> +<project xmlns="http://maven.apache.org/POM/4.0.0"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd";> + + <modelVersion>4.0.0</modelVersion> + <prerequisites> + <maven>2.0.4</maven> + </prerequisites> + + <!-- POM Identification --> + <parent> + <groupId>org.apache.portals</groupId> + <artifactId>applications-pom</artifactId> + <version>1.0-SNAPSHOT</version> + </parent> + + <groupId>org.apache.portals.applications</groupId> + <artifactId>apa-databaseBrowser</artifactId> + <packaging>pom</packaging> + <name>Portals Database Browser Application</name> + <version>1.0-SNAPSHOT</version> + <description>Database browser Portlet Application</description> + + <!-- Application Modules --> + + <modules> + <module>dbBrowser-jar</module> + <module>dbBrowser-war</module> + </modules> + + <!-- Project Information --> + + <scm> + <connection>scm:svn:http://svn.apache.org/repos/asf/portals/applications/databaseBrowser/trunk</connection> + <developerConnection>scm:svn:https://svn.apache.org/repos/asf/portals/applications/databaseBrowser/trunk</developerConnection> + <url>http://svn.apache.org/viewcvs.cgi/portals/applications/databaseBrowser/trunk/</url> + </scm> + +</project> Propchange: portals/applications/databaseBrowser/trunk/pom.xml ------------------------------------------------------------------------------ svn:mime-type = text/plain
