×÷ÕߣºÎ´Öª À´Ô´£ºÔ¹âÈí¼þÕ¾ ¼ÓÈëʱ¼ä£º2005-2-28¡¡Ô¹âÈí¼þÕ¾

aspÓësql server Êý¾Ý¿âµÄÁ¬½Ó
<%
'Á¬½ÓÊý¾Ý¿â¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª
set conn=server.createobject("adodb.connection")
Connstr="Provider=SQLOLEDB;Data Source=127.0.0.1;UID=sa;PWD=sa;DataBase=web"
'´ò¿ªÊý¾Ý¿â¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª
conn.open connstr 
'дÊý¾Ý²éѯÓï¾ä¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª
set rs=conn.execute("select * from asp where id>2")
'Êä³ö²éѯ½á¹û¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª
do until rs.eof
   response.write rs("id")&"<br>"
   response.write rs("name")&"<br>"
   rs.movenext
loop
%>
************************************
aspÓëaccess Êý¾Ý¿âµÄÁ¬½Ó
********************************
<% dim conn  
   dim connstr
   on error resume next
   connstr="DBQ="+server.mappath("login.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
   set conn=server.createobject("ADODB.CONNECTION")
   if err then
      err.clear
   else
        conn.open connstr
        if err then
           err.clear
        end if
   end if
set rs=conn.execute("select * from login_info where id>1")
do until rs.eof
  response.write rs("id")&"<br>"
  response.write rs("username")&"<br>"
  response.write rs("password")&"<br>"
  rs.Movenext
loop %>

*****************************************************
*****************************************************
<!--#include file="conn.asp"-->
<%
set rs=conn.execute("select * from login_info where id>2")
'set rs=server.createobject("adodb.recordset")
'sql="select * from login_info where id > ='1' "
'rs.open sql,conn,1,1
do until rs.eof
  response.write rs("id")&"<br>"
  response.write rs("username")&"<br>"
  response.write rs("password")&"<br>"
  rs.Movenext
loop
%>

**********************************************************
***********************************************************

Á¬½áÆäËûÊý¾Ý¿âµÄ·½·¨(*.dbf,*.txt,excel,foxproµÈ)    ----ÊÕ²Ø
2002-10-30 18:41:05   ä¯ÀÀ´ÎÊý:145 
 
'Á¬½ádbfÎļþ
<%
'  ½¨Á¢Connection  ¶ÔÏó
Set  conn  =  Server.CreateObject("ADODB.Connection")
Driver  =  "Driver={Microsoft  Visual  FoxPro  Driver};"
SourceType  =  "SourceType=DBF;"
DBPath  =  "SourceDB="  &  Server.MapPath(  "Dbf"  )

'  µ÷ÓÃOpen  ·½·¨Á¬½ÓÊý¾Ý¿â
conn.Open  Driver  &  SourceType  &  DBPath

Set  rs  =  Server.CreateObject("ADODB.Recordset")
'  ´ò¿ªÊý¾ÝÔ´£¬²ÎÊý¶þΪConnection¶ÔÏó
rs.Open  "Select  *  From  sample",  conn,  2,  2
%>
'Á¬½áfoxproÎļþ
<%
'  ½¨Á¢Connection  ¶ÔÏó
Set  conn  =  Server.CreateObject("ADODB.Connection")
Driver  =  "Driver={Microsoft  Visual  FoxPro  Driver};"
SourceType  =  "SourceType=DBC;"
DBPath  =  "SourceDB="  &  Server.MapPath(  "Dbf/Sample.dbc"  )

'  µ÷ÓÃOpen  ·½·¨Á¬½ÓÊý¾Ý¿â
conn.Open  Driver  &  SourceType  &  DBPath

Set  rs  =  Server.CreateObject("ADODB.Recordset")
'  ´ò¿ªÊý¾ÝÔ´£¬²ÎÊý¶þΪConnectionª«¶ÔÏó
rs.Open  "Select  *  From  sample",  conn,  2,  2
%>

'Á¬½áexcelÎļþ
<%
'  ½¨Á¢Connection¶ÔÏó
Set  conn  =  Server.CreateObject("ADODB.Connection")
Driver  =  "Driver={Microsoft  Excel  Driver  (*.xls)};"
DBPath  =  "DBQ="  &  Server.MapPath(  "Sample.xls"  )

'  µ÷ÓÃOpen  ·½·¨Á¬½ÓÊý¾Ý¿â
conn.Open  Driver  &  DBPath

Set  rs  =  Server.CreateObject("ADODB.Recordset")
'  ´ò¿ªÊý¾ÝÔ´£¬²ÎÊý¶þΪConnection¶ÔÏó
rs.Open  "Select  *  From  [³É¼¨µ¥$]",  conn,  2,  2
%>

'Á¬½átxtÎļþ
<%
'  «Ø½¨Á¢Connection  ¶ÔÏó
Set  conn  =  Server.CreateObject("ADODB.Connection")
Driver  =  "Driver={Microsoft  Text  Driver  (*.txt;  *.csv)};"
DBPath  =  "DBQ="  &  Server.MapPath(  "Text"  )

'  µ÷ÓÃOpen  ·½·¨Á¬½ÓÊý¾Ý¿â
conn.Open  Driver  &  DBPath

Set  rs  =  Server.CreateObject("ADODB.Recordset")
'  ´ò¿ªÊý¾ÝÔ´£¬²ÎÊý¶þΪConnectionª«¶ÔÏó
rs.Open  "Select  *  From  sample.txt",  conn,  2,  2
%>

SELECTÓï·¨£º(»ù±¾)

*************************************************************
**********************************************************
SELECT [DISTINCT]
(column [{, column } ] )| *
FROM table [ { , table} ]
[ORDER BY column [ASC] | [DESC
[{ , column [ASC] | [DESC } ] ]
WHERE predicate [ { logical-connector predicate } ];
------------------------------------------------------

INSERTÓï·¨£º

INSERT INTO table
[(column { ,column})]
VALUES
(columnvalue [{,columnvalue}]);
------------------------------------------------------

UPDATEÓï·¨£º

UPDATE table
SET column = value [{, column = value}]
[ WHERE predicate [ { logical-connector predicate}]];
------------------------------------------------------

DELETEÓï·¨£º

DELETE FROM table
[WHERE predicate [ { logical-connector predicate} ] ];
------------------------------------------------------

Ïà¹ØÈí¼þ£º