Information Systems

College of Business Administration
University of Missouri - St. Louis

A Sample DSS

First Database Example: Select 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="graphics/background.jpg">
<FONT FACE="ARIAL">

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

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

<h4><font face="arial"><p>
<center><FONT SIZE=+1>First Database Example: Select 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.sql" />

Specifies the name of the file that holds the SQL statements.
This example requests the use of the "class_select" statement to find records.

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

This names the file that has all HTML code 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/myselect.body"/>

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

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

This specifies the file that defines the format of the page after the data are 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 >
<caption><h4><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.

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

</tbody>

</table>

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

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.