asp Êý¾Ý²éѯÁ½ÖÖ·½Ê½µÄ×ܽá
µÚÒ»ÖÖ£º
'ʹÓÃÊý¾Ý¿âÁ¬½Ó¶ÔÏó²éѯÊý¾Ý¼¯¶ÔÏó£¬Óà set±äÁ¿½ÓÊÕ¡£
set rset1 = conn.execute("select * from productType where id="&request("id"))
'±íʾֻÄÜÈ¡³ö½á¹û¼¯ÀïÃæµÄÖµ£¬µ«ÊDz»ÄÜÈ¡µ½×ܵÄÌõÊýÖ®ÀàµÄ¡£¡£¡£
set rset2 = conn.execute("select top 8 * from productType where typeId="&request("id")&" order by id")
µÚ¶þÖÖ£º
'±íʾµÄÊÇ¿ÉÒÔÈ¡½á¹û¼¯¡¢¿ÉÒÔÈ¡µ½×ܵÄÌõÊý£¬±ÈÈç·ÖÒ³
'set rset2=server.createobject("adodb.recordset") =========´´½¨Ò»¸ö¿ÉÒÔÓÃÓÚ·ÖÒ³µÈ¹¦ÄܵĽá¹û¼¯¶ÔÏó¡£°üº¬ÓÐһЩÊôÐԺͷ½·¨
'rset2.open "select top 8 * from productType where typeId="&request("id")&" order by id",conn,1,1 ====µ÷ÓÃÕâ¸ö½á¹û¼¯¶ÔÏóÖ´ÐÐopen·½·¨£¬Ê¹ÓÃÊý¾Ý¿âÁ¬½Ó²éѯÊý¾Ý£¬²¢·µ»ØÒ»¸ö·â×°ºÃµÄ½á¹û¶ÔÏó¡£
Ïà¹ØÎĵµ£º
ĿǰÔÚInternetÉϹ㷺ʹÓõĺǫ́¼¼ÊõÖÖÀà·±¶à£¬Ó¦ÓñȽϹ㷺µÄÓÐCGI£¬ASP£¬PHP£¬JSP/JavaServlet£¬ColdFusionµÈ¡£ÔÚÕâÒ»½ÚÀÖ÷Òª½éÉܼ¸ÖÖÔÚ¹úÄÚÓ¦ÓñȽϹ㷺µÄºǫ́ÓïÑÔ¡£
¡¡¡¡CGI£¬È«³ÆÎªCommon Gateway Interface
¡¡¡¡CGI¾ÍÊǹ«¹²Íø¹Ø½Ó¿Ú (Common Gateway Interface) µÄËõд¡£ËüÊÇ×îÔç±»ÓÃÀ´½¨Á¢¶¯Ì¬ÍøÕ¾µÄºǫ́¼¼Êõ ......
Êé½ÓÉÏÎÄ£¬Ö±½Ó´Ó×Ö·û´®·µ»Ø¶ÔÏ󣬴˴θüУ¬ÊµÏÖÁË·µ»Ø¶ÔÏóµÄ×Ô¶¯»¯£¬ÎÞÐèÔÚÉùÃ÷ʵÌåÀà¡£µ«Õâ¸öº¯ÊýÖ»ÊʺÏÒ³ÃæÉùÃ÷¼¸¸ö¶ÔÏó£¬ÅúÁ¿¶ÔÏ󣬱ÈÈ缸°Ù¸ö£¬ÍƼöʹÓÃÏÂÒ»ÎÄËùʹÓú¯Êý¡£
º¯ÊýºÜ¼òµ¥£¬²»½âÊÍ£¬Ö±½ÓÌù´úÂë¡£
option explicit
'·µ»Ø¶ÔÏóµÄº¯Êý
function getObj(byval str)
dim classname,itemlist,i
cl ......
Ò»:
1 ÃÜÂëÊÇÊý¾Ý¿âÃÜÂ룺
ÉèÖÃÊý¾Ý¿âÃÜÂ룬´ò¿ªÃÜÂëΪ555´ò¿ªÊ±ÐèҪʹÓÃ
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1.mdb;User ID=admin;Password=;Jet OLEDB:Database Password=555"
2 Óû§×飺
Óû§ÃûΪ admin ÃÜÂëΪ rr Óû§×éÎļþΪ c:\system.mdw£¬´ò¿ªÊ±ÐèҪʹÓÃ
"Provider=Microsoft.Jet.OLEDB.4.0 ......
<%@ Page Language="C#" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server"> </script>
<html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server">
<title ......
¡¡¡¡1. Ö»·µ»Øµ¥Ò»¼Ç¼¼¯µÄ´æ´¢¹ý³Ì
¡¡¡¡¼ÙÉèÓÐÒÔÏ´洢¹ý³Ì(±¾ÎĵÄÄ¿µÄ²»ÔÚÓÚ½²ÊöT-SQLÓï·¨£¬ËùÒÔ´æ´¢¹ý³ÌÖ»¸ø³ö´úÂ룬²»×÷˵Ã÷)£º
/*SP1*/
CREATE PROCEDURE dbo.getUserList
as
set nocount on
begin
select * from dbo.[userinfo]
end
go
¡¡¡¡ÒÔÉÏ´æ´¢¹ý³ÌÈ¡µÃuserinfo±íÖеÄËùÓмǼ£¬·µ»ØÒ»¸ö¼Ç¼¼¯¡£Í¨¹ ......