01.<html>
02.
03.<meta http-equiv="x-ua-compatible" content="ie=edge">
04.<meta charset="utf-8">
05.<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
06.<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.1/css/bootstrap.css">
07.
08.<head>
09.<script>
10.// 処理の開始
11.
12.document.write("MySQL の処理を開始します<br>");
13.
14.document.write("まず、オブジェクトを作成します<br>");
15.
16.var cn = new ActiveXObject("ADODB.Connection");
17.var rs = new ActiveXObject("ADODB.Recordset");
18.
19.var strDriver = "{MySQL ODBC 5.3 Unicode Driver}"
20.var strServer = "localhost"
21.var strDb = "lightbox"
22.var strUser = "root"
23.var strPass = ""
24.
25.var connectionString = "Provider=MSDASQL;Driver=" + strDriver;
26.connectionString += ";Server=" + strServer
27.connectionString += ";Database=" + strDb
28.connectionString += ";UID=" + strUser
29.connectionString += ";PWD=" + strPass
30.connectionString += ";"
31.
32.document.write(connectionString + "<br>");
33.
34.// 接続
35.cn.Open( connectionString );
36.
37.var query = "select 社員コード,氏名,フリガナ,所属,性別,給与,手当,管理者,DATE_FORMAT(生年月日,'%Y-%m-%d') as 生年月日 from 社員マスタ";
38.
39.rs.Open( query, cn );
40.
41.var text = "";
42.
43.document.write("<table class='table table-hover'>");
44.
45.while ( !rs.EOF ) {
46.
47. document.write("<tr>");
48.
49. for( var i = 0; i < rs.Fields.Count; i++ ) {
50. document.write( "<td>" + rs.Fields( i ).Value + "</td>" );
51. }
52.
53. document.write("</tr>");
54.
55. rs.MoveNext();
56.}
57.
58.document.write("</table>");
59.
60.
61.// 閉じる
62.rs.Close();
63.// 閉じる
64.cn.Close();
65.
66.
67.document.write("処理終了<br>");
68.
69.</script>
70.</head>
71.<body>
72.
73.
74.
75.
76.
77.</body>
78.</html>