<html> <meta charset="utf-8"> <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 * from 社員マスタ where 社員コード"; rs.Open( query, cn ); var text = ""; document.write("<table>"); 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>