summaryrefslogtreecommitdiff
path: root/doc/dao/SQLexecutor.html
diff options
context:
space:
mode:
Diffstat (limited to 'doc/dao/SQLexecutor.html')
-rw-r--r--doc/dao/SQLexecutor.html198
1 files changed, 198 insertions, 0 deletions
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 = "../";
19loadScripts(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">&nbsp;</span><span class="nav-bar-toggle-icon">&nbsp;</span><span class="nav-bar-toggle-icon">&nbsp;</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&nbsp;
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&nbsp;</span>&#10094;</button><button class="show-sidebar">&#10095;<span>&nbsp;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 =&gt; préparation de la requête =&gt; exécution
96 =&gt; copie du ResultSet dans une ArrayList d'HashMap =&gt; 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">&nbsp;</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>&nbsp;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>...&nbsp;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&nbsp;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&nbsp;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="&lt;init&gt;()">
153<h3>SQLexecutor</h3>
154<div class="horizontal-scroll">
155<div class="member-signature"><span class="modifiers">public</span>&nbsp;<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>&nbsp;<span class="return-type"><a href="ResultObject.html" title="class in dao">ResultObject</a></span>&nbsp;<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>&nbsp;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>...&nbsp;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>
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-14 02:05:46 +0000