hotel.asp

来自「酒店预约系统,适合中小型酒店使用」· ASP 代码 · 共 23 行

<%
Dim hotel_conn

db = "database/hotel.mdb"	'ACCESS数据库
connstr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db)
Set hotel_conn  =  Server.CreateObject("ADODB.Connection")
if err Then
	err.clear
end if

hotel_conn.Open connstr

'关闭数据库连接，在每页中调用此函数，将连接放入连接池
sub CloseConn()
	hotel_conn.Close()
	Set hotel_conn  =  Nothing
end sub

'替换单引号
function RealString(strSrc)
	RealString  =  Replace(Trim(strSrc), "'", "''")
end function
%>