问题 问答题


阅读下列网站建设的技术说明,结合网页显示的效果图,根据要求回答问题1~问题5。
【说明】
以下是用ASP实现了一个网络收藏夹网页,用于保存用户感兴趣的Web网页地址。用IE打开网页文件“index.asp”后的效果如图4-14所示。程序中使用的Access数据表结构见表4-8。


表4-8 Access数据表结构表

字段名类 型备 注
no自动编号序号
name文本主页名称
url文本超链接
category文本网站类别
【index.asp文档的内容】
<% @language="VBscript" %>
<%
set conn=server. (1) ("Adodb.Cormection")
provider="Provider=Microsoft.Jet.OLEDB.4.0;"
path="Data Source="& Server.MapPath("main.mdb")
connstR=provider & path
conn.open connstr
%>
<html>
<head><title>网络收藏夹</title></head>
(2)
<center>
<%
set rs=Server.CreateObject("Adodb.RecordSet")
sql="select * from address"
rs.open() sql,conn,1,3
if Request("name")="" or Request("url")="" then
Response.write("内容填写不完整")
else
rs.addnew
rs(1)=request("name")
rs(2)=request("URL")
rs(3)=request("category")
rs.update
end If
%>
<table width="500" border=-"1" cellpadding="0" cellspacing="0" bordercolor="#00FCFF">
<tr><td>序 号</td><td>名 称</td><td>类 别</td></tr>
<% rs.movefirst
for j=1 to ts. (3) %>
<tr>
<td><%=j%></td>
<td><a href="<%=rs("url")%>" target="blank"><%=rs("name")%></a></td>
<td><%=rs("category")%></td>
</tr>
<% rs.movenext
(4) %>
</table><br>
<form method="post" name="new" id="new" action="index.asp">
<table width="300" border="1" cellpadding="0" cellspacing="0" bordercolor="#FF00CC">
<tr>
<td width="61">名 称:</td>
<td width="223" align="left"><input name="name" type="text" id="name">*</td>
</tr>
<tr>
<td>超链接:</td>
<td align="left"><input name="URL" type="text" id="URL">*</td>
</tr>
<tr>
<td colspan="2">类别:</td>
</tr>
<tr>
<td colspan="2"><textarea name="category" rows="5" id="disc"></textarea></td>
</tr>
<td colspan="2">*为必填项目</td>
</table><br>
(5)
</form>
<%
rs.close
conn.close
%>
</center>
</body>
</html>

【问题3】
网页中使用的数据库连接引擎是什么连接的后台数据库文件名是什么

答案

参考答案:

解析:数据库连接引擎是:Microsofi.Jet.OLEDB.4.0 连接的后台数据库文件名:main.mdb由题干的index.asp文档中可以找到与数据库连接方面相关的ASP代码如下。 set conn=server. (1) ("Adodb.Connection") provider="Provider=Microsoft.Jet.OLEDB.4.0;" path="Data Source="& Server.MapPath("main.mdb") connstr=provider & path conn.open connstr 在使用conn.open命令与数据库连接时"provider="Provider=Microsoft.Jet.OLEDB.4.0;""语句可知,网页中使用的数据库连接引擎是就是PROVIDER的参数值,即Microsoft.jet.OLEDB.4.0。 由语句path="Data Source--" & Server.MapPath("main.mdb")可知,连接的后台数据库文件是Microsoft的Access数据库main.mdb。

填空题
阅读理解

A trip to Key West

As we cross the bridge to Key West, we can see many boats.___小题1:____ Others belongs to people who have sailed their boats here from many different places.

In the city, the houses are almost all painted white.A few are pink or light blue.Many houses are very old and very small.Key West is a very old city._______小题2:_______.

Many palm trees (棕榈树) grow here. Colorful flowers grow in front of many of the little houses. You can stay in a room in one of these houses for the night.You can smell the ocean on the soft warm wind that blows across the island.

We drive past several streets and then come to Whitehead Street. There is a monument there. The signs says this is the southernmost part of the United States.The sign says “ America Begins Here.” __小题3:____ It is the second largest ocean.

After taking a few photographs of the sign, we turn the car around and follow Whitehead Street to number 1907.____小题4:_____  For a few dollars, you can see the inside of the house.Hemingway had many cats when he lived here.He is gone, but the cats remain.Many are asleep on the beds or chairs.They are used to seeing people walking through the old house.

_____小题5:____ There is a private museum here we want to visit.It is the Mel Fisher Maritime Heritage Society Museum.The museum is named after treasure hunter Mel Fisher, who discovered an old sunken Spanish treasure ship near Key West more than twenty years ago.

A.Finally, we go back home.

B.Beyond the sign is the Atlantic Ocean.

C.Some are fishing boats you can use for the day.

D.After that, we travel a little way to Green Street.E.Many of the buildings are more than 100 years old.

F.It is made of modern materials, i.e.steel and concrete.

G.This house belonged to the famous American writer Ernest Hemingway.