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]>