01.
document.write(
"MySQL の処理を開始します<br>"
);
02.
03.
document.write(
"まず、オブジェクトを作成します<br>"
);
04.
05.
var
cn =
new
ActiveXObject(
"ADODB.Connection"
);
06.
var
rs =
new
ActiveXObject(
"ADODB.Recordset"
);
07.
08.
var
strDriver =
"{MySQL ODBC 5.3 Unicode Driver}"
09.
var
strServer =
"localhost"
10.
var
strDb =
"lightbox"
11.
var
strUser =
"root"
12.
var
strPass =
""
13.
14.
var
connectionString =
"Provider=MSDASQL;Driver="
+ strDriver;
15.
connectionString +=
";Server="
+ strServer
16.
connectionString +=
";Database="
+ strDb
17.
connectionString +=
";UID="
+ strUser
18.
connectionString +=
";PWD="
+ strPass
19.
connectionString +=
";"
20.
21.
document.write(connectionString +
"<br>"
);
22.
23.
24.
cn.Open( connectionString );
25.
26.
var
query =
"select 社員コード,氏名,フリガナ,所属,性別,給与,手当,管理者,DATE_FORMAT(生年月日,'%Y-%m-%d') as 生年月日 from 社員マスタ"
;
27.
28.
rs.Open( query, cn );
29.
30.
var
text =
""
;
31.
32.
document.write(
"<table class='table table-hover'>"
);
33.
34.
while
( !rs.EOF ) {
35.
36.
document.write(
"<tr>"
);
37.
38.
for
(
var
i = 0; i < rs.Fields.Count; i++ ) {
39.
document.write(
"<td>"
+ rs.Fields( i ).Value +
"</td>"
);
40.
}
41.
42.
document.write(
"</tr>"
);
43.
44.
rs.MoveNext();
45.
}
46.
47.
document.write(
"</table>"
);
48.
49.
50.
51.
rs.Close();
52.
53.
cn.Close();
54.
55.
56.
document.write(
"処理終了<br>"
);