%@ LANGUAGE="VBSCRIPT" CODEPAGE="936" TRANSACTION="Required" %>
<%
'---------------------------
'author:lujing
'ontime:07-06-12
'---------------------------
Option Explicit
On Error Resume Next
Response.Charset="gb2312"
Response.Buffer="true"
Response.Expires=0
Response.Expiresabsolute=Now()-1
Response.CacheControl="no-cache"
Response.AddHeader "pragma","no-cache"
Response.AddHeader "cache-control","private"
%>
<%
'---------------------------
'author:lujing
'ontime:07-06-12
'---------------------------
dim conn
'-----------------------------------
'open sqlserver connection
'-----------------------------------
Function OpenConn()
On Error Resume Next
Set conn=Server.CreateObject("ADODB.Connection")
conn.CursorLocation=3
'conn.open "Provider=SQLOLEDB.1;Persist Security Info=False;Server=.;Database=shops;User ID=sa;Password=;"
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&Server.MapPath("data1.mdb")
If Err Then SayErr()
End Function
'-----------------------------------
'close sqlserver connection
'-----------------------------------
Function CloseConn()
On Error Resume Next
If IsObject(conn) Then
If conn.state=1 Then
conn.close
Set conn=Nothing
End If
End If
If Err Then SayErr()
End Function
'---------------------------------
'show error
'---------------------------------
Function SayErr()
Response.Write(FormatDateTime(now,0)&"
")
Response.Write(CStr(Hex(Err.Number))&"
")
Response.Write(Err.Source&"
")
Response.Write(Err.Description&"
")
Err.Clear
Response.End()
End Function
'---------------------------------
'jump next page
'---------------------------------
Function SayJump(info,href)
Response.Write("")
Response.End()
End Function
'---------------------------------
'check request word
'---------------------------------
Function NoSql(str)
If Not isnull(str) Then
str=trim(str)
str=replace(str,";",";") '分号
str=replace(str,"'","'") '单引号
str=replace(str,"""",""") '双引号
str=replace(str,"chr(9)"," ") '空格
str=replace(str,"chr(10)","
") '回车
str=replace(str,"chr(13)","
") '回车
str=replace(str,"chr(32)"," ") '空格
str=replace(str,"chr(34)",""") '双引号
str=replace(str,"chr(39)","'") '单引号
str=Replace(str, "script", "script")'jscript
str=replace(str,"<","<") '左<
str=replace(str,">",">") '右>
str=replace(str,"(","(") '左(
str=replace(str,")",")") '右)
str=replace(str,"--","--") 'SQL注释符
nosql=str
End If
End Function
'---------------------------------
'edit id
'---------------------------------
Function GetId()
dim fname
fname = now()
fname = replace(fname,"-","")
fname = replace(fname," ","")
fname = replace(fname,":","")
fname = replace(fname,"PM","")
fname = replace(fname,"AM","")
fname = replace(fname,"上午","")
fname = replace(fname,"下午","")
fname = int(fname) + int((10-1+1)*Rnd + 1)
dim num
randomize
num=Int((99-10+1)*Rnd+10)
GetId=fname&num
End Function
'---------------------------------
'split page
'---------------------------------
Sub PageControl(icount,pagecount,page,table_style,font_style)
Dim query, a, b, temp,action
action = "http://" & Request.ServerVariables("HTTP_HOST") & Request.ServerVariables("SCRIPT_NAME")
query = Split(Request.ServerVariables("QUERY_STRING"), "&")
For Each b In query
a = Split(b, "=")
If StrComp(a(0), "page", vbTextCompare) <> 0 Then
temp = temp & a(0) & "=" & a(1) & "&"
End If
Next
Response.Write("
" & vbCrLf )
Response.Write("| " & vbCrLf )
if page<=1 then
Response.Write ("首页 " & vbCrLf)
Response.Write ("上页 " & vbCrLf)
else
Response.Write("首页 " & vbCrLf)
Response.Write("上页 " & vbCrLf)
end if
if page>=pagecount then
Response.Write ("下页 " & vbCrLf)
Response.Write ("尾页 " & vbCrLf)
else
Response.Write("下页 " & vbCrLf)
Response.Write("尾页 " & vbCrLf)
end if
Response.Write(" 页次:" & page & "/" & pageCount & "页" & vbCrLf)
Response.Write(" 共有" & icount & "条信息" & vbCrLf)
Response.Write(" |
" & vbCrLf )
End Sub
%>
清华大学凝聚态理论研究组
>>