You are viewing a plain text version of this content. The canonical link for it is here.
Posted to portalapps-dev@portals.apache.org by vk...@apache.org on 2009/04/10 18:16:20 UTC

svn commit: r763970 [3/3] - in /portals/applications/databaseBrowser: ./ trunk/ trunk/dbBrowser-jar/ trunk/dbBrowser-jar/src/ trunk/dbBrowser-jar/src/main/ trunk/dbBrowser-jar/src/main/java/ trunk/dbBrowser-jar/src/main/java/org/ trunk/dbBrowser-jar/sr...

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:taylor@apache.org">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>&nbsp;</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>&nbsp;
+            #end
+            </td>
+        #end
+    #end
+  </tr>
+  #end
+  #if ($tableLinks)
+    #if ($tableLinks.size() > 0)
+      <tr>
+        <td>&nbsp;
+        </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>&nbsp;
+    </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