01.
<html>
02.
<meta charset=
"utf-8"
>
03.
<head>
04.
<script>
05.
06.
07.
document.write(
"MySQL の処理を開始します<br>"
);
08.
09.
document.write(
"まず、オブジェクトを作成します<br>"
);
10.
11.
var
cn =
new
ActiveXObject(
"ADODB.Connection"
);
12.
var
rs =
new
ActiveXObject(
"ADODB.Recordset"
);
13.
14.
var
strDriver =
"{MySQL ODBC 5.3 Unicode Driver}"
15.
var
strServer =
"localhost"
16.
var
strDb =
"lightbox"
17.
var
strUser =
"root"
18.
var
strPass =
""
19.
20.
var
connectionString =
"Provider=MSDASQL;Driver="
+ strDriver;
21.
connectionString +=
";Server="
+ strServer
22.
connectionString +=
";Database="
+ strDb
23.
connectionString +=
";UID="
+ strUser
24.
connectionString +=
";PWD="
+ strPass
25.
connectionString +=
";"
26.
27.
document.write(connectionString +
"<br>"
);
28.
29.
30.
cn.Open( connectionString );
31.
32.
var
query =
"select * from 社員マスタ where 社員コード"
;
33.
34.
rs.Open( query, cn );
35.
36.
var
text =
""
;
37.
38.
document.write(
"<table>"
);
39.
40.
while
( !rs.EOF ) {
41.
42.
document.write(
"<tr>"
);
43.
44.
for
(
var
i = 0; i < rs.Fields.Count; i++ ) {
45.
document.write(
"<td>"
+ rs.Fields( i ).Value +
"</td>"
);
46.
}
47.
48.
document.write(
"</tr>"
);
49.
50.
rs.MoveNext();
51.
}
52.
53.
document.write(
"</table>"
);
54.
55.
56.
57.
rs.Close();
58.
59.
cn.Close();
60.
61.
62.
document.write(
"処理終了<br>"
);
63.
64.
</script>
65.
</head>
66.
<body>
67.
68.
69.
70.
71.
72.
</body>
73.
</html>