Ӧ
COMPUTER APPLICATIONS
1999 19 9 Vol.19 No.9 1999



ASP/ADONTݿ
֡ƽ
ժҪĽNTWebϣIISںASPADOASPADOϣʵNTݿʵķ
ؼʡIIS, ASP, ADO, ODBC, SQL
1
ڿͻʹͨͨInternetIntranetݿеݣжֽ紫ͳCGIʽڽϳADCʽIDCʽȡMicrosoft˾ƳĻASP/ADOݿNTݿơ
2ASPADOݿƷ
ASPǶ̬ҳдںMicrosoft˾IIS 3.0ϰ汾УMicrosoft˾ΪWebһŵġҪWebӦûASP ṩһ˵ĽűдHTMLҳűActiveXж̬ĻWeb ĹǿӦó
ADOλODBCOLE ݿ֮ϵĸܵݷʽӿڡṩ˿ŵݲģͣԱʹκԺͳһıģʽODBCOLE-DBݵݿ⣬Access SQLOracleInformixFoxProȡASPADOϣṩݿϢҳݣִͨSQLûнݵĲѯ롢޸ġɾ͸µȲVBScriptJScriptȽűݿķʣʵֲѯʾȹܡ
ASPADOϣʵNTݿʵB/SṹʵҲģʽC/Sһ֡ݿĻͼ1ʾ
ASPADOϣʵݿʵľ巽£
ȣѡһ֧ODBCݿ⣬AccessȣݿӦݱ
ΣԴDSNData Source Name£ѡ񡰿塱еODBCѡѡһDSNSystem DSNȻ󵥻ӡťѡӦݿѡһڡһԴԻԴѡӦʵݿɡDSNӦóݿ֮ڳзݿʱDSNϵͳͨDSNʵݿ⡣

NTݿʵĻ
ţݿӣݿ⡣ʹáSet MyConn = Server.CreateObject ("ADODB.Connection")䴴ӣʹáMyConn.Open "Դ"ݿ⣬ͬʱָʸݿû롣£MyConn.Open "Դ" "username","password"
Ȼִݿķʲڼ򵥵SQLֱʹ䡰Set RS = MyConn.Execute("SQL")ʵ֣ڸӵSQLַͨ&Ҳôʵ֡
ݿĹرպӵĹرաֱͨ򵥵ʵ֣RS.CloseMyConn.Close
3ʵ
InternetWWWչԶ̽(Distance Education)ǵչһȫµĿ⣬ǶԴͳشºͲ䡣Զ̽漰ҪļЭͬʽȡASPADOеҪݿиЧ̬ʽʵĲӦģ飬߱ɼѯȷǳʺϡ棬߱ΪҪܸƷ
ʹWebAccess97ݿBMXT.MDBݱBMBֶΣxm char(8),xb char(2),nl number(2),bmzy char(40),byxx char(40),lxdz char(40)bz char10,bmrq date()ԴstudentsASPļbmxt.asp
bmxt.aspĲԴ:
<!-- ƿͻ˵ -->
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=gb2312-80">
<meta name="GENERATOR" 
content="Microsoft FrontPage Express 2.0">
<title>ϱϵͳ</title>
<bgsound src="TheMicrosoftSound.wav" loop="1">
</head>
<body background="file:///C:/WINDOWS/Backgrnd.gif"
bgcolor="#FFFFFF" topmargin="4" leftmargin="15">
<p align="center"><font color="#FF0000" size="7" face=""><strong>ϱϵͳ</strong></font></p>
<p><font color="#008000" size="4" face="塪GB2312"><em><strong><u>
Ϣ</u></strong></em></font></p>
<form action="bmxt.asp" method="post">
<p align="left"><font color="#FF00FF">
</font><input type="text" size="10" 
name="T1"><font color="#FF00FF">
רҵ<input type="text" size="17" name="T1"></font></p>
<p align="left"><font color="#FF00FF">
Ա<select name="D1" size="1">
<option selected></option> 
<option>Ů</option>
</select>
ҵѧУ<input type="text" size="22" name="T1"></font></p>
<p align="left"><font color="#FF00FF">
䣺<input type="text" size="5" name="T1"> 
ͨѶַ</font><input type="text" size="22" name="T1"></p>
<p align="center"><font color="#FF00FF">
<input type="submit" name="B1" value="ύ"> 
<input type="reset" name="B2" value="ԭ"><br>
</font></p>
</form>
<! -- Web˴ -- >
<%
if request.form("xm")<>"" and request.form("xb")<>"" and request.form("nl") <>"" and request.form("bmzy")<>""
and request.form("lxdz")<>"" then
set MyConn=Server.CreateObject("ADODB.Connection")
MyConn.Open "Students","",""
SQL="insert into bmb(xm,xb,nl,bmzy,byxx,lxdz,bmrq) 
values("&request.form ("xm")&",
"&request.form("xb")&" ,
"&request.form("nl")&",
"&request.form("bmzy")&","&request.form("byxx")&","&request.form("lxdz")&", 
"&request.form("&date()")&")"
set RS=MyConn.Execute(SQL)
response.write("ıǣ"&RS("ID1"))
Response.write("ıѽ!")
RS.close
MyConn.close
else
Response.write("дϢȫ,д!")
Response.end
end if
%>
</body>
</html>
߼飺ְ֡˶ʿоʦҪо򣺼缰Զ̽
ƽڡҪо򣺼硣
ߵλ֡ʦѧѧ.ɳ (410081
ƽϴѧϵ.ɳ 410082
ο
1ݡ. NT̬վ.ѧ磬1997
2ݡ÷.B/SṹĿƽ̨칹ݿϵͳ.ϵͳӦã1998;(8)
ո:1999-06-28(޸ĸ)
