天狼星

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%>
<% Response.Charset="utf-8"; %>
<% Session.CodePage=65001; %>

<%
//程序全局变量和初始化
//sql_connection("cnspica","sa","cnspica");
//access_connection("cnspica.mdb");

//conn定义为全局变量
var conn;

//定义access数据库连接
function access_connection(database){
try {
    conn = Server.CreateObject("ADODB.Connection");
    conn.open("driver={Microsoft Access Driver (*.mdb)};DBQ="+Server.MapPath(""+database+""));
    }
    catch(e){
    Response.Write(e.description);
    }
}

//定义sql数据库连接
function sql_connection(database,username,password){
try {
    conn = Server.CreateObject("ADODB.Connection");
    conn.open("Provider=SQLOLEDB;Server=127.0.0.1;Database="+database+";UID="+username+";PWD="+password+"");
    }
    catch(e){
    Response.Write(e.description);
    }
}

//定义connection数据库关闭
function connection_close(){
try{
    conn.close;
    conn=null;
    rs=null;
    }
    catch(e){
    Response.Write(e.description);
    }
}

//定义sql数据库操作
function get_data(sql){
try{
    var rs = Server.CreateObject("ADODB.RecordSet");
    rs.open(sql,conn,3,2);
    return(rs);
    }
    catch(e){
    Response.Write(e.description);
    }
}

//数据过滤
function conversion_content(content){
try{
    content=content.replace(/>/g,">");
    content=content.replace(/</g,"<");
    content=content.replace(/\"/g,""");
    content=content.replace(/\’/g,"´");
    content=content.replace(/\r/g,"<br />");
    content=content.replace(/\s/g," ");
    return(content);
    }
    catch(e){
    Response.Write(e.description);
    }
}

function out_table(sql){        
    var rs = get_data(sql);
    out_string="<table width=\"384\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n";
    out_string+="\t<tr>\n";
    for(var i=1;i<rs.Fields.Count;i++){out_string+="\t\t<td>"+rs(i).name+"</td>\n"}
    out_string+="\t</tr>\n";
    while(!rs.eof && !rs.bof){
    out_string+="\t<tr>\n";
    for(var i=1;i<rs.Fields.Count;i++){out_string+="\t\t<td><input type=\"text\" name=\""+rs(i).name+"\" value=\""+rs(i)+"\"></td>\n"}
    out_string+="\t</tr>\n";
    rs.MoveNext;
    }
    out_string+="</table>\n";
    Response.Write(out_string);
    connection_close();
    }

%>