jakarta-taglibs-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hor...@apache.org
Subject cvs commit: jakarta-taglibs/standard/examples/web/sql index.jsp Update.jsp Transaction.jsp QueryParam.jsp QueryIterate.jsp QueryDirect.jsp
Date Wed, 16 Jan 2002 22:43:51 GMT
horwat      02/01/16 14:43:51

  Modified:    standard/examples/web/sql index.jsp Update.jsp
                        Transaction.jsp QueryParam.jsp QueryIterate.jsp
                        QueryDirect.jsp
  Log:
  Simplify table creation to support the majority of databases. Clarify documentation.
  
  Revision  Changes    Path
  1.6       +11 -4     jakarta-taglibs/standard/examples/web/sql/index.jsp
  
  Index: index.jsp
  ===================================================================
  RCS file: /home/cvs/jakarta-taglibs/standard/examples/web/sql/index.jsp,v
  retrieving revision 1.5
  retrieving revision 1.6
  diff -u -r1.5 -r1.6
  --- index.jsp	11 Jan 2002 19:49:28 -0000	1.5
  +++ index.jsp	16 Jan 2002 22:43:51 -0000	1.6
  @@ -28,10 +28,14 @@
   </table>
   <!-- #BeginEditable "body" --> 
   <h1>SQL Tags Examples</h1>
  -<p>Enter your Driver Name and DataBase URL name to test Database Tag Library. 
  -  NOTE: You can access the tags directly at the bottom of the page to look at 
  -  the source, but they will NOT run properly without the correct database driver 
  -  and url.</p>
  +<p>These examples create their own table for demonstration purposes.  Every database
supports table creation in a slightly different way. For instance, different databases have
different types and constraints. The simplest possible table was chosen, however it may still
not be supported by your particular database. Check your database documentation or administrator
if you have problems creating the table and modify the examples acordingly. Here is the table
used in the examples:</p>
  +<pre><code>
  +    create table mytable (
  +      nameid int primary key,
  +      name varchar(80)
  +    )
  +</code></pre>
  +<p>Enter your Driver Name and DataBase URL to test the Database Tag Library. NOTE:
You will need to have the DataBase Driver classes available in your server's CLASSPATH at
startup.</p>
   <form name="myform" action="session.jsp" method="get" >
     <table width="90%" border="0" cellspacing="0" cellpadding="0">
       <tr> 
  @@ -51,6 +55,9 @@
       <input type="submit" name="Submit" value="Submit">
     </p>
   </form>
  +<hr>
  +<p>NOTE: You can access the tags directly here to look at the source. If you do not
provide a valid Driver and URL using the above form the tags NOT run properly.</p>
  +<%@ include file="links.html" %>
   <!-- #EndEditable --> 
   <hr noshade color="#000099">
   <table width="100%" border="0" cellpadding="5">
  
  
  
  1.4       +2 -3      jakarta-taglibs/standard/examples/web/sql/Update.jsp
  
  Index: Update.jsp
  ===================================================================
  RCS file: /home/cvs/jakarta-taglibs/standard/examples/web/sql/Update.jsp,v
  retrieving revision 1.3
  retrieving revision 1.4
  diff -u -r1.3 -r1.4
  --- Update.jsp	16 Jan 2002 02:22:20 -0000	1.3
  +++ Update.jsp	16 Jan 2002 22:43:51 -0000	1.4
  @@ -24,9 +24,8 @@
   
     <sql:update var="newTable" dataSource="$example">
       create table mytable (
  -      nameid int not null,
  -      name varchar(80) null,
  -      constraint pk_mytable primary key (nameid)
  +      nameid int primary key,
  +      name varchar(80)
       )
     </sql:update>
   
  
  
  
  1.3       +2 -3      jakarta-taglibs/standard/examples/web/sql/Transaction.jsp
  
  Index: Transaction.jsp
  ===================================================================
  RCS file: /home/cvs/jakarta-taglibs/standard/examples/web/sql/Transaction.jsp,v
  retrieving revision 1.2
  retrieving revision 1.3
  diff -u -r1.2 -r1.3
  --- Transaction.jsp	16 Jan 2002 02:22:20 -0000	1.2
  +++ Transaction.jsp	16 Jan 2002 22:43:51 -0000	1.3
  @@ -24,9 +24,8 @@
   <sql:transaction dataSource="$example">
     <sql:update var="newTable" dataSource="$example">
       create table mytable (
  -      nameid int not null,
  -      name varchar(80) null,
  -      constraint pk_mytable primary key (nameid)
  +      nameid int primary key,
  +      name varchar(80)
       )
     </sql:update>
   </sql:transaction>
  
  
  
  1.4       +2 -3      jakarta-taglibs/standard/examples/web/sql/QueryParam.jsp
  
  Index: QueryParam.jsp
  ===================================================================
  RCS file: /home/cvs/jakarta-taglibs/standard/examples/web/sql/QueryParam.jsp,v
  retrieving revision 1.3
  retrieving revision 1.4
  diff -u -r1.3 -r1.4
  --- QueryParam.jsp	16 Jan 2002 02:22:20 -0000	1.3
  +++ QueryParam.jsp	16 Jan 2002 22:43:51 -0000	1.4
  @@ -26,9 +26,8 @@
   
     <sql:update var="newTable" dataSource="$example">
       create table mytable (
  -      nameid int not null,
  -      name varchar(80) null,
  -      constraint pk_mytable primary key (nameid)
  +      nameid int primary key,
  +      name varchar(80)
       )
     </sql:update>
   
  
  
  
  1.4       +2 -3      jakarta-taglibs/standard/examples/web/sql/QueryIterate.jsp
  
  Index: QueryIterate.jsp
  ===================================================================
  RCS file: /home/cvs/jakarta-taglibs/standard/examples/web/sql/QueryIterate.jsp,v
  retrieving revision 1.3
  retrieving revision 1.4
  diff -u -r1.3 -r1.4
  --- QueryIterate.jsp	16 Jan 2002 02:22:20 -0000	1.3
  +++ QueryIterate.jsp	16 Jan 2002 22:43:51 -0000	1.4
  @@ -22,9 +22,8 @@
   
     <sql:update var="newTable" dataSource="$example">
       create table mytable (
  -      nameid int not null,
  -      name varchar(80) null,
  -      constraint pk_mytable primary key (nameid)
  +      nameid int primary key,
  +      name varchar(80)
       )
     </sql:update>
   
  
  
  
  1.4       +2 -3      jakarta-taglibs/standard/examples/web/sql/QueryDirect.jsp
  
  Index: QueryDirect.jsp
  ===================================================================
  RCS file: /home/cvs/jakarta-taglibs/standard/examples/web/sql/QueryDirect.jsp,v
  retrieving revision 1.3
  retrieving revision 1.4
  diff -u -r1.3 -r1.4
  --- QueryDirect.jsp	16 Jan 2002 02:22:20 -0000	1.3
  +++ QueryDirect.jsp	16 Jan 2002 22:43:51 -0000	1.4
  @@ -23,9 +23,8 @@
   
     <sql:update var="newTable" dataSource="$example">
       create table mytable (
  -      nameid int not null,
  -      name varchar(80) null,
  -      constraint pk_mytable primary key (nameid)
  +      nameid int primary key,
  +      name varchar(80)
       )
     </sql:update>
   
  
  
  

--
To unsubscribe, e-mail:   <mailto:taglibs-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:taglibs-dev-help@jakarta.apache.org>


Mime
View raw message