Information Systems

College of Business Administration
University of Missouri - St. Louis

A Sample DSS

Third Database Example: Delete Example


<?xml version="1.0" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/1999/PR-xhtml1-19991210/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

This specifies the version of xhtml to be used.

<HTML>
<HEAD>

<Title>A Sample Database Use</title>
</HEAD>

<BODY TEXT="#000000" link="000000" VLINK="#000000" BACKGROUND="background.jpg">
<FONT FACE="ARIAL">

<CENTER><TABLE WIDTH="79%" >

<TR>
<TD> <CENTER><H4><FONT FACE="Arial"><FONT COLOR="#C100C1"><FONT SIZE=+2>A Sample Database Use</FONT></FONT></FONT>
</TD>
</TR>
</TABLE></CENTER>

<h5><font face="arial"><p> <center><FONT SIZE=+1>Third Database Example: Delete Example</center></FONT><p>

<form method="post" action="http://www.umsl.edu/servlet/FormServlet">

Declares the intent to use the form servlet.

<input type="hidden" name="USER" value="sauter">

Specifies the name of the user. The "name" will tell it on whose directory to look for the sql instructions
(it already knows to look in the database_sql directory for the file from your data packet).
The field name that it passes to form servlet is "USER" and the value tells it your web account.

<input type="hidden" name="SQLFile" value="class_select_delete.sql">

Specifies the SQL statement to be used.
This example requests the use of the "class_select_delete" statement to find records.

<input type="hidden" name="URLhead"
value="/accounts/faculty/sauter/public_html/help/database/mydelete.head">

This names the file that has all HTML code for the output of the "delete" defining the top of the page to the beginning of the first data record. This should include the heading, color definitions, explanatory material, etc.
This MUST be stated as a path.

<input type="hidden" name="URLbody"
value="/accounts/faculty/sauter/public_html/help/database/mydelete.body">

This specifies the file that defines the format of the data as it appears in the table. This too must be stated as a path.

<input type="hidden" name="URLfoot"
value="/accounts/faculty/sauter/public_html/help/database/mydelete.foot">

This specifies the file that defines the format of the page on which the selected item is printed.
It includes the end of the table and any documentation or other material that appears below the table.
This file must also be specified as a path.

<table border="2" cellpadding=10>

<caption><h3><font face="arial">Select Exam Results</caption>

This specifies the table that will receive the input for the query.
It has all the characteristics of a normal table definition.

<tbody>

This defines the beginning of the query table.

<tr>
<td><h4><font face="arial">Student Id</td> <td>
<input type="text" size="20" name="Student_Id" value="=Student_Id"></td>
</tr>

This specifies the format for the first field.

<tr>
<td><h4><font face="arial">Student Name</td> <td>
<input type="text" size="20" name="Name" maxlength="45"></td>
</tr>

This specifies the format for the second field.

<tr>
<td><h4><font face="arial">Exam Score</td> <td>
<input type="text" size="20" name="Score" value="=Score"></td>
</tr>

This specifies the format for the third field.

</tbody>
</table>

<br><p> <input type="submit" value="Select"></form>

</center>

This specifies the end of the query table.

<p><p><p><P><hr><p>

<h4><strong><img src="/~sauter/DSS/javascript_examples/button2.jpg" width = 20>
<a href="/~sauter/help/Links_databases.html">Return to Index</a>

<p><br><p>

<h6><i>Page Owner:</i> <a href="http://www.umsl.edu/~sauter/">Professor Sauter</a>
(<a href="mailto:Vicki.Sauter@umsl.edu">Vicki.Sauter@umsl.edu</a>)<br>

<SCRIPT LANGUAGE = "JavaScript"> // This automatically updates the last modified date for the page. // when = document.lastModified
document.write("<i>This page was last modified on:</i> " + when + "<br>")
//
// This automatically updates the location documentation on the page.
where = document.location
document.write("<i>URL:</i> " + where)
</script>

<br>
© Vicki L. Sauter. All rights Reserved.
</html>


| UM-St. Louis Home Page | College of Business Page | IS Home Page |



Page Owner: Professor Sauter (Vicki.Sauter@umsl.edu)
Vicki L. Sauter. All rights reserved.