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 ÔËÐÐʱ´
Ïà¹ØÎÊ´ð£º
<%@language="vbscript"%>
<%option explicit%>
<html>
<head> <title>xxx </title> </head>
<script language=vbs>
'×¢Òâ±äÁ¿ ......
VBScript code:
Set http=Server.CreateObject("MSXML2.ServerXMLHTTP")
http.Open "post","http://www.yodao.com/smartresult-xml/search.s?type=ip&q=221.123.123.123" ......
<%set rs=server.CreateObject("Adodb.recordset")
rs.open "select * from zs_news where m_classid="&classid&" order by m_id desc",conn,1,1
......
ÎÒ°ïѧУ×öÁËÒ»¸öÕ¾£®
ÔÚÐ£Ô°ÍøµÄÇé¿öÏ£¬Äܹ»µÇ½³É¹¦£¬ºǫ́ÕʺŶ¼ÄÜͨ¹ý£¬½øÈëºǫ́
µ«ÊÇÔÚÍâÍø£Á£ÄµÄÇé¿öÏ£¬Äܹ»µÇ½ºǫ́µÄÒ³Ãæ£¬Ò³ÃæÊÇ£Á£Ó£ÐÎļþ£®
µ«ÊÇÊäÈëÕʺźÍÃÜÂëµÄʱºò£¬ÍøÒ³ÔËÐкܾö¼ ......
ÎÒÒª×öÒ»¸öÏÂÀ¿ò ÄÚÈÝÊÇ56¸öÃñ×å
¿ÉÊÇÏÂÀ¿òµÄÄÚÈÝ ÎÒÖ»»á
<select name="sex">
<option value="ÄÐ" selected>ÄÐ < ......