diff options
author | polo-pc-greta <ordipolo@gmx.fr> | 2025-02-15 14:12:55 +0100 |
---|---|---|
committer | polo-pc-greta <ordipolo@gmx.fr> | 2025-02-15 14:12:55 +0100 |
commit | efed27a703022ecb366a301340f5fcbb8135a2fd (patch) | |
tree | a58593f0522156a3fca146eb973ec2aba8c8cb51 /src/dao/ResultObject.java | |
parent | d8dc2b6d0d4dbc93da853ef5a7562d6a223ee918 (diff) | |
download | JDBC-efed27a703022ecb366a301340f5fcbb8135a2fd.zip |
release candidate 2
Diffstat (limited to 'src/dao/ResultObject.java')
-rw-r--r-- | src/dao/ResultObject.java | 25 |
1 files changed, 16 insertions, 9 deletions
diff --git a/src/dao/ResultObject.java b/src/dao/ResultObject.java index e41af0b..1df9d88 100644 --- a/src/dao/ResultObject.java +++ b/src/dao/ResultObject.java | |||
@@ -5,12 +5,20 @@ import java.sql.ResultSetMetaData; | |||
5 | import java.sql.SQLException; | 5 | import java.sql.SQLException; |
6 | import java.util.ArrayList; | 6 | import java.util.ArrayList; |
7 | import java.util.HashMap; | 7 | import java.util.HashMap; |
8 | import java.util.List; | ||
9 | 8 | ||
9 | /** | ||
10 | * conteneur pour ResultSet dans le cas d'un SELECT, | ||
11 | * les valeurs des HashMap sont des "Object" pour gérer tous les types de données | ||
12 | */ | ||
10 | public class ResultObject | 13 | public class ResultObject |
11 | { | 14 | { |
12 | private final List<HashMap<String, Object>> data = new ArrayList<>(); | 15 | private final ArrayList<HashMap<String, Object>> data = new ArrayList<>(); |
13 | 16 | ||
17 | /** | ||
18 | * copie du ResultSet dans une ArrayList composée d'HashMap | ||
19 | * @param rs instance de ResultSet | ||
20 | * @throws SQLException en cas d'erreur avec le ResultSet | ||
21 | */ | ||
14 | public ResultObject(ResultSet rs) throws SQLException | 22 | public ResultObject(ResultSet rs) throws SQLException |
15 | { | 23 | { |
16 | ResultSetMetaData metaData = rs.getMetaData(); | 24 | ResultSetMetaData metaData = rs.getMetaData(); |
@@ -24,15 +32,14 @@ public class ResultObject | |||
24 | row.put(metaData.getColumnName(i), rs.getObject(i)); | 32 | row.put(metaData.getColumnName(i), rs.getObject(i)); |
25 | } | 33 | } |
26 | data.add(row); | 34 | data.add(row); |
27 | } | 35 | } |
28 | |||
29 | // rs.close(); | ||
30 | // rs.getStatement().close(); | ||
31 | // rs.getStatement().getConnection().close(); | ||
32 | |||
33 | } | 36 | } |
34 | 37 | ||
35 | public List<HashMap<String, Object>> getData() | 38 | /** |
39 | * à utiliser dans la boucle permettant de parcourir la liste | ||
40 | * @return retourne la liste encapsulée | ||
41 | */ | ||
42 | public ArrayList<HashMap<String, Object>> getData() | ||
36 | { | 43 | { |
37 | return data; | 44 | return data; |
38 | } | 45 | } |