diff options
Diffstat (limited to 'das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp')
8 files changed, 662 insertions, 0 deletions
diff --git a/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/DASMenu.jsp b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/DASMenu.jsp new file mode 100644 index 0000000000..041e05c8bb --- /dev/null +++ b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/DASMenu.jsp @@ -0,0 +1,63 @@ +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<!--
+ Copyright (c) 2005 The Apache Software Foundation or its licensors, as applicable.
+
+ Licensed 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.
+ -->
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
+ <head>
+ <link rel="stylesheet" type="text/css" href="main.css" media="screen, print" />
+ <script type="text/javascript" src="../js/dasmenu.js" >
+ </script>
+
+ <title>DASMenu: Web Sample</title>
+ <meta name="description" content="DAS Features Demo" />
+ <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
+ <meta http-equiv="expires" content="-1" />
+ <meta http-equiv="pragma" content="no-cache" />
+ </head>
+ <body onload="initialiseMenu();
+
+ ">
+ <h1>Tuscany DAS Web Sample</h1>
+ <ul id="mainmenu">
+ <li><a href="../html/blank.html" target="dynamic">Advanced Features</a>
+ <ul>
+ <li><a href="./occ.jsp" target="dynamic">OCC</a></li>
+ <li><a href="./converter.jsp" target="dynamic">Converter</a></li>
+ <li><a href="./rss.jsp" target="dynamic">Result Set Shape</a></li>
+ </ul>
+ </li>
+ <li><a href="./indexAdhoc.jsp" target="dynamic">Adhoc Query</a></li>
+ <li><a href="./indexCommand.jsp" target="dynamic">Command</a></li>
+ </ul>
+ <p>Tuscany DAS web sample demonstrates - simple adhoc queries, DAS predefined commands execution and
+ some advanced features like Optimistic Concurrency Control (OCC), Converter, Result Set Shape etc.
+ </p>
+ <p>Check more details by navigating menu.
+ Press <b>Refresh!</b> button anytime for database refresh.
+ </p>
+
+ <FORM name='MenuForm'>
+ <INPUT TYPE="button" id="refreshButton" name="refreshButton" value="Refresh!"
+ onClick=" refreshdb();
+ "
+ >
+ </INPUT>
+ <!-- Font for Status Message -->
+ <font face="Arial,Helvetica,Verdana" size="2" color="#FF0000">
+ <b id="dbmsg"></b>
+ </font>
+ </FORM>
+ </body>
+</html>
\ No newline at end of file diff --git a/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/converter.jsp b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/converter.jsp new file mode 100644 index 0000000000..a3610e7639 --- /dev/null +++ b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/converter.jsp @@ -0,0 +1,117 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+
+<%--
+ * Copyright (c) 2005 The Apache Software Foundation or its licensors, as applicable.
+ *
+ * Licensed 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.
+ --%>
+
+<%-- JSTL tags --%>
+<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
+<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
+
+<html>
+
+<head>
+<link href="default.css" rel="stylesheet" type="text/css">
+<script type="text/javascript" src="../js/ajax.js" >
+</script>
+
+</head>
+
+<body onload="startup()">
+
+<%@ page import="java.util.*" %>
+
+<font face="Arial,Helvetica,Verdana" size="3">
+
+<form name="DasForm" >
+
+<input type="hidden" id="serviceName" name="serviceName" value="org.apache.tuscany.samples.das.DASQueryProcessor"/>
+<input type="hidden" id="configFile" name="configFile" value="CustomerConfigWithConverter.xml"/>
+<input type="hidden" id="type" name="type" value="converter:"/>
+<input type="hidden" id="param" name="param" value=""/>
+<input type="hidden" id="xslFileName" name="xslFileName" value=""/>
+
+<b>Arbitrary Converter: </b>
+ The column converted is a VARCAHAR.
+ ResultSetShape is used to specify that the property will be a SDODataTypes.DATE.
+ So this example uses a converter that transforms a string column into a date property
+ and conversely, a date property back to a string for the underlying column.
+ <br>
+ The converter returns 1957.09.27 if the column value is "Pavick" and 1966.12.20 if
+ the value is "Williams"
+ <br>
+ On write, the converter returns "Williams" if the property value is 1966.12.20 and "Pavick"
+ if the property value is 1957.09.27
+ <br>
+ Check using direct database connection that the database table rows's column values are
+ either "Williams" or "Pavick".
+<br>
+<hr width="90%" size="1">
+<input type="radio" name="stmt" id="stmt" checked="checked" value="stmt0">
+Select * from CUSTOMER where ID = 1;
+<br>
+<input type="radio" name="stmt" id="stmt" value="stmt1">
+Check First Customer's LastName is 1957.09.27
+<br>
+<input type="radio" name="stmt" id="stmt" value="stmt2">
+Set First Customer's LastName to 1966.12.20
+<br>
+<input type="radio" name="stmt" id="stmt" value="stmt3">
+Check First Customer's LastName is 1966.12.20
+<br>
+
+
+
+<input type="button" id="converterButton" name="converterButton" value="ExecuteTransaction"
+ onclick="
+ var varVal;
+ if(this.form.stmt[0].checked){
+ varVal = 'stmt0';
+ xslFileName.value = '../xsl/customer.xsl';
+ }
+ if(this.form.stmt[1].checked){
+ varVal = 'stmt1';
+ xslFileName.value = '';
+ }
+ if(this.form.stmt[2].checked){
+ varVal = 'stmt2';
+ xslFileName.value = '';
+ }
+ if(this.form.stmt[3].checked){
+ varVal = 'stmt3';
+ xslFileName.value = '';
+ }
+
+ param.value = 'Query=' + this.form.type.value+varVal;
+ param.value += '&serviceName='+this.form.serviceName.value;
+ param.value += '&configFile='+this.form.configFile.value;
+ executeQuery(param.value, xslFileName.value);
+ formWaitMessage();
+ ">
+</input>
+<hr>
+
+<!-- Font for Status Message -->
+<font face="Arial,Helvetica,Verdana" size="2" color="#FF0000">
+<div id="msg"> </div>
+</font>
+<!-- Font End -->
+
+</form>
+
+</font>
+
+</body>
+</html>
diff --git a/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/default.css b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/default.css new file mode 100644 index 0000000000..5680fab9ed --- /dev/null +++ b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/default.css @@ -0,0 +1,35 @@ +/*
+ * 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.
+ */
+
+BODY {BACKGROUND-COLOR: #FFFFFF; COLOR: #333366; FONT-FAMILY: 'Times New Roman'}
+H1 {COLOR: #6666CC; FONT-FAMILY: 'Times New Roman'; TEXT-TRANSFORM: capitalize }
+H2 {COLOR: #6666CC; FONT-FAMILY: 'Times New Roman'; TEXT-TRANSFORM: capitalize }
+H3 {COLOR: #6666CC; FONT-FAMILY: 'Times New Roman'; TEXT-TRANSFORM: capitalize }
+H4 {COLOR: #6666CC; FONT-FAMILY: 'Times New Roman'; TEXT-TRANSFORM: capitalize }
+H5 {COLOR: #6666CC; FONT-FAMILY: 'Times New Roman'; TEXT-TRANSFORM: capitalize }
+H6 {COLOR: #6666CC; FONT-FAMILY: 'Times New Roman'; TEXT-TRANSFORM: capitalize }
+TH {COLOR: #000000; font-weight: bold }
+
+#TRowEven {background-color: #ccff99}
+#TRowOdd {background-color: #ffffcc}
+
+A:link {cursor:hand; color: #3300FF; text-decoration: none;}
+A:visited {cursor:hand; color: #3300FF; text-decoration: none; }
+A:active {cursor:hand; color:#FEAA02; text-decoration: none;}
+A:hover {cursor:hand; color:#FEAA02;}
diff --git a/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/indexAdhoc.jsp b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/indexAdhoc.jsp new file mode 100644 index 0000000000..f212d744f1 --- /dev/null +++ b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/indexAdhoc.jsp @@ -0,0 +1,87 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+
+<%--
+ * Copyright (c) 2005 The Apache Software Foundation or its licensors, as applicable.
+ *
+ * Licensed 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.
+ --%>
+
+<%-- JSTL tags --%>
+<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
+<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
+
+<html>
+
+<head>
+<link href="default.css" rel="stylesheet" type="text/css">
+<script type="text/javascript" src="../js/ajax.js" >
+</script>
+
+</head>
+
+<body onload="startup()">
+
+<%@ page import="java.util.*" %>
+
+<font face="Arial,Helvetica,Verdana" size="3">
+
+<form name="DasForm" >
+
+<input type="hidden" id="serviceName" name="serviceName" value="org.apache.tuscany.samples.das.DASQueryProcessor"/>
+<input type="hidden" id="configFile" name="configFile" value="DasConfig.xml"/>
+<input type="hidden" id="type" name="type" value="query:"/>
+<input type="hidden" id="param" name="param" value=""/>
+<input type="hidden" id="xslFileName" name="xslFileName" value=""/>
+
+<b>Adhoc SQL Query: </b><br>
+<select id="sqlQuery" name="sqlQuery"
+ onfocus="this.form.queryButton.disabled=false;">
+<option value="NullQuery"></option>
+<option value="SELECT * FROM COMPANY">SELECT * FROM COMPANY</option>
+<option value="SELECT * FROM COMPANY LEFT OUTER JOIN DEPARTMENT ON COMPANY.ID = DEPARTMENT.COMPANYID">SELECT * FROM COMPANY LEFT OUTER JOIN DEPARTMENT ON COMPANY.ID = DEPARTMENT.COMPANYID</option>
+<option value="{INSERT INTO DEPARTMENT (NAME, COMPANYID) VALUES ('MyDept',1)}{SELECT * FROM COMPANY LEFT OUTER JOIN DEPARTMENT ON COMPANY.ID = DEPARTMENT.COMPANYID}">
+ INSERT INTO DEPARTMENT (NAME, COMPANYID) VALUES ('MyDept',1)</option>
+<option value="{DELETE FROM DEPARTMENT WHERE DEPARTMENT.COMPANYID=1 and DEPARTMENT.ID>1}{SELECT * FROM COMPANY LEFT OUTER JOIN DEPARTMENT ON COMPANY.ID = DEPARTMENT.COMPANYID}">
+ DELETE FROM DEPARTMENT WHERE COMPANYID=1 and ID>1</option>
+<option value="{UPDATE DEPARTMENT SET NAME='MyUpdDept' WHERE COMPANYID=1 AND ID=1}{SELECT * FROM COMPANY LEFT OUTER JOIN DEPARTMENT ON COMPANY.ID = DEPARTMENT.COMPANYID}">
+ UPDATE DEPARTMENT SET NAME='MyUpdDept' WHERE COMPANYID=1 AND ID=1</option>
+</select>
+
+<input type="button" id="queryButton" name="queryButton" value="ExecuteQuery"
+ onclick="
+ if(this.form.sqlQuery.value=='SELECT * FROM COMPANY'){
+ this.form.xslFileName.value = '../xsl/company.xsl';
+ }
+ else{
+ this.form.xslFileName.value = '../xsl/companyDepartment.xsl';
+ }
+ param.value = 'Query=' + this.form.type.value+this.form.sqlQuery.value;
+ param.value += '&serviceName='+this.form.serviceName.value;
+ param.value += '&configFile='+this.form.configFile.value;
+ executeQuery(param.value, xslFileName.value);
+ formWaitMessage();
+ " >
+</input>
+<hr>
+
+<!-- Font for Status Message -->
+<font face="Arial,Helvetica,Verdana" size="2" color="#FF0000">
+<div id="msg"> </div>
+</font>
+<!-- Font End -->
+</form>
+
+</font>
+
+</body>
+</html>
diff --git a/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/indexCommand.jsp b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/indexCommand.jsp new file mode 100644 index 0000000000..55dcb56e38 --- /dev/null +++ b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/indexCommand.jsp @@ -0,0 +1,85 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+
+<%--
+ * Copyright (c) 2005 The Apache Software Foundation or its licensors, as applicable.
+ *
+ * Licensed 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.
+ --%>
+
+<%-- JSTL tags --%>
+<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
+<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
+
+<html>
+
+<head>
+<link href="default.css" rel="stylesheet" type="text/css">
+<script src="../js/ajax.js" language="javascript" type="text/javascript"></script>
+
+</head>
+
+<body onload="startup()">
+
+<%@ page import="java.util.*" %>
+
+<font face="Arial,Helvetica,Verdana" size="3">
+
+<form name="DasForm" >
+
+<input type="hidden" id="serviceName" name="serviceName" value="org.apache.tuscany.samples.das.DASQueryProcessor"/>
+<input type="hidden" id="configFile" name="configFile" value="DasConfig.xml"/>
+<input type="hidden" id="type" name="type" value="command:"/>
+<input type="hidden" id="param" name="param" value=""/>
+<input type="hidden" id="xslFileName" name="xslFileName" value=""/>
+
+<b>DAS Command: </b>
+
+<select id="DasCommand" name="DasCommand"
+ onfocus="this.form.commandButton.disabled=false;">
+<option value="NullCommand"></option>
+<option value="AllCompanies">all companies</option>
+<option value="AllCompaniesAndDepartments">all companies and departments</option>
+<option value="AddDepartmentToFirstCompany">Add department to first company</option>
+<option value="DeleteDepartmentFromFirstCompany">Delete department from first company</option>
+<option value="UpdateCompanyDepartmentNames">Update one department name from first company</option>
+</select>
+
+
+<input type="button" id="commandButton" name="commandButton" value="ExecuteCommand"
+ onclick="this.form.type.value='command:';
+ if(this.form.DasCommand.value=='AllCompanies'){
+ this.form.xslFileName.value = '../xsl/company.xsl';
+ }
+ else{
+ this.form.xslFileName.value = '../xsl/companyDepartment.xsl';
+ }
+
+ param.value = 'Query=' + this.form.type.value+this.form.DasCommand.value;
+ param.value += '&serviceName='+this.form.serviceName.value;
+ param.value += '&configFile='+this.form.configFile.value;
+ executeQuery(param.value, this.form.xslFileName.value);
+ formWaitMessage();
+ " >
+</input>
+<hr>
+<!-- Font for Status Message -->
+<font face="Arial,Helvetica,Verdana" size="2" color="#FF0000">
+<div id="msg"> </div>
+</font>
+<!-- Font End -->
+</form>
+
+</font>
+
+</body>
+</html>
diff --git a/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/main.css b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/main.css new file mode 100644 index 0000000000..264facc985 --- /dev/null +++ b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/main.css @@ -0,0 +1,120 @@ +/*
+ * 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.
+ */
+
+body
+{
+ margin: 0px;
+ border: 0px;
+ padding: 0px;
+ font-family: Verdana, Arial, Sans-Serif;
+ font-size: 0px;
+}
+
+img
+{
+ border: none 0px #ffffff;
+}
+
+h1
+{
+ background-color: #ffcc00;
+ border-bottom: solid 1px #333333;
+ padding: 5px;
+ margin: 0px;
+ font-size: x-large;
+}
+
+h2
+{
+ font-size: large;
+}
+
+p
+{
+ font-size: small;
+}
+
+/* Real menu */
+ul, li
+{
+ font-size: small;
+ margin-top: 0px;
+ margin-right: 0px;
+ margin-bottom: 0px;
+ display: block;
+}
+
+ul
+{
+ width: 130px;
+ border: solid 1px #333333;
+ border-top: solid 5px #333333;
+ border-right: solid 2px #333333;
+ padding: 0px;
+}
+
+li ul
+{
+ display: none;
+ position: absolute;
+ margin-left: 100px;
+ margin-top: -20px;
+}
+
+li a
+{
+ padding: 2px;
+ text-decoration: none;
+ color: #000000;
+ background-color: #ffffee;
+ width: 100%;
+ display: block;
+ border-bottom: dashed 1px #333333;
+ text-indent: 2px;
+ font-size: small;
+}
+
+li a:hover
+{
+ background-color: #ffcc00;
+ font-weight: bold;
+ border-bottom: solid 1px #333333;
+}
+
+li
+{
+ float: left;
+ width: 98%;
+}
+
+a.hassubmenu
+{
+ background-image: url(../img/lay_dmnuhassub.gif);
+ background-repeat: no-repeat;
+ background-position: 120px 7px;
+}
+
+#mainmenu
+{
+ margin: 10px;
+ margin-left: 5px;
+ float: left;
+ border-bottom: solid 2px #333333;
+ margin-bottom: 100%;
+}
\ No newline at end of file diff --git a/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/occ.jsp b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/occ.jsp new file mode 100644 index 0000000000..ed5a7ee0c1 --- /dev/null +++ b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/occ.jsp @@ -0,0 +1,77 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+
+<%--
+ * Copyright (c) 2005 The Apache Software Foundation or its licensors, as applicable.
+ *
+ * Licensed 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.
+ --%>
+
+<%-- JSTL tags --%>
+<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
+<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
+
+<html>
+
+<head>
+<link href="default.css" rel="stylesheet" type="text/css">
+<script type="text/javascript" src="../js/ajax.js" >
+</script>
+
+</head>
+
+<body onload="startup()">
+
+<%@ page import="java.util.*" %>
+
+<font face="Arial,Helvetica,Verdana" size="3">
+
+<form name="DasForm" >
+
+<input type="hidden" id="serviceName" name="serviceName" value="org.apache.tuscany.samples.das.DASQueryProcessor"/>
+<input type="hidden" id="configFile" name="configFile" value="DasConfig.xml"/>
+<input type="hidden" id="type" name="type" value="occ:"/>
+<input type="hidden" id="param" name="param" value=""/>
+<input type="hidden" id="xslFileName" name="xslFileName" value=""/>
+
+<b>Automatic Optimistic Concurrency Control: </b>
+ Try to modify same column in same database table row twice in one transaction.
+<br>
+<TEXTAREA name="occTransactions" id="occTransactions" rows="3" cols="60" readonly="true">
+ Select * from BOOK where BOOK_ID = 1;
+ update BOOK set NAME = 'Puss in Hat' where BOOK_ID = 1;
+ 'UpdateNameForFirstBook'
+</TEXTAREA>
+
+
+<input type="button" id="occButton" name="occButton" value="ExecuteTransaction"
+ onclick="
+ param.value = 'Query=' + this.form.type.value;
+ param.value += '&serviceName='+this.form.serviceName.value;
+ param.value += '&configFile='+this.form.configFile.value;
+ executeQuery(param.value, xslFileName.value);
+ formWaitMessage();
+ ">
+</input>
+<hr>
+
+<!-- Font for Status Message -->
+<font face="Arial,Helvetica,Verdana" size="2" color="#FF0000">
+<div id="msg"> </div>
+</font>
+<!-- Font End -->
+</form>
+
+</font>
+
+</body>
+</html>
diff --git a/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/rss.jsp b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/rss.jsp new file mode 100644 index 0000000000..2d217d68b3 --- /dev/null +++ b/das-java/tags/1.0-incubating-beta1-rc3/samples/sample-ajax-das/src/main/webapp/jsp/rss.jsp @@ -0,0 +1,78 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+
+<%--
+ * Copyright (c) 2005 The Apache Software Foundation or its licensors, as applicable.
+ *
+ * Licensed 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.
+ --%>
+
+<%-- JSTL tags --%>
+<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
+<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
+
+<html>
+
+<head>
+<link href="default.css" rel="stylesheet" type="text/css">
+<script type="text/javascript" src="../js/ajax.js" >
+</script>
+
+</head>
+
+<body onload="startup()">
+
+<%@ page import="java.util.*" %>
+
+<font face="Arial,Helvetica,Verdana" size="3">
+
+<form name="DasForm" >
+
+<input type="hidden" id="serviceName" name="serviceName" value="org.apache.tuscany.samples.das.DASQueryProcessor"/>
+<input type="hidden" id="configFile" name="configFile" value="CustomerConfigWithIDConverter.xml"/>
+<input type="hidden" id="type" name="type" value="rss:"/>
+<input type="hidden" id="param" name="param" value=""/>
+<input type="hidden" id="xslFileName" name="xslFileName" value=""/>
+
+<b>Result Set Shape: </b>
+ DAS has ability to specify format(shape) of the ResultSet. This is necessary
+ when the JDBC driver in use does not provide adequate support for ResultSetMetadata.
+ Also, we expect that specifying the result set shape will increase performance.
+<br>
+<hr width="90%" size="1">
+<input type="text" name="stmt" id="stmt" value="literal" size="20">
+(Select 99, 'Roosevelt', '1600 Pennsylvania Avenue' from customer)
+
+
+<input type="button" id="rssButton" name="rssButton" value="ExecuteQuery"
+ onclick="
+ this.form.xslFileName.value='../xsl/customer.xsl';
+ param.value = 'Query=' + this.form.type.value+this.form.stmt.value;
+ param.value += '&serviceName='+this.form.serviceName.value;
+ param.value += '&configFile='+this.form.configFile.value;
+ executeQuery(param.value, xslFileName.value);
+ formWaitMessage();
+ " >
+</input>
+<hr>
+
+<!-- Font for Status Message -->
+<font face="Arial,Helvetica,Verdana" size="2" color="#FF0000">
+<div id="msg"> </div>
+</font>
+<!-- Font End -->
+</form>
+
+</font>
+
+</body>
+</html>
|