<%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%>
<%
//定义数据库环境变量
function sys_conf() {
this.dbuser = "sa";
this.dbpwd = "12345678";
this.dbname = "bookshop";
this.dbhost = "(local)";
}
%>

<!--#Include file="sys_conf.asp"-->
<%
/*----------------------------------------------*/
//数据库类database
//参数 : 无
/*----------------------------------------------*/
function database() {
       //建立数据库环境变量对象
       var sys_conf_obj = new sys_conf();
       //私有属性
       var host = sys_conf_obj.dbhost;
       var user = sys_conf_obj.dbuser;
       var pwd = sys_conf_obj.dbpwd;
       var name = sys_conf_obj.dbname;
       //公共属性
       this.conn = "";
       this.rs = "";
      
       /*----------------------------------------------*/
       //公共方法:connection()
       //参数 : 无
       //作用 : 建立数据库连接
       //返回值:无
       /*----------------------------------------------*/
       this.connection = function() {
              try {
                     this.conn = Server.CreateObject("ADODB.CONNECTION");
                     this.conn.open("PROVIDER=SQLOLEDB.1;Data Source=" + host + ";Initial Catalog=" + name + ";Persist Security Info=True;User ID=" + user + ";Password=" + pwd + ";Connect Timeout=30");
                     if(this.conn.state == 1) {
                            this.rs = Server.CreateObject("ADODB.RECORDSET");
                            this.rs.ActiveConnection = this.conn;
                     }
              }

              catch(e) {
                     this.conn.close();
                     this.conn = null;
                     Response.Write ("The database connection makes a mistake, please inspect connects the string.");
                     Response.End();
              }
       }
      
       /*----------------------------------------------*/
       //公共方法:create_rs()
       //作用 : 创建记录集对象
       //返回值:无
       /*----------------------------------------------*/
       this.create_rs = function() {
                     this.rs = Server.CreateObject("ADODB.RECORDSET");
                     this.rs.ActiveConnection = this.conn;
       }

       /*----------------------------------------------*/
       //公共方法:close_rs()
       //作用 :释放记录集对象
       //返回值:无
       /*----------------------------------------------*/
       this.close_rs = function() {
                     this.rs.close();
                     this.rs = null;
       }

       /*----------------------------------------------*/
       //公共方法:close_database()
       //参数 : 无
       //作用 : 释放数据库连接对象
       //返回值:无
       /*----------------------------------------------*/
       this.close_database = function() {
              this.conn.close();
              this.conn = null;
       }
      
       /*----------------------------------------------*/
       //公共方法:query()
       //参数 : sql - sql语句 max - 最大记录数
       //作用 : 将记录集对象转换为二维数组
       //返回值:记录集数组
       /*----------------------------------------------*/
       this.query = function(sql,max) {
              var i,j,fieldslen,len,vdata,data=[],sp;
              this.rs.Open(sql),this.conn,1,1;
              if(this.rs.EOF || this.rs.BOF) {
                     this.close_rs();
                     return null;
              } else {
                     vdata = this.rs.GetRows().toArray();
                     //获取数据表的字段数
                     fieldslen = this.rs.fields.count;
                     this.close_rs();
                     //开始转换数组
                     //得到记录数
                     len = vdata.length/fieldslen;
                     if(typeof(max) == "undefined") {
                            //遍历所有记录
                            //i：记录号 j：字段号
                            for(i=0;i<len;i++) {
                                   data[i] = new Array();
                                   //指针指向下一条记录的首字段
                                   sp = i * fieldslen;
                                   for(j=0;j<fieldslen;j++)
                                          data[i][j] = vdata[sp+j];
                            }
                     }else{
                            //显示指定的记录数
                            for(i=0;i<max;i++) {
                                   if(i>=len) break;
                                   data[i] = new Array();
                                   //指针指向下一条记录的首字段
                                   sp = i * fieldslen;
                                   for(j=0;j<fieldslen;j++)
                                          data[i][j] = vdata[sp+j];
                            }
                     }
                     return data;
              }
       }

}

%>

<!--#Include file="class_database.asp"-->
<%
var database_obj = new database();

database_obj.connection();

str_sql = "Select CourseID,CourseName,UpdateTime,CommDateTime,Comm,Hit From Course order by UpdateTime Desc";

var tmp_arr = database_obj.query(str_sql);
if(!tmp_arr) {
      Response.Write("no data...");
} else {
// 循环输出数据
for(var y=0;y<tmp_arr.length;y++) {

    // 注意，数组下标从0开始

    // 显示数据库中数据

    Response.Write("CourseID: "+tmp_arr[y][0]+", CourseName: "+tmp_arr[y][1] + ",UpdateTime: "+tmp_arr[y][2]);

}
}

database_obj.close_database();

%>