<% @Language="JavaScript" %>
<%
function OpenDB(sdbname)
{
/*
*--------------- OpenDB(sdbname) -----------------
* OpenDB(sdbname)
* 功能:打開數(shù)據(jù)庫(kù)sdbname,返回conn對(duì)象.
* 參數(shù):sdbname,字符串,數(shù)據(jù)庫(kù)名稱.
* 實(shí)例:var conn = OpenDB("database.mdb");
*--------------- OpenDB(sdbname) -----------------
*/
var connstr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(sdbname);
var conn = Server.CreateObject("ADODB.Connection");
conn.Open(connstr);
return conn;
}
var sResult;
var oConn = OpenDB("images/toupiao.mdb");
//特殊字符：+,%,&,=,?等的傳輸解決辦法.客戶端字符是經(jīng)過escape編碼的
//所以服務(wù)器端先要經(jīng)過unescape解碼.
//Update:2004-6-1 12:22
var sql = "select top 1 * from toupiao ";
var rs = oConn.Execute(sql);
//一條記錄用"###"隔開.每列數(shù)據(jù)用"@@@"隔開. 這是以只有兩個(gè)列數(shù)據(jù)的情況.
sResult= rs("piaosh").Value 
Response.Write(escape(sResult));
%>