華師網(wǎng)絡(luò)學(xué)院作業(yè)答案-WEB程序設(shè)計(jì)分析題.doc
下面是一個(gè)使用CSS對(duì)文字顯示特性進(jìn)行控制的HTML文件,要求:1,整個(gè)文件采用gb2312字符集;2,h1標(biāo)記采用 宋體;3,span標(biāo)記字體為20pt 紅字。請(qǐng)將相應(yīng)代碼填寫完整。html TitleCSS示例/Title meta http-equiv = "Content-Type" content="text/html;charset=_(1)_" style type = "text/css" h1font-family:"_(2)_" .text_(3)_:20pt;color:_(4)_ /style body h1這是一個(gè)CSS示例。/h1 span class="_(5)_"這段文字應(yīng)該是紅字,字體為20pt。/span /body/html答案: 1,gb2312<br>2,宋體<br>3,font-size<br>4,red<br>5,text<br>下列ASP程序根據(jù)名為MyComponent的組件創(chuàng)建一個(gè)名為MyApp的Application變量,并且檢測客戶端主機(jī)的IP,如果IP為202.113.168.1,則將該變量值置為1。請(qǐng)將程序填寫完整。% Set _(1)_ = Server._(2)_("MyComponent") _(3)_ 禁止其他用戶修改MyApp屬性 If _(4)_ = "202.113.168.1" Then Application("MyApp") = 1 End If _(5)_ 允許其他用戶修改MyApp屬性%答案: 1,Application("MyApp")2,CreateObject3,Request.ServerVariables("remote_addr")4,Application.Lock5,Application.Unlock數(shù)據(jù)庫中存在works_ondept,emp_no、employeeemp_no,sex,name、salaryemp_no,grade,salaries三個(gè)表,它們通過emp_no字段相互關(guān)聯(lián)。請(qǐng)按下列要求寫出相應(yīng)SQL。a,挑出部門(dept)為"IT",姓名(name)姓"張"的所有男職員的name和emp_no信息。(職員性別用sex字段表示,其中M表示男職員,F(xiàn)表示女職員);b,將姓名為"李三"的員工的級(jí)別(grade)調(diào)整為3;c,挑出級(jí)別(grade)為1,薪水(salaries)排名為前三位的職員的emp_no,name,dept信息。答案: 1,SELECT name, b.emp_no FROM works_on a, employee b WHERE a.emp_no = b.emp_no AND a.dept = "IT" AND sex = "M" AND name like "張%"2,UPDATE salary SET grade = 3 WHERE emp_no IN (SELECT emp_no from employee where name = "李三") 3,SELECT a.emp_no, name, dept FROM employee a, works_on b WHERE a.emp_no = b.emp_no AND a.emp_no in (SELECT TOP 3 emp_no from salary where grade = 1 ORDER BY salaries DESC)下面這段ASP程序用于打開MyDB數(shù)據(jù)源,并執(zhí)行名為Upd_Students的存儲(chǔ)過程,請(qǐng)將程序填寫完整。% Set Conn = Server.CreateObject("_(1)_") Set Cmmd = Server.CreateObject("_(2)_") Conn.Open "MyDB" Set Cmmd._(3)_ = Conn Cmmd.CommandType = adCMDText Cmmd.CommandText = "_(4)_" Cmmd._(5)_ 執(zhí)行存儲(chǔ)過程 Conn.Close%答案: 1,ADODB.Connection<br>2,ADODB.Command<br>3,ActiveConnection<br>4,Upd_Students<br>5,Execute<br>在下列JavaScript程序中,單擊p1標(biāo)記分別獲得父節(jié)點(diǎn)和右兄弟節(jié)點(diǎn),并輸出它們的標(biāo)記名,請(qǐng)將程序填寫完整。html TitleDOM示例 /Title script language = "javascript" function GetNodeInfo() var str; str = "父節(jié)點(diǎn)是: " + _(1)_; str += " 右兄弟節(jié)點(diǎn)是: " + _(2)_; p2.innerHTML = str; function GetParentNode() var pnode = _(3)_; return pnode.nodeName; function GetRigtSiblingNode() var rnode = _(4)_; return rnode.nodeName; /script body p id = "p1" _(5)_ = "GetNodeInfo()"點(diǎn)擊這里將獲得p1的父節(jié)點(diǎn)和右兄弟節(jié)點(diǎn),并輸出它們的名字到p2中 /p span id = "p2" /span /body/html答案: 1,GetParentNode()<br>2,GetRigtSiblingNode()<br>3,p1.parentNode<br>4,p1.nextSibling<br>5,onclick<br>寫一個(gè)簡單的HTML頁面,要求:1, 網(wǎng)頁標(biāo)題為:HTML Sample 2, 頁面顯示內(nèi)容為:Hello,HTML 3, 頁面內(nèi)容應(yīng)置中; 4, 建立一個(gè)圖像鏈接,插入當(dāng)前目錄下一幅名為Libray.gif的圖片,鏈接指向地址為http:/www.sohu.com;答案: <html> <Title>HTML Sample</Title> <body> <p align=center>Hello,HTML</p> <a href=http:/www.sohu.com><img alt="搜狐" src = "Library.gif"></a> </body></html>編寫函數(shù),用于過濾一個(gè)數(shù)組arrNum內(nèi)重復(fù)的元素,并用原數(shù)組內(nèi)的非重復(fù)元素重新產(chǎn)生一個(gè)新數(shù)組arrNewNum并輸出其值,輸出結(jié)果應(yīng)為:6 8 5 11script type="text/javascript"var arrNum=1,4,1,1,1,3,3,4,6,7,8,7,5,11,22,22;var arrNewNum = new _(1)_;var bRepeate;for(var i=0;iarrNum.length;i+)_(2)_; for(var j=0;j_(3)_;j+) if(i!=j && arrNumi=arrNumj) bRepeate=true; if(!bRepeate) arrNewNumarrNewNum.length = _(4)_; ;for(var i in arrNewNum) document.write(_(5)_ + " ");/script答案: 1,Array()2,bRepeate = false3,arrNum.length4,arrNumi5,arrNewNumi下面程序利用Cookies來記錄客戶的訪問次數(shù),如果客戶第一次訪問設(shè)置為1,否則在原來的次數(shù)上加1,并將名為Number的Cookie的有效期設(shè)置為2015-12-31。請(qǐng)將相應(yīng)代碼填寫完整。% Response.Buffer=True %htmlbody% Dim varNumbervarNumber=_(1)_("Number") 讀取Cookies值if varNumber="" then varNumber=1 如果是第一次,則令訪問次數(shù)為1Else _(2)_ End IfResponse.Write "您是第" & varNumber & "次訪問本站" _(3)_ 將新的訪問次數(shù)存到Cookies中_(4)_=#_(5)_# 設(shè)置有效期%/body/html答案: 1,Request.Cookies<br>2,varNumber=varNumber+1<br>3,Response.Cookies("Number")=varNumber<br>4,Response.Cookies("Number").Expires<br>5,2015-12-31<br>下面JavaScript函數(shù)用來輸出當(dāng)前時(shí)間,輸出格式為24小時(shí)制,例如09:12:01,并且要求每隔一秒刷新一次時(shí)間。請(qǐng)將相應(yīng)代碼填寫完整。html TitleJavaScript Timer/Title script type="text/javascript" function aClock() var now = _(1)_; var hour = now.getHours(); var min = now.getMinutes(); var sec = now.getSeconds(); var timeStr = " " + hour; timeStr += (min 10) ? ":0" : ":") + min; timeStr += (sec 10) ? ":0" : ":") + sec; document.clock_form.clock_text.value = _(2)_; clockId = _(3)_(aClock(), 1000); /script body onload = "_(4)_" form name = "clock_form" 當(dāng)前時(shí)間是:input type = "text" name = "_(5)_" value = "" / /form /body/html答案: 1,new Date()2,timeStr3,setTimeout4,aClock()5,clock_text下面ASP程序用來處理CreditCard和Shipping表,如果當(dāng)日是星期天(非交易日),則取消事務(wù)操作。假設(shè)數(shù)據(jù)源名字為"CardDB"請(qǐng)將代碼填寫完整。% Set Conn = Server.CreateObject("_(1)_") Conn.Open "CardDB" _(2)_ 開始事務(wù)處理 Conn.Execute "INSERT INTO CreditCard(CreNo) VALUES(8888-12345678)" Conn.Execute "UPDATE Shipping SET SalesCount = SalesCount 1 WHERE ID = 1000001" IF _(3)_(WeekDay(Date) = "Sunday" THEN _(4)_ ELSE _(5)_ 提交事務(wù)操作 END IF Conn.Close%答案: 1,ADODB.Connection2,Conn.BeginTrans3,WeekDayName4,Conn.RollBackTrans5,Conn.CommitTrans下面這段程序,打開本文件夾下的文本文件test.txt,并讀取其中所有的內(nèi)容顯示在頁面上,請(qǐng)?zhí)顚懫渲械目崭瘛?Dim fso Set fso=_(1)_("Scripting.FileSystemObject")Dim TextFile Set TextFile= fso._(2)_(Server._(3)_("test.txt")Do While Not TextFile.AtEndOfStream Response.Write TextFile.ReadLine Response.Write "" _(4)_ 結(jié)束循環(huán)_(5)_ 關(guān)閉文件,并釋放資源%答案: 1,Server.CreateObject<br>2,OpenTextFile<br>3,MapPath<br>4,Loop<br>5,TextFile.close<br>