<html> <meta http-equiv="x-ua-compatible" content="ie=edge"> <meta charset="utf-8"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.1/css/bootstrap.css"> <head> <script> // 処理の開始 document.write("MySQL の処理を開始します<br>"); document.write("まず、オブジェクトを作成します<br>"); 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 += ";" 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(); document.write("処理終了<br>"); </script> </head> <body> </body> </html>