The final exam will cover the following topics:

• XML, XSL, DTD
• Given DTD, create XML document that follows the DTD defintion. For example, given the author.dtd, create an xml document for an author follows the author.dtd definition.
• Given a XML template document, derived a DTD file, e.g., on-line bidding records, personal record, or cookie order records.
• Given a simple XML document, format and display it as a table using XSL  similar to grade.xml/grade.xsl example. Given author.xml creates author.xsl that displays the author information similar to that displayed by showdb.php.
• MySQL, DBI
• Familar with the SQL commands for creating tables, inserting entries to the table, and selecting certain entriers.
• Familar with the cookieOrderDB.pl and processOrderDB.pl
• Given an order table, select all order entries fall within certain period or originate from certain customer.
• What is the corresponding SQL command?
• What is your design for allowing access to this information?
• Since the return result can contain multiple entries,  how do you iterate through the return results in a perl script using DBI
• PHP
  • What tags identify the start and end of PHP scripts?
  • Why it is called the language with web page centered design paradigm?
  • How it references the formed valued submitted, say an input tag with password? What function needs to be called before those formed data can be accessed?
  • What are mysql function calls for
    • connecting to mysql database,
    • selecting specific database,
    • submitting the SQL statement,
    • accessing the rows of records returns from the mysql for the SQL execution result?
• Servlet/JSP/JDBC
  • What is JSTL tag?
  • Write a finalizeOrdre.jsp that create a database order record.
  • What are difference between JSP and PHP? Can you have a loop formed between two script in php?
  • On tomcat, how we can specify the database
  • Can we forward the request from a servlet to a JSP, or from JSP to JSP?
  • Can we call a .php script from a .jsp script, and vice versa?

1. CSS
1. What are the new features provided by CSS1?

1. Allow to modify the presentation style of a tag.	Yes No
2. Can change the font size and color.	Yes No
3. Cannot change the margins of a tag's displaying area.	Yes No
4. A web page can reference multiple CSS files directly or indirectly.	Yes No
5. The CSS file can be shared and referenced by a HTML web page using the <LINK> tag.	Yes No
6. Cannot change a subset of tag instance with the same tag name.	Yes No
7. Can change individual instance of a tag.	Yes No

2. Specify the style of a class of tags with name called highlight and use helvetica font, font size=24, and blue color.


2. Javascript
1. Write a javascript function that check the correctness of the zip code. Note that both 80905 (5 digits) and 80933-7150 (9 digits with dash) formats are legal.
   
2. For the timing control,

1. Use setTimeout to call a function after certain time from now expires	Yes No
2. Use setInterval to call a function in a regular time interval.	Yes No
3. The function call "setTimeout(10000, clock)" will execute the clock function call in 10 seconds.	Yes No
4. The statement "win = window.open("http://owl.uccs.edu/~cs301/");" creates a separate browser window and displays a web page whose url = http://owl.uccs.edu/~cs301/	Yes No

3. For generating the web document,

1. Use document_print()	Yes No
2. Use document.write()	Yes No
3. Use print()	Yes No

3. DHTML

The following code implements three buttons for controlling the show, hide, and move to the left by 100 pixels operations of a label.
It can be used with IE5 and NS4.
<script>
ns4 = (document.layers)? true:false
ie = (document.all)? true:false
x = 100;
function hide() {
   if (ns4) document.searchPopup.visibility="hide";
   else searchPopup.style.visibility="hidden";
}
function show() {
   if (ns4) document.searchPopup.visibility="visible";
   else searchPopup.style.visibility="visible";
}
function moveRight() {
   x += 100;
   if (x > 800) x = 0;
   if (ns4) document.searchPopup.left +=x;
   else searchPopup.style.left = x;
}
</script>
<DIV ID="searchPopup" STYLE="POSITION: absolute; Z-INDEX: 20;
VISIBILITY: visible; TOP: 38px; LEFT: 40px; BACKGROUND: lime">
search popup
</DIV>
<form>
<input type=button value="show" onClick="show();">
<input type=button value="hide" onClick="hide();">
<input type=button value="moveleft" onClick="moveRight();">
</form>
Add a button with label moveDown and  a Javascript function moveDown for the operation that moves the label down by 100 pixels and reset after reach 800 pixels.  Enter the moveDown button tag and moveDown javascript function in the following textarea.  The sample code is in http://wetterhorn.uccs.edu/~cs301/test.html.

4. XML, XSL, DTD


Given the following stock profile xml document template, create the DTD.  Assume the order of the tags need to be strickly followed and all attributes are required.   The exchange attribute allows only nyse, nasdaq, and amx.  The dt:dt attribute allows only number, int, and float.  Use the same dt namespace as in hw5 exercise.
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="portfolio.xsl"?>
<portfolio xmlns:dt="urn:schemas-microsoft-com:datatypes" xml:space="preserve">
  <stock exchange="nyse">
    <name>zacx corp</name>
    <symbol>ZCXM</symbol>
    <price dt:dt="number">28.875</price>
    <share dt:dt="number">1000</share>
  </stock>
  <stock exchange="nasdaq">
    <name>zaffymat inc</name>
    <symbol>ZFFX</symbol>
    <price dt:dt="number">92.250</price>
    <share dt:dt="number">1500</share>
  </stock>
  <stock exchange="nasdaq">
    <name>zysmergy inc</name>
    <symbol>ZYSZ</symbol>
    <price dt:dt="number">20.313</price>
    <share dt:dt="number">2000</share>
  </stock>
</portfolio>
Enter the DTD in the following textarea.

Create a portfolio.xsl that display the  profile  similar to grade.xsl in hw5, sorting the stock records according to the descending order of the price value.
Enter the portfolio.xsl  in the following textarea.


5. MySQL and DBI

Specify the SQL command  for creating a new table called "drink" with the following columns: drink_name (varchar type, 30 characters),  SUP_ID (int type, 6 digits), PRICE (float type, 8 digits), INVENTORY (int type, 9 digits), and inserting a new record, where drink_name='sprite', SUP_ID=111, PRICE=0.6, INVENTORY=2000.

Assume the above SQL command is saved as a file, drink.sql. Specify the mysql command that takes drink.sql and create a table in your database at blanca.uccs.edu.

For a perl CGI script, orderDrinkDB.pl similar to orderCookieDB.pl that generates web page to allow  a customer to order drinks,

1. Need to declare CGI to access database.	Yes No
2. Need to declare DBI to read customer's input data.	Yes No
3. The cgi  script should be reference as http://wetterhorn.uccs.edu/~cs301/cgi-bin/cs301/orderDrinkDB.pl for its execution	Yes No