diff options
Diffstat (limited to 'doc/dao')
-rw-r--r-- | doc/dao/JDBC.html | 303 | ||||
-rw-r--r-- | doc/dao/ResultObject.html | 192 | ||||
-rw-r--r-- | doc/dao/SQLexecutor.html | 198 | ||||
-rw-r--r-- | doc/dao/class-use/JDBC.html | 86 | ||||
-rw-r--r-- | doc/dao/class-use/ResultObject.html | 85 | ||||
-rw-r--r-- | doc/dao/class-use/SQLexecutor.html | 64 | ||||
-rw-r--r-- | doc/dao/package-summary.html | 103 | ||||
-rw-r--r-- | doc/dao/package-tree.html | 77 | ||||
-rw-r--r-- | doc/dao/package-use.html | 85 |
9 files changed, 1193 insertions, 0 deletions
diff --git a/doc/dao/JDBC.html b/doc/dao/JDBC.html new file mode 100644 index 0000000..14950ae --- /dev/null +++ b/doc/dao/JDBC.html | |||
@@ -0,0 +1,303 @@ | |||
1 | <!DOCTYPE HTML> | ||
2 | <html lang="fr"> | ||
3 | <head> | ||
4 | <!-- Generated by javadoc (23) on Sat Feb 15 14:09:35 CET 2025 --> | ||
5 | <title>JDBC</title> | ||
6 | <meta name="viewport" content="width=device-width, initial-scale=1"> | ||
7 | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> | ||
8 | <meta name="dc.created" content="2025-02-15"> | ||
9 | <meta name="description" content="declaration: package: dao, class: JDBC"> | ||
10 | <meta name="generator" content="javadoc/ClassWriter"> | ||
11 | <link rel="stylesheet" type="text/css" href="../resource-files/jquery-ui.min.css" title="Style"> | ||
12 | <link rel="stylesheet" type="text/css" href="../resource-files/stylesheet.css" title="Style"> | ||
13 | <script type="text/javascript" src="../script-files/script.js"></script> | ||
14 | <script type="text/javascript" src="../script-files/jquery-3.7.1.min.js"></script> | ||
15 | <script type="text/javascript" src="../script-files/jquery-ui.min.js"></script> | ||
16 | </head> | ||
17 | <body class="class-declaration-page"> | ||
18 | <script type="text/javascript">const pathtoroot = "../"; | ||
19 | loadScripts(document, 'script');</script> | ||
20 | <noscript> | ||
21 | <div>JavaScript is disabled on your browser.</div> | ||
22 | </noscript> | ||
23 | <header role="banner"> | ||
24 | <nav role="navigation"> | ||
25 | <!-- ========= START OF TOP NAVBAR ======= --> | ||
26 | <div class="top-nav" id="navbar-top"> | ||
27 | <div class="nav-content"> | ||
28 | <div class="nav-menu-button"><button id="navbar-toggle-button" aria-controls="navbar-top" aria-expanded="false" aria-label="Toggle navigation links"><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span></button></div> | ||
29 | <div class="skip-nav"><a href="#skip-navbar-top" title="Skip navigation links">Skip navigation links</a></div> | ||
30 | <ul id="navbar-top-firstrow" class="nav-list" title="Navigation"> | ||
31 | <li><a href="package-summary.html">Package</a></li> | ||
32 | <li class="nav-bar-cell1-rev">Class</li> | ||
33 | <li><a href="class-use/JDBC.html">Use</a></li> | ||
34 | <li><a href="package-tree.html">Tree</a></li> | ||
35 | <li><a href="../index-files/index-1.html">Index</a></li> | ||
36 | <li><a href="../search.html">Search</a></li> | ||
37 | <li><a href="../help-doc.html#class">Help</a></li> | ||
38 | </ul> | ||
39 | </div> | ||
40 | </div> | ||
41 | <div class="sub-nav"> | ||
42 | <div class="nav-content"> | ||
43 | <ol class="sub-nav-list"> | ||
44 | <li><a href="package-summary.html">dao</a></li> | ||
45 | <li><a href="JDBC.html" class="current-selection">JDBC</a></li> | ||
46 | </ol> | ||
47 | <div class="nav-list-search"> | ||
48 | <input type="text" id="search-input" disabled placeholder="Search" aria-label="Search in documentation" autocomplete="off"> | ||
49 | <input type="reset" id="reset-search" disabled value="Reset"> | ||
50 | </div> | ||
51 | </div> | ||
52 | </div> | ||
53 | <!-- ========= END OF TOP NAVBAR ========= --> | ||
54 | <span class="skip-nav" id="skip-navbar-top"></span></nav> | ||
55 | </header> | ||
56 | <div class="main-grid"> | ||
57 | <nav role="navigation" class="toc" aria-label="Table of contents"> | ||
58 | <div class="toc-header">Contents | ||
59 | <input type="text" class="filter-input" disabled placeholder="Filter" aria-label="Filter table of contents" autocomplete="off"> | ||
60 | <input type="reset" class="reset-filter" disabled value="Reset"> | ||
61 | </div> | ||
62 | <button class="hide-sidebar"><span>Hide sidebar </span>❮</button><button class="show-sidebar">❯<span> Show sidebar</span></button> | ||
63 | <ol class="toc-list"> | ||
64 | <li><a href="#" tabindex="0">Description</a></li> | ||
65 | <li><a href="#constructor-summary" tabindex="0">Constructor Summary</a></li> | ||
66 | <li><a href="#method-summary" tabindex="0">Method Summary</a></li> | ||
67 | <li><a href="#constructor-detail" tabindex="0">Constructor Details</a> | ||
68 | <ol class="toc-list"> | ||
69 | <li><a href="#%3Cinit%3E()" tabindex="0">JDBC()</a></li> | ||
70 | </ol> | ||
71 | </li> | ||
72 | <li><a href="#method-detail" tabindex="0">Method Details</a> | ||
73 | <ol class="toc-list"> | ||
74 | <li><a href="#getConnection()" tabindex="0">getConnection()</a></li> | ||
75 | <li><a href="#setStrUrl()" tabindex="0">setStrUrl()</a></li> | ||
76 | <li><a href="#setHost(java.lang.String)" tabindex="0">setHost(String)</a></li> | ||
77 | <li><a href="#setDBMS(java.lang.String)" tabindex="0">setDBMS(String)</a></li> | ||
78 | <li><a href="#setDbName(java.lang.String)" tabindex="0">setDbName(String)</a></li> | ||
79 | <li><a href="#setLogin(java.lang.String)" tabindex="0">setLogin(String)</a></li> | ||
80 | <li><a href="#setPassword(java.lang.String)" tabindex="0">setPassword(String)</a></li> | ||
81 | <li><a href="#setInfos(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String)" tabindex="0">setInfos(String, String, String, String, String)</a></li> | ||
82 | </ol> | ||
83 | </li> | ||
84 | </ol> | ||
85 | </nav> | ||
86 | <main role="main"> | ||
87 | <!-- ======== START OF CLASS DATA ======== --> | ||
88 | <div class="header"> | ||
89 | <h1 title="Class JDBC" class="title">Class JDBC</h1> | ||
90 | </div> | ||
91 | <div class="inheritance" title="Inheritance Tree"><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">java.lang.Object</a> | ||
92 | <div class="inheritance">dao.JDBC</div> | ||
93 | </div> | ||
94 | <section class="class-description" id="class-description"> | ||
95 | <div class="horizontal-scroll"> | ||
96 | <dl class="notes"> | ||
97 | <dt>Direct Known Subclasses:</dt> | ||
98 | <dd><code><a href="SQLexecutor.html" title="class in dao">SQLexecutor</a></code></dd> | ||
99 | </dl> | ||
100 | <hr> | ||
101 | <div class="type-signature"><span class="modifiers">public abstract class </span><span class="element-name type-name-label">JDBC</span> | ||
102 | <span class="extends-implements">extends <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">Object</a></span></div> | ||
103 | <div class="block">connexion avec JDBC pour utilisation par la classe fille: SQLexecutor, | ||
104 | les paramètres de connexion et les setters sont statiques</div> | ||
105 | </div> | ||
106 | </section> | ||
107 | <section class="summary"> | ||
108 | <ul class="summary-list"> | ||
109 | <!-- ======== CONSTRUCTOR SUMMARY ======== --> | ||
110 | <li> | ||
111 | <section class="constructor-summary" id="constructor-summary"> | ||
112 | <h2>Constructor Summary</h2> | ||
113 | <div class="caption"><span>Constructors</span></div> | ||
114 | <div class="summary-table two-column-summary"> | ||
115 | <div class="table-header col-first">Constructor</div> | ||
116 | <div class="table-header col-last">Description</div> | ||
117 | <div class="col-constructor-name even-row-color"><code><a href="#%3Cinit%3E()" class="member-name-link">JDBC</a>()</code></div> | ||
118 | <div class="col-last even-row-color"> </div> | ||
119 | </div> | ||
120 | </section> | ||
121 | </li> | ||
122 | <!-- ========== METHOD SUMMARY =========== --> | ||
123 | <li> | ||
124 | <section class="method-summary" id="method-summary"> | ||
125 | <h2>Method Summary</h2> | ||
126 | <div id="method-summary-table"> | ||
127 | <div class="table-tabs" role="tablist" aria-orientation="horizontal"><button id="method-summary-table-tab0" role="tab" aria-selected="true" aria-controls="method-summary-table.tabpanel" tabindex="0" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table', 3)" class="active-table-tab">All Methods</button><button id="method-summary-table-tab1" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab1', 3)" class="table-tab">Static Methods</button><button id="method-summary-table-tab2" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab2', 3)" class="table-tab">Instance Methods</button><button id="method-summary-table-tab4" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab4', 3)" class="table-tab">Concrete Methods</button></div> | ||
128 | <div id="method-summary-table.tabpanel" role="tabpanel" aria-labelledby="method-summary-table-tab0"> | ||
129 | <div class="summary-table three-column-summary"> | ||
130 | <div class="table-header col-first">Modifier and Type</div> | ||
131 | <div class="table-header col-second">Method</div> | ||
132 | <div class="table-header col-last">Description</div> | ||
133 | <div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code>protected <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.sql/java/sql/Connection.html" title="class or interface in java.sql" class="external-link">Connection</a></code></div> | ||
134 | <div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#getConnection()" class="member-name-link">getConnection</a>()</code></div> | ||
135 | <div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> | ||
136 | <div class="block">retourne une instance de Connection avec JDBC</div> | ||
137 | </div> | ||
138 | <div class="col-first odd-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code>static void</code></div> | ||
139 | <div class="col-second odd-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code><a href="#setDBMS(java.lang.String)" class="member-name-link">setDBMS</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> dbms)</code></div> | ||
140 | <div class="col-last odd-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"> </div> | ||
141 | <div class="col-first even-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code>static void</code></div> | ||
142 | <div class="col-second even-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code><a href="#setDbName(java.lang.String)" class="member-name-link">setDbName</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> dbName)</code></div> | ||
143 | <div class="col-last even-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"> </div> | ||
144 | <div class="col-first odd-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code>static void</code></div> | ||
145 | <div class="col-second odd-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code><a href="#setHost(java.lang.String)" class="member-name-link">setHost</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> host)</code></div> | ||
146 | <div class="col-last odd-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"> </div> | ||
147 | <div class="col-first even-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code>static void</code></div> | ||
148 | <div class="col-second even-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code><a href="#setInfos(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String)" class="member-name-link">setInfos</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> host, | ||
149 | <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> dbms, | ||
150 | <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> dbname, | ||
151 | <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> login, | ||
152 | <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> password)</code></div> | ||
153 | <div class="col-last even-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"> | ||
154 | <div class="block">donner tous les paramètres de connexion en une fois | ||
155 | il est également possible de les donner un par un avec les setters en finissant pas JDBC.setStrUrl()</div> | ||
156 | </div> | ||
157 | <div class="col-first odd-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code>static void</code></div> | ||
158 | <div class="col-second odd-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code><a href="#setLogin(java.lang.String)" class="member-name-link">setLogin</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> login)</code></div> | ||
159 | <div class="col-last odd-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"> </div> | ||
160 | <div class="col-first even-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code>static void</code></div> | ||
161 | <div class="col-second even-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code><a href="#setPassword(java.lang.String)" class="member-name-link">setPassword</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> motdepasse)</code></div> | ||
162 | <div class="col-last even-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"> </div> | ||
163 | <div class="col-first odd-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code>static void</code></div> | ||
164 | <div class="col-second odd-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code><a href="#setStrUrl()" class="member-name-link">setStrUrl</a>()</code></div> | ||
165 | <div class="col-last odd-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"> | ||
166 | <div class="block">génère l'url utilisée par le driver, | ||
167 | à n'exécuter que lorsque tous les paramètres ont été renseignés (en particulier dbname, login et password), | ||
168 | certains: host, dbms, strClassName et port ont des valeurs par défaut pour un serveur mysql sur localhost</div> | ||
169 | </div> | ||
170 | </div> | ||
171 | </div> | ||
172 | </div> | ||
173 | <div class="inherited-list"> | ||
174 | <h3 id="methods-inherited-from-class-java.lang.Object">Methods inherited from class java.lang.<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">Object</a></h3> | ||
175 | <code><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#clone()" title="class or interface in java.lang" class="external-link">clone</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#equals(java.lang.Object)" title="class or interface in java.lang" class="external-link">equals</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#finalize()" title="class or interface in java.lang" class="external-link">finalize</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#getClass()" title="class or interface in java.lang" class="external-link">getClass</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#hashCode()" title="class or interface in java.lang" class="external-link">hashCode</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#notify()" title="class or interface in java.lang" class="external-link">notify</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#notifyAll()" title="class or interface in java.lang" class="external-link">notifyAll</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#toString()" title="class or interface in java.lang" class="external-link">toString</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#wait()" title="class or interface in java.lang" class="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#wait(long)" title="class or interface in java.lang" class="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#wait(long,int)" title="class or interface in java.lang" class="external-link">wait</a></code></div> | ||
176 | </section> | ||
177 | </li> | ||
178 | </ul> | ||
179 | </section> | ||
180 | <section class="details"> | ||
181 | <ul class="details-list"> | ||
182 | <!-- ========= CONSTRUCTOR DETAIL ======== --> | ||
183 | <li> | ||
184 | <section class="constructor-details" id="constructor-detail"> | ||
185 | <h2>Constructor Details</h2> | ||
186 | <ul class="member-list"> | ||
187 | <li> | ||
188 | <section class="detail" id="<init>()"> | ||
189 | <h3>JDBC</h3> | ||
190 | <div class="horizontal-scroll"> | ||
191 | <div class="member-signature"><span class="modifiers">public</span> <span class="element-name">JDBC</span>()</div> | ||
192 | </div> | ||
193 | </section> | ||
194 | </li> | ||
195 | </ul> | ||
196 | </section> | ||
197 | </li> | ||
198 | <!-- ============ METHOD DETAIL ========== --> | ||
199 | <li> | ||
200 | <section class="method-details" id="method-detail"> | ||
201 | <h2>Method Details</h2> | ||
202 | <ul class="member-list"> | ||
203 | <li> | ||
204 | <section class="detail" id="getConnection()"> | ||
205 | <h3>getConnection</h3> | ||
206 | <div class="horizontal-scroll"> | ||
207 | <div class="member-signature"><span class="modifiers">protected</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.sql/java/sql/Connection.html" title="class or interface in java.sql" class="external-link">Connection</a></span> <span class="element-name">getConnection</span>() | ||
208 | throws <span class="exceptions"><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.sql/java/sql/SQLException.html" title="class or interface in java.sql" class="external-link">SQLException</a>, | ||
209 | <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/ClassNotFoundException.html" title="class or interface in java.lang" class="external-link">ClassNotFoundException</a></span></div> | ||
210 | <div class="block">retourne une instance de Connection avec JDBC</div> | ||
211 | <dl class="notes"> | ||
212 | <dt>Returns:</dt> | ||
213 | <dd>instance de Connection</dd> | ||
214 | <dt>Throws:</dt> | ||
215 | <dd><code><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.sql/java/sql/SQLException.html" title="class or interface in java.sql" class="external-link">SQLException</a></code> - en cas d'erreur de connexion</dd> | ||
216 | <dd><code><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/ClassNotFoundException.html" title="class or interface in java.lang" class="external-link">ClassNotFoundException</a></code> - pour Class.forName()</dd> | ||
217 | </dl> | ||
218 | </div> | ||
219 | </section> | ||
220 | </li> | ||
221 | <li> | ||
222 | <section class="detail" id="setStrUrl()"> | ||
223 | <h3>setStrUrl</h3> | ||
224 | <div class="horizontal-scroll"> | ||
225 | <div class="member-signature"><span class="modifiers">public static</span> <span class="return-type">void</span> <span class="element-name">setStrUrl</span>()</div> | ||
226 | <div class="block">génère l'url utilisée par le driver, | ||
227 | à n'exécuter que lorsque tous les paramètres ont été renseignés (en particulier dbname, login et password), | ||
228 | certains: host, dbms, strClassName et port ont des valeurs par défaut pour un serveur mysql sur localhost</div> | ||
229 | </div> | ||
230 | </section> | ||
231 | </li> | ||
232 | <li> | ||
233 | <section class="detail" id="setHost(java.lang.String)"> | ||
234 | <h3>setHost</h3> | ||
235 | <div class="horizontal-scroll"> | ||
236 | <div class="member-signature"><span class="modifiers">public static</span> <span class="return-type">void</span> <span class="element-name">setHost</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> host)</span></div> | ||
237 | </div> | ||
238 | </section> | ||
239 | </li> | ||
240 | <li> | ||
241 | <section class="detail" id="setDBMS(java.lang.String)"> | ||
242 | <h3>setDBMS</h3> | ||
243 | <div class="horizontal-scroll"> | ||
244 | <div class="member-signature"><span class="modifiers">public static</span> <span class="return-type">void</span> <span class="element-name">setDBMS</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> dbms)</span></div> | ||
245 | </div> | ||
246 | </section> | ||
247 | </li> | ||
248 | <li> | ||
249 | <section class="detail" id="setDbName(java.lang.String)"> | ||
250 | <h3>setDbName</h3> | ||
251 | <div class="horizontal-scroll"> | ||
252 | <div class="member-signature"><span class="modifiers">public static</span> <span class="return-type">void</span> <span class="element-name">setDbName</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> dbName)</span></div> | ||
253 | </div> | ||
254 | </section> | ||
255 | </li> | ||
256 | <li> | ||
257 | <section class="detail" id="setLogin(java.lang.String)"> | ||
258 | <h3>setLogin</h3> | ||
259 | <div class="horizontal-scroll"> | ||
260 | <div class="member-signature"><span class="modifiers">public static</span> <span class="return-type">void</span> <span class="element-name">setLogin</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> login)</span></div> | ||
261 | </div> | ||
262 | </section> | ||
263 | </li> | ||
264 | <li> | ||
265 | <section class="detail" id="setPassword(java.lang.String)"> | ||
266 | <h3>setPassword</h3> | ||
267 | <div class="horizontal-scroll"> | ||
268 | <div class="member-signature"><span class="modifiers">public static</span> <span class="return-type">void</span> <span class="element-name">setPassword</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> motdepasse)</span></div> | ||
269 | </div> | ||
270 | </section> | ||
271 | </li> | ||
272 | <li> | ||
273 | <section class="detail" id="setInfos(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String)"> | ||
274 | <h3>setInfos</h3> | ||
275 | <div class="horizontal-scroll"> | ||
276 | <div class="member-signature"><span class="modifiers">public static</span> <span class="return-type">void</span> <span class="element-name">setInfos</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> host, | ||
277 | <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> dbms, | ||
278 | <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> dbname, | ||
279 | <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> login, | ||
280 | <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> password)</span></div> | ||
281 | <div class="block">donner tous les paramètres de connexion en une fois | ||
282 | il est également possible de les donner un par un avec les setters en finissant pas JDBC.setStrUrl()</div> | ||
283 | <dl class="notes"> | ||
284 | <dt>Parameters:</dt> | ||
285 | <dd><code>host</code> - adresse du serveur</dd> | ||
286 | <dd><code>dbms</code> - obtenir le nom du driver et le numéro du port à partir du nom du SGBD</dd> | ||
287 | <dd><code>dbname</code> - de la base de données</dd> | ||
288 | <dd><code>login</code> - nom d'utilisateur</dd> | ||
289 | <dd><code>password</code> - mot de passe</dd> | ||
290 | </dl> | ||
291 | </div> | ||
292 | </section> | ||
293 | </li> | ||
294 | </ul> | ||
295 | </section> | ||
296 | </li> | ||
297 | </ul> | ||
298 | </section> | ||
299 | <!-- ========= END OF CLASS DATA ========= --> | ||
300 | </main> | ||
301 | </div> | ||
302 | </body> | ||
303 | </html> | ||
diff --git a/doc/dao/ResultObject.html b/doc/dao/ResultObject.html new file mode 100644 index 0000000..b4f4694 --- /dev/null +++ b/doc/dao/ResultObject.html | |||
@@ -0,0 +1,192 @@ | |||
1 | <!DOCTYPE HTML> | ||
2 | <html lang="fr"> | ||
3 | <head> | ||
4 | <!-- Generated by javadoc (23) on Sat Feb 15 14:09:35 CET 2025 --> | ||
5 | <title>ResultObject</title> | ||
6 | <meta name="viewport" content="width=device-width, initial-scale=1"> | ||
7 | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> | ||
8 | <meta name="dc.created" content="2025-02-15"> | ||
9 | <meta name="description" content="declaration: package: dao, class: ResultObject"> | ||
10 | <meta name="generator" content="javadoc/ClassWriter"> | ||
11 | <link rel="stylesheet" type="text/css" href="../resource-files/jquery-ui.min.css" title="Style"> | ||
12 | <link rel="stylesheet" type="text/css" href="../resource-files/stylesheet.css" title="Style"> | ||
13 | <script type="text/javascript" src="../script-files/script.js"></script> | ||
14 | <script type="text/javascript" src="../script-files/jquery-3.7.1.min.js"></script> | ||
15 | <script type="text/javascript" src="../script-files/jquery-ui.min.js"></script> | ||
16 | </head> | ||
17 | <body class="class-declaration-page"> | ||
18 | <script type="text/javascript">const pathtoroot = "../"; | ||
19 | loadScripts(document, 'script');</script> | ||
20 | <noscript> | ||
21 | <div>JavaScript is disabled on your browser.</div> | ||
22 | </noscript> | ||
23 | <header role="banner"> | ||
24 | <nav role="navigation"> | ||
25 | <!-- ========= START OF TOP NAVBAR ======= --> | ||
26 | <div class="top-nav" id="navbar-top"> | ||
27 | <div class="nav-content"> | ||
28 | <div class="nav-menu-button"><button id="navbar-toggle-button" aria-controls="navbar-top" aria-expanded="false" aria-label="Toggle navigation links"><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span></button></div> | ||
29 | <div class="skip-nav"><a href="#skip-navbar-top" title="Skip navigation links">Skip navigation links</a></div> | ||
30 | <ul id="navbar-top-firstrow" class="nav-list" title="Navigation"> | ||
31 | <li><a href="package-summary.html">Package</a></li> | ||
32 | <li class="nav-bar-cell1-rev">Class</li> | ||
33 | <li><a href="class-use/ResultObject.html">Use</a></li> | ||
34 | <li><a href="package-tree.html">Tree</a></li> | ||
35 | <li><a href="../index-files/index-1.html">Index</a></li> | ||
36 | <li><a href="../search.html">Search</a></li> | ||
37 | <li><a href="../help-doc.html#class">Help</a></li> | ||
38 | </ul> | ||
39 | </div> | ||
40 | </div> | ||
41 | <div class="sub-nav"> | ||
42 | <div class="nav-content"> | ||
43 | <ol class="sub-nav-list"> | ||
44 | <li><a href="package-summary.html">dao</a></li> | ||
45 | <li><a href="ResultObject.html" class="current-selection">ResultObject</a></li> | ||
46 | </ol> | ||
47 | <div class="nav-list-search"> | ||
48 | <input type="text" id="search-input" disabled placeholder="Search" aria-label="Search in documentation" autocomplete="off"> | ||
49 | <input type="reset" id="reset-search" disabled value="Reset"> | ||
50 | </div> | ||
51 | </div> | ||
52 | </div> | ||
53 | <!-- ========= END OF TOP NAVBAR ========= --> | ||
54 | <span class="skip-nav" id="skip-navbar-top"></span></nav> | ||
55 | </header> | ||
56 | <div class="main-grid"> | ||
57 | <nav role="navigation" class="toc" aria-label="Table of contents"> | ||
58 | <div class="toc-header">Contents | ||
59 | <input type="text" class="filter-input" disabled placeholder="Filter" aria-label="Filter table of contents" autocomplete="off"> | ||
60 | <input type="reset" class="reset-filter" disabled value="Reset"> | ||
61 | </div> | ||
62 | <button class="hide-sidebar"><span>Hide sidebar </span>❮</button><button class="show-sidebar">❯<span> Show sidebar</span></button> | ||
63 | <ol class="toc-list"> | ||
64 | <li><a href="#" tabindex="0">Description</a></li> | ||
65 | <li><a href="#constructor-summary" tabindex="0">Constructor Summary</a></li> | ||
66 | <li><a href="#method-summary" tabindex="0">Method Summary</a></li> | ||
67 | <li><a href="#constructor-detail" tabindex="0">Constructor Details</a> | ||
68 | <ol class="toc-list"> | ||
69 | <li><a href="#%3Cinit%3E(java.sql.ResultSet)" tabindex="0">ResultObject(ResultSet)</a></li> | ||
70 | </ol> | ||
71 | </li> | ||
72 | <li><a href="#method-detail" tabindex="0">Method Details</a> | ||
73 | <ol class="toc-list"> | ||
74 | <li><a href="#getData()" tabindex="0">getData()</a></li> | ||
75 | </ol> | ||
76 | </li> | ||
77 | </ol> | ||
78 | </nav> | ||
79 | <main role="main"> | ||
80 | <!-- ======== START OF CLASS DATA ======== --> | ||
81 | <div class="header"> | ||
82 | <h1 title="Class ResultObject" class="title">Class ResultObject</h1> | ||
83 | </div> | ||
84 | <div class="inheritance" title="Inheritance Tree"><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">java.lang.Object</a> | ||
85 | <div class="inheritance">dao.ResultObject</div> | ||
86 | </div> | ||
87 | <section class="class-description" id="class-description"> | ||
88 | <div class="horizontal-scroll"> | ||
89 | <hr> | ||
90 | <div class="type-signature"><span class="modifiers">public class </span><span class="element-name type-name-label">ResultObject</span> | ||
91 | <span class="extends-implements">extends <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">Object</a></span></div> | ||
92 | <div class="block">conteneur pour ResultSet dans le cas d'un SELECT, | ||
93 | les valeurs des HashMap sont des "Object" pour gérer tous les types de données</div> | ||
94 | </div> | ||
95 | </section> | ||
96 | <section class="summary"> | ||
97 | <ul class="summary-list"> | ||
98 | <!-- ======== CONSTRUCTOR SUMMARY ======== --> | ||
99 | <li> | ||
100 | <section class="constructor-summary" id="constructor-summary"> | ||
101 | <h2>Constructor Summary</h2> | ||
102 | <div class="caption"><span>Constructors</span></div> | ||
103 | <div class="summary-table two-column-summary"> | ||
104 | <div class="table-header col-first">Constructor</div> | ||
105 | <div class="table-header col-last">Description</div> | ||
106 | <div class="col-constructor-name even-row-color"><code><a href="#%3Cinit%3E(java.sql.ResultSet)" class="member-name-link">ResultObject</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.sql/java/sql/ResultSet.html" title="class or interface in java.sql" class="external-link">ResultSet</a> rs)</code></div> | ||
107 | <div class="col-last even-row-color"> | ||
108 | <div class="block">copie du ResultSet dans une ArrayList composée d'HashMap</div> | ||
109 | </div> | ||
110 | </div> | ||
111 | </section> | ||
112 | </li> | ||
113 | <!-- ========== METHOD SUMMARY =========== --> | ||
114 | <li> | ||
115 | <section class="method-summary" id="method-summary"> | ||
116 | <h2>Method Summary</h2> | ||
117 | <div id="method-summary-table"> | ||
118 | <div class="table-tabs" role="tablist" aria-orientation="horizontal"><button id="method-summary-table-tab0" role="tab" aria-selected="true" aria-controls="method-summary-table.tabpanel" tabindex="0" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table', 3)" class="active-table-tab">All Methods</button><button id="method-summary-table-tab2" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab2', 3)" class="table-tab">Instance Methods</button><button id="method-summary-table-tab4" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab4', 3)" class="table-tab">Concrete Methods</button></div> | ||
119 | <div id="method-summary-table.tabpanel" role="tabpanel" aria-labelledby="method-summary-table-tab0"> | ||
120 | <div class="summary-table three-column-summary"> | ||
121 | <div class="table-header col-first">Modifier and Type</div> | ||
122 | <div class="table-header col-second">Method</div> | ||
123 | <div class="table-header col-last">Description</div> | ||
124 | <div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/util/ArrayList.html" title="class or interface in java.util" class="external-link">ArrayList</a><wbr><<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/util/HashMap.html" title="class or interface in java.util" class="external-link">HashMap</a><<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a>,<wbr><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">Object</a>>></code></div> | ||
125 | <div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#getData()" class="member-name-link">getData</a>()</code></div> | ||
126 | <div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> | ||
127 | <div class="block">à utiliser dans la boucle permettant de parcourir la liste</div> | ||
128 | </div> | ||
129 | </div> | ||
130 | </div> | ||
131 | </div> | ||
132 | <div class="inherited-list"> | ||
133 | <h3 id="methods-inherited-from-class-java.lang.Object">Methods inherited from class java.lang.<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">Object</a></h3> | ||
134 | <code><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#clone()" title="class or interface in java.lang" class="external-link">clone</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#equals(java.lang.Object)" title="class or interface in java.lang" class="external-link">equals</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#finalize()" title="class or interface in java.lang" class="external-link">finalize</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#getClass()" title="class or interface in java.lang" class="external-link">getClass</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#hashCode()" title="class or interface in java.lang" class="external-link">hashCode</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#notify()" title="class or interface in java.lang" class="external-link">notify</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#notifyAll()" title="class or interface in java.lang" class="external-link">notifyAll</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#toString()" title="class or interface in java.lang" class="external-link">toString</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#wait()" title="class or interface in java.lang" class="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#wait(long)" title="class or interface in java.lang" class="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#wait(long,int)" title="class or interface in java.lang" class="external-link">wait</a></code></div> | ||
135 | </section> | ||
136 | </li> | ||
137 | </ul> | ||
138 | </section> | ||
139 | <section class="details"> | ||
140 | <ul class="details-list"> | ||
141 | <!-- ========= CONSTRUCTOR DETAIL ======== --> | ||
142 | <li> | ||
143 | <section class="constructor-details" id="constructor-detail"> | ||
144 | <h2>Constructor Details</h2> | ||
145 | <ul class="member-list"> | ||
146 | <li> | ||
147 | <section class="detail" id="<init>(java.sql.ResultSet)"> | ||
148 | <h3>ResultObject</h3> | ||
149 | <div class="horizontal-scroll"> | ||
150 | <div class="member-signature"><span class="modifiers">public</span> <span class="element-name">ResultObject</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.sql/java/sql/ResultSet.html" title="class or interface in java.sql" class="external-link">ResultSet</a> rs)</span> | ||
151 | throws <span class="exceptions"><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.sql/java/sql/SQLException.html" title="class or interface in java.sql" class="external-link">SQLException</a></span></div> | ||
152 | <div class="block">copie du ResultSet dans une ArrayList composée d'HashMap</div> | ||
153 | <dl class="notes"> | ||
154 | <dt>Parameters:</dt> | ||
155 | <dd><code>rs</code> - instance de ResultSet</dd> | ||
156 | <dt>Throws:</dt> | ||
157 | <dd><code><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.sql/java/sql/SQLException.html" title="class or interface in java.sql" class="external-link">SQLException</a></code> - en cas d'erreur avec le ResultSet</dd> | ||
158 | </dl> | ||
159 | </div> | ||
160 | </section> | ||
161 | </li> | ||
162 | </ul> | ||
163 | </section> | ||
164 | </li> | ||
165 | <!-- ============ METHOD DETAIL ========== --> | ||
166 | <li> | ||
167 | <section class="method-details" id="method-detail"> | ||
168 | <h2>Method Details</h2> | ||
169 | <ul class="member-list"> | ||
170 | <li> | ||
171 | <section class="detail" id="getData()"> | ||
172 | <h3>getData</h3> | ||
173 | <div class="horizontal-scroll"> | ||
174 | <div class="member-signature"><span class="modifiers">public</span> <span class="return-type"><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/util/ArrayList.html" title="class or interface in java.util" class="external-link">ArrayList</a><<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/util/HashMap.html" title="class or interface in java.util" class="external-link">HashMap</a><<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a>,<wbr><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">Object</a>>></span> <span class="element-name">getData</span>()</div> | ||
175 | <div class="block">à utiliser dans la boucle permettant de parcourir la liste</div> | ||
176 | <dl class="notes"> | ||
177 | <dt>Returns:</dt> | ||
178 | <dd>retourne la liste encapsulée</dd> | ||
179 | </dl> | ||
180 | </div> | ||
181 | </section> | ||
182 | </li> | ||
183 | </ul> | ||
184 | </section> | ||
185 | </li> | ||
186 | </ul> | ||
187 | </section> | ||
188 | <!-- ========= END OF CLASS DATA ========= --> | ||
189 | </main> | ||
190 | </div> | ||
191 | </body> | ||
192 | </html> | ||
diff --git a/doc/dao/SQLexecutor.html b/doc/dao/SQLexecutor.html new file mode 100644 index 0000000..3ce03a0 --- /dev/null +++ b/doc/dao/SQLexecutor.html | |||
@@ -0,0 +1,198 @@ | |||
1 | <!DOCTYPE HTML> | ||
2 | <html lang="fr"> | ||
3 | <head> | ||
4 | <!-- Generated by javadoc (23) on Sat Feb 15 14:09:35 CET 2025 --> | ||
5 | <title>SQLexecutor</title> | ||
6 | <meta name="viewport" content="width=device-width, initial-scale=1"> | ||
7 | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> | ||
8 | <meta name="dc.created" content="2025-02-15"> | ||
9 | <meta name="description" content="declaration: package: dao, class: SQLexecutor"> | ||
10 | <meta name="generator" content="javadoc/ClassWriter"> | ||
11 | <link rel="stylesheet" type="text/css" href="../resource-files/jquery-ui.min.css" title="Style"> | ||
12 | <link rel="stylesheet" type="text/css" href="../resource-files/stylesheet.css" title="Style"> | ||
13 | <script type="text/javascript" src="../script-files/script.js"></script> | ||
14 | <script type="text/javascript" src="../script-files/jquery-3.7.1.min.js"></script> | ||
15 | <script type="text/javascript" src="../script-files/jquery-ui.min.js"></script> | ||
16 | </head> | ||
17 | <body class="class-declaration-page"> | ||
18 | <script type="text/javascript">const pathtoroot = "../"; | ||
19 | loadScripts(document, 'script');</script> | ||
20 | <noscript> | ||
21 | <div>JavaScript is disabled on your browser.</div> | ||
22 | </noscript> | ||
23 | <header role="banner"> | ||
24 | <nav role="navigation"> | ||
25 | <!-- ========= START OF TOP NAVBAR ======= --> | ||
26 | <div class="top-nav" id="navbar-top"> | ||
27 | <div class="nav-content"> | ||
28 | <div class="nav-menu-button"><button id="navbar-toggle-button" aria-controls="navbar-top" aria-expanded="false" aria-label="Toggle navigation links"><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span></button></div> | ||
29 | <div class="skip-nav"><a href="#skip-navbar-top" title="Skip navigation links">Skip navigation links</a></div> | ||
30 | <ul id="navbar-top-firstrow" class="nav-list" title="Navigation"> | ||
31 | <li><a href="package-summary.html">Package</a></li> | ||
32 | <li class="nav-bar-cell1-rev">Class</li> | ||
33 | <li><a href="class-use/SQLexecutor.html">Use</a></li> | ||
34 | <li><a href="package-tree.html">Tree</a></li> | ||
35 | <li><a href="../index-files/index-1.html">Index</a></li> | ||
36 | <li><a href="../search.html">Search</a></li> | ||
37 | <li><a href="../help-doc.html#class">Help</a></li> | ||
38 | </ul> | ||
39 | </div> | ||
40 | </div> | ||
41 | <div class="sub-nav"> | ||
42 | <div class="nav-content"> | ||
43 | <ol class="sub-nav-list"> | ||
44 | <li><a href="package-summary.html">dao</a></li> | ||
45 | <li><a href="SQLexecutor.html" class="current-selection">SQLexecutor</a></li> | ||
46 | </ol> | ||
47 | <div class="nav-list-search"> | ||
48 | <input type="text" id="search-input" disabled placeholder="Search" aria-label="Search in documentation" autocomplete="off"> | ||
49 | <input type="reset" id="reset-search" disabled value="Reset"> | ||
50 | </div> | ||
51 | </div> | ||
52 | </div> | ||
53 | <!-- ========= END OF TOP NAVBAR ========= --> | ||
54 | <span class="skip-nav" id="skip-navbar-top"></span></nav> | ||
55 | </header> | ||
56 | <div class="main-grid"> | ||
57 | <nav role="navigation" class="toc" aria-label="Table of contents"> | ||
58 | <div class="toc-header">Contents | ||
59 | <input type="text" class="filter-input" disabled placeholder="Filter" aria-label="Filter table of contents" autocomplete="off"> | ||
60 | <input type="reset" class="reset-filter" disabled value="Reset"> | ||
61 | </div> | ||
62 | <button class="hide-sidebar"><span>Hide sidebar </span>❮</button><button class="show-sidebar">❯<span> Show sidebar</span></button> | ||
63 | <ol class="toc-list"> | ||
64 | <li><a href="#" tabindex="0">Description</a></li> | ||
65 | <li><a href="#constructor-summary" tabindex="0">Constructor Summary</a></li> | ||
66 | <li><a href="#method-summary" tabindex="0">Method Summary</a></li> | ||
67 | <li><a href="#constructor-detail" tabindex="0">Constructor Details</a> | ||
68 | <ol class="toc-list"> | ||
69 | <li><a href="#%3Cinit%3E()" tabindex="0">SQLexecutor()</a></li> | ||
70 | </ol> | ||
71 | </li> | ||
72 | <li><a href="#method-detail" tabindex="0">Method Details</a> | ||
73 | <ol class="toc-list"> | ||
74 | <li><a href="#executeQuery(java.lang.String,java.lang.Object...)" tabindex="0">executeQuery(String, Object...)</a></li> | ||
75 | </ol> | ||
76 | </li> | ||
77 | </ol> | ||
78 | </nav> | ||
79 | <main role="main"> | ||
80 | <!-- ======== START OF CLASS DATA ======== --> | ||
81 | <div class="header"> | ||
82 | <h1 title="Class SQLexecutor" class="title">Class SQLexecutor</h1> | ||
83 | </div> | ||
84 | <div class="inheritance" title="Inheritance Tree"><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">java.lang.Object</a> | ||
85 | <div class="inheritance"><a href="JDBC.html" title="class in dao">dao.JDBC</a> | ||
86 | <div class="inheritance">dao.SQLexecutor</div> | ||
87 | </div> | ||
88 | </div> | ||
89 | <section class="class-description" id="class-description"> | ||
90 | <div class="horizontal-scroll"> | ||
91 | <hr> | ||
92 | <div class="type-signature"><span class="modifiers">public class </span><span class="element-name type-name-label">SQLexecutor</span> | ||
93 | <span class="extends-implements">extends <a href="JDBC.html" title="class in dao">JDBC</a></span></div> | ||
94 | <div class="block">exécuter des requêtes SQL: | ||
95 | connexion avec JDBC => préparation de la requête => exécution | ||
96 | => copie du ResultSet dans une ArrayList d'HashMap => fermeture de la connexion</div> | ||
97 | </div> | ||
98 | </section> | ||
99 | <section class="summary"> | ||
100 | <ul class="summary-list"> | ||
101 | <!-- ======== CONSTRUCTOR SUMMARY ======== --> | ||
102 | <li> | ||
103 | <section class="constructor-summary" id="constructor-summary"> | ||
104 | <h2>Constructor Summary</h2> | ||
105 | <div class="caption"><span>Constructors</span></div> | ||
106 | <div class="summary-table two-column-summary"> | ||
107 | <div class="table-header col-first">Constructor</div> | ||
108 | <div class="table-header col-last">Description</div> | ||
109 | <div class="col-constructor-name even-row-color"><code><a href="#%3Cinit%3E()" class="member-name-link">SQLexecutor</a>()</code></div> | ||
110 | <div class="col-last even-row-color"> </div> | ||
111 | </div> | ||
112 | </section> | ||
113 | </li> | ||
114 | <!-- ========== METHOD SUMMARY =========== --> | ||
115 | <li> | ||
116 | <section class="method-summary" id="method-summary"> | ||
117 | <h2>Method Summary</h2> | ||
118 | <div id="method-summary-table"> | ||
119 | <div class="table-tabs" role="tablist" aria-orientation="horizontal"><button id="method-summary-table-tab0" role="tab" aria-selected="true" aria-controls="method-summary-table.tabpanel" tabindex="0" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table', 3)" class="active-table-tab">All Methods</button><button id="method-summary-table-tab2" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab2', 3)" class="table-tab">Instance Methods</button><button id="method-summary-table-tab4" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab4', 3)" class="table-tab">Concrete Methods</button></div> | ||
120 | <div id="method-summary-table.tabpanel" role="tabpanel" aria-labelledby="method-summary-table-tab0"> | ||
121 | <div class="summary-table three-column-summary"> | ||
122 | <div class="table-header col-first">Modifier and Type</div> | ||
123 | <div class="table-header col-second">Method</div> | ||
124 | <div class="table-header col-last">Description</div> | ||
125 | <div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="ResultObject.html" title="class in dao">ResultObject</a></code></div> | ||
126 | <div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#executeQuery(java.lang.String,java.lang.Object...)" class="member-name-link">executeQuery</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> sql, | ||
127 | <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">Object</a>... params)</code></div> | ||
128 | <div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> | ||
129 | <div class="block">Exécute une requête SQL et retourne le résultat si applicable.</div> | ||
130 | </div> | ||
131 | </div> | ||
132 | </div> | ||
133 | </div> | ||
134 | <div class="inherited-list"> | ||
135 | <h3 id="methods-inherited-from-class-dao.JDBC">Methods inherited from class dao.<a href="JDBC.html" title="class in dao">JDBC</a></h3> | ||
136 | <code><a href="JDBC.html#getConnection()">getConnection</a>, <a href="JDBC.html#setDBMS(java.lang.String)">setDBMS</a>, <a href="JDBC.html#setDbName(java.lang.String)">setDbName</a>, <a href="JDBC.html#setHost(java.lang.String)">setHost</a>, <a href="JDBC.html#setInfos(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String)">setInfos</a>, <a href="JDBC.html#setLogin(java.lang.String)">setLogin</a>, <a href="JDBC.html#setPassword(java.lang.String)">setPassword</a>, <a href="JDBC.html#setStrUrl()">setStrUrl</a></code></div> | ||
137 | <div class="inherited-list"> | ||
138 | <h3 id="methods-inherited-from-class-java.lang.Object">Methods inherited from class java.lang.<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">Object</a></h3> | ||
139 | <code><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#clone()" title="class or interface in java.lang" class="external-link">clone</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#equals(java.lang.Object)" title="class or interface in java.lang" class="external-link">equals</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#finalize()" title="class or interface in java.lang" class="external-link">finalize</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#getClass()" title="class or interface in java.lang" class="external-link">getClass</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#hashCode()" title="class or interface in java.lang" class="external-link">hashCode</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#notify()" title="class or interface in java.lang" class="external-link">notify</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#notifyAll()" title="class or interface in java.lang" class="external-link">notifyAll</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#toString()" title="class or interface in java.lang" class="external-link">toString</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#wait()" title="class or interface in java.lang" class="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#wait(long)" title="class or interface in java.lang" class="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html#wait(long,int)" title="class or interface in java.lang" class="external-link">wait</a></code></div> | ||
140 | </section> | ||
141 | </li> | ||
142 | </ul> | ||
143 | </section> | ||
144 | <section class="details"> | ||
145 | <ul class="details-list"> | ||
146 | <!-- ========= CONSTRUCTOR DETAIL ======== --> | ||
147 | <li> | ||
148 | <section class="constructor-details" id="constructor-detail"> | ||
149 | <h2>Constructor Details</h2> | ||
150 | <ul class="member-list"> | ||
151 | <li> | ||
152 | <section class="detail" id="<init>()"> | ||
153 | <h3>SQLexecutor</h3> | ||
154 | <div class="horizontal-scroll"> | ||
155 | <div class="member-signature"><span class="modifiers">public</span> <span class="element-name">SQLexecutor</span>()</div> | ||
156 | </div> | ||
157 | </section> | ||
158 | </li> | ||
159 | </ul> | ||
160 | </section> | ||
161 | </li> | ||
162 | <!-- ============ METHOD DETAIL ========== --> | ||
163 | <li> | ||
164 | <section class="method-details" id="method-detail"> | ||
165 | <h2>Method Details</h2> | ||
166 | <ul class="member-list"> | ||
167 | <li> | ||
168 | <section class="detail" id="executeQuery(java.lang.String,java.lang.Object...)"> | ||
169 | <h3>executeQuery</h3> | ||
170 | <div class="horizontal-scroll"> | ||
171 | <div class="member-signature"><span class="modifiers">public</span> <span class="return-type"><a href="ResultObject.html" title="class in dao">ResultObject</a></span> <span class="element-name">executeQuery</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> sql, | ||
172 | <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">Object</a>... params)</span> | ||
173 | throws <span class="exceptions"><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.sql/java/sql/SQLException.html" title="class or interface in java.sql" class="external-link">SQLException</a>, | ||
174 | <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/ClassNotFoundException.html" title="class or interface in java.lang" class="external-link">ClassNotFoundException</a></span></div> | ||
175 | <div class="block">Exécute une requête SQL et retourne le résultat si applicable.</div> | ||
176 | <dl class="notes"> | ||
177 | <dt>Parameters:</dt> | ||
178 | <dd><code>sql</code> - requête avec des ?</dd> | ||
179 | <dd><code>params</code> - nombre libre de paramètres, "Object..." permet de créer un tableau à partir des paramètres</dd> | ||
180 | <dt>Returns:</dt> | ||
181 | <dd>ResultSet si la requête est un SELECT, null sinon</dd> | ||
182 | <dt>Throws:</dt> | ||
183 | <dd><code><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.sql/java/sql/SQLException.html" title="class or interface in java.sql" class="external-link">SQLException</a></code> - en cas d'erreur SQL</dd> | ||
184 | <dd><code><a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/ClassNotFoundException.html" title="class or interface in java.lang" class="external-link">ClassNotFoundException</a></code> - pour DriverManager.getConnection</dd> | ||
185 | </dl> | ||
186 | </div> | ||
187 | </section> | ||
188 | </li> | ||
189 | </ul> | ||
190 | </section> | ||
191 | </li> | ||
192 | </ul> | ||
193 | </section> | ||
194 | <!-- ========= END OF CLASS DATA ========= --> | ||
195 | </main> | ||
196 | </div> | ||
197 | </body> | ||
198 | </html> | ||
diff --git a/doc/dao/class-use/JDBC.html b/doc/dao/class-use/JDBC.html new file mode 100644 index 0000000..e0df55b --- /dev/null +++ b/doc/dao/class-use/JDBC.html | |||
@@ -0,0 +1,86 @@ | |||
1 | <!DOCTYPE HTML> | ||
2 | <html lang="fr"> | ||
3 | <head> | ||
4 | <!-- Generated by javadoc (23) on Sat Feb 15 14:09:35 CET 2025 --> | ||
5 | <title>Uses of Class dao.JDBC</title> | ||
6 | <meta name="viewport" content="width=device-width, initial-scale=1"> | ||
7 | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> | ||
8 | <meta name="dc.created" content="2025-02-15"> | ||
9 | <meta name="description" content="use: package: dao, class: JDBC"> | ||
10 | <meta name="generator" content="javadoc/ClassUseWriter"> | ||
11 | <link rel="stylesheet" type="text/css" href="../../resource-files/jquery-ui.min.css" title="Style"> | ||
12 | <link rel="stylesheet" type="text/css" href="../../resource-files/stylesheet.css" title="Style"> | ||
13 | <script type="text/javascript" src="../../script-files/script.js"></script> | ||
14 | <script type="text/javascript" src="../../script-files/jquery-3.7.1.min.js"></script> | ||
15 | <script type="text/javascript" src="../../script-files/jquery-ui.min.js"></script> | ||
16 | </head> | ||
17 | <body class="class-use-page"> | ||
18 | <script type="text/javascript">const pathtoroot = "../../"; | ||
19 | loadScripts(document, 'script');</script> | ||
20 | <noscript> | ||
21 | <div>JavaScript is disabled on your browser.</div> | ||
22 | </noscript> | ||
23 | <header role="banner"> | ||
24 | <nav role="navigation"> | ||
25 | <!-- ========= START OF TOP NAVBAR ======= --> | ||
26 | <div class="top-nav" id="navbar-top"> | ||
27 | <div class="nav-content"> | ||
28 | <div class="nav-menu-button"><button id="navbar-toggle-button" aria-controls="navbar-top" aria-expanded="false" aria-label="Toggle navigation links"><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span></button></div> | ||
29 | <div class="skip-nav"><a href="#skip-navbar-top" title="Skip navigation links">Skip navigation links</a></div> | ||
30 | <ul id="navbar-top-firstrow" class="nav-list" title="Navigation"> | ||
31 | <li><a href="../package-summary.html">Package</a></li> | ||
32 | <li><a href="../JDBC.html">Class</a></li> | ||
33 | <li class="nav-bar-cell1-rev">Use</li> | ||
34 | <li><a href="../package-tree.html">Tree</a></li> | ||
35 | <li><a href="../../index-files/index-1.html">Index</a></li> | ||
36 | <li><a href="../../search.html">Search</a></li> | ||
37 | <li><a href="../../help-doc.html#use">Help</a></li> | ||
38 | </ul> | ||
39 | </div> | ||
40 | </div> | ||
41 | <div class="sub-nav"> | ||
42 | <div class="nav-content"> | ||
43 | <ol class="sub-nav-list"> | ||
44 | <li><a href="../package-summary.html">dao</a></li> | ||
45 | <li><a href="../JDBC.html" class="current-selection">JDBC</a></li> | ||
46 | </ol> | ||
47 | <div class="nav-list-search"> | ||
48 | <input type="text" id="search-input" disabled placeholder="Search" aria-label="Search in documentation" autocomplete="off"> | ||
49 | <input type="reset" id="reset-search" disabled value="Reset"> | ||
50 | </div> | ||
51 | </div> | ||
52 | </div> | ||
53 | <!-- ========= END OF TOP NAVBAR ========= --> | ||
54 | <span class="skip-nav" id="skip-navbar-top"></span></nav> | ||
55 | </header> | ||
56 | <div class="main-grid"> | ||
57 | <main role="main"> | ||
58 | <div class="header"> | ||
59 | <h1 title="Uses of Class dao.JDBC" class="title">Uses of Class<br>dao.JDBC</h1> | ||
60 | </div> | ||
61 | <section class="class-uses"> | ||
62 | <ul class="block-list"> | ||
63 | <li> | ||
64 | <section class="detail" id="dao"> | ||
65 | <h2>Uses of <a href="../JDBC.html" title="class in dao">JDBC</a> in <a href="../package-summary.html">dao</a></h2> | ||
66 | <div class="caption"><span>Subclasses of <a href="../JDBC.html" title="class in dao">JDBC</a> in <a href="../package-summary.html">dao</a></span></div> | ||
67 | <div class="summary-table three-column-summary"> | ||
68 | <div class="table-header col-first">Modifier and Type</div> | ||
69 | <div class="table-header col-second">Class</div> | ||
70 | <div class="table-header col-last">Description</div> | ||
71 | <div class="col-first even-row-color"><code>class </code></div> | ||
72 | <div class="col-second even-row-color"><code><a href="../SQLexecutor.html" class="type-name-link" title="class in dao">SQLexecutor</a></code></div> | ||
73 | <div class="col-last even-row-color"> | ||
74 | <div class="block">exécuter des requêtes SQL: | ||
75 | connexion avec JDBC => préparation de la requête => exécution | ||
76 | => copie du ResultSet dans une ArrayList d'HashMap => fermeture de la connexion</div> | ||
77 | </div> | ||
78 | </div> | ||
79 | </section> | ||
80 | </li> | ||
81 | </ul> | ||
82 | </section> | ||
83 | </main> | ||
84 | </div> | ||
85 | </body> | ||
86 | </html> | ||
diff --git a/doc/dao/class-use/ResultObject.html b/doc/dao/class-use/ResultObject.html new file mode 100644 index 0000000..6371131 --- /dev/null +++ b/doc/dao/class-use/ResultObject.html | |||
@@ -0,0 +1,85 @@ | |||
1 | <!DOCTYPE HTML> | ||
2 | <html lang="fr"> | ||
3 | <head> | ||
4 | <!-- Generated by javadoc (23) on Sat Feb 15 14:09:35 CET 2025 --> | ||
5 | <title>Uses of Class dao.ResultObject</title> | ||
6 | <meta name="viewport" content="width=device-width, initial-scale=1"> | ||
7 | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> | ||
8 | <meta name="dc.created" content="2025-02-15"> | ||
9 | <meta name="description" content="use: package: dao, class: ResultObject"> | ||
10 | <meta name="generator" content="javadoc/ClassUseWriter"> | ||
11 | <link rel="stylesheet" type="text/css" href="../../resource-files/jquery-ui.min.css" title="Style"> | ||
12 | <link rel="stylesheet" type="text/css" href="../../resource-files/stylesheet.css" title="Style"> | ||
13 | <script type="text/javascript" src="../../script-files/script.js"></script> | ||
14 | <script type="text/javascript" src="../../script-files/jquery-3.7.1.min.js"></script> | ||
15 | <script type="text/javascript" src="../../script-files/jquery-ui.min.js"></script> | ||
16 | </head> | ||
17 | <body class="class-use-page"> | ||
18 | <script type="text/javascript">const pathtoroot = "../../"; | ||
19 | loadScripts(document, 'script');</script> | ||
20 | <noscript> | ||
21 | <div>JavaScript is disabled on your browser.</div> | ||
22 | </noscript> | ||
23 | <header role="banner"> | ||
24 | <nav role="navigation"> | ||
25 | <!-- ========= START OF TOP NAVBAR ======= --> | ||
26 | <div class="top-nav" id="navbar-top"> | ||
27 | <div class="nav-content"> | ||
28 | <div class="nav-menu-button"><button id="navbar-toggle-button" aria-controls="navbar-top" aria-expanded="false" aria-label="Toggle navigation links"><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span></button></div> | ||
29 | <div class="skip-nav"><a href="#skip-navbar-top" title="Skip navigation links">Skip navigation links</a></div> | ||
30 | <ul id="navbar-top-firstrow" class="nav-list" title="Navigation"> | ||
31 | <li><a href="../package-summary.html">Package</a></li> | ||
32 | <li><a href="../ResultObject.html">Class</a></li> | ||
33 | <li class="nav-bar-cell1-rev">Use</li> | ||
34 | <li><a href="../package-tree.html">Tree</a></li> | ||
35 | <li><a href="../../index-files/index-1.html">Index</a></li> | ||
36 | <li><a href="../../search.html">Search</a></li> | ||
37 | <li><a href="../../help-doc.html#use">Help</a></li> | ||
38 | </ul> | ||
39 | </div> | ||
40 | </div> | ||
41 | <div class="sub-nav"> | ||
42 | <div class="nav-content"> | ||
43 | <ol class="sub-nav-list"> | ||
44 | <li><a href="../package-summary.html">dao</a></li> | ||
45 | <li><a href="../ResultObject.html" class="current-selection">ResultObject</a></li> | ||
46 | </ol> | ||
47 | <div class="nav-list-search"> | ||
48 | <input type="text" id="search-input" disabled placeholder="Search" aria-label="Search in documentation" autocomplete="off"> | ||
49 | <input type="reset" id="reset-search" disabled value="Reset"> | ||
50 | </div> | ||
51 | </div> | ||
52 | </div> | ||
53 | <!-- ========= END OF TOP NAVBAR ========= --> | ||
54 | <span class="skip-nav" id="skip-navbar-top"></span></nav> | ||
55 | </header> | ||
56 | <div class="main-grid"> | ||
57 | <main role="main"> | ||
58 | <div class="header"> | ||
59 | <h1 title="Uses of Class dao.ResultObject" class="title">Uses of Class<br>dao.ResultObject</h1> | ||
60 | </div> | ||
61 | <section class="class-uses"> | ||
62 | <ul class="block-list"> | ||
63 | <li> | ||
64 | <section class="detail" id="dao"> | ||
65 | <h2>Uses of <a href="../ResultObject.html" title="class in dao">ResultObject</a> in <a href="../package-summary.html">dao</a></h2> | ||
66 | <div class="caption"><span>Methods in <a href="../package-summary.html">dao</a> that return <a href="../ResultObject.html" title="class in dao">ResultObject</a></span></div> | ||
67 | <div class="summary-table three-column-summary"> | ||
68 | <div class="table-header col-first">Modifier and Type</div> | ||
69 | <div class="table-header col-second">Method</div> | ||
70 | <div class="table-header col-last">Description</div> | ||
71 | <div class="col-first even-row-color"><code><a href="../ResultObject.html" title="class in dao">ResultObject</a></code></div> | ||
72 | <div class="col-second even-row-color"><span class="type-name-label">SQLexecutor.</span><code><a href="../SQLexecutor.html#executeQuery(java.lang.String,java.lang.Object...)" class="member-name-link">executeQuery</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a> sql, | ||
73 | <a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">Object</a>... params)</code></div> | ||
74 | <div class="col-last even-row-color"> | ||
75 | <div class="block">Exécute une requête SQL et retourne le résultat si applicable.</div> | ||
76 | </div> | ||
77 | </div> | ||
78 | </section> | ||
79 | </li> | ||
80 | </ul> | ||
81 | </section> | ||
82 | </main> | ||
83 | </div> | ||
84 | </body> | ||
85 | </html> | ||
diff --git a/doc/dao/class-use/SQLexecutor.html b/doc/dao/class-use/SQLexecutor.html new file mode 100644 index 0000000..df0f5b9 --- /dev/null +++ b/doc/dao/class-use/SQLexecutor.html | |||
@@ -0,0 +1,64 @@ | |||
1 | <!DOCTYPE HTML> | ||
2 | <html lang="fr"> | ||
3 | <head> | ||
4 | <!-- Generated by javadoc (23) on Sat Feb 15 14:09:35 CET 2025 --> | ||
5 | <title>Uses of Class dao.SQLexecutor</title> | ||
6 | <meta name="viewport" content="width=device-width, initial-scale=1"> | ||
7 | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> | ||
8 | <meta name="dc.created" content="2025-02-15"> | ||
9 | <meta name="description" content="use: package: dao, class: SQLexecutor"> | ||
10 | <meta name="generator" content="javadoc/ClassUseWriter"> | ||
11 | <link rel="stylesheet" type="text/css" href="../../resource-files/jquery-ui.min.css" title="Style"> | ||
12 | <link rel="stylesheet" type="text/css" href="../../resource-files/stylesheet.css" title="Style"> | ||
13 | <script type="text/javascript" src="../../script-files/script.js"></script> | ||
14 | <script type="text/javascript" src="../../script-files/jquery-3.7.1.min.js"></script> | ||
15 | <script type="text/javascript" src="../../script-files/jquery-ui.min.js"></script> | ||
16 | </head> | ||
17 | <body class="class-use-page"> | ||
18 | <script type="text/javascript">const pathtoroot = "../../"; | ||
19 | loadScripts(document, 'script');</script> | ||
20 | <noscript> | ||
21 | <div>JavaScript is disabled on your browser.</div> | ||
22 | </noscript> | ||
23 | <header role="banner"> | ||
24 | <nav role="navigation"> | ||
25 | <!-- ========= START OF TOP NAVBAR ======= --> | ||
26 | <div class="top-nav" id="navbar-top"> | ||
27 | <div class="nav-content"> | ||
28 | <div class="nav-menu-button"><button id="navbar-toggle-button" aria-controls="navbar-top" aria-expanded="false" aria-label="Toggle navigation links"><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span></button></div> | ||
29 | <div class="skip-nav"><a href="#skip-navbar-top" title="Skip navigation links">Skip navigation links</a></div> | ||
30 | <ul id="navbar-top-firstrow" class="nav-list" title="Navigation"> | ||
31 | <li><a href="../package-summary.html">Package</a></li> | ||
32 | <li><a href="../SQLexecutor.html">Class</a></li> | ||
33 | <li class="nav-bar-cell1-rev">Use</li> | ||
34 | <li><a href="../package-tree.html">Tree</a></li> | ||
35 | <li><a href="../../index-files/index-1.html">Index</a></li> | ||
36 | <li><a href="../../search.html">Search</a></li> | ||
37 | <li><a href="../../help-doc.html#use">Help</a></li> | ||
38 | </ul> | ||
39 | </div> | ||
40 | </div> | ||
41 | <div class="sub-nav"> | ||
42 | <div class="nav-content"> | ||
43 | <ol class="sub-nav-list"> | ||
44 | <li><a href="../package-summary.html">dao</a></li> | ||
45 | <li><a href="../SQLexecutor.html" class="current-selection">SQLexecutor</a></li> | ||
46 | </ol> | ||
47 | <div class="nav-list-search"> | ||
48 | <input type="text" id="search-input" disabled placeholder="Search" aria-label="Search in documentation" autocomplete="off"> | ||
49 | <input type="reset" id="reset-search" disabled value="Reset"> | ||
50 | </div> | ||
51 | </div> | ||
52 | </div> | ||
53 | <!-- ========= END OF TOP NAVBAR ========= --> | ||
54 | <span class="skip-nav" id="skip-navbar-top"></span></nav> | ||
55 | </header> | ||
56 | <div class="main-grid"> | ||
57 | <main role="main"> | ||
58 | <div class="header"> | ||
59 | <h1 title="Uses of Class dao.SQLexecutor" class="title">Uses of Class<br>dao.SQLexecutor</h1> | ||
60 | </div> | ||
61 | No usage of dao.SQLexecutor</main> | ||
62 | </div> | ||
63 | </body> | ||
64 | </html> | ||
diff --git a/doc/dao/package-summary.html b/doc/dao/package-summary.html new file mode 100644 index 0000000..d9d67d6 --- /dev/null +++ b/doc/dao/package-summary.html | |||
@@ -0,0 +1,103 @@ | |||
1 | <!DOCTYPE HTML> | ||
2 | <html lang="fr"> | ||
3 | <head> | ||
4 | <!-- Generated by javadoc (23) on Sat Feb 15 14:09:35 CET 2025 --> | ||
5 | <title>dao</title> | ||
6 | <meta name="viewport" content="width=device-width, initial-scale=1"> | ||
7 | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> | ||
8 | <meta name="dc.created" content="2025-02-15"> | ||
9 | <meta name="description" content="declaration: package: dao"> | ||
10 | <meta name="generator" content="javadoc/PackageWriter"> | ||
11 | <link rel="stylesheet" type="text/css" href="../resource-files/jquery-ui.min.css" title="Style"> | ||
12 | <link rel="stylesheet" type="text/css" href="../resource-files/stylesheet.css" title="Style"> | ||
13 | <script type="text/javascript" src="../script-files/script.js"></script> | ||
14 | <script type="text/javascript" src="../script-files/jquery-3.7.1.min.js"></script> | ||
15 | <script type="text/javascript" src="../script-files/jquery-ui.min.js"></script> | ||
16 | </head> | ||
17 | <body class="package-declaration-page"> | ||
18 | <script type="text/javascript">const pathtoroot = "../"; | ||
19 | loadScripts(document, 'script');</script> | ||
20 | <noscript> | ||
21 | <div>JavaScript is disabled on your browser.</div> | ||
22 | </noscript> | ||
23 | <header role="banner"> | ||
24 | <nav role="navigation"> | ||
25 | <!-- ========= START OF TOP NAVBAR ======= --> | ||
26 | <div class="top-nav" id="navbar-top"> | ||
27 | <div class="nav-content"> | ||
28 | <div class="nav-menu-button"><button id="navbar-toggle-button" aria-controls="navbar-top" aria-expanded="false" aria-label="Toggle navigation links"><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span></button></div> | ||
29 | <div class="skip-nav"><a href="#skip-navbar-top" title="Skip navigation links">Skip navigation links</a></div> | ||
30 | <ul id="navbar-top-firstrow" class="nav-list" title="Navigation"> | ||
31 | <li class="nav-bar-cell1-rev">Package</li> | ||
32 | <li><a href="package-use.html">Use</a></li> | ||
33 | <li><a href="package-tree.html">Tree</a></li> | ||
34 | <li><a href="../index-files/index-1.html">Index</a></li> | ||
35 | <li><a href="../search.html">Search</a></li> | ||
36 | <li><a href="../help-doc.html#package">Help</a></li> | ||
37 | </ul> | ||
38 | </div> | ||
39 | </div> | ||
40 | <div class="sub-nav"> | ||
41 | <div class="nav-content"> | ||
42 | <ol class="sub-nav-list"> | ||
43 | <li><a href="package-summary.html" class="current-selection">dao</a></li> | ||
44 | </ol> | ||
45 | <div class="nav-list-search"> | ||
46 | <input type="text" id="search-input" disabled placeholder="Search" aria-label="Search in documentation" autocomplete="off"> | ||
47 | <input type="reset" id="reset-search" disabled value="Reset"> | ||
48 | </div> | ||
49 | </div> | ||
50 | </div> | ||
51 | <!-- ========= END OF TOP NAVBAR ========= --> | ||
52 | <span class="skip-nav" id="skip-navbar-top"></span></nav> | ||
53 | </header> | ||
54 | <div class="main-grid"> | ||
55 | <nav role="navigation" class="toc" aria-label="Table of contents"> | ||
56 | <div class="toc-header">Contents</div> | ||
57 | <button class="hide-sidebar"><span>Hide sidebar </span>❮</button><button class="show-sidebar">❯<span> Show sidebar</span></button> | ||
58 | <ol class="toc-list"> | ||
59 | <li><a href="#" tabindex="0">Description</a></li> | ||
60 | <li><a href="#class-summary" tabindex="0">Classes and Interfaces</a></li> | ||
61 | </ol> | ||
62 | </nav> | ||
63 | <main role="main"> | ||
64 | <div class="header"> | ||
65 | <h1 title="Package dao" class="title">Package dao</h1> | ||
66 | </div> | ||
67 | <hr> | ||
68 | <div class="horizontal-scroll"> | ||
69 | <div class="package-signature">package <span class="element-name">dao</span></div> | ||
70 | </div> | ||
71 | <section class="summary"> | ||
72 | <ul class="summary-list"> | ||
73 | <li> | ||
74 | <div id="class-summary"> | ||
75 | <div class="caption"><span>Classes</span></div> | ||
76 | <div class="summary-table two-column-summary"> | ||
77 | <div class="table-header col-first">Class</div> | ||
78 | <div class="table-header col-last">Description</div> | ||
79 | <div class="col-first even-row-color class-summary class-summary-tab2"><a href="JDBC.html" title="class in dao">JDBC</a></div> | ||
80 | <div class="col-last even-row-color class-summary class-summary-tab2"> | ||
81 | <div class="block">connexion avec JDBC pour utilisation par la classe fille: SQLexecutor, | ||
82 | les paramètres de connexion et les setters sont statiques</div> | ||
83 | </div> | ||
84 | <div class="col-first odd-row-color class-summary class-summary-tab2"><a href="ResultObject.html" title="class in dao">ResultObject</a></div> | ||
85 | <div class="col-last odd-row-color class-summary class-summary-tab2"> | ||
86 | <div class="block">conteneur pour ResultSet dans le cas d'un SELECT, | ||
87 | les valeurs des HashMap sont des "Object" pour gérer tous les types de données</div> | ||
88 | </div> | ||
89 | <div class="col-first even-row-color class-summary class-summary-tab2"><a href="SQLexecutor.html" title="class in dao">SQLexecutor</a></div> | ||
90 | <div class="col-last even-row-color class-summary class-summary-tab2"> | ||
91 | <div class="block">exécuter des requêtes SQL: | ||
92 | connexion avec JDBC => préparation de la requête => exécution | ||
93 | => copie du ResultSet dans une ArrayList d'HashMap => fermeture de la connexion</div> | ||
94 | </div> | ||
95 | </div> | ||
96 | </div> | ||
97 | </li> | ||
98 | </ul> | ||
99 | </section> | ||
100 | </main> | ||
101 | </div> | ||
102 | </body> | ||
103 | </html> | ||
diff --git a/doc/dao/package-tree.html b/doc/dao/package-tree.html new file mode 100644 index 0000000..9be127e --- /dev/null +++ b/doc/dao/package-tree.html | |||
@@ -0,0 +1,77 @@ | |||
1 | <!DOCTYPE HTML> | ||
2 | <html lang="fr"> | ||
3 | <head> | ||
4 | <!-- Generated by javadoc (23) on Sat Feb 15 14:09:35 CET 2025 --> | ||
5 | <title>dao Class Hierarchy</title> | ||
6 | <meta name="viewport" content="width=device-width, initial-scale=1"> | ||
7 | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> | ||
8 | <meta name="dc.created" content="2025-02-15"> | ||
9 | <meta name="description" content="tree: package: dao"> | ||
10 | <meta name="generator" content="javadoc/PackageTreeWriter"> | ||
11 | <link rel="stylesheet" type="text/css" href="../resource-files/jquery-ui.min.css" title="Style"> | ||
12 | <link rel="stylesheet" type="text/css" href="../resource-files/stylesheet.css" title="Style"> | ||
13 | <script type="text/javascript" src="../script-files/script.js"></script> | ||
14 | <script type="text/javascript" src="../script-files/jquery-3.7.1.min.js"></script> | ||
15 | <script type="text/javascript" src="../script-files/jquery-ui.min.js"></script> | ||
16 | </head> | ||
17 | <body class="package-tree-page"> | ||
18 | <script type="text/javascript">const pathtoroot = "../"; | ||
19 | loadScripts(document, 'script');</script> | ||
20 | <noscript> | ||
21 | <div>JavaScript is disabled on your browser.</div> | ||
22 | </noscript> | ||
23 | <header role="banner"> | ||
24 | <nav role="navigation"> | ||
25 | <!-- ========= START OF TOP NAVBAR ======= --> | ||
26 | <div class="top-nav" id="navbar-top"> | ||
27 | <div class="nav-content"> | ||
28 | <div class="nav-menu-button"><button id="navbar-toggle-button" aria-controls="navbar-top" aria-expanded="false" aria-label="Toggle navigation links"><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span></button></div> | ||
29 | <div class="skip-nav"><a href="#skip-navbar-top" title="Skip navigation links">Skip navigation links</a></div> | ||
30 | <ul id="navbar-top-firstrow" class="nav-list" title="Navigation"> | ||
31 | <li><a href="package-summary.html">Package</a></li> | ||
32 | <li><a href="package-use.html">Use</a></li> | ||
33 | <li class="nav-bar-cell1-rev">Tree</li> | ||
34 | <li><a href="../index-files/index-1.html">Index</a></li> | ||
35 | <li><a href="../search.html">Search</a></li> | ||
36 | <li><a href="../help-doc.html#tree">Help</a></li> | ||
37 | </ul> | ||
38 | </div> | ||
39 | </div> | ||
40 | <div class="sub-nav"> | ||
41 | <div class="nav-content"> | ||
42 | <ol class="sub-nav-list"> | ||
43 | <li><a href="package-summary.html" class="current-selection">dao</a></li> | ||
44 | </ol> | ||
45 | <div class="nav-list-search"> | ||
46 | <input type="text" id="search-input" disabled placeholder="Search" aria-label="Search in documentation" autocomplete="off"> | ||
47 | <input type="reset" id="reset-search" disabled value="Reset"> | ||
48 | </div> | ||
49 | </div> | ||
50 | </div> | ||
51 | <!-- ========= END OF TOP NAVBAR ========= --> | ||
52 | <span class="skip-nav" id="skip-navbar-top"></span></nav> | ||
53 | </header> | ||
54 | <div class="main-grid"> | ||
55 | <main role="main"> | ||
56 | <div class="header"> | ||
57 | <h1 class="title">Hierarchy For Package dao</h1> | ||
58 | </div> | ||
59 | <section class="hierarchy"> | ||
60 | <h2 title="Class Hierarchy">Class Hierarchy</h2> | ||
61 | <ul> | ||
62 | <li class="circle">java.lang.<a href="https://docs.oracle.com/en/java/javase/22/docs/api/java.base/java/lang/Object.html" class="type-name-link external-link" title="class or interface in java.lang">Object</a> | ||
63 | <ul> | ||
64 | <li class="circle">dao.<a href="JDBC.html" class="type-name-link" title="class in dao">JDBC</a> | ||
65 | <ul> | ||
66 | <li class="circle">dao.<a href="SQLexecutor.html" class="type-name-link" title="class in dao">SQLexecutor</a></li> | ||
67 | </ul> | ||
68 | </li> | ||
69 | <li class="circle">dao.<a href="ResultObject.html" class="type-name-link" title="class in dao">ResultObject</a></li> | ||
70 | </ul> | ||
71 | </li> | ||
72 | </ul> | ||
73 | </section> | ||
74 | </main> | ||
75 | </div> | ||
76 | </body> | ||
77 | </html> | ||
diff --git a/doc/dao/package-use.html b/doc/dao/package-use.html new file mode 100644 index 0000000..6a05f55 --- /dev/null +++ b/doc/dao/package-use.html | |||
@@ -0,0 +1,85 @@ | |||
1 | <!DOCTYPE HTML> | ||
2 | <html lang="fr"> | ||
3 | <head> | ||
4 | <!-- Generated by javadoc (23) on Sat Feb 15 14:09:35 CET 2025 --> | ||
5 | <title>Uses of Package dao</title> | ||
6 | <meta name="viewport" content="width=device-width, initial-scale=1"> | ||
7 | <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> | ||
8 | <meta name="dc.created" content="2025-02-15"> | ||
9 | <meta name="description" content="use: package: dao"> | ||
10 | <meta name="generator" content="javadoc/PackageUseWriter"> | ||
11 | <link rel="stylesheet" type="text/css" href="../resource-files/jquery-ui.min.css" title="Style"> | ||
12 | <link rel="stylesheet" type="text/css" href="../resource-files/stylesheet.css" title="Style"> | ||
13 | <script type="text/javascript" src="../script-files/script.js"></script> | ||
14 | <script type="text/javascript" src="../script-files/jquery-3.7.1.min.js"></script> | ||
15 | <script type="text/javascript" src="../script-files/jquery-ui.min.js"></script> | ||
16 | </head> | ||
17 | <body class="package-use-page"> | ||
18 | <script type="text/javascript">const pathtoroot = "../"; | ||
19 | loadScripts(document, 'script');</script> | ||
20 | <noscript> | ||
21 | <div>JavaScript is disabled on your browser.</div> | ||
22 | </noscript> | ||
23 | <header role="banner"> | ||
24 | <nav role="navigation"> | ||
25 | <!-- ========= START OF TOP NAVBAR ======= --> | ||
26 | <div class="top-nav" id="navbar-top"> | ||
27 | <div class="nav-content"> | ||
28 | <div class="nav-menu-button"><button id="navbar-toggle-button" aria-controls="navbar-top" aria-expanded="false" aria-label="Toggle navigation links"><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span><span class="nav-bar-toggle-icon"> </span></button></div> | ||
29 | <div class="skip-nav"><a href="#skip-navbar-top" title="Skip navigation links">Skip navigation links</a></div> | ||
30 | <ul id="navbar-top-firstrow" class="nav-list" title="Navigation"> | ||
31 | <li><a href="package-summary.html">Package</a></li> | ||
32 | <li class="nav-bar-cell1-rev">Use</li> | ||
33 | <li><a href="package-tree.html">Tree</a></li> | ||
34 | <li><a href="../index-files/index-1.html">Index</a></li> | ||
35 | <li><a href="../search.html">Search</a></li> | ||
36 | <li><a href="../help-doc.html#use">Help</a></li> | ||
37 | </ul> | ||
38 | </div> | ||
39 | </div> | ||
40 | <div class="sub-nav"> | ||
41 | <div class="nav-content"> | ||
42 | <ol class="sub-nav-list"> | ||
43 | <li><a href="package-summary.html" class="current-selection">dao</a></li> | ||
44 | </ol> | ||
45 | <div class="nav-list-search"> | ||
46 | <input type="text" id="search-input" disabled placeholder="Search" aria-label="Search in documentation" autocomplete="off"> | ||
47 | <input type="reset" id="reset-search" disabled value="Reset"> | ||
48 | </div> | ||
49 | </div> | ||
50 | </div> | ||
51 | <!-- ========= END OF TOP NAVBAR ========= --> | ||
52 | <span class="skip-nav" id="skip-navbar-top"></span></nav> | ||
53 | </header> | ||
54 | <div class="main-grid"> | ||
55 | <main role="main"> | ||
56 | <div class="header"> | ||
57 | <h1 title="Uses of Package dao" class="title">Uses of Package<br>dao</h1> | ||
58 | </div> | ||
59 | <section class="package-uses"> | ||
60 | <ul class="block-list"> | ||
61 | <li> | ||
62 | <section class="detail" id="dao"> | ||
63 | <div class="caption"><span>Classes in <a href="package-summary.html">dao</a> used by <a href="package-summary.html">dao</a></span></div> | ||
64 | <div class="summary-table two-column-summary"> | ||
65 | <div class="table-header col-first">Class</div> | ||
66 | <div class="table-header col-last">Description</div> | ||
67 | <div class="col-first even-row-color"><a href="class-use/JDBC.html#dao">JDBC</a></div> | ||
68 | <div class="col-last even-row-color"> | ||
69 | <div class="block">connexion avec JDBC pour utilisation par la classe fille: SQLexecutor, | ||
70 | les paramètres de connexion et les setters sont statiques</div> | ||
71 | </div> | ||
72 | <div class="col-first odd-row-color"><a href="class-use/ResultObject.html#dao">ResultObject</a></div> | ||
73 | <div class="col-last odd-row-color"> | ||
74 | <div class="block">conteneur pour ResultSet dans le cas d'un SELECT, | ||
75 | les valeurs des HashMap sont des "Object" pour gérer tous les types de données</div> | ||
76 | </div> | ||
77 | </div> | ||
78 | </section> | ||
79 | </li> | ||
80 | </ul> | ||
81 | </section> | ||
82 | </main> | ||
83 | </div> | ||
84 | </body> | ||
85 | </html> | ||