<optgroup LABEL="标题">
asc函数
Session.Contents.Remove("name")
response.Write("<script language=javascript>alert('密码或用户名输入错误!');history.go(-1)</script>")
url=Request.ServerVariables("HTTP_REFERER")
response.Write("<meta http-equiv=refresh content=0;URL="&url&">")
window.opener.location='" & url & "';
response.Redirect(Request.ServerVariables("HTTP_REFERER"))
response.Write("<meta http-equiv=refresh content=0;URL=javascript:history.back();>")
Set Fso=Server.CreateObject("Scripting.FileSystemObject")
filepath=server.mappath("../upload/goods/" & img)
Fso.DeleteFile FilePath,true
style="overflow-x:visible" 自动换行
style="CURSOR:hand;"
style="background-color:transparent"
弹出模式窗口window.showModalDialog(url,window,"dialogWidth=500px;dialogHeight=360px;center=yes;middle=yes;help=no;status=no;scroll=no")
javascript:window.close();
onKeyUp="this.value=this.value.replace(/\D/,'')"
onclick="return confirm('确定要删除吗?');"
<div style="OVERFLOW-Y: auto; HEIGHT: 300px">
onload="javascript:if(this.width>500)this.width=500"
style="TABLE-LAYOUT: fixed; WORD-BREAK: break-all"
onKeyUp="this.value=this.value.replace(/\D/,'')"
style="FILTER:alpha(opacity=99) shadow(color=#bbbbbb,direction=150);"//投影
Function ToMD5(ByVal InputString As String) As String
Dim code, MD5
Dim dataToHash As Byte() = (New System.Text.ASCIIEncoding).GetBytes(InputString)
Dim hashvalue As Byte() = CType(System.Security.Cryptography.CryptoConfig.CreateFromName("MD5"), System.Security.Cryptography.HashAlgorithm).ComputeHash(dataToHash)
Dim i As Integer
For i = 0 To 15 '选择32位字符的加密结果
MD5 += Hex(hashvalue(i)).ToLower
Next
Return MD5
End Function
'================随机数============
Randomize()
psw=Int((999999-100000+1)*Rnd(now())+100000)
'==================================
连接数据库:
<!--#include file="conn.asp"-->
photo=Replace(Request.Form("photo"),"'","''")
<%
Server.scriptTimeout="10"
connstr="DBQ="+server.mappath("数据文件.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
set conn=Server.CreateObject("ADODB.connection")
conn.open connstr
%>
<%
sql="select * from bbs order by date desc"
rs.open sql,conn,3
if rs.recordcount>0 then
rs.pagesize=20
if request("page")<>"" then
epage=cint(request("page"))
if epage<1 then epage=1
if epage>rs.pagecount then epage=rs.pagecount
else
epage=1
end if
rs.absolutepage=epage
for i=1 to rs.pagesize
if rs.bof or rs.eof then exit for%>
<%rs.movenext
next
else
end if
rs.close%>
读取:
读取数量:set sl=conn.execute("select count(*) as counts from news where types="&rs("ids")&" ")
=sl("counts")
写入:
set savereg=conn.execute("insert into reg(user,psw,mail,sex)values('"&user&"','"&psw&"','"&mail&"','"&sex&"')")
修改:set savebbs=conn.execute("update bbs set click = "&cl&" where id="&id&"")
查询:sql="select * from bbs where body like '%"&key&"%' or title like '%"&key&"%' order by date desc"
搜索:
删除:set delbbs=conn.execute("delete*from danwei where id="&id&"")
select * from table where name like [a-z]%
***********************翻页**********************
<%if rs.pagecount=1 then%>
<td><div align="center">共<span class="STYLE10"><%=rs.pagecount%></span>页 当前第<span class="STYLE10"><%=epage%></span>页 首页 上页 下页 尾页</div></td>
<%elseif rs.pagecount=epage then%>
<td><div align="center">共<span class="STYLE10"><%=rs.pagecount%></span>页 当前第<span class="STYLE10"><%=epage%></span>页 <a href="news.asp">首页</a> <a href="news.asp?page=<%=epage-1%>">上页</a> 下页 尾页</div></td>
<%elseif epage=1 then%>
<td><div align="center">共<span class="STYLE10"><%=rs.pagecount%></span>页 当前第<span class="STYLE10"><%=epage%></span>页 首页 上页 <a href="news.asp?page=<%=epage+1%>">下页</a> <a href="news.asp?page=<%=rs.pagecount%>">尾页</a></div></td>
<%elseif epage=rs.pagecount then%>
<td><div align="center">共<span class="STYLE10"><%=rs.pagecount%></span>页 当前第<span class="STYLE10"><%=epage%></span>页 <a href="news.asp">首页</a> <a href="news.asp?page=<%=epage-1%>">上页</a> 下页 尾页</div></td>
<%else%>
<td><div align="center">共<span class="STYLE10"><%=rs.pagecount%></span>页 当前第<span class="STYLE10"><%=epage%></span>页 <a href="news.asp">首页</a> <a href="news.asp?page=<%=epage-1%>">上页</a> <a href="news.asp?page=<%=epage+1%>">下页</a> <a href="news.asp?page=<%=rs.pagecount%>">尾页</a></div></td>
<%
end if
rs.close%>
**************************************************************
新数据库操作:
if request("id")="" then
sql = "select top 1 * from link"
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open sql,conn,1,3
rs.addnew
else
sql = "select * from link where id="&request("id")
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.Open sql,conn,1,3
end if
rs("linkname")=request("linkname")
rs("url")=trim(request("url"))
rs("logo")=trim(request("logo"))
rs("js")=trim(request("js"))
rs.update
rs.close
set rs=nothing
end if
*****************************************************************
半透明 style="filter: alpha(opacity=70);"
***********************************************************
Java鼠标位置:
event.clientX, event.clientY, event.offsetX, event.offsetY, event.screenX, event.screenY, event.x, and event.y
***************************************************
<%sql="select * from users order by times desc"
rs.open sql,conn,3
if rs.recordcount>0 then
rs.pagesize=rs.recordcount
for i=1 to rs.pagesize
if rs.bof or rs.eof then exit for%>
<%rs.movenext
next
else
end if
rs.close%>
<%sql2="select * from users order by times desc"
rs2.open sql2,conn,3
if rs2.recordcount>0 then
rs2.pagesize=rs2.recordcount
for i2=1 to rs2.pagesize
if rs2.bof or rs2.eof then exit for%>
<%rs2.movenext
next
else
end if
rs2.close%>
***************************************************
时间比较
if datediff("d",s1("onehfrq"),now())=0 then
'输出:xxxxxxxxxxxxxxxxxx
end if
这里标准写法.
datediff函数,是返回两个时间差,如果两个时间相差0,表示是同一天.
参数"d" 表示天
"m" 表示月
"y" 表示年
"h"小时
"m"分钟
"s"秒
**************************************************
function NoHtml(str) '消除Html代码
dim re
Set re=new RegExp
re.IgnoreCase =true
re.Global=True
str = replace(replace(str,"<BR>","{br}"),"<br>","{br}")
re.Pattern="(\<.[^\<]*\>)"
str=re.replace(str," ")
re.Pattern="(\<\/[^\<]*\>)"
str=re.replace(str," ")
str = replace(str,"{br}","<br>")
nohtml=str
set re=nothing
end function
*************************************************