MBA 683 E-Business Technology --

Examples
 Home    Site Map    Search    EhrlichOrg.com

Syllabus    Classes    References  Examples  Student Info    Guest Info

 

Examples for E-B Tech

Code Examples (see also usf-acs.rho.net/tech)

          Example                    ADP Source Web Page
time: shows the current system time. time-adp.htm http://usf-acs.rho.net/tech/time.adp 
s-list.adp: display the contents of table s in list form. s-list-adp.htm http://usf-acs.rho.net/tech/s-list.adp 
s-table.adp: display the content of table s in  HTML table format. s-table-adp.htm http://usf-acs.rho.net/tech/s-table.adp
s-insert: displays the contents of table s formatted as SQL Insert statements. s-insert-adp.htm http://usf-acs.rho.net/tech/s-insert.adp 
s-csv.adp: displays the contents of table s in comma separated values format (for Excel). s-csv-adp.htm http://usf-acs.rho.net/tech/s-csv.adp 
s-add-del.adp: display the contents of table s and provides forms for add, change and update actions using the following three helper pages.  s-add-del-adp.htm http://usf-acs.rho.net/tech/s-add-del.adp 
  s-add-2.adp:
Helper page for the Add request.		 s-add-2-adp.htm   helper page for add requests
  s-del-2.adp:
Helper page for the Delete request.		 s-del-2-adp.htm   helper page for delete requests
  s-upd-2.adp:
Helper page for the Update request. 		 s-upd-2-adp.htm   helper page for update requests
s2-add-del: more advanced version of s-add-del that displays data in forms to allow editing for update. Uses the same three helper pages above. s2-add-del-adp.htm http://usf-acs.rho.net/tech/s2-add-del.adp 
disp-seq.adp:
display the value of an Oracle  Sequence		 disp-seq-adp.htm http://usf-acs.rho.net/tech/disp-seq.adp 
s3-add-del.adp: enhanced version of s2-add-del, with Update/Delete buttons for each row and automatically assigned sid values. Number field is now display only. Uses two helper pages below. s3-add-del-adp.htm http://usf-acs.rho.net/tech/s3-add-del.adp 
  s-add-seq-2:
Helper page that assigns sid values using an Oracle sequence.		 s-add-seq-2-adp.htm   helper page for add requests
  s3-upd-2.adp:
Helper page that implements both update and delete requests, depending on the value of the Action variable.		 s3-upd-2-adp.htm   helper page for update and delete requests 
helper-1.adp:
creates HTML forms for drop down menu and scrolling list using information from a database table. Uses helper-2 below. Note that multiple selections from a scrolling list are not supported.		 helper-1-adp.htm http://usf-acs.rho.net/tech/helper-1.adp 
  helper-2.adp:
Display the data passed from helper-1.adp. Notice that only the course number received passed, not the course title.		 helper-2-adp.htm   helper page to display result of helper-1.adp
headers-1.adp:
displays the contents of the HTTP message headers including cookie data.		 headers-1.adp http://usf-acs.rho.net/tech/headers-1.adp 
cookie.adp:
displays the contents of all the current cookies and provides the ability to set a cookie.		 cookie.adp http://usf-acs.rho.net/tech/cookie.adp 
  cookie-1.adp:
helper page for creating cookies.		 cookie-1.adp   helper page for creating cookies
s-inq.adp: 
lookup in table s using a partial name for matching via LIKE.		 s-inq.adp http://usf-acs.rho.net/tech/s-inq.adp 
  s4-add-del-2.adp:
helper page for lookup, also allows update, delete (using page s3-upd-2.adp), add (using helper page s-add-seq-2.adp) and lookup (using the same page as the helper page). Includes an example of if_no_rows in TCL.		 s4-add-del-2.adp   helper page for lookup
send-mail.adp
entry form for sending e-mail messages		 send-mail.adp http://usf-acs.rho.net/tech/send-mail.adp 
 send-mail-2.adp
helper page that does the actual send mail call		 send-mail-2.adp   helper page for send-mail
csv-load.adp
loads data from a comma separated variable file into an Oracle Table. See the page for detailed instructions.		 csv-load.adp http://usf-acs.rho.net/tech/csv-load.adp 
 csv-2.adp
helper page that does the actual table loads.		 csv-2.adp   helper page for csv-load

Example Specifications

Note that these examples are not complete:

Event Management System Overview, Data Dictionary
Application Definition for a Client Web Project (word), Draft SQL (text file)
E-Business Information System (EBI), Data Model, Service Specification, Scenarios
 
 

© 2001 by Chuck Ehrlich, all rights reserved.  Comments to webmaster.  Updated on February 01, 2001.