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.<script src="mysql-9-access.js?002"></script>
09.
10.<head>
11.<script>
12.
13.var tableName = "社員マスタ";
14.
15.$(function(){
16.
17. $("#btn").on("click", function(){
18.
19. var value = getFieldValue( tableName );
20. for( var i = 1; i < count; i++ ) {
21.
22. $("#fld" + (i+1) ).val( value[i] );
23.
24. }
25.
26. });
27.
28.
29. var count = getFieldCount( tableName );
30. var name = getFieldName( tableName );
31.
32. console.dir(name);
33.
34. for( var i = 0; i < count; i++ ) {
35.
36. $("<span>")
37. .appendTo( $("body") )
38. .text(name[i])
39. .css( {
40. "display": "inline-block",
41. "width": "120px"
42. })
43. .prop( {
44. "id" : "col" + (i+1)
45. })
46. ;
47.
48. $("<input>")
49. .appendTo( $("body") )
50. .css( {
51. "background-color": "skyblue",
52. "color": "white"
53. })
54. .prop( {
55. "value": "",
56. "id" : "fld" + (i+1)
57. })
58. ;
59.
60. $("<br>")
61. .appendTo( $("body") )
62. ;
63.
64. }
65.
66.});
67.
68.
69.</script>
70.</head>
71.<body>
72.
73.<input type="button" id="btn" value="参照" style="position:absolute;left:500px;top:0px;">
74.
75.
76.
77.
78.</body>
79.</html>