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 ÔËÐÐʱ´
Ïà¹ØÎÊ´ð£º
HTML code:
dim jf
set conn=server.createobject("adodb.connection")
connstr="Driver={Sql Server};Server="&Sqlip&";Database="&Sqldb&";Uid="& ......
ÎÒÃÇÓÐÒ»¸öÍøÕ¾Ä£°å£¬www.c111.com.cn,Ï£ÍûÐÞ¸ÄһЩµØ·½£º
1£©µã»÷×ó²à¡°·þÎñÆ·ÅÆ¡±µÄÆäÖÐÒ»¸öС·ÖÀ࣬Èç¡°×ãÇò¡±£¬½çÃæµÄÓÒ²à¾Í³öÏÖÈçwww.c111.com.cn/1.jpg£¬µã»÷1.jpgÉÏ·½µÄÆäÖÐÒ»¸öÆ·ÅÆlogo£¬ÏÂÃæ¾Í³öÏÖÏà¹ØµÄÍ ......
µ±½áÊøÊ±¼ä´óÓÚ¿ªÊ¼Ê±¼äÔòÏÔʾδÍê³É
µ±½áÊøÊ±¼äСÓÚ¿ªÊ¼Ê±¼äÔòÏÔʾδ´ïµ½ÈÎÎñ
ûÓÐʱ¼äÔòÏÔʾÕýÔÚ½øÐÐÖÐ
asp´úÂëÓ¦¸ÃÔõôд
Èç:¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä & ......
ÎÒµÄ網頁´ú碼為ASP語ÑÔ,驗證·½Ê½為ϵ統×Ô帶µÄWINDOW驗證ģʽ.
現ÔÚÎÒÈç¹ûÒªÔÚASP´ú碼ÖÐ獲È¡當ǰµÄµÇÈëÈË ......
µÇÂ½Ò³Ãæ-ÑéÖ¤Ò³Ãæ-³É¹¦ºó·µ»ØµÇÂ½Ò³Ãæ
ÕâʱÔõôÏÔʾXXXÄúÒѳɹ¦µÇ½
Õâ¸öXXXÔõôʵÏÖ(ΪÁ˽ÚÊ¡´ó¼Òʱ¼ä ÎÒÖ»ÒªXXXÕâ¸ö±äÁ¿ÊµÏÖ´úÂë)
Òª´úÂë:
ÔڵǼÑéÖ¤Ò³ÃæÀµ±µÇ¼³É¹¦ºó°ÑÓû§Ãû±£´æµ½sessionÀï
......