ASPÊý¾ÝÁ¬½Ó
1. ÓÃDSNÁ¬½Ó²¢ÇÒûÓÐÓû§ÃûºÍÃÜÂ룺
<%
set conn = Server.CreateObject("ADODB.Connection")
conn.open "YourDSNName"
%>
ÓÃDSNÁ¬½Ó²¢ÇÒÓÐÓû§ÃûºÍÃÜÂ룺
<%
set conn = Server.CreateObject("ADODB.Connection")
conn.open "YourDSNName","username","password"
%>
2. ÓÃʵ¼ÊµÄÊý¾Ý¿â¾ø¶Ô·¾¶Á¬½Ó£º
<%
Set conn = Server.CreateObject("ADODB.Connection")
Strconn="DRIVER={Microsoft Access Driver (*.mdb)}; "
Strconn=Strconn & "DBQ=e:\yanhang\database.mdb"
conn.Open Strconn
%>
ÓÃʵ¼ÊµÄÊý¾Ý¿âÏà¶Ô·¾¶Á¬½Ó£º
"provider=microsoft.jet.OLEDB.4.0;Data source="&server.mappath("/admin/#Database.mdb")
<%
Set conn = Server.CreateObject("ADODB.Connection")
Strconn="DRIVER={Microsoft Access Driver (*.mdb)}; "
Strconn=Strconn & "DBQ=" & Server.MapPath("/database/yanhang.mdb")
conn.Open Strconn
%>
¶þ¡¢MS SQL ServerÊý¾Ý¿âÁ¬½Ó
ÓÃDSNÁ¬½Ó£º
<%
set conn = Server.CreateObject("ADODB.Connection")
conn.open "DSN=MyDSN;UID=user;PWD=password;DATABASE=databasename"
%>
²»ÓÃDSNÁ¬½Ó£º
<%
Set conn = Server.CreateObject("ADODB.Connection")
DSNtemp="DRIVER={SQL Server};SERVER=ServerName;UID=USER;PWD=password;DATABASE=databasename"
conn.open DSNtemp
%>
Èý¡¢FoxProÊý¾Ý¿âÁ¬½Ó
<%
Set Conn = Server.CreateObject("ADODB.connection")
ConnStr= "Driver=Microsoft Visual Foxpro Driver; UID=userID;SourceType=DBC;SourceDB=C:\yanhang\database.dbc"
Conn.Open ConnStr
%>
ËÄ¡¢OracleÊý¾Ý¿âÁ¬½Ó£º
<%
set conn=server.createobject("adodb.connection")
conn.cursorlocation=adUseClient
DSNTemp="Provider=MSDAORA.1;Password=xxxxx;User ID=yanhang;Data Source=xxx.world"
conn.open DSNtemp
%>
Ïà¹ØÎĵµ£º
×öÍøÕ¾Óë¸ã°²È«Ò»°ã¶¼Àë²»¿ªÈ¨ÏÞ·ÖÅä,ÍøÕ¾È¨ÏÞÒ»°ã¶¼Ö±½ÓÉèÖÃÕ¾µãËùÔÚµÄÐéÄâĿ¼µÄ,Ò²¾ÍÊÇÔÚÐéÄâĿ¼µÄ°²È«ÀïÌí¼ÓinternetÀ´±öÕË»§,²¢·ÖÅä³ýÍêÈ«¿ØÖÆÍâµÄËùÓÐȨÏÞ;Èç¹ûÊÇ.NET,»¹±ØÐë¸øASP.NETÓû§ÅäÖóýÍêÈ«¿ØÖÆÒÔÍâµÄȨÏÞ!
Ò»°ãÇé¿öÏÂ,ÕâÑù¾ÍOKÁË,·þÎñÆ÷ÉϵÄÒ»°ãÍøÕ¾¶¼¿ÉÒÔÕý³£ÔËÐÐÁË!µ«ÏÖÔÚÎÒ·¢ÏÖ:C\WINDOWS ......
<%
'ÒÔϲ¿·ÖÊÇÑéÖ¤Ìá½»µÄpageÊÇ·ñΪºÏ·¨µÄ²ÎÊý
'Õⲿ·Ö×îºÃÅжÏÒ»ÏÂÌá½»µÄ²ÎÊýÊÇ·ñΪÊýÖµ×Ö·û
dim page
page=Trim(request("page"))
If page="" Then
page=1
Elseif CInt(page)<=0 then
page=1
else
page=CInt(page)
End If
'½øÐвéѯ£¬È¡³öÒªÏÔʾµÄ¼Ç¼
str=rs1("content")
'°Ñ³ö ......
<Html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Éú³ÉWordÎĵµ</title>
</head>
<script ......
³ý·ÇÄúÒÔϵͳÕÊ»§µÄÉí·ÝµÇ½µ½·þÎñÆ÷£¨ÔÚä¯ÀÀÆ÷»·¾³ÖÐÒ²ÊÇ¿ÉÒÔʵÏÖ£©£¬»òÕßÖ÷»ú¶Ë½øÐÐÁËÁ¼ºÃµÄȨÏÞÅäÖ㬷ñÔò±¾ÎÄÉæ¼°µÄ¹¦ÄÜÊǺÜÄÑʵÏֵġ£ÒòΪÎÒÃÇͨ¹ýiis·ÃÎÊij¸öÒ³ÃæÊ±£¬Ò»°ãÊÇiisÄäÃûÕÊ»§µÄÉí·Ý£¬ÔÚ´ó¶àÊýÇé¿öÏ£¬aspµÄWScript.ShellÊDZ»½ûÓõģ¬ÒòΪËüÓкܴóµÄ°²È«Òþ»¼¡£
¡¡¡¡ÒªÏëʵÏÖÕâÖÖ¹¦ÄÜ£¬Ê×ÏÈÒªµÃµ½Rar³ ......
ǰÁ½Ì죬¿Í»§ÐèÒªÌí¼ÓÏÂÀ²Ëµ¥£¬ÎÒÔεĺܣ¬ºÜ¼òµ¥µÄÒ»¸öÎÊÌâ°ÑÎÒÓÕµ¼ÁËÁ½ÈýÌ죬ºóÀ´ÐÑÎò¹ýÀ´£¬ÕæÏë´ò×Ô¼º¡£
֮ǰÎÒҲʹÓùýdivÌ×divµÄ·½·¨£¬Ö»Òª¿ØÖÆËûÃǵÄλÖþͿÉÒÔÁË£¬µ«Õâ´ÎÎÒûÓУ¬Ê¹ÓõÄÔÚ±í¸ñʽÌ×div£¬×Ô¼º×ÁÄ¥Á˰ëÌ죬ÒѾÍü¼ÇÁËdivËùÏÔʾµÄÊÇÏà¶Ô ......