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(); }