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 [2/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-jar/src/main/java/org/apache/portals/applications/dbBrowser/ValidationHelper.java
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-jar/src/main/java/org/apache/portals/applications/dbBrowser/ValidationHelper.java?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-jar/src/main/java/org/apache/portals/applications/dbBrowser/ValidationHelper.java (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-jar/src/main/java/org/apache/portals/applications/dbBrowser/ValidationHelper.java Fri Apr 10 16:16:18 2009
@@ -0,0 +1,453 @@
+/*
+ * 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.
+ */
+package org.apache.portals.applications.dbBrowser;
+
+import java.text.ParseException;
+import java.text.SimpleDateFormat;
+import java.util.Date;
+
+import org.apache.commons.lang.StringUtils;
+
+/**
+ * ValidationHelper using regular expressions
+ *
+ * @author <a href="mailto:taylor@apache.org">David Sean Taylor</a>
+ * @version $Id: $
+ */
+public abstract class ValidationHelper
+{
+ public static final SimpleDateFormat EUROPEAN_DATE_FORMAT = new SimpleDateFormat("dd-MM-yyyy");
+ public static final SimpleDateFormat EUROPEAN_DATETIME_FORMAT = new SimpleDateFormat("dd-MM-yyyy HH:mm");
+ public static final SimpleDateFormat AMERICAN_DATE_FORMAT = new SimpleDateFormat("MM-dd-yyyy");
+ public static final SimpleDateFormat AMERICAN_DATETIME_FORMAT = new SimpleDateFormat("MM-dd-yyyy HH:mm");
+
+ /**
+ * Tests that the input string contains only alpha numeric or white spaces
+ * <P>
+ * @param evalString The string that is to be evaluated
+ * @param required indicates whether the field is required or not
+ * @return True if the input is alpha numeric, false otherwise.
+ **/
+ public static boolean isAlphaNumeric(String evalString, boolean required)
+ {
+ if (StringUtils.isEmpty(evalString))
+ {
+ if (true == required)
+ {
+ return false;
+ }
+ return true;
+ }
+ return evalString.matches("^[\\w\\s]+$");
+ }
+
+ public static boolean isAlphaNumeric(String evalString, boolean required, int maxLength)
+ {
+ if (isTooLong(evalString, maxLength))
+ {
+ return false;
+ }
+ return isAlphaNumeric(evalString, required);
+ }
+
+ public static boolean isLooseAlphaNumeric(String evalString, boolean required)
+ {
+ if (StringUtils.isEmpty(evalString))
+ {
+ if (true == required)
+ {
+ return false;
+ }
+ return true;
+ }
+ return evalString.matches("^[\\w\\s\\.\\,\\/\\-\\(\\)\\+]+$");
+ }
+
+ public static boolean isLooseAlphaNumeric(String evalString, boolean required, int maxLength)
+ {
+ if (isTooLong(evalString, maxLength))
+ {
+ return false;
+ }
+ return isLooseAlphaNumeric(evalString, required);
+ }
+
+ /**
+ * Tests that the input string contains only numeric
+ * <P>
+ * @param evalString The string that is to be evaluated
+ * @return True if the input is numeric, false otherwise.
+ **/
+ public static boolean isDecimal(String evalString, boolean required)
+ {
+ if (StringUtils.isEmpty(evalString))
+ {
+ if (true == required)
+ {
+ return false;
+ }
+ return true;
+ }
+ return evalString.matches("^(\\d+\\.)?\\d+$");
+ }
+
+ public static boolean isDecimal(String evalString, boolean required, int maxLength)
+ {
+ if (isTooLong(evalString, maxLength))
+ {
+ return false;
+ }
+ return isDecimal(evalString, required);
+ }
+
+ /**
+ * Tests that the input string contains only an integer
+ * <P>
+ * @param evalString The string that is to be evaluated
+ * @return True if the input is numeric, false otherwise.
+ **/
+ public static boolean isInteger (String evalString, boolean required)
+ {
+ if (StringUtils.isEmpty(evalString))
+ {
+ if (true == required)
+ {
+ return false;
+ }
+ return true;
+ }
+ return evalString.matches("^\\d+$");
+ }
+
+ public static boolean isInteger(String evalString, boolean required, int maxLength)
+ {
+ if (isTooLong(evalString, maxLength))
+ {
+ return false;
+ }
+ return isInteger(evalString, required);
+ }
+
+ /**
+ * Tests that the input string contains a valid email addess
+ * <P>
+ * @param evalString The string that is to be evaluated
+ * @return True if the input is a valid email address.
+ **/
+ public static boolean isEmailAddress(String evalString, boolean required)
+ {
+ if (StringUtils.isEmpty(evalString))
+ {
+ if (true == required)
+ {
+ return false;
+ }
+ return true;
+ }
+ return evalString.matches("^(?:\\w[\\w-]*\\.)*\\w[\\w-]*@(?:\\w[\\w-]*\\.)+\\w[\\w-]*$");
+ }
+
+ public static boolean isEmailAddress(String evalString, boolean required, int maxLength)
+ {
+ if (isTooLong(evalString, maxLength))
+ {
+ return false;
+ }
+ return isEmailAddress(evalString, required);
+ }
+
+ /**
+ * Tests that the input string contains a valid URL
+ * <P>
+ * @param evalString The string that is to be evaluated
+ * @return True if the input is a valid URL.
+ **/
+ public static boolean isURL(String evalString, boolean required)
+ {
+ try
+ {
+ if (StringUtils.isEmpty(evalString))
+ {
+ if (true == required)
+ {
+ return false;
+ }
+ return true;
+ }
+
+ //URL url = new URL(evalString);
+
+ /*
+ Perl5Util util = new Perl5Util();
+ System.out.println("looking at " +evalString);
+ return evalString.matches("^[\\w%?-_~]$", evalString);
+ */
+ //Object content = url.getContent();
+ //System.out.println("url contains :["+content+"]");
+ return true;
+ }
+ catch (Exception e)
+ {
+ System.err.println(evalString+" is not a valid URL: "+ e);
+ return false;
+ }
+ }
+
+ public static boolean isURL(String evalString, boolean required, int maxLength)
+ {
+ if (isTooLong(evalString, maxLength))
+ {
+ return false;
+ }
+ return isURL(evalString, required);
+ }
+
+ public static boolean isValidIdentifier(String folderName)
+ {
+ boolean valid = true;
+
+ char[] chars = folderName.toCharArray();
+ for (int ix = 0; ix < chars.length; ix++)
+ {
+ if (!Character.isJavaIdentifierPart(chars[ix]))
+ {
+ valid = false;
+ break;
+ }
+ }
+ return valid;
+ }
+
+ public static boolean isTooLong(String evalString, int maxLength)
+ {
+ if (null != evalString)
+ {
+ return (evalString.length() > maxLength);
+ }
+ return false;
+ }
+
+ public static boolean isPhoneNumber(String evalString, boolean required, int maxLength)
+ {
+ if (isTooLong(evalString, maxLength))
+ {
+ return false;
+ }
+ return isPhoneNumber(evalString, required);
+ }
+
+ public static boolean isPhoneNumber(String evalString, boolean required)
+ {
+ if (StringUtils.isEmpty(evalString))
+ {
+ if (true == required)
+ {
+ return false;
+ }
+ return true;
+ }
+ //return evalString.matches("[(][0-9]{3}[)][ ]*[0-9]{3}-[0-9]{4}", evalString);
+ return evalString.matches("(\\+[0-9]{2})?(\\({0,1}[0-9]{3}\\){0,1} {0,1}[ |-]{0,1} {0,1}){0,1}[0-9]{3,5}[ |-][0-9]{4,6}");
+ }
+
+ public static Date parseDate(String formatted)
+ {
+ Date date = null;
+ if (null == formatted)
+ {
+ return null;
+ }
+ try
+ {
+ synchronized (EUROPEAN_DATE_FORMAT)
+ {
+ date = EUROPEAN_DATE_FORMAT.parse(formatted);
+ }
+ }
+ catch (ParseException e)
+ {
+ try
+ {
+ synchronized (AMERICAN_DATE_FORMAT)
+ {
+ date = AMERICAN_DATE_FORMAT.parse(formatted);
+ }
+ }
+ catch (ParseException ee)
+ {
+ }
+ }
+ return date;
+ }
+
+ public static Date parseDatetime(String formatted)
+ {
+ Date date = null;
+ if (null == formatted)
+ {
+ return null;
+ }
+
+ try
+ {
+ synchronized (EUROPEAN_DATETIME_FORMAT)
+ {
+ date = EUROPEAN_DATETIME_FORMAT.parse(formatted);
+ }
+ }
+ catch (ParseException e)
+ {
+ try
+ {
+ synchronized (AMERICAN_DATETIME_FORMAT)
+ {
+ date = AMERICAN_DATETIME_FORMAT.parse(formatted);
+ }
+ }
+ catch (ParseException ee)
+ {
+ }
+ }
+ return date;
+ }
+
+ public static String formatEuropeanDate(Date date)
+ {
+ if (null == date)
+ {
+ return null;
+ }
+ synchronized (EUROPEAN_DATE_FORMAT)
+ {
+ return EUROPEAN_DATE_FORMAT.format(date);
+ }
+ }
+
+ public static String formatAmericanDate(Date date)
+ {
+ if (null == date)
+ {
+ return null;
+ }
+ synchronized (AMERICAN_DATE_FORMAT)
+ {
+ return AMERICAN_DATE_FORMAT.format(date);
+ }
+ }
+
+ public static String formatEuropeanDatetime(Date date)
+ {
+ if (null == date)
+ {
+ return null;
+ }
+ synchronized (EUROPEAN_DATETIME_FORMAT)
+ {
+ return EUROPEAN_DATETIME_FORMAT.format(date);
+ }
+ }
+
+ public static String formatAmericanDatetime(Date date)
+ {
+ if (null == date)
+ {
+ return null;
+ }
+ synchronized (AMERICAN_DATETIME_FORMAT)
+ {
+ return AMERICAN_DATETIME_FORMAT.format(date);
+ }
+ }
+
+ public static boolean isValidDate(String formatted)
+ {
+ if (formatted == null || formatted.trim().length() == 0)
+ return true;
+
+ try
+ {
+ EUROPEAN_DATE_FORMAT.parse(formatted);
+ }
+ catch (ParseException e)
+ {
+ try
+ {
+ synchronized (AMERICAN_DATE_FORMAT)
+ {
+ AMERICAN_DATE_FORMAT.parse(formatted);
+ }
+ }
+ catch (ParseException ee)
+ {
+ return false;
+ }
+ }
+ return true;
+ }
+
+ public static boolean isValidDatetime(String formatted)
+ {
+ if (formatted == null || formatted.trim().length() == 0)
+ return true;
+
+ try
+ {
+ synchronized (EUROPEAN_DATETIME_FORMAT)
+ {
+ EUROPEAN_DATETIME_FORMAT.parse(formatted);
+ }
+ }
+ catch (ParseException e)
+ {
+ try
+ {
+ synchronized (AMERICAN_DATETIME_FORMAT)
+ {
+ AMERICAN_DATETIME_FORMAT.parse(formatted);
+ }
+ }
+ catch (ParseException ee)
+ {
+ return false;
+ }
+ }
+ return true;
+ }
+
+ public static boolean isAny(String evalString, boolean required)
+ {
+ if (StringUtils.isEmpty(evalString))
+ {
+ if (true == required)
+ {
+ return false;
+ }
+ return true;
+ }
+ return true;
+ }
+
+ public static boolean isAny(String evalString, boolean required, int maxLength)
+ {
+ if (isTooLong(evalString, maxLength))
+ {
+ return false;
+ }
+ return isAny(evalString, required);
+ }
+
+}
Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-jar/src/main/java/org/apache/portals/applications/dbBrowser/ValidationHelper.java
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser.properties
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser.properties?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser.properties (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser.properties Fri Apr 10 16:16:18 2009
@@ -0,0 +1,49 @@
+# 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.
+
+javax.portlet.title = Database Browser
+javax.portlet.short-title = DB
+javax.portlet.keywords = database, sql
+name = Name
+url = URL
+add = Add
+delete = Delete
+cancel = Cancel
+help.title = Help Mode
+help.text = The Database Browser portlet provides a browser of SQL databases.
+dbnext = Next
+dbprev = Previous
+dbrefresh = Refresh
+label.datasource.type = Data Source Type
+label.datasource.jndi = JNDI Data Source
+label.datasource.dbcp = DBCP Data Source
+label.datasource.sso = SSO Credential Store
+label.select.ds = Please Select a Data Source Type
+label.jndi = JNDI Data Source
+label.dbcp = DBCP Data Source
+label.sso = SSO Credential Store
+label.prefs = Database Browser Preferences
+label.jndi.settings = JNDI Settings
+label.dbcp.settings = JDBC/DBCP Settings
+label.sso.settings = J2 SSO Settings
+label.general.settings = General Settings
+label.jdbc.driver = JDBC Driver
+label.jdbc.connection = JDBC Connection
+label.jdbc.username = JDBC Username
+label.jdbc.password = JDBC Password
+label.window.size = Window Size
+label.sql = SQL
+
+
Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser.properties
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_de.properties
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_de.properties?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_de.properties (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_de.properties Fri Apr 10 16:16:18 2009
@@ -0,0 +1,49 @@
+# 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.
+
+javax.portlet.title = Database Browser
+javax.portlet.short-title = DB
+javax.portlet.keywords = database, sql
+name = Name
+url = URL
+add = Hinzufügen
+delete = löschen
+cancel = Abbrechen
+help.title = Help Mode
+help.text = The Database Browser portlet provides a browser of SQL databases.
+dbnext = Weiter
+dbprev = Zuruck
+dbrefresh = Erneuern
+label.datasource.type = Data Source Type
+label.datasource.jndi = JNDI Data Source
+label.datasource.dbcp = DBCP Data Source
+label.datasource.sso = SSO Credential Store
+label.select.ds = Please Select a Data Source Type
+label.jndi = JNDI Data Source
+label.dbcp = DBCP Data Source
+label.sso = SSO Credential Store
+label.prefs = Database Browser Preferences
+label.jndi.settings = JNDI Settings
+label.dbcp.settings = JDBC/DBCP Settings
+label.sso.settings = J2 SSO Settings
+label.general.settings = General Settings
+label.jdbc.driver = JDBC Driver
+label.jdbc.connection = JDBC Connection
+label.jdbc.username = JDBC Username
+label.jdbc.password = JDBC Password
+label.window.size = Window Size
+label.sql = SQL
+
+
\ No newline at end of file
Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_de.properties
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_en.properties
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_en.properties?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_en.properties (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_en.properties Fri Apr 10 16:16:18 2009
@@ -0,0 +1,53 @@
+# 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: Browser_en.properties 516448 2007-03-09 16:25:47Z ate $
+#
+# LOCALIZATION MAINTAINER:
+# Jetspeed Development Team
+
+javax.portlet.title = Database Browser
+javax.portlet.short-title = DB
+javax.portlet.keywords = database, sql
+name = Name
+url = URL
+add = Add
+delete = Delete
+cancel = Cancel
+help.title = Help Mode
+help.text = The Database Browser portlet provides a browser of SQL databases.
+dbnext = Next
+dbprev = Previous
+dbrefresh = Refresh
+label.datasource.type = Data Source Type
+label.datasource.jndi = JNDI Data Source
+label.datasource.dbcp = DBCP Data Source
+label.datasource.sso = SSO Credential Store
+label.select.ds = Please Select a Data Source Type
+label.jndi = JNDI Data Source
+label.dbcp = DBCP Data Source
+label.sso = SSO Credential Store
+label.prefs = Database Browser Preferences
+label.jndi.settings = JNDI Settings
+label.dbcp.settings = JDBC/DBCP Settings
+label.sso.settings = J2 SSO Settings
+label.general.settings = General Settings
+label.jdbc.driver = JDBC Driver
+label.jdbc.connection = JDBC Connection
+label.jdbc.username = JDBC Username
+label.jdbc.password = JDBC Password
+label.window.size = Window Size
+label.sql = SQL
+
Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_en.properties
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_hu.properties
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_hu.properties?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_hu.properties (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_hu.properties Fri Apr 10 16:16:18 2009
@@ -0,0 +1,53 @@
+# 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: Browser_en.properties 188342 2005-02-20 23:00:25Z shinsuke $
+#
+# LOCALIZATION MAINTAINER:
+# Jetspeed Development Team
+
+javax.portlet.title = Adatb\u00e1zis Tall\u00f3z\u00f3
+javax.portlet.short-title = DB
+javax.portlet.keywords = adatb\u00e1zis, database, sql
+name = N\u00e9v
+url = URL
+add = Hozz\u00e1ad\u00e1s
+delete = T\u00f6rl\u00e9s
+cancel = M\u00e9gse
+help.title = S\u00fag\u00f3
+help.text = Az Adatb\u00e1zis Tall\u00f3z\u00f3 portlet SQL adatb\u00e1zisok tall\u00f3z\u00e1s\u00e1t teszi lehet\u0151v\u00e9.
+dbnext = K\u00f6vetkez\u0151
+dbprev = El\u0151z\u0151
+dbrefresh = Friss\u00edt\u00e9s
+label.datasource.type = Adatforr\u00e1s tipusa
+label.datasource.jndi = JNDI adatforr\u00e1s
+label.datasource.dbcp = DBCP adatforr\u00e1s
+label.datasource.sso = SSO Credential Store
+label.select.ds = K\u00e9rem v\u00e1lassza ki az adatforr\u00e1s tipus\u00e1t
+label.jndi = JNDI adatforr\u00e1s
+label.dbcp = DBCP adatforr\u00e1s
+label.sso = SSO Credential Store
+label.prefs = Adatb\u00e1zis Tall\u00f3z\u00f3 be\u00e1ll\u00edt\u00e1sok
+label.jndi.settings = JNDI Be\u00e1ll\u00edt\u00e1sok
+label.dbcp.settings = JDBC/DBCP Be\u00e1ll\u00edt\u00e1sok
+label.sso.settings = J2 SSO Be\u00e1ll\u00edt\u00e1sok
+label.general.settings = \u00c1ltal\u00e1nos be\u00e1ll\u00edt\u00e1sok
+label.jdbc.driver = JDBC Driver
+label.jdbc.connection = JDBC Connection
+label.jdbc.username = JDBC Felhaszn\u00e1l\u00f3n\u00e9v
+label.jdbc.password = JDBC Jelsz\u00f3
+label.window.size = Ablak m\u00e9ret
+label.sql = SQL
+
Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_hu.properties
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_it.properties
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_it.properties?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_it.properties (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_it.properties Fri Apr 10 16:16:18 2009
@@ -0,0 +1,53 @@
+# 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.
+#
+# Please contact me if you have any questions or suggestion : desmax74@yahoo.it
+#
+# Italian version by Dessì Massimiliano <a href="desmax74@yahoo.it.it">desmax74@yahoo.it</a>.
+# Vers 0.1 jetspeed 2.0 03/04/2005
+
+javax.portlet.title = Visualizzatore Database
+javax.portlet.short-title = DB
+javax.portlet.keywords = database, sql
+name = Nome
+url = URL
+add = Aggiungi
+delete = Rimuovi
+cancel = Cancella
+help.title = Help Mode
+help.text = La portlet Database Browser fornisce un browser di database SQL.
+dbnext = Prossimo
+dbprev = Precedente
+dbrefresh = Aggiorna
+label.datasource.type = Tipo Data Source
+label.datasource.jndi = Data Source JNDI
+label.datasource.dbcp = Data Source DBCP
+label.datasource.sso = Credenziali SSO
+label.select.ds = Seleziona un tipo di Data Source
+label.jndi = JNDI Data Source
+label.dbcp = DBCP Data Source
+label.sso = SSO Credential Store
+label.prefs = Database Browser Preferences
+label.jndi.settings = Settaggi JNDI
+label.dbcp.settings = Settaggi JDBC/DBCP
+label.sso.settings = Settaggi J2 SSO
+label.general.settings = Settaggi generali
+label.jdbc.driver = JDBC Driver
+label.jdbc.connection = JDBC Connection
+label.jdbc.username = JDBC Username
+label.jdbc.password = JDBC Password
+label.window.size = Dimensioni finestra
+label.sql = SQL
+
Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_it.properties
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_ja.properties
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_ja.properties?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_ja.properties (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_ja.properties Fri Apr 10 16:16:18 2009
@@ -0,0 +1,49 @@
+# 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.
+
+javax.portlet.title = \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d6\u30e9\u30a6\u30b6
+javax.portlet.short-title = DB
+javax.portlet.keywords = \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9, sql
+name = \u540d\u524d
+url = URL
+add = \u8ffd\u52a0
+delete = \u524a\u9664
+cancel = \u30ad\u30e3\u30f3\u30bb\u30eb
+help.title = \u30d8\u30eb\u30d7\u30e2\u30fc\u30c9
+help.text = \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d6\u30e9\u30a6\u30b6\u30dd\u30fc\u30c8\u30ec\u30c3\u30c8\u306f\u3001SQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d6\u30e9\u30a6\u30b6\u6a5f\u80fd\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002
+dbnext = \u6b21\u3078
+dbprev = \u524d\u3078
+dbrefresh = \u66f4\u65b0
+label.datasource.type = \u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u30bf\u30a4\u30d7
+label.datasource.jndi = JNDI \u30c7\u30fc\u30bf\u30bd\u30fc\u30b9
+label.datasource.dbcp = DBCP \u30c7\u30fc\u30bf\u30bd\u30fc\u30b9
+label.datasource.sso = SSO \u8cc7\u683c\u8a3c\u660e\u30b9\u30c8\u30a2
+label.select.ds = \u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u30bf\u30a4\u30d7\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044
+label.jndi = JNDI \u30c7\u30fc\u30bf\u30bd\u30fc\u30b9
+label.dbcp = DBCP \u30c7\u30fc\u30bf\u30bd\u30fc\u30b9
+label.sso = SSO \u8cc7\u683c\u8a3c\u660e\u30b9\u30c8\u30a2
+label.prefs = \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d6\u30e9\u30a6\u30b6\u306e\u8a2d\u5b9a
+label.jndi.settings = JNDI \u8a2d\u5b9a
+label.dbcp.settings = JDBC/DBCP \u8a2d\u5b9a
+label.sso.settings = J2 SSO \u8a2d\u5b9a
+label.general.settings = \u5168\u822c\u8a2d\u5b9a
+label.jdbc.driver = JDBC \u30c9\u30e9\u30a4\u30d0
+label.jdbc.connection = JDBC \u63a5\u7d9a
+label.jdbc.username = JDBC \u30e6\u30fc\u30b6\u30fc\u540d
+label.jdbc.password = JDBC \u30d1\u30b9\u30ef\u30fc\u30c9
+label.window.size = \u30a6\u30a3\u30f3\u30c9\u30a6\u30b5\u30a4\u30ba
+label.sql = SQL
+
+
Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_ja.properties
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_ko.properties
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_ko.properties?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_ko.properties (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_ko.properties Fri Apr 10 16:16:18 2009
@@ -0,0 +1,53 @@
+# 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: Browser_en.properties 188342 2005-02-20 23:00:25Z shinsuke $
+#
+# LOCALIZATION MAINTAINER:
+# Jetspeed Development Team
+
+javax.portlet.title = \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ube0c\ub77c\uc6b0\uc800
+javax.portlet.short-title = \ub370\uc774\ud130\ubca0\uc774\uc2a4
+javax.portlet.keywords = \ub370\uc774\ud130\ubca0\uc774\uc2a4, SQL
+name = \uc774\ub984
+url = URL
+add = \ucd94\uac00
+delete = \uc0ad\uc81c
+cancel = \ucde8\uc18c
+help.title = \ub3c4\uc6c0\ub9d0 \ubaa8\ub4dc
+help.text = \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ube0c\ub77c\uc6b0\uc800 \ud3ec\ud2c0\ub9bf\uc740 SQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub4e4\uc5d0 \ub300\ud55c \ube0c\ub77c\uc6b0\uc9d5 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.
+dbnext = \ub2e4\uc74c
+dbprev = \uc774\uc804
+dbrefresh = \uc0c8\ub85c\uace0\uce68
+label.datasource.type = \ub370\uc774\ud130 \uc6d0\ubcf8 \uc720\ud615
+label.datasource.jndi = JNDI \ub370\uc774\ud130 \uc6d0\ubcf8
+label.datasource.dbcp = DBCP \ub370\uc774\ud130 \uc6d0\ubcf8
+label.datasource.sso = SSO \ubcf4\uc99d\uc11c \uc800\uc7a5\uc18c
+label.select.ds = \ub370\uc774\ud130 \uc6d0\ubcf8 \uc720\ud615\uc744 \uc120\ud0dd\ud558\uc2ed\uc2dc\uc624.
+label.jndi = JNDI \ub370\uc774\ud130 \uc6d0\ubcf8
+label.dbcp = DBCP \ub370\uc774\ud130 \uc6d0\ubcf8
+label.sso = SSO \ubcf4\uc99d\uc11c \uc800\uc7a5\uc18c
+label.prefs = \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ube0c\ub77c\uc6b0\uc800 \uc120\ud0dd\uc0ac\ud56d
+label.jndi.settings = JNDI \uc124\uc815
+label.dbcp.settings = JDBC/DBCP \uc124\uc815
+label.sso.settings = J2 SSO \uc124\uc815
+label.general.settings = \uc77c\ubc18 \uc124\uc815
+label.jdbc.driver = JDBC \ub4dc\ub77c\uc774\ubc84
+label.jdbc.connection = JDBC \uc5f0\uacb0
+label.jdbc.username = JDBC \uc0ac\uc6a9\uc790\uba85
+label.jdbc.password = JDBC \ube44\ubc00\ubc88\ud638
+label.window.size = \uc708\ub3c4\uc6b0 \ud06c\uae30
+label.sql = SQL
+
Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_ko.properties
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_ua.properties
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_ua.properties?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_ua.properties (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_ua.properties Fri Apr 10 16:16:18 2009
@@ -0,0 +1,53 @@
+# 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: Browser_en.properties 188342 2005-02-20 23:00:25Z shinsuke $
+#
+# LOCALIZATION MAINTAINER:
+# Jetspeed Development Team
+
+javax.portlet.title = \u0411\u0440\u0430\u0443\u0437\u0435\u0440 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445
+javax.portlet.short-title = DB
+javax.portlet.keywords = \u0431\u0430\u0437\u0430 \u0434\u0430\u043d\u0438\u0445, sql
+name = \u0406\u043c'\u044f
+url = URL
+add = \u0414\u043e\u0434\u0430\u0442\u0438
+delete = \u0412\u0438\u0434\u0430\u043b\u0438\u0442\u0438
+cancel = \u0412\u0456\u0434\u043c\u0456\u043d\u0438\u0442\u0438
+help.title = \u0420\u0435\u0436\u0438\u043c \u0414\u043e\u043f\u043e\u043c\u043e\u0433\u0430
+help.text = \u041f\u043e\u0440\u0442\u043b\u0435\u0442 \u0411\u0440\u0430\u0443\u0437\u0435\u0440 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445 \u043d\u0430\u0434\u0430\u0454 \u0431\u0440\u0430\u0443\u0437\u0435\u0440 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445.
+dbnext = \u041d\u0430\u0441\u0442\u0443\u043f\u043d\u0438\u0439
+dbprev = \u041f\u043e\u043f\u0435\u0440\u0435\u0434\u043d\u0456\u0439
+dbrefresh = \u041f\u043e\u043d\u043e\u0432\u0438\u0442\u0438
+label.datasource.type = \u0422\u0438\u043f \u0434\u0436\u0435\u0440\u0435\u043b\u0430 \u0434\u0430\u043d\u0438\u0445
+label.datasource.jndi = \u0414\u0436\u0435\u0440\u0435\u043b\u043e \u0434\u0430\u043d\u0438\u0445 JNDI
+label.datasource.dbcp = \u0414\u0436\u0435\u0440\u0435\u043b\u043e \u0434\u0430\u043d\u0438\u0445 DBCP
+label.datasource.sso = \u0421\u0445\u043e\u0432\u0438\u0449\u0435 \u043c\u0430\u043d\u0434\u0430\u0442\u0456\u0432 SSO
+label.select.ds = \u0411\u0443\u0434\u044c \u043b\u0430\u0441\u043a\u0430, \u043e\u0431\u0435\u0440\u0456\u0442\u044c \u0442\u0438\u043f \u0434\u0436\u0435\u0440\u0435\u043b\u0430 \u0434\u0430\u043d\u0438\u0445
+label.jndi = \u0414\u0436\u0435\u0440\u0435\u043b\u043e \u0434\u0430\u043d\u0438\u0445 JNDI
+label.dbcp = \u0414\u0436\u0435\u0440\u0435\u043b\u043e \u0434\u0430\u043d\u0438\u0445 DBCP
+label.sso = \u0421\u0445\u043e\u0432\u0438\u0449\u0435 \u043c\u0430\u043d\u0434\u0430\u0442\u0456\u0432 SSO
+label.prefs = \u041f\u0435\u0440\u0441\u043e\u043d\u0430\u043b\u044c\u043d\u0456 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0430 \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445
+label.jndi.settings = \u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 JNDI
+label.dbcp.settings = \u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 JDBC/DBCP
+label.sso.settings = \u041d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438 J2 SSO
+label.general.settings = \u0417\u0430\u0433\u0430\u043b\u044c\u043d\u0456 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u0438
+label.jdbc.driver = \u0414\u0440\u0430\u0439\u0432\u0435\u0440 JDBC
+label.jdbc.connection = \u0417\u2019\u0454\u0434\u043d\u0430\u043d\u043d\u044f JDBC
+label.jdbc.username = \u0406\u043c'\u044f \u043a\u043e\u0440\u0438\u0441\u0442\u0443\u0432\u0430\u0447\u0430 JDBC
+label.jdbc.password = \u041f\u0430\u0440\u043e\u043b\u044c JDBC
+label.window.size = \u0420\u043e\u0437\u043c\u0456\u0440 \u0432\u0456\u043a\u043d\u0430
+label.sql = SQL
+
Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_ua.properties
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_zh.properties
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_zh.properties?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_zh.properties (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_zh.properties Fri Apr 10 16:16:18 2009
@@ -0,0 +1,52 @@
+# 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.
+#
+#
+# LOCALIZATION MAINTAINER:
+# James Liao <ji...@gmail.com>
+
+javax.portlet.title = \u6570\u636e\u5e93\u6570\u636e\u6d4f\u89c8\u5668
+javax.portlet.short-title = DB
+javax.portlet.keywords = \u6570\u636e\u5e93, \u7ed3\u6784\u5316\u67e5\u8be2\u8bed\u8a00
+name = \u540d\u5b57
+url = URL
+add = \u6dfb\u52a0
+delete = \u5220\u9664
+cancel = \u53d6\u6d88
+help.title = \u5e2e\u52a9\u6a21\u5f0f
+help.text = \u8fd9\u662f\u4e00\u4e2a\u63d0\u4f9b\u6d4f\u89c8\u6570\u636e\u5e93\u4e2d\u6570\u636e\u7684\u529f\u80fd\u7684Portlet.
+dbnext = \u4e0b\u4e00\u6761
+dbprev = \u4e0a\u4e00\u6761
+dbrefresh = \u5237\u65b0
+label.datasource.type = \u6570\u636e\u6e90\u7c7b\u578b
+label.datasource.jndi = JNDI \u6570\u636e\u6e90
+label.datasource.dbcp = DBCP \u6570\u636e\u6e90
+label.datasource.sso = SSO \u51ed\u8bc1\u6570\u636e\u6e90
+label.select.ds = \u8bf7\u9009\u62e9\u60a8\u7684\u6570\u636e\u6e90\u7c7b\u578b
+label.jndi = JNDI \u6570\u636e\u6e90
+label.dbcp = DBCP \u6570\u636e\u6e90
+label.sso = SSO \u51ed\u8bc1\u6570\u636e\u6e90
+label.prefs = \u6570\u636e\u6d4f\u89c8\u5668\u53c2\u6570\u914d\u7f6e
+label.jndi.settings = JNDI \u8bbe\u7f6e
+label.dbcp.settings = JDBC/DBCP \u8bbe\u7f6e
+label.sso.settings = J2 SSO \u8bbe\u7f6e
+label.general.settings = \u5e38\u89c4\u5c5e\u6027\u8bbe\u7f6e
+label.jdbc.driver = JDBC \u9a71\u52a8\u7a0b\u5e8f
+label.jdbc.connection = JDBC \u8fde\u63a5
+label.jdbc.username = JDBC \u7528\u6237\u540d
+label.jdbc.password = JDBC \u5bc6\u7801
+label.window.size = \u5355\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570
+label.sql = SQL
+
Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_zh.properties
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_zh_TW.properties
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_zh_TW.properties?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_zh_TW.properties (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_zh_TW.properties Fri Apr 10 16:16:18 2009
@@ -0,0 +1,52 @@
+# 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.
+#
+#
+# LOCALIZATION MAINTAINER:
+# Cubehead Fang <cu...@gmail.com>
+
+javax.portlet.title = \u8cc7\u6599\u5eab\u8cc7\u6599\u6d41\u89bd\u5668
+javax.portlet.short-title = DB
+javax.portlet.keywords = \u8cc7\u6599\u5eab, \u7d50\u69cb\u5316\u67e5\u8a62\u8a9e\u8a00
+name = \u540d\u5b57
+url = URL
+add = \u6dfb\u52a0
+delete = \u522a\u9664
+cancel = \u53d6\u6d88
+help.title = \u5e6b\u52a9\u6a21\u5f0f
+help.text = \u9019\u662f\u4e00\u500b\u63d0\u4f9b\u6d41\u89bd\u8cc7\u6599\u5eab\u4e2d\u8cc7\u6599\u7684\u529f\u80fd\u7684Portlet.
+dbnext = \u4e0b\u4e00\u689d
+dbprev = \u4e0a\u4e00\u689d
+dbrefresh = \u5237\u65b0
+label.datasource.type = \u8cc7\u6599\u6e90\u985e\u578b
+label.datasource.jndi = JNDI \u6578\u64da\u6e90
+label.datasource.dbcp = DBCP \u6578\u64da\u6e90
+label.datasource.sso = SSO \u6191\u8b49\u6578\u64da\u6e90
+label.select.ds = \u8acb\u9078\u64c7\u60a8\u7684\u8cc7\u6599\u6e90\u985e\u578b
+label.jndi = JNDI \u6578\u64da\u6e90
+label.dbcp = DBCP \u6578\u64da\u6e90
+label.sso = SSO \u6191\u8b49\u6578\u64da\u6e90
+label.prefs = \u8cc7\u6599\u6d41\u89bd\u5668\u53c3\u6578\u914d\u7f6e
+label.jndi.settings = JNDI \u8a2d\u7f6e
+label.dbcp.settings = JDBC/DBCP \u8a2d\u7f6e
+label.sso.settings = J2 SSO \u8a2d\u7f6e
+label.general.settings = \u5e38\u898f\u5c6c\u6027\u8a2d\u7f6e
+label.jdbc.driver = JDBC \u9a45\u52d5\u7a0b\u5f0f
+label.jdbc.connection = JDBC \u9023\u63a5
+label.jdbc.username = JDBC \u7528\u6236\u540d
+label.jdbc.password = JDBC \u5bc6\u78bc
+label.window.size = \u55ae\u9801\u986f\u793a\u7684\u8a18\u9304\u6578
+label.sql = SQL
+
Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/java/org/apache/portals/applications/dbBrowser/resources/Browser_zh_TW.properties
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/jetspeed-portlet.xml
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/jetspeed-portlet.xml?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/jetspeed-portlet.xml (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/jetspeed-portlet.xml Fri Apr 10 16:16:18 2009
@@ -0,0 +1,28 @@
+<?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.
+-->
+<portlet-app id="apa-dbBrowser" version="1.0"
+ xmlns="http://portals.apache.org/jetspeed"
+ xmlns:js="http://portals.apache.org/jetspeed"
+ xmlns:dc="http://www.purl.org/dc"
+ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:schemaLocation="http://portals.apache.org/jetspeed http://portals.apache.org/jetspeed-2/2.1/schemas/jetspeed-portlet.xsd">
+
+ <dc:title>Portals Database Browser Portlet</dc:title>
+ <dc:title xml:lang="en">Database Browser Portlet</dc:title>
+ <dc:creator>J2 Team</dc:creator>
+</portlet-app>
\ No newline at end of file
Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/jetspeed-portlet.xml
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/log4j.properties
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/log4j.properties?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/log4j.properties (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/log4j.properties Fri Apr 10 16:16:18 2009
@@ -0,0 +1,60 @@
+# 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.
+# ------------------------------------------------------------------------
+#
+# Logging Configuration
+#
+# $Id:$
+#
+# ------------------------------------------------------------------------
+
+#
+# If we don't know the logging facility, put it into the pa.log
+#
+#
+log4j.rootLogger = ERROR, pa
+
+log4j.category.org.apache.jetspeed = ERROR, pa
+log4j.additivity.org.apache.jetspeed = false
+
+#
+# Velocity
+#
+log4j.category.velocity = ERROR, velocity
+log4j.additivity.velocity = false
+
+########################################################################
+#
+# Logfile definitions
+#
+########################################################################
+
+#
+# pa.log
+#
+log4j.appender.pa = org.apache.log4j.FileAppender
+log4j.appender.pa.file = ${webApplicationRoot}/logs/pa.log
+log4j.appender.pa.layout = org.apache.log4j.PatternLayout
+log4j.appender.pa.layout.conversionPattern = %d [%t] %-5p %c - %m%n
+log4j.appender.pa.append = false
+
+#
+# velocity.log
+#
+log4j.appender.velocity = org.apache.log4j.FileAppender
+log4j.appender.velocity.file = ${webApplicationRoot}/logs/velocity.log
+log4j.appender.velocity.layout = org.apache.log4j.PatternLayout
+log4j.appender.velocity.layout.conversionPattern = %d [%t] %-5p %c - %m%n
+log4j.appender.velocity.append = false
Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/log4j.properties
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/portlet.tld
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/portlet.tld?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/portlet.tld (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/portlet.tld Fri Apr 10 16:16:18 2009
@@ -0,0 +1,103 @@
+<?xml version="1.0" encoding="ISO-8859-1" ?>
+<!--
+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 taglib PUBLIC
+ "-//Sun Microsystems, Inc.//DTD JSP Tag Library 1.1//EN"
+ "http://java.sun.com/j2ee/dtds/web-jsptaglibrary_1_1.dtd">
+<taglib>
+ <tlibversion>1.0</tlibversion>
+ <jspversion>1.1</jspversion>
+ <shortname>Tags for portlets</shortname>
+ <tag>
+ <name>defineObjects</name>
+ <tagclass>org.apache.pluto.tags.DefineObjectsTag</tagclass>
+ <teiclass>org.apache.pluto.tags.DefineObjectsTag$TEI</teiclass>
+ <bodycontent>empty</bodycontent>
+ </tag>
+ <tag>
+ <name>param</name>
+ <tagclass>org.apache.pluto.tags.ParamTag</tagclass>
+ <bodycontent>empty</bodycontent>
+ <attribute>
+ <name>name</name>
+ <required>true</required>
+ <rtexprvalue>true</rtexprvalue>
+ </attribute>
+ <attribute>
+ <name>value</name>
+ <required>true</required>
+ <rtexprvalue>true</rtexprvalue>
+ </attribute>
+ </tag>
+ <tag>
+ <name>actionURL</name>
+ <tagclass>org.apache.pluto.tags.ActionURLTag</tagclass>
+ <teiclass>org.apache.pluto.tags.BasicURLTag$TEI</teiclass>
+ <bodycontent>JSP</bodycontent>
+ <attribute>
+ <name>windowState</name>
+ <required>false</required>
+ <rtexprvalue>true</rtexprvalue>
+ </attribute>
+ <attribute>
+ <name>portletMode</name>
+ <required>false</required>
+ <rtexprvalue>true</rtexprvalue>
+ </attribute>
+ <attribute>
+ <name>secure</name>
+ <required>false</required>
+ <rtexprvalue>true</rtexprvalue>
+ </attribute>
+ <attribute>
+ <name>var</name>
+ <required>false</required>
+ <rtexprvalue>true</rtexprvalue>
+ </attribute>
+ </tag>
+ <tag>
+ <name>renderURL</name>
+ <tagclass>org.apache.pluto.tags.RenderURLTag</tagclass>
+ <teiclass>org.apache.pluto.tags.BasicURLTag$TEI</teiclass>
+ <bodycontent>JSP</bodycontent>
+ <attribute>
+ <name>windowState</name>
+ <required>false</required>
+ <rtexprvalue>true</rtexprvalue>
+ </attribute>
+ <attribute>
+ <name>portletMode</name>
+ <required>false</required>
+ <rtexprvalue>true</rtexprvalue>
+ </attribute>
+ <attribute>
+ <name>secure</name>
+ <required>false</required>
+ <rtexprvalue>true</rtexprvalue>
+ </attribute>
+ <attribute>
+ <name>var</name>
+ <required>false</required>
+ <rtexprvalue>true</rtexprvalue>
+ </attribute>
+ </tag>
+ <tag>
+ <name>namespace</name>
+ <tagclass>org.apache.pluto.tags.NamespaceTag</tagclass>
+ <bodycontent>empty</bodycontent>
+ </tag>
+</taglib>
Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/portlet.tld
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/portlet.xml
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/portlet.xml?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/portlet.xml (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/portlet.xml Fri Apr 10 16:16:18 2009
@@ -0,0 +1,120 @@
+<?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.
+-->
+<portlet-app id="apa-dbBrowser"
+ xmlns="http://java.sun.com/xml/ns/portlet/portlet-app_2_0.xsd" version="2.0"
+ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xsi:schemaLocation="http://java.sun.com/xml/ns/portlet/portlet-app_2_0.xsd http://java.sun.com/xml/ns/portlet/portlet-app_2_0.xsd">
+ <portlet>
+ <description>Database Browser will hook into any database table and display it in a tabular format. Edit mode allows configuration by JDBC, JNDI or SSO credentials</description>
+ <portlet-name>DbBrowserExample</portlet-name>
+ <display-name>Database Browser</display-name>
+ <portlet-class>org.apache.portals.applications.dbBrowser.DatabaseBrowserPortlet</portlet-class>
+ <init-param>
+ <name>ViewPage</name>
+ <value>/WEB-INF/view/database-view.vm</value>
+ </init-param>
+ <init-param>
+ <name>EditPage</name>
+ <value>/WEB-INF/view/database-edit.vm</value>
+ </init-param>
+ <init-param>
+ <name>HelpPage</name>
+ <value>/WEB-INF/view/database-help.vm</value>
+ </init-param>
+ <init-param>
+ <name>portlet-icon</name>
+ <value>system-file-manager.png</value>
+ </init-param>
+ <expiration-cache>1800</expiration-cache>
+ <supports>
+ <mime-type>text/html</mime-type>
+ <portlet-mode>VIEW</portlet-mode>
+ <portlet-mode>EDIT</portlet-mode>
+ <portlet-mode>HELP</portlet-mode>
+ </supports>
+ <supported-locale>en</supported-locale>
+ <supported-locale>de</supported-locale>
+ <resource-bundle>org.apache.portals.applications.dbBrowser.resources.Browser</resource-bundle>
+ <portlet-info>
+ <title>Database Browser</title>
+ <short-title>DB Browser</short-title>
+ <keywords>tools,database,browser,SQL,query,DB</keywords>
+ </portlet-info>
+ <portlet-preferences>
+ <preference>
+ <name>DatasourceType</name>
+ <value>dbcp</value>
+ </preference>
+ <preference>
+ <name>JndiDatasource</name>
+ <value>jdbc/jetspeed</value>
+ </preference>
+ <preference>
+ <name>JdbcDriver</name>
+ <value>org.apache.derby.jdbc.EmbeddedDriver</value>
+ </preference>
+ <preference>
+ <name>JdbcConnection</name>
+ <value>jdbc:derby:/tmp/productiondb</value>
+ </preference>
+ <preference>
+ <name>JdbcUsername</name>
+ <value></value>
+ </preference>
+ <preference>
+ <name>JdbcPassword</name>
+ <value></value>
+ </preference>
+ <preference>
+ <name>SSOJdbcDriver</name>
+ <value>org.apache.derby.jdbc.EmbeddedDriver</value>
+ </preference>
+ <preference>
+ <name>SSOJdbcConnection</name>
+ <value>jdbc:derby:/tmp/productiondb</value>
+ </preference>
+ <preference>
+ <name>SSOSite</name>
+ <value></value>
+ </preference>
+ <preference>
+ <name>WindowSize</name>
+ <value>10</value>
+ </preference>
+ <preference>
+ <name>tableName</name>
+ <value>CLIENT</value>
+ </preference>
+ <preference>
+ <name>conditions</name>
+ <value><![CDATA[where CLIENT_ID > 5]]></value>
+ </preference>
+ <preference>
+ <name>columnTitles</name>
+ <value>CLIENT,NAME,CLIENT-MODEL</value>
+ </preference>
+ <preference>
+ <name>columnNames</name>
+ <value>CLIENT_ID,NAME,MODEL</value>
+ </preference>
+ <preference>
+ <name>orderByColumns</name>
+ <value></value>
+ </preference>
+ </portlet-preferences>
+ </portlet>
+</portlet-app>
+
Propchange: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/portlet.xml
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-edit.vm
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-edit.vm?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-edit.vm (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-edit.vm Fri Apr 10 16:16:18 2009
@@ -0,0 +1,180 @@
+#*
+ 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.
+*#
+#set ($MESSAGES = $portletConfig.getResourceBundle($renderRequest.Locale))
+#set ($dst = $prefsMap.get('DatasourceType'))
+#set ($disableDS = "disabled")
+#set ($disableDBCP = "disabled")
+#set ($disableSSO = "disabled")
+#if ($!dst == 'jndi')
+#set ($disableDS = "")
+#elseif ($!dst == 'dbcp')
+#set ($disableDBCP = "")
+#elseif ($!dst == 'sso')
+#set ($disableSSO = "")
+#end
+
+#set($name=$renderResponse.Namespace)
+
+#if ($statusMsg)
+#parse ('/WEB-INF/view/status-include.vm')
+#end
+
+<h3 class="portlet-section-header">$MESSAGES.getString('label.prefs')</h3>
+
+<form name='J2DBEdit$name' action="$renderResponse.createActionURL()" method="post">
+<table border="0" cellspacing="2" cellpadding="3">
+ <tr>
+ <th class="portlet-section-alternate"><font class="portlet-form-field-label">$MESSAGES.getString('label.datasource.type')</font></th>
+ <td>
+ <div>
+ <input type="radio" default name="DatasourceType" value='jndi' #if ($dst == 'jndi') checked #end onClick="javascript:chooseDS();"/> <font class="portlet-form-field-label">$MESSAGES.getString("label.datasource.jndi")</font>
+ </div>
+ <div>
+ <input type="radio" name="DatasourceType" value='dbcp' #if ($dst == 'dbcp') checked #end onClick="javascript:chooseDBCP();"/> <font class="portlet-form-field-label">$MESSAGES.getString("label.datasource.dbcp")</font>
+ </div>
+ </td>
+ </tr>
+</table>
+
+<h4 class="portlet-section-header">$MESSAGES.getString('label.jndi.settings')</h4>
+
+<table border="0" cellspacing="2" cellpadding="3">
+ <tr>
+ <th class="portlet-section-alternate"><font class="portlet-form-field-label">$MESSAGES.getString("label.jndi")</font></th>
+ <td>
+ <input name='JndiDatasource' $!disableDS type="input" value="$!prefsMap.get('JndiDatasource')" size="30" maxlength="30" class="portlet-form-field-label"/>
+ </td>
+ </tr>
+</table>
+
+<h4 class="portlet-section-header">$MESSAGES.getString('label.dbcp.settings')</h4>
+
+<table border="0" cellspacing="2" cellpadding="3">
+ <tr>
+ <th class="portlet-section-alternate"><font class="portlet-form-field-label">$MESSAGES.getString("label.jdbc.driver")</font></th>
+ <td>
+ <input type="input" name="JdbcDriver" $!disableDBCP value="$!prefsMap.get('JdbcDriver')" size="60" maxlength="100" class="portlet-form-field-label"/>
+ </td>
+ </tr>
+ <tr>
+ <th class="portlet-section-alternate"><font class="portlet-form-field-label">$MESSAGES.getString("label.jdbc.connection")</font></th>
+ <td>
+ <input type="input" name="JdbcConnection" $!disableDBCP value="$!prefsMap.get('JdbcConnection')" size="60" maxlength="100" class="portlet-form-field-label"/>
+ </td>
+ </tr>
+ <tr>
+ <th class="portlet-section-alternate"><font class="portlet-form-field-label">$MESSAGES.getString("label.jdbc.username")</font></th>
+ <td>
+ <input type="input" name="JdbcUsername" $!disableDBCP value="$!prefsMap.get('JdbcUsername')" size="30" maxlength="30" class="portlet-form-field-label"/>
+ </td>
+ </tr>
+ <tr>
+ <th class="portlet-section-alternate"><font class="portlet-form-field-label">$MESSAGES.getString("label.jdbc.password")</font></th>
+ <td>
+ <input type="password" name="JdbcPassword" $!disableDBCP value="$!prefsMap.get('JdbcPassword')" size="30" maxlength="30" class="portlet-form-field-label"/>
+ </td>
+ </tr>
+</table>
+
+<h4 class="portlet-section-header">$MESSAGES.getString('label.general.settings')</h4>
+<table border="0" cellspacing="2" cellpadding="3">
+ <tr>
+ <th class="portlet-section-alternate"><font class="portlet-form-field-label">$MESSAGES.getString("label.window.size")</font></th>
+ <td>
+ <input type="input" name="WindowSize" value="$!prefsMap.get('WindowSize')" size="5" maxlength="5" class="portlet-form-field-label"/>
+ </td>
+ </tr>
+ <tr>
+ #set($tabelPref = $!prefsMap.get('tableName'))
+ <th class="portlet-section-alternate"><font class="portlet-form-field-label">TABLE</font></th>
+ <td>
+ #if($tableLists)
+ <select name="tables${name}" id="tables${name}">
+ #foreach ($table in $tableLists )
+ <option value='$table'
+ #if($table == $tabelPref)
+ selected
+ #end>$table</option>
+ #end
+ </select>
+ #else
+ <input type="input" name="tables" id="tables" class="portlet-form-field-label" value="$!prefsMap.get('tableName')" />
+ #end
+ </td>
+ </tr>
+</table>
+
+<input type="hidden" name="tableName" id="tableName" value=""/>
+<input type="hidden" name="configPage" value=""/>
+<input type="submit" name="Save" value="Save" onClick="javascript:presave();"/>
+<input type="submit" name="Test" value="Test" onClick="javascript:presave();"/>
+<input type="button" name="Next" value="Next" onClick="javascript:nextPage();"/>
+</form>
+
+<script language="JavaScript">
+ function nextPage()
+ {
+ #if($tableLists)
+ var tables = document.getElementById('tables${name}');
+ document.J2DBEdit${name}.tableName.value = tables.options[tables.selectedIndex].value;
+ #else
+ var tables = document.getElementById('tables${name}');
+ document.J2DBEdit${name}.tableName.value = tables.value;
+ #end
+ document.J2DBEdit${name}.configPage.value = 'configPage1';
+ document.J2DBEdit${name}.submit();
+ }
+ function chooseDS()
+ {
+ disableDS(false);
+ disableDBCP(true);
+ }
+
+ function chooseDBCP()
+ {
+ disableDS(true);
+ disableDBCP(false);
+ }
+
+ function disableDS(flag)
+ {
+ document.forms['J2DBEdit$name'].JndiDatasource.disabled = flag;
+ }
+
+ function disableDBCP(flag)
+ {
+ document.forms['J2DBEdit$name'].JdbcDriver.disabled = flag;
+ document.forms['J2DBEdit$name'].JdbcConnection.disabled = flag;
+ document.forms['J2DBEdit$name'].JdbcUsername.disabled = flag;
+ document.forms['J2DBEdit$name'].JdbcPassword.disabled = flag;
+ }
+
+ function presave()
+ {
+ #if($tableLists)
+ var tables = document.getElementById('tables');
+ document.J2DBEdit${name}.tableName.value = tables.options[tables.selectedIndex].value;
+ #else
+ var tables = document.getElementById('tables');
+ document.J2DBEdit${name}.tableName.value = tables.value;
+ #end
+ disableDS(false);
+ disableDBCP(false);
+ disableSSO(false);
+ }
+
+</script>
\ No newline at end of file
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-edit1.vm
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-edit1.vm?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-edit1.vm (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-edit1.vm Fri Apr 10 16:16:18 2009
@@ -0,0 +1,400 @@
+#*
+ 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.
+*#
+#set ($MESSAGES = $portletConfig.getResourceBundle($renderRequest.Locale))
+#set ($dst = $prefsMap.get('DatasourceType'))
+#set ($disableDS = "disabled")
+#set ($disableDBCP = "disabled")
+#set ($disableSSO = "disabled")
+#if ($!dst == 'jndi')
+#set ($disableDS = "")
+#elseif ($!dst == 'dbcp')
+#set ($disableDBCP = "")
+#elseif ($!dst == 'sso')
+#set ($disableSSO = "")
+#end
+
+#set($name=$renderResponse.Namespace)
+
+#if ($statusMsg)
+#parse ('/WEB-INF/view/status-include.vm')
+#end
+
+<h3 class="portlet-section-header">Fields</h3>
+
+<form name='J2DBEdit$name' action="" method="post">
+<table border="0" cellspacing="2" cellpadding="3">
+ <tr>
+ <td class="portlet-section-alternate"><font class="portlet-form-field-label">Field Name</font></td>
+ <td><select size="8" name="avilableCols" id="avilableCols">
+ #foreach ($col in $cols )
+ <option value="$col">$col</option>
+ #end
+ </select></td>
+ <td><input type="button" onClick="javascript:moveoutid('avilableCols','selectedCols');" value=" > " /><br/><input type="button" onClick="javascript:moveinid('avilableCols','selectedCols');" value=" < " /></td>
+ <td><select size="8" name="selectedCols" id="selectedCols">
+ </select></td>
+ <td><input type="button" onClick="javascript:moveUpList();" value="Move Up" /><br/><input type="button" onClick="javascript:moveDownList();" value="Move Down" /></td>
+ </tr>
+ <tr>
+ <td colspan="3"> </td>
+ <td colspan="2">Set Column Labels</td>
+ </tr>
+ <tr>
+ <td colspan="3"> </td>
+ <td><input type="text" id="colLabel" name="colLabel" /></td>
+ <td><input type="button" onClick="javascript:setLabel()" value="Set Label"/></td>
+ </tr>
+</table>
+
+<h3 class="portlet-section-header">Sort Fields</h3>
+
+<table border="0" cellspacing="2" cellpadding="3">
+ <tr>
+ <td class="portlet-section-alternate"><font class="portlet-form-field-label">Sort Columns</font></td>
+ <td><select size="8" name="sortCols" id="sortCols">
+ #foreach ($col in $cols )
+ <option value="$col">$col</option>
+ #end
+ </select></td>
+ <td><input type="button" onClick="javascript:moveoutid('sortCols','sortedCols');" value=" > " /><br/><input type="button" onClick="javascript:moveinid('sortCols','sortedCols');" value=" < " /></td>
+ <td><select size="8" name="sortedCols" id="sortedCols">
+ </select></td>
+ <td><input type="button" onClick="javascript:setSortType('ASC','ASC');" value="Asc" /><br/><input type="button" onClick="javascript:setSortType('DESC','DESC');" value="Desc" /></td>
+ </tr>
+</table>
+
+<h4 class="portlet-section-header">Where clause</h4>
+<table border="0" cellspacing="2" cellpadding="3">
+ <tr>
+ <th class="portlet-section-alternate"><font class="portlet-form-field-label">$MESSAGES.getString("label.sql")</font></th>
+ <td>
+ <textarea name="conditions" id="conditions" cols='60' rows='8' class="portlet-form-field-label">$!prefsMap.get('conditions')</textarea>
+ </td>
+ <td>
+ <input type="button" onClick="javascript:insertPlaceHolder('$USER');" value="User Name" /><br/>
+ </td>
+ </tr>
+</table>
+
+<input type="hidden" name="columnTitles" id="columnTitles" value=""/>
+<input type="hidden" name="columnNames" id="columnNames" value=""/>
+<input type="hidden" name="orderByColumns" id="orderByColumns" value=""/>
+<input type="hidden" id="configPage" name="configPage" value=""/>
+<input type="button" name="back" value="Back" onClick="javascript:goBack();"/>
+<input type="button" name="Save" value="Save" onClick="javascript:saveAdvanceData();"/>
+</form>
+
+<script language="JavaScript">
+
+ var ColTitle = new Array();
+ #set($index = 0)
+ #foreach ($colT in $colTitle )
+ ColTitle[$index] = '$colT';
+ #set($index = $index + 1)
+ #end
+ var ColName = new Array();
+ #set($index = 0)
+ #foreach ($colN in $colName )
+ ColName[$index] = '$colN';
+ #set($index = $index + 1)
+ #end
+
+ var sortColName = new Array();
+ #set($index = 0)
+ #foreach ($colN in $sortCols )
+ sortColName[$index] = '$colN';
+ #set($index = $index + 1)
+ #end
+
+ function insertPlaceHolder(placeHolder)
+ {
+ document.getElementById('conditions').value = document.getElementById('conditions').value + placeHolder;
+ }
+ function arrangeColumns()
+ {
+ document.getElementById('conditions').value = document.getElementById('conditions').value.replace('where ' ,'');
+ var columns = document.getElementById('avilableCols');
+ var selectedCols = document.getElementById('selectedCols');
+ for(var j=0; j<ColName.length; j++)
+ {
+ for(var i=0; i<columns.length; i++)
+ {
+ if(columns.options[i].value == ColName[j])
+ {
+ columns.remove(i);
+ var y=document.createElement('option');
+ y.text=ColName[j] + ' ' + ColTitle[j];
+ y.value=ColName[j] + ':' + ColTitle[j];
+ try
+ {
+ selectedCols.add(y,null);
+ }
+ catch(ex)
+ {
+ selectedCols.add(y);
+ }
+ }
+ }
+ }
+ }
+
+ function arrangeSortColumns()
+ {
+ var tempValue='';
+ var columns = document.getElementById('sortCols');
+ var selectedCols = document.getElementById('sortedCols');
+ for(var j=0; j<sortColName.length; j++)
+ {
+ for(var i=0; i<columns.length; i++)
+ {
+ tempValue = sortColName[j].split(' ');
+ if(columns.options[i].value == tempValue[0])
+ {
+ columns.remove(i);
+ var y=document.createElement('option');
+ if(tempValue[1] == 'ASC')
+ {
+ y.text= tempValue[0] + ' ASC';
+ y.value=tempValue[0] + ':' + tempValue[1];
+ }else if(tempValue[1] == 'DESC'){
+ y.text= tempValue[0] + ' DESC';
+ y.value=tempValue[0] + ':' + tempValue[1];
+ }else{
+ y.text= tempValue[0] + ' ASC';
+ y.value=tempValue[0] + ':ASC';
+ }
+ try
+ {
+ selectedCols.add(y,null);
+ }
+ catch(ex)
+ {
+ selectedCols.add(y);
+ }
+ }
+ }
+ }
+ }
+
+ function listToString()
+ {
+ var columns = document.getElementById('columnTitles');
+ var selectedCols = document.getElementById('selectedCols');
+ var len = selectedCols.length;
+ var tempValue = '';
+ var sqlValue ='';
+ for(var j=0; j<len; j++)
+ {
+ if(selectedCols.options[j].value.indexOf(':')>-1){
+ tempValue = tempValue + "," +selectedCols.options[j].value.split(':')[1];
+ sqlValue = sqlValue + "," +selectedCols.options[j].value.split(':')[0];
+ }else{
+ tempValue = tempValue + "," +selectedCols.options[j].value;
+ sqlValue = sqlValue + "," +selectedCols.options[j].value;
+ }
+ }
+ document.getElementById('columnTitles').value = tempValue.substring(1);
+ document.getElementById('columnNames').value = sqlValue.substring(1);
+ }
+
+ function orderBylist()
+ {
+ var selectedCols = document.getElementById('sortedCols');
+ var len = selectedCols.length;
+ var tempValue = '';
+ var colValue ='';
+ for(var j=0; j<len; j++)
+ {
+ colValue = selectedCols.options[j].value;
+ if(colValue.indexOf(':')>-1){
+ tempValue = tempValue + "," + colValue.split(':')[0] + " " + colValue.split(':')[1];
+ }
+ }
+
+ var whereCond = document.getElementById('conditions').value;
+ if(whereCond.length>0)
+ {
+ whereCond = 'where ' + whereCond;
+ document.getElementById('conditions').value = whereCond;
+ }
+ document.getElementById('orderByColumns').value = tempValue.substring(1);
+ }
+
+ function goBack()
+ {
+ listToString();
+ #set ($xmlLink = $renderResponse.createActionURL())
+ $xmlLink.setParameter("configPage","configPage")
+ document.J2DBEdit${name}.action = '$xmlLink';
+ document.J2DBEdit${name}.submit();
+ }
+ function saveAdvanceData()
+ {
+ listToString();
+ orderBylist();
+ #set ($xmlLink = $renderResponse.createActionURL())
+ $xmlLink.setParameter("configPage","save")
+ document.J2DBEdit${name}.action = '$xmlLink';
+ document.J2DBEdit${name}.submit();
+ }
+
+ function moveoutid(source,destination)
+ {
+ var avilableCols = document.getElementById(source);
+ var len = avilableCols.length;
+ var selectedCols = document.getElementById(destination);
+ for(var j=0; j<len; j++)
+ {
+ if(avilableCols[j].selected)
+ {
+ var tmp = avilableCols.options[j].text;
+ var tmp1 = avilableCols.options[j].value;
+ avilableCols.remove(j);
+ j--;
+ var y=document.createElement('option');
+ y.text=tmp;
+ y.value=tmp1;
+ try
+ {
+ selectedCols.add(y,null);
+ }
+ catch(ex)
+ {
+ selectedCols.add(y);
+ }
+ break;
+ }
+ }
+ }
+
+
+ function moveinid(source,destination)
+ {
+ var avilableCols = document.getElementById(source);
+ var selectedCols = document.getElementById(destination);
+ var len = selectedCols.length;
+ for(var j=0; j<len; j++)
+ {
+ if(selectedCols[j].selected)
+ {
+ var tmp = selectedCols.options[j].text.split(' ')[0];
+ var tmp1 = selectedCols.options[j].value.split(':')[0];
+ selectedCols.remove(j);
+ j--;
+ var y=document.createElement('option');
+ y.text=tmp;
+ y.value=tmp1;
+ try
+ {
+ avilableCols.add(y,null);}
+ catch(ex){
+ avilableCols.add(y);
+ }
+ break;
+ }
+ }
+ }
+
+ function setLabel()
+ {
+ var listField = document.getElementById('selectedCols');
+ var colLabel = document.getElementById('colLabel').value;
+ var index = listField.selectedIndex
+ var labelsVal = listField[index].value.split(':');
+ listField[index].text = labelsVal[0] + ' ' + colLabel;
+ listField[index].value = labelsVal[0] + ':' + colLabel;
+ document.getElementById('colLabel').value = '';
+ listField.selectedIndex=0;
+ }
+
+ function setSortType(sort,SortLabel)
+ {
+ var listField = document.getElementById('sortedCols');
+ var index = listField.selectedIndex
+ var labelsVal = listField[index].value.split(':');
+ listField[index].text = labelsVal[0] + ' ' + SortLabel;
+ listField[index].value = labelsVal[0] + ':' + sort;
+ listField.selectedIndex=0;
+ }
+
+ function moveUpList() {
+ var listField = document.getElementById('selectedCols');
+ if ( listField.length == -1) { // If the list is empty
+ alert("There are no values which can be moved!");
+ } else {
+ var selected = listField.selectedIndex;
+ if (selected == -1) {
+ alert("You must select an entry to be moved!");
+ } else { // Something is selected
+ if ( listField.length == 0 ) { // If there's only one in the list
+ alert("There is only one entry!\nThe one entry will remain in place.");
+ } else { // There's more than one in the list, rearrange the list order
+ if ( selected == 0 ) {
+ alert("The first entry in the list cannot be moved up.");
+ } else {
+ // Get the text/value of the one directly above the hightlighted entry as
+ // well as the highlighted entry; then flip them
+ var moveText1 = listField[selected-1].text;
+ var moveText2 = listField[selected].text;
+ var moveValue1 = listField[selected-1].value;
+ var moveValue2 = listField[selected].value;
+ listField[selected].text = moveText1;
+ listField[selected].value = moveValue1;
+ listField[selected-1].text = moveText2;
+ listField[selected-1].value = moveValue2;
+ listField.selectedIndex = selected-1; // Select the one that was selected before
+ } // Ends the check for selecting one which can be moved
+ } // Ends the check for there only being one in the list to begin with
+ } // Ends the check for there being something selected
+ } // Ends the check for there being none in the list
+ }
+
+ function moveDownList() {
+ var listField = document.getElementById('selectedCols');
+ if ( listField.length == -1) { // If the list is empty
+ alert("There are no values which can be moved!");
+ } else {
+ var selected = listField.selectedIndex;
+ if (selected == -1) {
+ alert("You must select an entry to be moved!");
+ } else { // Something is selected
+ if ( listField.length == 0 ) { // If there's only one in the list
+ alert("There is only one entry!\nThe one entry will remain in place.");
+ } else { // There's more than one in the list, rearrange the list order
+ if ( selected == listField.length-1 ) {
+ alert("The last entry in the list cannot be moved down.");
+ } else {
+ // Get the text/value of the one directly below the hightlighted entry as
+ // well as the highlighted entry; then flip them
+ var moveText1 = listField[selected+1].text;
+ var moveText2 = listField[selected].text;
+ var moveValue1 = listField[selected+1].value;
+ var moveValue2 = listField[selected].value;
+ listField[selected].text = moveText1;
+ listField[selected].value = moveValue1;
+ listField[selected+1].text = moveText2;
+ listField[selected+1].value = moveValue2;
+ listField.selectedIndex = selected+1; // Select the one that was selected before
+ } // Ends the check for selecting one which can be moved
+ } // Ends the check for there only being one in the list to begin with
+ } // Ends the check for there being something selected
+ } // Ends the check for there being none in the list
+ }
+
+ arrangeColumns();
+ arrangeSortColumns();
+</script>
\ No newline at end of file
Added: portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-help.vm
URL: http://svn.apache.org/viewvc/portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-help.vm?rev=763970&view=auto
==============================================================================
--- portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-help.vm (added)
+++ portals/applications/databaseBrowser/trunk/dbBrowser-war/src/main/webapp/WEB-INF/view/database-help.vm Fri Apr 10 16:16:18 2009
@@ -0,0 +1,32 @@
+#*
+ 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.
+*#
+#set ($MESSAGES = $portletConfig.getResourceBundle($renderRequest.Locale))
+<p>TODO: arguably the long descriptive strings here shouldn't be localized by resource bundles but by file i.e. database-help_en.vm etc </b>
+
+<h3 class="portlet-section-header">$MESSAGES.getString('label.prefs')</h3>
+
+<table border="0" cellspacing="2" cellpadding="3">
+<tr>
+ <th class="portlet-section-alternate"><font class="portlet-form-field-label">$MESSAGES.getString("label.jndi")</font></th>
+ <td>
+ <input type="input" name="jndi.ds" value="" size="30" maxlength="30" class="portlet-form-field-label"/>
+ </td>
+ <td>
+ <input type="input" name="jndi.ds" value="" size="30" maxlength="30" class="portlet-form-field-label"/>
+ </td>
+</tr>
+</table>