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

aspµ÷ÓÃDLL·µ»ØrsµÄÎÊÌâ

²ÉÓÃÈý²ã£¬ÎÒÖ»ÌùÏà¹Ø´úÂë
SqlHelper²¿·Ö
VBScript code:

Public Function getObjRs(Sql)
Set objRs = New ADODB.Recordset
objRs.Open Sql, objConn, 1, 1
Set getObjRs = obj
End Function



Dal²¿·Ö
VBScript code:

Public Function getItem(Model As moonPotato_Model)
Sql = "Select * from Mpt_CostItem where CostItem_ParentID = " & Model.CostItem_ParentID & " order by CostItem_Order desc"
Set getItem = SqlHelper.getObjRs(Sql)
End Function



BLL²¿·Ö
VBScript code:

Public Function getItem(Model As moonPotato_Model)
Set getItem = Dal.getItem(Model)
End Function



ÒÔÉϲ¿·Ö±àÒë³ÉÁËDLLÎļþ

ASP²¿·Ö
VBScript code:

Set BLL = Server.CreateObject("OfficeNet.moonPotato_DAL")
Set Model = Server.CreateObject("OfficeNet.moonPotato_Model")
Model.CostItem_ParentID = 5
Set rs = BLL.getItem(Model)


´íÎóÌáʾ
Microsoft VBScript ÔËÐÐʱ´


Ïà¹ØÎÊ´ð£º

aspÊÂÎñÎÊÌâ

<%On Error Resume Next
Set conn=Server.CreateObject("ADODB.Connection")
conn.begintrans
conn.Open ("Driver={SQL Server};server=(local);uid=sa;database=student;pwd=") ......

ASPα¾²Ì¬µÄÁíÀàÎÊÌâ

ÓÉÓÚ¶ÔÒ³ÃæÊ¹ÓÃÁËα¾²Ì¬
²¢ÇÒ¶ÔID½øÐÐÁ˼ÓÃÜ¡£
Ö÷Òª´úÂëÈçÏ£º
httpd.ini
RewriteRule /List-([0-9,a-z]*).html /List.asp\?ComId=$1 [N,I]

³ÌÐò´úÂë
AΪ¼ÓÃÜ£¬BΪ½âÃܺ¯Êý
<a href=&q ......

asp rs.movenext²»¹ÜÓÃ

<%set rs=server.CreateObject("Adodb.recordset")

rs.open "select * from zs_news where m_classid="&classid&"  order by m_id desc",conn,1,1

......

aspºǫ́µÇ½ÎÊÌâ

ÎÒ°ïѧУ×öÁËÒ»¸öÕ¾£®

ÔÚÐ£Ô°ÍøµÄÇé¿öÏ£¬Äܹ»µÇ½³É¹¦£¬ºǫ́ÕʺŶ¼ÄÜͨ¹ý£¬½øÈëºǫ́

µ«ÊÇÔÚÍâÍø£Á£ÄµÄÇé¿öÏ£¬Äܹ»µÇ½ºǫ́µÄÒ³Ãæ£¬Ò³ÃæÊÇ£Á£Ó£ÐÎļþ£®
µ«ÊÇÊäÈëÕʺźÍÃÜÂëµÄʱºò£¬ÍøÒ³ÔËÐкܾö¼ ......

asp怫

µÇÂ½Ò³Ãæ-ÑéÖ¤Ò³Ãæ-³É¹¦ºó·µ»ØµÇÂ½Ò³Ãæ
ÕâʱÔõôÏÔʾXXXÄúÒѳɹ¦µÇ½
Õâ¸öXXXÔõôʵÏÖ(ΪÁ˽ÚÊ¡´ó¼Òʱ¼ä ÎÒÖ»ÒªXXXÕâ¸ö±äÁ¿ÊµÏÖ´úÂë)
Òª´úÂë:
ÔڵǼÑéÖ¤Ò³ÃæÀµ±µÇ¼³É¹¦ºó°ÑÓû§Ãû±£´æµ½sessionÀï
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ