学习ASP动态网页编程技术很有用代码

学习ASP动态网页编程技术很有用代码 1、数据库连接。 ASP与Access数据库连接: <%@ language=VBscript%> <% dim conn,mdbfile mdbfile=server.mappath("数据库名称.mdb") set conn=server.createobject("adodb.connection") conn.open "driver={microsoft access driver (*.mdb)};uid=admin;pwd=数据库密码;dbq="&mdbfile %> ASP与SQL数据库连接: <%@ language=VBscript%> <% dim conn set conn=server.createobject("ADODB.connection") con.open "PROVIDER=SQLOLEDB;DATA SOURCE=SQL服务器名称或IP地址;UID=sa;PWD=数据库密码;DATABASE=数据库名称 %> DW中用字符串连接代码: "Driver={Microsoft Access Driver (*.mdb)};DBQ=数据库的绝对路径" 等做完后再打开数据库服务器，把 "Driver={Microsoft Access Driver (*.mdb)};DBQ=数据库的绝对路径" 换成 "Provider=Microsoft.Jet.OLEDB.4.0;data source="& server.mappath("服务器根目录下所在数据库路径") 并把本地服务器修改成测试服务器 2、加载别的页面。 3、显示数据库中的数据。 <%=rs("字段")%> 4、输出。 Response.Write("文字或者字符串"); 5、打开数据库并建立数据集对象。 set conn=server.CreateObject("ADODB.connection") conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&server.MapPath("***/photodata.mdb") '更改您的数据库文件存放路径 set rs=server.createobject("ADODB.recordset") '建立数据集 sql="SELECT * FROM data" '更改您的数据库表名 rs.Open sql,conn,1,1 6、获得系统的时间。 <%=now()%> 7、取得来访问的IP。 <%=request.serverVariables("remote_host")%> 8、随机数。 <%randomize%> <%=(int(rnd()*n)+1)%> N为可改变数 9、跳转页面。 Response.Redirect("页面") 10、弹出消息框。 Response.Write("") 11、用hidden类型来传递变量。 < % form method="post" action="mynextpage.asp" > < % for each item in request.form % > < input namee="< %=item% >" type="HIDDEN" value="< %=server.HTMLEncode(Request.form(item)) % >" > < % next % > < /form > 12、常用SQL语句整理。 (1) 数据记录筛选: sql="select * from 数据表 where 字段名=字段值 order by 字段名 [desc]" sql="select * from 数据表 where 字段名 like ''%字段值%'' order by 字段名 [desc]" sql="select top 10 * from 数据表 where 字段名 order by 字段名 [desc]" sql="select * from 数据表 where 字段名 in (''值1'',''值2'',''值3'')" sql="select * from 数据表 where 字段名 between 值1 and 值2" (2) 更新数据记录: sql="update 数据表 set 字段名=字段值 where 条件表达式" sql="update 数据表 set 字段1=值1,字段2=值2 …… 字段n=值n where 条件表达式" (3) 删除数据记录: sql="delete from 数据表 where 条件表达式" sql="delete from 数据表" (将数据表所有记录删除) (4) 添加数据记录: sql="insert into 数据表 (字段1,字段2,字段3 …) values (值1,值2,值3 …)" sql="insert into 目标数据表 select * from 源数据表" (把源数据表的记录添加到目标数据表) (5) 数据记录统计函数: AVG(字段名) 得出一个表格栏平均值 COUNT(*|字段名) 对数据行数的统计或对某一栏有值的数据行数统计 MAX(字段名) 取得一个表格栏最大的值 MIN(字段名) 取得一个表格栏最小的值 SUM(字段名) 把数据栏的值相加 引用以上函数的方法: sql="select sum(字段名) as 别名 from 数据表 where 条件表达式" set rs=conn.excute(sql) 用 rs("别名") 获取统的计值，其它函数运用同上。 (5) 数据表的建立和删除: CREATE TABLE 数据表名称(字段1 类型1(长度),字段2 类型2(长度) …… ) 例:CREATE TABLE tab01(name varchar(50),datetime default now()) DROP TABLE 数据表名称 (永久性删除一个数据表) 封IP的方法 <% Dim IP,IPString,VisitIP '要禁止的IP地址 IPString="|195.225.177.34|195.225.177.137|72.232.250.10|" '获取IP地址 IP = Request.ServerVariables("HTTP_X_FORWARDED_FOR") If IP = "" Then IP = Request.ServerVariables("REMOTE_ADDR") End If VisitIP="|"&IP&"|" If instr(1,IPString,VisitIP)>0 Then response.write "你的IP被禁止发表留言，若有必要，请与站长联系。如果你正在发送垃圾，奉劝你收手～" response.end End If 'response.Write("你的IP:"&IP&"可以访问本站") %> 注:记得将此代码嵌入到最终执行页(不一定为留言发表页面)的头部，大部分垃圾都是直接POST数据到该执行页的。建议不定期修改最终执行页的文件名及与之链接的留言发表页面的 form 标签内的 action. 利用ASP代码实现对 IP 的访问限制 '可以进入的ip '218.7.44.0 - 218.7.45.253 '61.180.240.0 - 61.180.240.253 '202.118.208.0 - 202.118.223.253 ' '218.7.44.0 3657903103 '218.7.45.253 3657903612 ' '61.180.240.0 1035268095 '61.180.240.253 1035268348 ' '202.118.208.0 3396784127 '202.118.223.253 3396788220 ip=request.servervariables("remote_addr") sip=split(ip,".") num=cint(sip(0))*256*256*256+cint(sip(1))*256*256+cint(sip(2))*256+cint(sip(3))- 1 response.write(ip) response.write("<br>") if ((num>=3657903103 and num<=3657903612) or (num>=1035268095 and num<=1035268348) or (num>=3396784127 and num<=3396788220)) then response.write("抱歉，您的ip不合法～") response.End() else response.write("您的ip合法") end if ASP实现无组件生成验证码-GIF格式 <% Option Explicit ' 显示声明 Class Com_GifCode_Class ''''''''''''''''''''''''''''''''''''''''''''' ' Author: Layen support@ssaw.net 84815733(QQ) ' Thanks: Laomi, Laomiao, NetRube ' 2006-01-02 ''''''''''''''''''''''''''''''''''''''''''''' Public Noisy, Count, Width, Height, Angle, Offset, Border Private Graph(), Margin(3) Private Sub Class_Initialize() Randomize Noisy = 16 ' 干扰点出现的概率 Count = 4 ' 字符数量 Width = 80 ' 图片宽度 Height = 20 ' 图片高度 Angle = 2 ' 角度随机变化量 Offset = 20 ' 偏移随机变化量 Border = 1 ' 边框大小 End Sub Public Function Create() Const cCharSet = "123456789" Dim i, x, y Dim vValidCode : vValidCode = "" Dim vIndex ReDim Graph(Width-1, Height-1) For i = 0 To Count - 1 vIndex = Int(Rnd * Len(cCharSet)) vValidCode = vValidCode + Mid(cCharSet, vIndex+1 , 1) SetDraw vIndex, i Next Create = vValidCode End Function Sub SetDot(pX, pY) If pX * (Width-pX-1) >= 0 And pY * (Height-pY-1) >= 0 Then Graph(pX, pY) = 1 End If End Sub Public Sub SetDraw(pIndex, pNumber) ' 字符数据 Dim DotData(8) DotData(0) = Array(30, 15, 50, 1, 50, 100) DotData(1) = Array(1 ,34 ,30 ,1 ,71, 1, 100, 34, 1, 100, 93, 100, 100, 86) DotData(2) = Array(1, 1, 100, 1, 42, 42, 100, 70, 50, 100, 1, 70) DotData(3) = Array(100, 73, 6, 73, 75, 6, 75, 100) DotData(4) = Array(100, 1, 1, 1, 1, 50, 50, 35, 100, 55, 100, 80, 50, 100, 1, 95) DotData(5) = Array(100, 20, 70, 1, 20, 1, 1, 30, 1, 80, 30, 100, 70, 100, 100, 80, 100, 60, 70, 50, 30, 50, 1, 60) DotData(6) = Array(6, 26, 6, 6, 100, 6, 53, 100) DotData(7) = Array(100, 30, 100, 20, 70, 1, 30, 1, 1, 20, 1, 30, 100, 70, 100, 80, 70, 100, 30, 100, 1, 80, 1, 70, 100, 30) DotData(8) = Array(1, 80, 30, 100, 80, 100, 100, 70, 100, 20, 70, 1, 30, 1, 1, 20, 1, 40, 30, 50, 70, 50, 100, 40) Dim vExtent : vExtent = Width / Count Margin(0) = Border + vExtent * (Rnd * Offset) / 100 + Margin(1) Margin(1) = vExtent * (pNumber + 1) - Border - vExtent * (Rnd * Offset) / 100 Margin(2) = Border + Height * (Rnd * Offset) / 100 Margin(3) = Height - Border - Height * (Rnd * Offset) / 100 Dim vStartX, vEndX, vStartY, vEndY Dim vWidth, vHeight, vDX, vDY, vDeltaT Dim vAngle, vLength vWidth = Int(Margin(1) - Margin(0)) vHeight = Int(Margin(3) - Margin(2)) ' 起始坐标 vStartX = Int((DotData(pIndex)(0)-1) * vWidth / 100) vStartY = Int((DotData(pIndex)(1)-1) * vHeight / 100) Dim i, j For i = 1 To UBound(DotData(pIndex), 1)/2 If DotData(pIndex)(2*i-2) <> 0 And DotData(pIndex)(2*i) <> 0 Then ' 终点坐标 vEndX = (DotData(pIndex)(2*i)-1) * vWidth / 100 vEndY = (DotData(pIndex)(2*i+1)-1) * vHeight / 100 ' 横向差距 vDX = vEndX - vStartX ' 纵向差距 vDY = vEndY - vStartY ' 倾斜角度 If vDX = 0 Then vAngle = Sgn(vDY) * 3.14/2 Else vAngle = Atn(vDY / vDX) End If ' 两坐标距离 If Sin(vAngle) = 0 Then vLength = vDX Else vLength = vDY / Sin(vAngle) End If ' 随机转动角度 vAngle = vAngle + (Rnd - 0.5) * 2 * Angle * 3.14 * 2 / 100 vDX = Int(Cos(vAngle) * vLength) vDY = Int(Sin(vAngle) * vLength) If Abs(vDX) > Abs(vDY) Then vDeltaT = Abs(vDX) Else vDeltaT = Abs(vDY) For j = 1 To vDeltaT SetDot Margin(0) + vStartX + j * vDX / vDeltaT, Margin(2) + vStartY + j * vDY / vDeltaT Next vStartX = vStartX + vDX vStartY = vStartY + vDY End If Next End Sub Public Sub Output() Response.Expires = -9999 Response.AddHeader "pragma", "no-cache" Response.AddHeader "cache-ctrol", "no-cache" Response.ContentType = "image/gif" ' 文件类型 Response.BinaryWrite ChrB(Asc("G")) & ChrB(Asc("I")) & ChrB(Asc("F")) ' 版本信息 Response.BinaryWrite ChrB(Asc("8")) & ChrB(Asc("9")) & ChrB(Asc("a")) ' 逻辑屏幕宽度 Response.BinaryWrite ChrB(Width Mod 256) & ChrB((Width \ 256) Mod 256) ' 逻辑屏幕高度 Response.BinaryWrite ChrB(Height Mod 256) & ChrB((Height \ 256) Mod 256) Response.BinaryWrite ChrB(128) & ChrB(0) & ChrB(0) ' 全局颜色列表 Response.BinaryWrite ChrB(255) & ChrB(255) & ChrB(255) Response.BinaryWrite ChrB(0) & ChrB(85) & ChrB(255) ' 图象标识符 Response.BinaryWrite ChrB(Asc(",")) Response.BinaryWrite ChrB(0) & ChrB(0) & ChrB(0) & ChrB(0) ' 图象宽度 Response.BinaryWrite ChrB(Width Mod 256) & ChrB((Width \ 256) Mod 256) ' 图象高度 Response.BinaryWrite ChrB(Height Mod 256) & ChrB((Height \ 256) Mod 256) Response.BinaryWrite ChrB(0) & ChrB(7) & ChrB(255) Dim x, y, i : i = 0 For y = 0 To Height - 1 For x = 0 To Width - 1 If Rnd < Noisy / 100 Then Response.BinaryWrite ChrB(1-Graph(x, y)) Else If x * (x-Width) = 0 Or y * (y-Height) = 0 Then Response.BinaryWrite ChrB(Graph(x, y)) Else If Graph(x-1, y) = 1 Or Graph(x, y) Or Graph(x, y-1) = 1 Then Response.BinaryWrite ChrB(1) Else Response.BinaryWrite ChrB(0) End If End If End If If (y * Width + x + 1) Mod 126 = 0 Then Response.BinaryWrite ChrB(128) i = i + 1 End If If (y * Width + x + i + 1) Mod 255 = 0 Then If (Width*Height - y * Width - x - 1) > 255 Then Response.BinaryWrite ChrB(255) Else Response.BinaryWrite ChrB(Width * Height Mod 255) End If End If Next Next Response.BinaryWrite ChrB(128) & ChrB(0) & ChrB(129) & ChrB(0) & ChrB(59) End Sub End Class Dim mCode Set mCode = New Com_GifCode_Class Session("GetCode") = mCode.Create() mCode.Output() Set mCode = Nothing %> 一个非常简洁的验证码程序 <% Response.Buffer = True With Response .Expires = -1 .AddHeader "Pragma","no-cache" .AddHeader "cache-ctrol","no-cache" End With Dim a(10,10) a(0,1) = "0x3c" '数字0 a(0,2) = "0x66" a(0,3) = "0xc3" a(0,4) = "0xc3" a(0,5) = "0xc3" a(0,6) = "0xc3" a(0,7) = "0xc3" a(0,8) = "0xc3" a(0,9) = "0x66" a(0,10)= "0x3c" a(1,1) = "0x18" '数字1 a(1,2) = "0x1c" a(1,3) = "0x18" a(1,4) = "0x18" a(1,5) = "0x18" a(1,6) = "0x18" a(1,7) = "0x18" a(1,8) = "0x18" a(1,9) = "0x18" a(0,10)= "0x7e" a(2,1) = "0x3c" '数字2 a(2,2) = "0x66" a(2,3) = "0x60" a(2,4) = "0x60" a(2,5) = "0x30" a(2,6) = "0x18" a(2,7) = "0x0c" a(2,8) = "0x06" a(2,9) = "0x06" a(2,10)= "0x7e" a(3,1) = "0x3c" '数字3 a(3,2) = "0x66" a(3,3) = "0xc0" a(3,4) = "0x60" a(3,5) = "0x1c" a(3,6) = "0x60" a(3,7) = "0xc0" a(3,8) = "0xc0" a(3,9) = "0x66" a(3,10)= "0x38" a(4,1) = "0x38" '数字4 a(4,2) = "0x3c" a(4,3) = "0x36" a(4,4) = "0x33" a(4,5) = "0x33" a(4,6) = "0x33" a(4,7) = "0xff" a(4,8) = "0x30" a(4,9) = "0x30" a(4,10)= "0xfe" a(5,1) = "0xfe" '数字5 a(5,2) = "0xfe" a(5,3) = "0x06" a(5,4) = "0x06" a(5,5) = "0x3e" a(5,6) = "0x60" a(5,7) = "0xc0" a(5,8) = "0xc3" a(5,9) = "0x66" a(5,10)= "0x3c" a(6,1) = "0x60" '数字6 a(6,2) = "0x30" a(6,3) = "0x18" a(6,4) = "0x0c" a(6,5) = "0x3e" a(6,6) = "0x63" a(6,7) = "0xc3" a(6,8) = "0xc3" a(6,9) = "0x66" a(6,10) ="0x3c" a(7,1) = "0xff" '数字7 a(7,2) = "0xc0" a(7,3) = "0x60" a(7,4) = "0x30" a(7,5) = "0x18" a(7,6) = "0x18" a(7,7) = "0x18" a(7,8) = "0x18" a(7,9) = "0x18" a(7,10)= "0x18" a(8,1) = "0x3c" '数字8 a(8,2) = "0x66" a(8,3) = "0xc3" a(8,4) = "0x66" a(8,5) = "0x3c" a(8,6) = "0x66" a(8,7) = "0xc3" a(8,8) = "0xc3" a(8,9) = "0x66" a(8,10)= "0x3c" a(9,1) = "0x3c" '数字9 a(9,2) = "0x66" a(9,3) = "0xc3" a(9,4) = "0xc3" a(9,5) = "0x66" a(9,6) = "0x3c" a(9,7) = "0x18" a(9,8) = "0x0c" a(9,9) = "0x06" a(9,10)= "0x03" Dim num Randomize num = Int(7999 * Rnd + 2000) Session("safenum") = num Dim Image Dim Width, Height Dim digtal Dim Length Dim sort Dim hc Length = 4 hc = chr(13) & chr(10) Redim sort(Length) digital = "" For I = 1 To Length - Len(num) digital = digital & "0" Next For I = 1 To Len(num) digital = digital & Mid(num, I, 1) Next For I = 1 To Len(digital) sort(I) = Mid(digital, I, 1) Next Width = 8 * Len(digital) Height = 10 Response.ContentType = "image/x-xbitmap" Image = "#define counter_width " & Width & hc Image = Image & "#define counter_height " & Height & hc Image = Image & "static unsigned char counter_bits[] = {" & hc For I = 1 To Height For J = 1 To Length Image = Image & a(sort(J),I) & "," Next Next Image = Left(Image, Len(Image) - 1) Image = Image & "};" & hc Response.Write Image %>