taylor 02/04/05 13:10:07
Modified: webapp/WEB-INF/conf portlets.xreg
webapp/WEB-INF/db jetspeed.properties jetspeed.script
webapp/css default.css
Added: webapp/WEB-INF/templates/vm/portlets/html
database-browser-customize.vm
database-browser-portlet.vm
Log:
Resources for new DatabaseBrowser portlet.
* added new sample 'COFFEES' table to the hsql database
* added DatabaseBrowser portlet to portlets.xreg
* added new styles to default.css for database browser table
* added two new templates for customization view and display view of database
browser
Revision Changes Path
1.20 +16 -1 jakarta-jetspeed/webapp/WEB-INF/conf/portlets.xreg
Index: portlets.xreg
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/conf/portlets.xreg,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -r1.19 -r1.20
--- portlets.xreg 4 Apr 2002 18:49:59 -0000 1.19
+++ portlets.xreg 5 Apr 2002 21:10:07 -0000 1.20
@@ -124,5 +124,20 @@
<portlet-entry name="IFramePortlet" hidden="false" type="abstract"
application="false">
<classname>org.apache.jetspeed.portal.portlets.IFramePortlet</classname>
<category>frames</category>
- </portlet-entry>
+ </portlet-entry>
+ <portlet-entry name="DatabaseBrowserPortlet" hidden="false" type="ref"
+ parent="CustomizerVelocity" application="false">
+ <meta-info>
+ <title>DatabaseBrowser</title>
+ <description>Database Browser Velocity Portlet Example</description>
+ </meta-info>
+ <parameter name="template" value="database-browser-portlet" hidden="false"/>
+ <parameter name="customizeTemplate" value="database-browser-customize"
hidden="false"/>
+ <parameter name="action" value="portlets.browser.DatabaseBrowserAction"
hidden="false"/>
+ <parameter name="sql" value="select * from coffees" hidden="false"/>
+ <parameter name="windowSize" value="5" hidden="false"/>
+ <media-type ref="html"/>
+ <category>demo</category>
+ <category>velocity.demo</category>
+ </portlet-entry>
</registry>
1.11 +1 -1 jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.properties
Index: jetspeed.properties
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.properties,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- jetspeed.properties 12 Nov 2001 03:43:01 -0000 1.10
+++ jetspeed.properties 5 Apr 2002 21:10:07 -0000 1.11
@@ -1,4 +1,4 @@
#Hypersonic SQL database
-#Sun Nov 11 18:51:45 PST 2001
+#Fri Apr 05 12:45:05 PST 2002
version=1.4
modified=no
1.13 +14 -1 jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script
Index: jetspeed.script
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/webapp/WEB-INF/db/jetspeed.script,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -r1.12 -r1.13
--- jetspeed.script 25 Feb 2002 04:25:37 -0000 1.12
+++ jetspeed.script 5 Apr 2002 21:10:07 -0000 1.13
@@ -16,6 +16,7 @@
CREATE INDEX JETSPEED_ROLE_PROFILE_INDEX ON
JETSPEED_ROLE_PROFILE(ROLE_NAME,MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE)
CREATE TABLE JETSPEED_ANON_PROFILE(PSML_ID INTEGER IDENTITY PRIMARY KEY,MEDIA_TYPE
VARCHAR,LANGUAGE VARCHAR,COUNTRY VARCHAR,PAGE VARCHAR,PROFILE
BINARY,UNIQUE(PSML_ID),UNIQUE(MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE))
CREATE INDEX JETSPEED_ANON_PROFILE_INDEX ON
JETSPEED_ANON_PROFILE(MEDIA_TYPE,LANGUAGE,COUNTRY,PAGE)
+CREATE TABLE COFFEES(COF_NAME VARCHAR,SUP_ID INTEGER,PRICE FLOAT,SALES
INTEGER,TOTAL INTEGER)
GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
GRANT ALL ON CLASS "org.hsql.Library" TO PUBLIC
CREATE USER SA PASSWORD "" ADMIN
@@ -117,7 +118,7 @@
INSERT INTO ID_TABLE VALUES(1,'TURBINE_PERMISSION',100,10)
INSERT INTO ID_TABLE VALUES(2,'TURBINE_ROLE',120,10)
INSERT INTO ID_TABLE VALUES(3,'TURBINE_GROUP',100,10)
-INSERT INTO ID_TABLE VALUES(4,'TURBINE_USER',120,10)
+INSERT INTO ID_TABLE VALUES(4,'TURBINE_USER',160,10)
INSERT INTO ID_TABLE VALUES(5,'TURBINE_SCHEDULED_JOB',100,10)
INSERT INTO ID_TABLE VALUES(6,'TURBINE_ROLE_PERMISSION',100,10)
INSERT INTO ID_TABLE VALUES(7,'TURBINE_USER_GROUP_ROLE',100,10)
@@ -125,4 +126,16 @@
INSERT INTO ID_TABLE VALUES(9,'JETSPEED_GROUP_PROFILE',120,10)
INSERT INTO ID_TABLE VALUES(10,'JETSPEED_ROLE_PROFILE',120,10)
INSERT INTO ID_TABLE VALUES(11,'JETSPEED_ANON_PROFILE',120,10)
+INSERT INTO COFFEES VALUES('ColombianGrade',5,7.99,1,2)
+INSERT INTO COFFEES VALUES('KonaGrade',6,7.99,1,2)
+INSERT INTO COFFEES VALUES('FrenchRoastGrade',7,7.99,1,2)
+INSERT INTO COFFEES VALUES('HazelNutGrade',8,7.99,1,2)
+INSERT INTO COFFEES VALUES('VanillaGrade',9,7.99,1,2)
+INSERT INTO COFFEES VALUES('JavaGrade',10,7.99,1,2)
+INSERT INTO COFFEES VALUES('IndonesianGrade',11,7.99,1,2)
+INSERT INTO COFFEES VALUES('OotyGrade',1,7.99,1,2)
+INSERT INTO COFFEES VALUES('KenyanGrade',2,7.99,1,2)
+INSERT INTO COFFEES VALUES('JoeGrade',3,7.99,1,2)
+INSERT INTO COFFEES VALUES('CantThinkOfAnymoreGrade',4,7.99,1,2)
+/*C4*/CONNECT USER sa PASSWORD ""
1.1
jakarta-jetspeed/webapp/WEB-INF/templates/vm/portlets/html/database-browser-customize.vm
Index: database-browser-customize.vm
===================================================================
#**
@author <a href="mailto:[EMAIL PROTECTED]";>David Sean Taylor</a>
@version $Id: database-browser-customize.vm,v 1.1 2002/04/05 21:10:07 taylor Exp $
<br /><input name="sql" value="$sql" size="200" />
*#
<form action="$jlink" method="post">
<p>Please Enter the new query for this database browser portlet:
<br/>
<textarea name="sql" rows="5" cols="75">$sql</textarea>
<p>Please Enter the new window size for this database browser portlet:
<input name="windowSize" value="$windowSize" size="2" />
<br/>
<input type="submit" name="eventSubmit_doUpdate" value="Update" />
<br/>
</p>
</form>
1.1
jakarta-jetspeed/webapp/WEB-INF/templates/vm/portlets/html/database-browser-portlet.vm
Index: database-browser-portlet.vm
===================================================================
#**
@author <a href="mailto:[EMAIL PROTECTED]";>David Sean Taylor</a>
@version $Id: database-browser-portlet.vm version 1.0
*#
<table cellpadding=0 cellspacing=1 border=0 width="100%">
<tbody>
<tr>
#foreach ($column in $title)
<td align=CENTER class="listCellHead" width="43" nowrap>
<div align="center">$column</div>
</td>
#end
</tr>
#foreach ( $row in $table )
<tr>
#foreach ( $entry in $row )
<td class="listCell" nowrap width="43">
<div align="center">$entry</div>
</td>
#end
</tr>
#end
</tbody>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#6868AB">
<td>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right" width="50%">
#if ($prev)
<form action="$jlink" method="post">
<input type="submit" value="< < Previous">
<input type="hidden" name="start" value="$prev">
</form>
#end
</td>
<td>
</td>
<td align="left" width="50%">
#if ($next)
<form action="$jlink" method="post">
<input type="submit" value="Next > >">
<input type="hidden" name="start" value="$next">
</form>
#end
</td>
</tr>
</table>
1.11 +62 -19 jakarta-jetspeed/webapp/css/default.css
Index: default.css
===================================================================
RCS file: /home/cvs/jakarta-jetspeed/webapp/css/default.css,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- default.css 19 Mar 2002 15:59:30 -0000 1.10
+++ default.css 5 Apr 2002 21:10:07 -0000 1.11
@@ -139,6 +139,49 @@
padding: 0;
}
+ .listCellHead
+ {
+ text-decoration:underline;
+ background-color:#6868AB;
+ layer-background-color:#CCCCFF;
+ border-style:outset;
+ border-width:2px;
+ border-left-color:white;
+ border-top-color:white;
+ border-bottom-color:black;
+ border-right-color:black;
+ cursor:hand;
+ FONT-SIZE:8pt;
+ FONT-WEIGHT:bold;
+ COLOR: white;
+ ; font-family: Verdana, Arial, Helvetica, sans-serif
+ }
+
+ .listCellHeadNoLink
+ {
+ background-color:#6868AB;
+ layer-background-color:#6868AB;
+ border-style:solid;
+ border-width:2px;
+ border-left-color:#6868AB;
+ border-top-color:#6868AB;
+ border-bottom-color:#6868AB;
+ border-right-color:#6868AB;
+ FONT-SIZE:7pt;
+ FONT-WEIGHT:normal;
+ COLOR: white;
+ ; font-family: Verdana, Arial, Helvetica, sans-serif
+ }
+
+ .listCell
+ {
+ background-color:#ECECEC;
+ layer-background-color: #FCFE52;
+ FONT-SIZE:7pt;
+ FONT-WEIGHT:normal;
+ }
+
+
.UPPERCASE {
text-transform: uppercase;
}
@@ -146,7 +189,7 @@
.WELCOME {
font-size: 12pt;
- font-color: #000000;
+ font-color: #000000;
font-weight: 900;
font-stretch: wider;
}
@@ -158,61 +201,61 @@
color: #000000;
font-size: 11pt;
font-weight: bold;
-
+
border-top: 1px solid #B0B0B0;
border-left: 1px solid #B0B0B0;
border-right: 1px solid #FAFAFA;
border-bottom: 1px solid #FAFAFA;
- }
-
+ }
+
.INPUTFORM {
font-family: arial,helvetica;
background: #F0F0F0;
color: #000000;
font-size: 11pt;
font-weight: bold;
-
+
border-top: 1px solid #A0A0A0;
border-left: 1px solid #A0A0A0;
border-right: 1px solid #FFFFFF;
border-bottom: 1px solid #FFFFFF;
- }
-
+ }
+
.INPUTFORMTITLE {
font-family: arial,helvetica;
background: #FAFAFA;
color: #000000;
font-size: 13pt;
font-weight: bold;
-
+
border-top: 1px solid #FFFFFF;
border-left: 1px solid #FFFFFF;
border-right: 1px solid #0A0A0A;
border-bottom: 1px solid #0A0A0A;
- }
-
+ }
+
.MENUBUTTON {
font-family: arial,helvetica;
- background: #E0E0E0;
+ background: #E0E0E0;
color: #808080;
font-size: 10pt;
font-weight: bold;
-
+
border-top: 1px solid #FFFFFF;
border-left: 1px solid #FFFFFF;
border-right: 1px solid #A0A0A0;
border-bottom: 1px solid #A0A0A0;
- }
-
+ }
+
.PANETITLE {
background: #FAFAFA;
font-weight: bold;
- }
-
-.BUTON
+ }
+
+.BUTON
{
font-family: arial,helvetica;
- background: #E0E0E0;
+ background: #E0E0E0;
color: NAVY;
font-size: 10pt;
font-weight: bold;
@@ -221,5 +264,5 @@
border-left: 1pt double #FFFFFF;
border-right: 1pt double #A0A0A0;
border-bottom: 1pt double #A0A0A0;
-}
+}
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
