某公司使用ASP开发商务网站，该商务网站具有商品介绍、会员管理、在线支付、物流管理等功能。该商务网站采用SQL Server数据库，数据库名为business，其中用户表名称为name，其结构如下表所示。
其中Usergrade仅有两个有效值：“m”表示会员，“b”表示非会员。21、该商务网站数据库连接代码如下，请根据题目说明在备选项中选择正确的答案填在对应栏上：＜%set conn= (1) . createobject("adodb.connection")conn. provider="sqloledb"provstr="server=127.0.0.1; database= (2) ; uid=sa; pwd=9857452" (3) . open provstr%＞备选答案：A．applicationB．businessC．connD．provstrE．nameF．server22、该商务网站只对会员用户开放购物车模块，当非会员用户点击购物车模块的首页链接时，系统跳转至会员注册页面；会员用户点击购物车模块的首页链接时，直接进入购物车模块的首页。其中购物车模块的首页为main.asp，用户登录时的判断页面是ChkLogin.asp，会员注册页面为Register.asp。1. ChkLogin.asp的部分代码如下，请在空(4)～(6)处填写正确的代码。＜!--#include file=conn.asp--＞＜%username=replace(trim( (4) ("username")), "'", "")sq1="select * from (5) where Password='"＆password＆"'andUserName='"＆username＆"'"rs.open sq1, conn, 1, 1if (6) (ms.bof and ms.eof)thenif password=rs("Password")thensession("Username")=rs("UserName")session("Usergrade")=ms("Usergrade")%＞2. main.asp的部分代码如下，请为空(7)～(8)选择正确的代码。＜%if (7) ＜＞"m" thenresponse. (8) "Register.asp"end if%＞＜html＞＜/html＞(7)备选答案：A．session("Username")B．session("Usergrade")C．application("Username") D．application("Usergrade")(8)备选答案：A．cookieB．endC．redirect D．write23、该网站举办购物优惠活动，希望用户打开网站首页时弹出提示窗口。首页Index.asp中部分代码如下，请在空(9)～(10)处填写正确的代码。＜html＞＜head＞＜script language="javascript"＞function win() {window. (9) ("yh.html", "newwindow", "height=100, width=400")}＜/script＞＜/head＞＜body (10) ="win()"＞…＜/body＞＜/html＞
正确答案及解析
正确答案
解析
21、(1)F. server(2)B. business (3)C. conn
22、1．(4)request(5)name(6)not2．(7)B．session("Usergrade")(8)C．redirect
23、(9)open(10)onload
21、本题考查电子商务网站开发代码的基本方法。本问题考查Web数据库的连接代码。根据题目说明，该网站采用ASP+SQL Server开发，其数据库名称为business，所以数据库的连接代码为：＜%set conn=server.createobject("adodb.connection")conn.provider="sqloledb"provstr="server=127.0.0.1; database=business; uid=sa; pwd=9857452"conn. open provstr%＞
22、本问题考查ASP编码的基本方法。用户登录时的判断页面是ChkLogin.asp，其作用在于当非会员用户点击购物车模块首页链接时，系统跳转至会员注册页面；会员用户点击购物车模块首页链接时，直接进入购物车模块的首页。另外，用户表名称为name，所以代码如下：＜!--#include file=conn.asp--＞＜%username=replace(trim(request ?("username")), "'", "")sq1="select * from name where Password='"＆password＆"'andUserName='"＆username＆"'"rs.open sq1, conn,1,1if not (rs.bof and rs.eof) thenif password=rs("Password")thensession("Username")=rs("UserName")session(”Usergrade”)=ms(”Usergrade”)%＞配合ChkLogin.asp页面，购物车模块的首页main.asp需要对session("Usergrade")进行判断，其程序代码如下：＜%if session("Usergrade") ＜＞"m" thenresponse. redirect "Register.asp"end it%＞＜html＞＜/html＞
23、本问题考查JSP脚本的基本知识。根据题目要求，用户打开网站首页时，弹出相应的提示窗口，所以对应的JSP脚本为：＜html＞＜head＞＜script language="javascript"＞function win() {window. open ("yh.html", "newwindow", "height=100, width=400")}＜/script＞＜/head＞＜body onload="win()"＞…＜/body＞＜/html＞
包含此试题的试卷
你可能感兴趣的试题
Advancements in （ ）have contributed to the growth of the automotive industry through the creation and evolution of self-driving vehicles.
-
- A.Artificial Intelligence
- B.Cloud Computing
- C.Internet of Things
- D.Big Data
- 查看答案
In project human resource management , （ ）is not a source of power for the project manager.
-
- A.referent power
- B.expert power
- C.reward power
- D.audit power
- 查看答案
At the project establishment stage , the feasibility study mainly includes techinical feasibility analysis , （ ）, operation environment feasibility analysis and other aspects of feasibility analysis.
-
- A.detail feasibility analysis
- B.opportunity analysis
- C.economic feasibility analysis
- D.risk analysis
- 查看答案
（ ）is a grid that shows the project resources assigned to each work package.
-
- A.Stakeholder engagement assessment matrix
- B.Requirements traceability matrix
- C.Probability and impact matrix
- D.Responsibility assignment matrix
- 查看答案
Xinhua News Agency reported in January 2022，Chian will further promote the developmet of a digital economy during the 14th Five-Year Plan eriod（2021-2025）. The plan also emphasized industrial （ ）transformation.
-
- A.digital
- B.networking
- C.intelligentize
- D.informatization
- 查看答案