🍓 列名の配列を取得する関数を追加(mysql-8-access.js)

var cn = new ActiveXObject("ADODB.Connection");
var rs = new ActiveXObject("ADODB.Recordset");
 
var strDriver = "{MySQL ODBC 5.3 Unicode Driver}"
var strServer = "localhost"
var strDb = "lightbox"
var strUser = "root"
var strPass =  ""
 
var connectionString = "Provider=MSDASQL;Driver=" + strDriver;
connectionString += ";Server=" + strServer
connectionString += ";Database=" + strDb
connectionString += ";UID=" + strUser
connectionString += ";PWD=" + strPass
connectionString += ";"
 
function getFieldName( tableName ) {
 
    // 接続
    cn.Open( connectionString );
    var query = "select * from " + tableName;
 
    rs.Open( query, cn );
 
    var count = rs.Fields.Count;
 
    var fieldName = [];
 
    for( var i = 0; i < count; i++ ) {
        fieldName[i] = rs.Fields(i).Name;
    }
 
    // 閉じる
    rs.Close();
    // 閉じる
    cn.Close();
 
    return fieldName;
 
}
 
// 列数を取得
function getFieldCount( tableName ) {
 
    // 接続
    cn.Open( connectionString );
    var query = "select * from " + tableName;
 
    rs.Open( query, cn );
 
    var count = rs.Fields.Count;
 
    // 閉じる
    rs.Close();
    // 閉じる
    cn.Close();
 
    return count;
 
}
 
function loadMySQL() {
 
     
    document.write(connectionString + "<br>");
     
    // 接続
    cn.Open( connectionString );
     
    var query = "select 社員コード,氏名,フリガナ,所属,性別,給与,手当,管理者,DATE_FORMAT(生年月日,'%Y-%m-%d') as 生年月日 from 社員マスタ";
      
    rs.Open( query, cn );
     
    var text = "";
     
    document.write("<table class='table table-hover'>");
     
    while ( !rs.EOF ) {
     
        document.write("<tr>");
     
        for( var i = 0; i < rs.Fields.Count; i++  ) {
            document.write( "<td>" + rs.Fields( i ).Value + "</td>" );
        }
     
        document.write("</tr>");
     
        rs.MoveNext();
    }
     
    document.write("</table>");
     
     
    // 閉じる
    rs.Close();
    // 閉じる
    cn.Close();
 
}