Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

aspʵÏÖ¼òµ¥Êý¾Ý¿âÁ¬½ÓÀà

ʵÏÖÁ˼òµ¥µÄÊý¾Ý¿âÁ¬½Ó£¬µÃµ½¼Ç¼¼¯£¬µÃµ½¶þάÊý×飬ִÐÐij¸öÓï¾ä£¬ÆäʵÕâ¸öÀà¿ÉÒÔ¼ÌÐøÀ©³ä£¬±ÈÈçÏȶÁÈ¡±äÁ¿£¬µÃµ½Ö´ÐдÎÊý£¬¼òµ¥·ÖÒ³µÈµÈ¡£¡££¬Æª·ùÓÐÏÞ£¬×Ô¼ºÀ©³ä
'----------------------------------------------
'Êý¾Ý¿â²Ù×÷
'----------------------------------------------
'¼ò»¯µÄÊý¾ÝÀà
Class dbconn
public connstr,conn,queryCount,die_err
private connstate
Private Sub Class_Initialize
queryCount=0
connstate = false
die_err = true
End Sub
'¹¹Ôì
Sub Conn_Open
on error resume next
set conn = server.CreateObject("adodb.connection")
conn.connectiontimeout = 120
Conn.Open connstr
if err then
if die_err = true then die "Êý¾Ý¿âÁ¬½Ó´íÎó£¡"
else
connstate= true
end if
End Sub
'µÃµ½¼Ç¼¼¯
Function getRs(byval sqlStr,byval vtype)
On Error Resume Next
if cint(vtype) <> 3 then vtype =1 end if
if connstate = false then call Conn_Open
set getrs = server.CreateObject("ADODB.RECORDSET")
getrs.open sqlStr,conn,1,vtype
queryCount = queryCount+1
if Err then
if die_err = true then die sqlStr
if die_err = true then die "Êý¾Ý¿âµÃµ½¼Ç¼¼¯´íÎó£¡"
end if
End Function
'µÃµ½µ¥Ò»µÄÖµ
Function getVal(byval sqlstr)
On Error Resume Next
if connstate = false then call Conn_Open
dim rs : set rs =conn.execute(sqlstr)
if rs.eof then
getVal =""
else
getVal = rs(0)
end if
rs.close : set rs = nothing
End Function

Function exec(Byval sqlstr)
if connstate = false then call Conn_Open
conn.execute(sqlstr)
End Function
'µÃµ½Êý×é
Function getArray(Byval sqlstr)
on error resume next
if connstate = false then call Conn_Open
dim rs : set rs =conn.execute(sqlstr)
if rs.eof then getArray = "" else getArray = rs.getrows
rs.close : set rs = nothing
queryCount = queryCount+1
if Err then
if die_err = true then die "Êý¾Ý¿âµÃµ½Êý×é´íÎó£¡"
end if
End Function

'Îö¹¹
Public Sub Class_Terminate()
if connstate = true


Ïà¹ØÎĵµ£º

ASPµ÷Óô洢¹ý³Ì£ºÓÐÊäÈë²ÎÊýºÍÊä³ö²ÎÊýµÄ´æ´¢¹ý³Ì


¡¡¡¡4. ÓÐÊäÈë²ÎÊýºÍÊä³ö²ÎÊýµÄ´æ´¢¹ý³Ì
¡¡¡¡·µ»ØÖµÆäʵÊÇÒ»ÖÖÌØÊâµÄÊä³ö²ÎÊý¡£ÔÚ´ó¶àÊýÇé¿öÏ£¬ÎÒÃÇÓõ½µÄÊÇͬʱÓÐÊäÈë¼°Êä³ö²ÎÊýµÄ´æ´¢¹ý³Ì£¬±ÈÈçÎÒÃÇÏëÈ¡µÃÓû§ÐÅÏ¢±íÖУ¬Ä³IDÓû§µÄÓû§Ãû£¬Õâʱºò£¬ÓÐÒ»¸öÊäÈë²ÎÊý----Óû§ID£¬ºÍÒ»¸öÊä³ö²ÎÊý----Óû§Ãû¡£ÊµÏÖÕâÒ»¹¦ÄܵĴ洢¹ý³ÌÈçÏ£º
/*SP4*/
CREATE PROCEDURE d ......

ASPµ÷Óô洢¹ý³Ì£º·µ»Ø¶à¸ö¼Ç¼¼¯µÄ´æ´¢¹ý³Ì


¡¡¡¡7. ·µ»Ø¶à¸ö¼Ç¼¼¯µÄ´æ´¢¹ý³Ì
¡¡¡¡±¾ÎÄ×îÏȽéÉܵÄÊÇ·µ»Ø¼Ç¼¼¯µÄ´æ´¢¹ý³Ì¡£ÓÐʱºò£¬ÐèÒªÒ»¸ö´æ´¢¹ý³Ì·µ»Ø¶à¸ö¼Ç¼¼¯£¬ÔÚASPÖУ¬ÈçºÎͬʱȡµÃÕâЩ¼Ç¼¼¯ÄØ£¿ÎªÁË˵Ã÷ÕâÒ»ÎÊÌ⣬ÔÚuserinfo±íÖÐÔö¼ÓÁ½¸ö×ֶΣºusertel¼°usermail£¬²¢É趨ֻÓеǼÓû§¿ÉÒԲ鿴ÕâÁ½ÏîÄÚÈÝ¡£
/*SP7*/
CREATE PROCEDURE dbo.getUserInfo
......

aspÈçºÎµ÷Óô洢¹ý³ÌʵÏÖ·ÖÒ³£¡£¨°Ù¶ÈÖªµÀ£©

ÎÊÌ⣺
aspÈçºÎµ÷Óô洢¹ý³ÌʵÏÖ·ÖÒ³£¡
´æ´¢¹ý³ÌÈçÏ£º
CREATE PROCEDURE GetRecordfromPage
    @tblName      varchar(255),       -- ±íÃû
    @fldName      varchar(255),   &nb ......

TOP CMS ASP»·¾³Éú³É¾²Ì¬Îļþ ͼƬ×Ô¶¯±¾µØ»¯


Top-CMSÖ÷ÒªÌØµã£º
    1.ϵͳ²ÉÓÃASP+COM¼¼Êõ¿ª·¢£¬Ò»·½Ãæ×î´ó³Ì¶È±£ÕÏϵͳ°²È«ÐÔ£¬ÁíÒ»·½Ã漫´óµÄÌá¸ßϵͳÔËÐÐЧÂÊ¡£
    2.ϵͳÍêÈ«»ùÓÚB/Sģʽ¹¹½¨£¬Ö»ÒªÔÚ·þÎñÆ÷Éϰ²×°Á˱¾ÏµÍ³£¬¿Í»§»ú²»ÐèÒª°²×°ÆäËûÈí¼þ£¬Ö±½ÓʹÓÃIE±ã¿Éä¯ÀÀ¡£
    3.ϵͳ±¾Éí¼¯³ÉÖîÈ繫¸æ¡¢×¨Ìâ¡¢ÔÚÏßµ÷²é¡¢Óû ......

ASP±éÀúXML½Úµã


±éÀúXMLÎĵµ
¶ÔÓÚÏÂÃæµÄÒ»¶ÎXML´úÂ룺
XMLÎĵµÊµÀýbooks.xml£¬ÈçÏÂËùʾ£º
<?xml version="1.0" encoding="gb2312" ?>
<books>
<book status="ÒÑÊÛÍê">
<author>ÆÆÆÆ</author>
<title>XMLÈëÃÅ</title >
</book>
<book statu ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ