conn.asp

通用考勤系统

<%
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''版权：野马原创                    ''''
''''联系：[e-mail]          ''''
''''说明：需要新功能联系我      ''''
''''QQ:2643148                     ''''
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
%>
 
<%
Response.Buffer=True
Response.Expires=0
'''''''''''''''''''''''''''''' Access数据库 '''''''''''''''''''''''''''''''''''''''''''''''''''''''''
datapath    ="data/"      '数据库目录的相对路径
datafile    ="#asoftkq.asp"      '数据库的文件名
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath(""&datapath&""&datafile&"")
'Connstr="DBQ="&server.mappath(""&datapath&""&datafile&"")&";DRIVER={Microsoft Access Driver (*.mdb)};"
SqlNowString="Now()"
SqlChar="'"
ver="5.13a"
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

On Error Resume Next
Set cn=Server.CreateObject("ADODB.Connection")
cn.open ConnStr
set rs=Server.CreateObject("ADODB.Recordset")
set rs1=Server.CreateObject("ADODB.Recordset")
set rs2=Server.CreateObject("ADODB.Recordset")
set rs3=Server.CreateObject("ADODB.Recordset")
set rs4=Server.CreateObject("ADODB.Recordset")
set rsa=Server.CreateObject("ADODB.Recordset")
set rsb=Server.CreateObject("ADODB.Recordset")
If Err Then
err.Clear
Set Conn = Nothing
Response.Write "数据库连接出错，请检查连接字串。"
Response.End
End If

Function Format_Time(s_Time, n_Flag) 
 Dim y, m, d, h, mi, s 
 Format_Time = "" 
 If IsDate(s_Time) = False Then Exit Function 
 y = cstr(year(s_Time)) 
 m = cstr(month(s_Time)) 
 If len(m) = 1 Then m = "0" & m 
 d = cstr(day(s_Time)) 
 If len(d) = 1 Then d = "0" & d 
 h = cstr(hour(s_Time)) 
 If len(h) = 1 Then h = "0" & h 
 mi = cstr(minute(s_Time)) 
 If len(mi) = 1 Then mi = "0" & mi 
 s = cstr(second(s_Time)) 
 If len(s) = 1 Then s = "0" & s 
 Select Case n_Flag 
 Case 1 
  '’ yyyy-mm-dd hh:mm:ss 
  Format_Time = y & "-" & m & "-" & d & " " & h & ":" & mi & ":" & s 
 Case 2 
  '’ yyyy-mm-dd 
  Format_Time = y & "-" & m & "-" & d 
 Case 3 
  '’ hh:mm:ss 
  Format_Time = h & ":" & mi & ":" & s 
 Case 4 
  '’ yyyy年mm月dd日 
  Format_Time = y & "年" & m & "月" & d & "日" 
 End Select 
End Function
%>