|
[×ÊÔ´]
¡¾ÊÔÌâ×ÊÔ´¡¿aspÄ£ÄâÊÔ¾í
aspÄ£ÄâÊÔ¾í
ÍøÂç³ÌÐòÉè¼Æ¡ªASPÄ£ÄâÊÔ¾í£¨Ò»£©
¿¼ÊÔÈÕÆÚ£º
¿¼ÊÔʱ¼ä£º
¿¼ÉúÐÅÏ¢£º
ϵ ±ð___________ѧ ºÅ_____________ÐÕ Ãû_____________±ÊÊԳɼ¨_____________
Ò»¡¢Ñ¡ÔñÌ⣨ÿСÌâ2·Ö£¬¹²40·Ö£©
1£®ÇëÅжÏÏÂÁÐÓï¾äÖ´ÐÐÍê±Ïºó£¬a¡¢b¡¢cµÄÖµ
<%
a="1" + 1
b="1" + "1"
c="1" & "1"
%>
(A) "11","11","11" (B) 2,"11","11" (C) "11",2,"11" (D) "11","11",2
2£®Ö´ÐÐÍêÓï¾äa="2"£¬aµÄÀàÐÍΪ
(A) ÊýÖµÐÍ (B) ×Ö·û´®ÐÍ (C) ²¼¶ûÐÍ (D) ÈÕÆÚÐÍ
3£®Ö´ÐÐÍêÈçÏÂÓï¾äºó£¬aµÄֵΪ£º
<%
Dim a
a=3
a=a+1
%>
(A) 0 (B) 1 (C) 3 (D) 4
4£®Ö´ÐÐÍêÈçÏÂÓï¾äºó£¬SumµÄֵΪ£º
<%
Dim a(5),Sum
Sum=0
For I=0 To 5
a(I)=I
Sum=Sum+a(I)
Next
%>
(A) 0 (B) 5 (C) 15 (D) 20
5£®Ö´ÐÐÍê a=5 Mod 3 Óï¾äºó£¬aµÄֵΪ£º
(A) 0 (B) 2 (C) 3 (D) 5
6£®Ö´ÐÐÍê a=5>3 And "a"<"c" Óï¾äºó£¬aµÄֵΪ£º
(A) True (B) False (C) 1 (D) 0
7£®ÏÂÃæ a=Trim(" vbscript") & Rtrim(" good") Óï¾äºó£¬aµÄÖµ£º
(A) " vbscript good"
(B) "vbscript good"
(C) " vbscriptgood"
(D) "vbscriptgood"
8£®ÏÂÃæÄĸöº¯Êý¿ÉÒÔ·µ»Øµ±Ç°µÄÈÕÆÚºÍʱ¼ä£º
(A) Now (B) Date (C) Time (D) DateTime
9£®¶ÔÓÚÀûÓà Dim a(4,5) Óï¾ä¶¨ÒåµÄ¶þάÊý×飬Ubound(a,1)½«·µ»Ø
(A) 0 (B) 4 (C) 5 (D) 6
10£®¶ÔÓÚRequest¶ÔÏó£¬Èç¹ûÊ¡ÂÔ»ñÈ¡·½·¨£¬ÈçRequest(¡°user_name¡±)£¬½«°´Ê²Ã´Ë³ÐòÒÀ´Î¼ì²éÊÇ·ñÓÐÐÅÏ¢´«È룺
£¨A£©Form¡¢QueryString¡¢Cookies¡¢Server Variables¡¢ClientCertificate
£¨B£©QueryString¡¢Form¡¢Cookies¡¢Server Variables¡¢ClientCertificate
£¨C£©Cookies¡¢QueryString¡¢Form¡¢Server Variables¡¢ClientCertificate
£¨D£©Form¡¢QueryString¡¢Cookies¡¢Server Variables¡¢ClientCertificate
11£®ÏÂÃæÄÄÌõÓï¾ä¿ÉÒÔ·µ»Ø·ÃÎÊÕßµÄIPµØÖ·
(A) Request.ServerVariables("REMOTE_ADDR")
(B) Request.ServerVariables("REMOTE_IP")
(C) Request.ClientCertificate("REMOTE_ADDR ")
(D) Request.ClientCertificate ("REMOTE_IP ")
12£®Ö´ÐÐÍêÈçÏÂÓï¾äºó£¬Ò³ÃæÉÏÏÔʾµÄÄÚÈÝΪ£º
<%
Response.Write "A"
Response.End
Response.Write "B"
%>
C
(A) A (B) AB (C) AC (D) ABC
13£®ÇëÎÊÏÂÃæ³ÌÐò¶ÎÖ´ÐÐÍê±Ï£¬Ò³ÃæÉÏÏÔʾÄÚÈÝÊÇʲô£º
<%
Response.Write ¡°ÐÂÀË¡±
%>
(A) ÐÂÀË (B) ÐÂÀË
(C) ÐÂÀË£¨³¬Á´½Ó£© (D) ¸Ã¾äÓÐ´í£¬ÎÞ·¨Õý³£Êä³ö
14£®Session¶ÔÏóµÄĬÈÏÓÐЧÆÚΪ¶àÉÙ·ÖÖÓ£¿
(A) 10 (B) 15 (C) 20 (D) Ó¦ÓóÌÐò´ÓÆô¶¯µ½½áÊø
15£®ÇëÎÊÏÂÃæ³ÌÐò¶ÎÖ´ÐÐÍê±Ï£¬Ò³ÃæÉÏÏÔʾÄÚÈÝÊÇʲô£º
<%
Response.Write Server.HTMLEncode(¡°ÐÂÀË¡±)
%>
(A) ÐÂÀË (B) ÐÂÀË
(C) ÐÂÀË£¨³¬Á´½Ó£© (D) ¸Ã¾äÓÐ´í£¬ÎÞ·¨Õý³£Êä³ö
16£®µ±Ê¹ÓÃÊÂÎñ´¦Àíʱ£¬¼ÙÈçÒªÌá½»ÊÂÎñ´¦Àí£¬Ó¦¸ÃÀûÓÃÈçÏ·½·¨£º
(A) BeginTrans (B) EndTrans
(C) CommitTrans (D) RollBackTrans
17£®Èç¹û¸Õ´ò¿ªÁËÒ»¸öº¬ÓÐ1Ìõ¼Ç¼µÄ¼Ç¼¼¯£¬ÄÇô BofµÄֵΪ
(A) 1 (B) True (C) False (D) NULL
18£®Ê¹ÓÃW3 Jmail×é¼þ·¢ËÍE-mailʱ£¬¸½¼þ±ØÐëλÓÚ
(A) ¿Í»§¶Ë (B) ·þÎñÆ÷¶Ë
(C) ·þÎñÆ÷¶ËºÍ¿Í»§¶Ë (D) ·þÎñÆ÷¶Ë»ò¿Í»§¶Ë
19£®¶ÔÓÚÎļþÉÏ´«×é¼þ£¬Èç¹ûÏ£Íû»ñÈ¡ÉÏ´«ÎļþµÄ´óС£¬Ó¦¸ÃÔõÑùÓã¿
(A) Upload.Files("upfile").Size
(B) Upload.Form("upfile").Size
(C) Request.Files("upfile").Size
(D) Request.Form("upfile").Size
20£®¶ÔÓÚÈçϵÄÎļþ³¬Á´½Ó×é¼þÖÐʹÓõij¬Á´½ÓÊý¾ÝÎļþ£¬Îļþ·¾¶ºÍ˵Ã÷Ö®¼äÓ¦¸ÃÓ㨠£©¸ô¿ª¡£
webcourse/www_1.htm µÚÒ»½²ÀûÓù¤¾ßÈí¼þÖÆ×÷ÍøÒ³
webcourse/www_2.htm µÚ¶þ½²ÍøÒ³ÖÆ×÷¸ß¼¶¹¦ÄÜ
webcourse/www_3.htm µÚÈý½²ÀûÓÃÔ´´úÂ뿪·¢ÍøÒ³
(A) ¿Õ¸ñ (B) Tab (C) (D) Space
¶þ¡¢Ìî¿ÕÌ⣨ÿ¿Õ1·Ö£¬¹²40·Ö£©
1. ASPÎļþ¾ÍÊÇÔÚÆÕͨµÄHTMLÎļþÖвåÈë »òJavaScript½Å±¾ÓïÑÔ¡£
2. Èç¹û²Ù×÷ϵͳÊÇWindows 2000£¬Ò»°ãÐèÒª°²×° ×é¼þ²ÅÄÜÔËÐÐASP³ÌÐò¡£
3. Ö´ÐÐÍê a= Left("vbscript",2) & Mid("vbscript",3,4) & Right("vbscript",2) ºó£¬aµÄֵΪ ¡£
4. Óï¾ä a=DateAdd(" ",10,Date()) ½«·µ»Ø10ÌìºóÊǼ¸ºÅ¡£
5. Óï¾ä b=Int(10 * ) +1) ½«·µ»Ø1µ½10Ö®¼äµÄËæ»úÕûÊý¡£
6. ÔÚÎļþ¿ªÍ·Ìí¼Ó Óï¾äºó£¬ÔòËùÓеıäÁ¿¶¼±ØÐëÏÈÉùÃ÷²ÅÄÜʹÓá£
7. ÔÚÊý¾Ý¿âµÄ±íÖУ¬×ݵÄÒ»ÐнÐ×öÒ»¸ö £¬ºáµÄÒ»ÐнÐ×öÒ»¸ö ¡£
8. ÔÀ´ÓÃÒ»¸öÊý×éusers±£´æѧÉúÃûµ¥£¬ÏÖÔÚÐÂתÀ´Ò»Î»Í¬Ñ§¡°Õŷ塱£¬ÐèÒª½«ÆäÃû×ÖÌí¼Óµ½¸ÃÊý×éÖУ¬ÇëÌîдÏÂÃæ³ÌÐò¶ÎÖеĿոñ¡£
<%
Dim users()
Redim users(40)
users(0)="Íõ¾ü"
users(1)="Àî¿¡"
¡¡
Redim users(41)
users(41)="ÕÅ·å"
%>
9. ÏÂÃæÊÇÒ»¸öº¯Êý£¬ÓÃÀ´·µ»Ø´Óaµ½bµÄÁ¢·½ºÍ£¬ÇëÌîдÆäÖеĿոñ¡£
<%
Function Cube(a,b)
Dim I,Sum
Sum=
For I= a To b
Sum=
Next
=Sum
End Function
%>
10. ÏÂÃæÕâ¶ÎÓï¾ä£¬½«¸ù¾Ý½ñÌìÊÇÐÇÆÚ¼¸£¬·Ö±ðÔÚÒ³ÃæÉÏÏÔʾһ·ùͼƬ£¬ÐÇÆÚÒ»¡¢¶þÏÔʾp1.jpg£¬ÆäËüʱ¼äÏÔʾp2.jpg¡£ÇëÌîдÍêÕûÏÂÃæµÄ³ÌÐò¡£
<%
Dim theday
theday= (Date())
Select Case theday
Case
""
Case Else
""
End Select
%>
11. ºÜ¶àÍøÕ¾ÒªÇó¿Í»§±ØÐëµÇ¼ºó²ÅÄÜ·ÃÎÊ£¬Èç¹û¿Í»§Ã»ÓеǼ£¬¾ÍÖ±½Ó·ÃÎÊÍøÕ¾µÄij¸öÒ³Ã棬Ӧ¸Ã½«ÆäÒýµ¼µ½Ê×Ò³¡£Çë¾Ý´ËÌîдÏÂÃæµÄ¿Õ¸ñ¡£
<%
If Session("UserName")= Then
"index.asp"
End If
%>
12. ÏÂÃæµÄ³ÌÐò¶ÎÓÃÀ´¼ÆËã¿Í»§Êǵڼ¸´Î·ÃÎʱ¾Õ¾¡£ÇëÌîдÆäÖеĿոñ¡£
<%
Dim varNumber
varNumber=Request.Cookies("number")
If Then
varNumber=1
Else
varNumber=varNumber+1
End If
. =varNumber
. =#2030-1-1#
Response.Write "ÄúÊǵÚ" & varNumber & "´Î·ÃÎʱ¾Õ¾"
%>
13. ¼ÙÈçApplication("UserOnLine")Öб£´æÁËÒ»¸öÊý×飬¸ÃÊý×éÖб£´æÁËÔÚÏßÓû§µÄÃû³Æ£¬ÏÂÃæµÄ³ÌÐò¶Î´ÓÆäÖжÁÈ¡ËùÓÐÓû§Ãû£¬²¢ÏÔʾÔÚÒ³ÃæÉÏ£¬ÇëÌîдÆäÖеĿոñ¡£
<%
Dim UserOnLine,Number
UserOnLine=Application("UserOnLine")
Number= (UserOnLine) '·µ»Ø¸ÃÊý×éµÄ×î´óϱê
For I=0 To Number
Response.Write
Next
%>
14. ¶ÔÓÚÈçÏÂͼµÄÊý¾Ý±ílink£¬ÇëÌîдÏÂÃæµÄSQLÓï¾äÖеĿոñ£º
ͼ1
²éѯ2003Äê1ÔÂ1ÈÕµ½2004Äê1ÔÂ1ÈÕÖ®¼äµÄÌá½»µÄÍøÕ¾£¬²¢°´Ìá½»ÈÕÆÚ½«ÐòÅÅÁÐ
strSql="Select * From link Where submit_date #2003-1-1# And #2004-1-1# Order By submit_date "
²éѯ2004Äê1ÔÂ1ÈÕÒÔºóÌá½»µÄÍøÕ¾×ÜÊýÄ¿
strSql="Select As Total From link Where submit_date > #2004-1-1#"
15. Õë¶ÔÉÏÃæͼ1Ëùʾ£¬ÏÂÃæÒªÔÚÒ³ÃæÉÏ°´Ìá½»ÈÕÆÚ½µÐòÅÅÁÐËùÓеÄÍøÕ¾£¬ÇëÌîдÏÂÃæ³ÌÐò¶ÎÖеĿոñ¡£¼ÙÉèÊý¾Ý¿âÎļþwwwlink.mdbºÍ±¾Îļþ´æ·ÅÔÚͬһ¸öÎļþ¼ÐÏ£¬Êý¾Ý±íÃûΪlink¡£
ÍøÕ¾Ãû³Æ | ÍøÕ¾µØÖ· | Ìá½»ÈÕÆÚ |
<%
'ÒÔÏÂÁ¬½ÓÊý¾Ý¿â
Dim db
Set db=Server.CreateObject("ADODB.Connection")
db.Open
'ÒÔϽ¨Á¢¼Ç¼¼¯
Dim strSql,rs
strSql=
set rs=db.execute(strsql)
'ÒÔÏÂÏÔʾÊý¾Ý¿â¼Ç¼
Do While
%>
<%=rs("name")%> |
<%=rs("URL")%> |
<%=rs("submit_date")%> |
<%
Loop
%>
16. Õë¶ÔÉÏÃæͼ1Ëùʾ£¬ÏÂÃæÊÇ·ÖÒ³ÏÔʾËùÓÐÍøÕ¾µÄÃû³ÆµÄÓï¾ä£¬Ã¿Ò³ÏÔʾ10Ìõ¼Ç¼£¬ÇëÌîдÆäÖеĿոñ¡£
<%
Dim db,rs,strSql
'½¨Á¢Connection¶ÔÏó
Set db=Server.CreateObject("ADODB.Connection")
db.Open "Dsn=addr" 'ÕâÀïÀûÓÃÊý¾ÝÔ´Á¬½Ó
'½¨Á¢Recordset¶ÔÏó
Set rs=Server.CreateObject("ADODB.Recordset")
strSql ="Select * From users order by name Asc"
rs.Open
'Èç¹û¼Ç¼¼¯²»Êǿյģ¬¾ÍÖ´ÐзÖÒ³ÏÔʾ
If Then
'ÏÂÃæÒ»¶ÎÅжϵ±Ç°ÏÔʾµÚ¼¸Ò³£¬ÈçÊǵÚÒ»´Î´ò¿ª£¬Îª1£¬·ñÔòÓÉ´«»Ø²ÎÊý¾ö¶¨
Dim page_no
If Request.QueryString("page_no")="" Then
page_no=1
Else
page_no= (Request.QueryString ("page_no"))
End If
'ÏÂÃæÒ»¶Î¿ªÊ¼·ÖÒ³ÏÔʾ£¬Ö¸ÏòÒªÏÔʾµÄÒ³£¬È»ºóÖðÌõÏÔʾµ±Ç°Ò³µÄËùÓмǼ¡£
rs. =10
rs. =page_no
Dim I
I=10
Do While And
I=I-1
Response.Write rs("name") & " "
rs.MoveNext
Loop
'ÏÂÃæÒ»¶ÎÔÚÏ·½ÏÔʾҳÊýÐÅÏ¢£¬´Ó1µ½×ÜÒ³ÊýÑ»·
......
Else
Response.Write "¸Ã¼Ç¼¼¯Îª¿Õ"
End If
%>
17. ÏÂÃæÕâ¶Î³ÌÐò£¬´ò¿ª±¾Îļþ¼ÐϵÄÎı¾Îļþtest.txt£¬²¢¶ÁÈ¡ÆäÖÐËùÓеÄÄÚÈÝÏÔʾÔÚÒ³ÃæÉÏ£¬ÇëÌîдÆäÖеĿոñ¡£
<%
Dim fso
Set fso=Server.CreateObject("Scripting.FileSystemObject")
Dim TextFile
Set TextFile= fso. (Server.MapPath("test.txt")
Do While Not TextFile.
Response.Write TextFile.ReadLine
Response.Write " "
Loop
%>
Èý¡¢±à³ÌÌ⣨ÿ¿Õ10·Ö£¬¹²30·Ö£©
1£®Çë±àд´úÂ룬ÔÚÒ³ÃæÉÏÏÔʾÈçÏÂͼÐΡ£×¢Ò⣺ֻҪд³öÖ÷Òª´úÂë¼´¿É
**********
*********
********
*******
******
*****
****
***
**
*
2£®ÀûÓÃRecodset¶ÔÏóÒ²¿ÉÒÔ²åÈë¼Ç¼£¬ÏÖÔÚÕë¶Ôͼ1ËùʾµÄÊý¾Ý±í£¬ÀûÓòåÈëÒ»Ìõ¼Ç¼£ºÆäÖÐÍøÕ¾Ãû³ÆΪ¡°ËѺü¡±£¬ÍøÕ¾µØַΪ¡°www.sohu.com¡±£¬ÍøÕ¾¼ò½éΪ¡°ÃÅ»§ÍøÕ¾¡±£¬Ìá½»ÈÕÆÚΪµ±Ìì¡£
×¢Ò⣺ֻ¸ø³öÖ÷Òª´úÂë¼´¿É£¬³ÌÐòµÄ¿ªÍ·²¿·ÖÒѾ¸ø³ö¡£
<%
Dim db, strConn
strConn="Dbq=" & Server.Mappath("address.mdb") & ";Driver={Microsoft Access Driver (*.mdb)}"
Set db=Server.CreateObject("ADODB.Connection")
3£®Õë¶Ôͼ1£¬ÏÖÔÚÓÐÁ½¸öÎļþadd_form.aspºÍadd.asp£¬ÕâÁ½¸öÎļþÓÃÀ´Ïò±íÖÐÌí¼Ó¼Ç¼£¬add_form.aspÒѾ¸ø³ö£¬ÇëÄãÍê³Éadd.asp¡£ÒªÇ󣺣¨1£©Ö»ÒªÍê³ÉÌí¼Ó¼Ç¼µÄÖ÷Òª´úÂ룻£¨2£©ÍøÕ¾¼ò½é£¨intro£©¿ÉÒÔÊ¡ÂÔ£¬ÆäËü×ֶξù²»¿ÉÒÔÊ¡ÂÔ¡£
Add_form.asp
add.asp£¨ÇëÔÚÏÂÃæÍê³Éadd.asp£¬¿ªÍ·²¿·ÖÓï¾äºÍ×îºóÒ»ÌõÓï¾äÒѾ¸ø³ö£¬Ö»ÒªÔÚÖмäÌí¼ÓÓï¾ä¼´¿É£©
<% Option Explicit %>
<%
If Request.Form("name")<>"" And Request.Form("URL")<>"" Then
'ÒÔÏÂÁ¬ÉÏÊý¾Ý¿â£¬½¨Á¢Ò»¸öConnection¶ÔÏóʵÀýdb
Dim db
Set db=Server.CreateObject("ADODB.Connection")
db.Open "Dbq=" & Server.Mappath("wwwlink.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"
End If
%>
²Î¿¼´ð°¸
Ò»£®Ñ¡ÔñÌ⣨ÿÌâ2·Ö£¬¹²40·Ö£©
BBDCB ABABB AACCB CCBAB
¶þ£®Ìî¿ÕÌ⣨ÿÌâ1·Ö£¬¹²40·Ö£©
1£® VBScript
2£® IIS
3£® ¡°vbscript¡±
4£® d
5£® Rnd»òRnd()
6£® <% Option Explicit %>
7£® ×Ö¶Î
¼Ç¼
8£® Preserve (˵Ã÷£ºÕâÑù¾Í¿ÉÒÔ±£ÁôÔÓÐÊý¾Ý£¬·ñÔò¾Í²»Äܱ£Áô)
9£® 0
Sum+I^3
Cube
10£® Weekday
2,3
Response.Write
Response.Write
11£® ¡°¡±
Response.Redirect
12£® VarNumber=¡±¡±
Response.Cookies(¡°number¡±)
Response.Cookies(¡°number¡±).Expires
13£® Ubound
UserOnLine(I)
14£® Between
Desc
Count(*)
15£® "Dbq=" & Server.Mappath("wwwlink.mdb") & ";Driver={Microsoft Access Driver (*.mdb)}"
"Select * From link Order By Submit_date Desc"
Not rs.Eof
<%=rs("URL")%>
rs.MoveNext
16£® strSql,db,1
Not rs.Bof And Not rs.Eof
CInt
PageSize
AbsolutePage
Not rs.Eof
I>0
17£® OpenTextFile
AtEndOfStream
Èý£®±à³ÌÌ⣨ÿÌâ10·Ö£¬¹²30·Ö£©
1£®
<%
Dim I,J
For I=10 To 1 Step -1
For J=1 To I
Response.Write "*"
Next
Response.Write " "
Next
%>
2£®
<%
Dim db, strConn
strConn="Dbq=" & Server.Mappath("address.mdb") & ";Driver={Microsoft Access Driver (*.mdb)}"
Set db=Server.CreateObject("ADODB.Connection")
'½¨Á¢Recordset¶ÔÏó
Set rs=Server.CreateObject("ADODB.Recordset")
strSql ="Select * From link"
rs.Open strSql,db,0,2
'Ìí¼Ó¼Ç¼
rs.AddNew
rs("name")= "ËѺü"
rs("url")="www.sohu.com"
rs("intro")="ÃÅ»§ÍøÕ¾"
rs("submit_date")=Date()
rs.Update
%>
3£®
<%
If Request.Form("name")<>"" And Request.Form("URL")<>"" Then
'ÒÔÏÂÁ¬ÉÏÊý¾Ý¿â£¬½¨Á¢Ò»¸öConnection¶ÔÏóʵÀýdb
Dim db
Set db=Server.CreateObject("ADODB.Connection")
db.Open "Dbq=" & Server.Mappath("wwwlink.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"
Dim sqla,sqlb,strSql
sqla="Insert Into link(name,url,submit_date"
sqlb=" Values('" & Request.Form("name") & "','" & Request.Form("url") & "',#" & Date() & "#"
If Request.Form("intro")<>"" Then
sqla=sqla & ",intro"
sqlb=sqlb & ",'" & Request.Form("intro") & "'"
End If
strSql=sqla & ")" & sqlb & ")"
db.Execute(strSql)
End If
%>[ Last edited by ÉîÀ¶µÀ¶ on 2013-2-18 at 09:33 ] |
» ±¾Ìû¸½¼þ×ÊÔ´Áбí
» ²ÂÄãϲ»¶
» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍƼö£¬¶ÔÄúͬÑùÓаïÖú:
|