CS401 S99 Final Exam will be turned on
10:50am, May 13 for Bryce. Email me your answer. The rest of the class
will be taken exam at ENS109.
There will be 4 main questions
asked. Your grade will be based on the best three answers.
NT IIS configuration and ASP-DB.
What is the difference between
the "Domain" in Microsoft Windows systems and the "Domain" in Internet?
How one decides the selection
of NTFS or FAT file system?
What services are provided in
IIS 2.0?
What is Dynamic Host Control
Protocol and why we are not choosing it when we set up IIS?
What are the steps involved
in setting up IP-based virtual hosting?
What is a virtual directory?
Can it be used with FTP service? Can it refer to a directory in a remote
machine other than that where the IIS resides? Is there an equivalent support
in a Linux/Apache system?
In Apache, we use deny and allow
directives to restrict access to the web server directory? Do we have an
equivalent access control on IIS?
What is default web page file
name in IIS www server after configuration? How do you change that?
What is ASP? What are script
languages supported?
In NT or Windows systems, what
is the default database access interface provided to the server-side scripts
and database applications?
With Microsoft Access Database,
we first specify the names and types for the fields of the table,
then specify the table name and database name, finally we enter the data
to the table.
We specify the association of
a System Data Source Name (such as cs401signup) with the Access database
(cs401signup.mdb) using the ODBC applet in the Control Panel. The
System Data Source Name is used in the VBScript?
In Active Server Page, <%
%> tag is used to specify the script and substituting data.
Request.From("attr") is used
to retrieve the value of the name-value pair submitted by the browser,
here attr identifies the name part of the name-value pair.
For accessing ODBC database
from a VBScript, you need to create a Database Connection object using
Set Conn = Server.CreateObject("ADODB.Connection") and create a record
set object to hold the SQL query results using Set rs
= Server.CreateObject("ADODB.RecordSet").
The database is open using Conn.Open
“cs401signup" Here "cs401signup" is the System Data Source
Name for the database.
The SQL query is performed using
RS.open sql,conn,1,1 where sql is the string of a SQL
statement. For example, sql="select * from cs401signup
where LastName='" & key &"'"
<% = rs("ProductName") %>
is used to specify the data from the query result to be substituted in
the return web page.
XML/XSL
XML is a meta language
for specifying the tag set and constraints on ordering of the tags in a
mark up language.
XSL is used to transform and
format the XML document.
XSL is also an XML document.
A tag with /> as concluding
symbol is called an empty element which does not require an ending
tag.
The tag starting with <?
is called processing instruction.
<?xml-stylesheet href="grade.xsl"
?> is used to specify the XSL document for processing the current XML document.
<! [CDATA[
...
]]>
are used to specify transparent text that should bypass the XML processor
without being test for conforming the tag set rules.
Concentrate on the grade example.
XSL takes a source tree structure
document specified in a XML document and transforms into a target tree
structure, such as HTML document.
XSL uses <xsl:template match="pattern">
to identify the location within a source structure.
XSL use <xsl:value-of
select="tagname"/> to retrieve the value wrapped by <tagname>... </tagname>.
<xsl:if expr="even(this)">
...</xsl:fi> can be used for conditional processing, here even(this)
is a boolean function.
<xsl:for-each select="HW">
...</xsl:for-each> is used to iterate through the subtrees of the source
tree specified by <HW>...</HW>.
order-by attribute can be used
to specify the order we iterate through a list of matched subtrees, e.g.,
<xsl:for-each select="GRADES/STUDENTS/STUDENT" order-by=“-FINAL">