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="& ......
×î½üÎÒͨ¹ýѧϰ£¬¸Ð¾õ×Ô¼ºÑ§µÄ»¹¿ÉÒÔÁË£¬Ïë×öÒ»ÍøÕ¾£¬µ«ÊÇÒ»Ö±¶¼ÕÒ²»µ½Ìâ²Ä£¬²»ÖªµÀ×öʲô£¬Ï£Íû¸÷λ¸øÎÒµãÒâ¼û£¬Èç¹ûÓÐÐèÇóÎĵµ¾Í¸üºÃÁË£¡Ï£Íû´ó¼Ò¸øÎÒµãÒâ¼û£¬Ð»Ð»£¡
ÏÈ×ö¸öÆóÒµÍøÕ¾°É£¬ÎҸоõÒ»¸öÈË×öÍøÕ¾²»ÊÊÒË ......
ÓÉÓÚ¶ÔÒ³ÃæÊ¹ÓÃÁËα¾²Ì¬
²¢ÇÒ¶ÔID½øÐÐÁ˼ÓÃÜ¡£
Ö÷Òª´úÂëÈçÏ£º
httpd.ini
RewriteRule /List-([0-9,a-z]*).html /List.asp\?ComId=$1 [N,I]
³ÌÐò´úÂë
AΪ¼ÓÃÜ£¬BΪ½âÃܺ¯Êý
<a href=&q ......
ÎÒÏë×öÒ»¸ö³ÌÐò£¬Ëûͨ¹ý½Ø»ñÍøÂçÊý¾Ý±¨ÎÄ£¬¹ýÂ˱¨ÎÄÖеÄasp.netÓï¾ä£¬È»ºó¸Äд±¨ÎĵĶ«Î÷¡£ÎÒ¶Ôasp.net²»¶®£¬ÎÒÏëÎÊϸ÷λ¸ßÈË£¬asp.netÊÇÒÔʲôÑùµÄ±êÖ¾ÆðÍ·£¬Ê²Ã´ÑùµÄ±êÖ¾½áÎ²ÄØ¡£¶àл¸÷λÁË¡£
Âé·³´ó¸çÄܸøÒ»¸ ......
HTML code:
sql = "select top 1 * from cm_info where lm2='"&lm2&"' and (name='"&Request("name")&"' or haoma='"&Request("haoma")&a ......