Sample ASP - Sample ASP Application - Part 1 Motes Notes...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Sample ASP Application - Part 1 Mote’s Notes 3/28/2011 Overview HTML files allow you to create static web pages. A typical HTML file is made up of two components: your basic content (e.g., words, pictures, sound clips, video) and markup tags to tell the browser how to display your content (e.g., fonts, spacing, alignment, color schemes). ASP files (aka, script files) allow you to use back-end databases to dynamically generate web pages. The ASP application shown in this document consists of two tables in a back-end database (employees and their paychecks), a set of photographs and two ASP script files. This small three-tier application will use four different computers: McCombs' SQL Server database (MISSQL) UT's Unix web server (www.utexas.edu) McCombs' ASP script processor (Classweb2) User's browser The first of the two ASP script files (Page1.asp) does the following: 1. Establishes a connection to the back-end SQL Server database 2. Requests an alphabetized list of current employees from the database 3. Dynamically generates a drop-down list on the web page 4. Includes a submit button on the web page (to move to the second page) 5. Releases the connection to the back-end database 6. Passes the first web page to the browser The second ASP script file (Page2.asp) does the following: 1. Establishes a connection to the back-end database 2. Determines which employee was selected by the user from the drop-down list on the first page 3. Requests the employee record from the database for the chosen employee 4. Dynamically puts the employee's name, address, phone and photograph on the web page 5. Requests the sorted paycheck records from the database for the chosen employee 6. Dynamically generates a "table" (i.e., grid) of paycheck information on the web page 7. Puts a return button on the web page (to move back to the first page) 8. Releases the connection to the back-end database 9. Passes the second web page to the browser While this isn't a very complex application, it should serve as an adequate demonstration of the classic three-tier model: back-end (database and photos), middle-tier (ASP) and client-side (browser). Our applications will get more elegant as the semester progresses, but the three-tier structure will remain the same as this elementary example.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Page1.asp Page2.asp Sorted drop-down list from tblEmployee Button to Page2.asp Name, address and phone from tblEmployee
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/26/2011 for the course MIS 325 taught by Professor Mote during the Spring '08 term at University of Texas at Austin.

Page1 / 7

Sample ASP - Sample ASP Application - Part 1 Motes Notes...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online