une foreign key qui renvoie vers la clé primaire de la meme table

Bonjour,

j'ai une table dans la base de données qui a un attribut foreign key qui renvoie vers la clé primaire de cette même table.
Dans la base de données, ça se fait normalement.
Mais en java, ceci induit que l'attribut en question est de type le nom de la classe.
Cela me pose un problème dans la compilation. comment le résoudre ?!

Hello,

je ne vois pas en quoi cela pose un problème:

Code:

---

1 2 3 4 5 6

class Foo { private int field1; private int field2;   private Foo field3; }

---

ça compile très bien...

Citation:

---

Envoyé par ROUGE87

Mais en java, ceci induit que l'attribut en question est de type le nom de la classe.
Cela me pose un problème dans la compilation. comment le résoudre ?!

---

Quel problème, quel message d'erreur avez vous, quel code avez vous?

Citation:

---

Envoyé par Pill_S

Hello,

je ne vois pas en quoi cela pose un problème:

Code:

---

1 2 3 4 5 6

class Foo { private int field1; private int field2;   private Foo field3; }

---

ça compile très bien...

---

j'utilise plutot ce type de décralation

Code:

---

1 2 3 4 5 6

class Foo { private int field1; private int field2;   private Foo field3 = new Foo(); }

---

ceci parce que la déclaration comme tu me l'as dit me génère une autre erreur.

Citation:

---

Envoyé par tchize_

Quel problème, quel message d'erreur avez vous, quel code avez vous?

---

ci joiint la table qui contient les forign key comme je l'ai présenté dans le premier message. l'erreur générée est la suivante :

Exception in thread "main" java.lang.StackOverflowError

avec un grand nombre de ligne de la forme :
at port_type_daogen.Board.<init>(Board.java:49)
at port_type_daogen.Board.<init>(Board.java:50)


NB: port_type_daogen est le nom de mon project et Board est le nom de ma classe.
voici ma déclaration comment je la fais :

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

public class Board implements Cloneable, Serializable {   /**      * Persistent Instance variables. This data is directly      * mapped to the columns of database table.      */ private int ID_Board; private int ID_MASG_CSG; private int ValidSlot; private int SlotCount; private Board_ref Board_Ref = new Board_ref (); private Board Board_process = new Board(); private Board Board_MotherBoard = new Board(); private String Board_Name; private String Board_Label; private Eng_rule_board_name Board_name_rule = new Eng_rule_board_name();

---

les lignes 49 et 50 correspondent aux lignes :
private Board_ref Board_Ref = new Board_ref ();
private Board Board_process = new Board();

non non pas cool ça.... regarde:

Code:

---

1 2 3 4

class Board { private Board Board_process = new Board(); }

---

impossible que ça fonctionne ça, c'est normal de se prendre une stackoverflow: ce que ça implique, c'est qu'on ne peut pas créer une instance de Board sans créer une autre instance de Board. A chaque fois que tu appelle "new Board", lors de l'initialisation de l'objet, on exécute "private Board Board_process = new Board();", qui lui-même va exécuter "private Board Board_process = new Board();", qui lui-même va exécuter "private Board Board_process = new Board();" etc sans aucun moyen de casser cette logique.... la machine aime jamais trop les pseudo-boucles infinies....

c'est pourquoi tu ne peux pas initialiser cette variable lors de la déclaration. Par contre, on peut différer cette assignation:

Code:

---

1 2 3 4 5 6 7 8

class Board { public Board b = null; // public uniquement pour simplifier l'exemple, sera private dans la vraie vie }   Board b1 = new Board(); Board b2 = new Board();   b1.b = b2; // tadaaam ça marche!

---

;)

Code:

---

1 2 3 4 5 6

class Foo { private int field1; private int field2;   private Foo field3 = new Foo(); }

---

Avec un telle déclaration, vous créez des classes à l'infini, ce qui aboutit à une récursion infinie.

En effet, vous construisez un Foo, qui a un champ privé field3 qu'il initialise en créant un Foo, qui a un champ privé field 3 qui est initialisé en créant un Foo qui .... vous avez compris.

... par contre, une alternative pourrait être:

Code:

---

1 2 3 4 5 6 7 8 9 10

class Board { private Board b;   // default constructor Board() {}   // constructor with the field as parameter Board(Board b){ this. b = b;} }

---

;)

Citation:

---

Envoyé par Pill_S

c'est pourquoi tu ne peux pas initialiser cette variable lors de la déclaration. Par contre, on peut différer cette assignation:

Code:

---

1 2 3 4 5 6 7 8

class Board { public Board b = null; // public uniquement pour simplifier l'exemple, sera private dans la vraie vie }   Board b1 = new Board(); Board b2 = new Board();   b1.b = b2; // tadaaam ça marche!

---

;)

---

oui, ca semble bien parfait mais dans le cas où j'utilise le pattern DAO pour fouiller dans la base de données, donc je dois créer les classes métiers et les classes DAO. donc je dois séparer entre les deux. je mettrai à la fin de cette réponse mes deux classes Board et BoardDAO.

Citation:

---

Envoyé par tchize_

Code:

---

1 2 3 4 5 6

class Foo { private int field1; private int field2;   private Foo field3 = new Foo(); }

---

Avec un telle déclaration, vous créez des classes à l'infini, ce qui aboutit à une récursion infinie.

En effet, vous construisez un Foo, qui a un champ privé field3 qu'il initialise en créant un Foo, qui a un champ privé field 3 qui est initialisé en créant un Foo qui .... vous avez compris.

---

Merci bien, je vois très bien.

Citation:

---

Envoyé par Pill_S

... par contre, une alternative pourrait être:

Code:

---

1 2 3 4 5 6 7 8 9 10

class Board { private Board b;   // default constructor Board() {}   // constructor with the field as parameter Board(Board b){ this. b = b;} }

---

;)

---

c'est une très bonne idée et ca aurait été sans problème s'il y avait un seul attribut foreign key de type Board!
seulement, comme j'ai deux attributs locaux qui sont des foreign key pour Board, ceci pose un problème, je pense.


Ci-joint deux pieces jointes:
- le schéma relationnel de la base (une partie de la base).
- mon code pour le pattern DAO pour mettre en place ce schéma.

Merci bien

Bonjour,

j'utilise le pattern DAO et trois cas se présentent dans mon cas:
1) une table qui n'a pas de foreign key. ceci fonctionne parfaitement. voici les codes pour l'objet métier et l'objet DAO.

---- Objet métier :

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119

package port_type_daogen;   import java.io.*; import java.sql.*; import java.util.*; import java.math.*;         public class Port_type implements Cloneable, Serializable {     private int ID_Port_Type; private String Port_Type_Name; private int Port_Type_capacity;           public Port_type () {   }   public Port_type (int ID_Port_TypeIn) {   this.ID_Port_Type = ID_Port_TypeIn;   }       public int getID_Port_Type() { return this.ID_Port_Type; } public void setID_Port_Type(int ID_Port_TypeIn) { this.ID_Port_Type = ID_Port_TypeIn; }   public String getPort_Type_Name() { return this.Port_Type_Name; } public void setPort_Type_Name(String Port_Type_NameIn) { this.Port_Type_Name = Port_Type_NameIn; }   public int getPort_Type_capacity() { return this.Port_Type_capacity; } public void setPort_Type_capacity(int Port_Type_capacityIn) { this.Port_Type_capacity = Port_Type_capacityIn; }         public void setAll(int ID_Port_TypeIn, String Port_Type_NameIn, int Port_Type_capacityIn) { this.ID_Port_Type = ID_Port_TypeIn; this.Port_Type_Name = Port_Type_NameIn; this.Port_Type_capacity = Port_Type_capacityIn; }       public boolean hasEqualMapping(Port_type valueObject) {   if (valueObject.getID_Port_Type() != this.ID_Port_Type) { return(false); } if (this.Port_Type_Name == null) { if (valueObject.getPort_Type_Name() != null) return(false); } else if (!this.Port_Type_Name.equals(valueObject.getPort_Type_Name())) { return(false); } if (valueObject.getPort_Type_capacity() != this.Port_Type_capacity) { return(false); }   return true; }       public String toString() { StringBuffer out = new StringBuffer(this.getDaogenVersion()); //StringBuffer out = new StringBuffer(); out.append("\nclass Port_type, mapping to table port_type\n"); out.append("Persistent attributes: \n"); out.append("ID_Port_Type = " + this.ID_Port_Type + "\n"); out.append("Port_Type_Name = " + this.Port_Type_Name + "\n"); out.append("Port_Type_capacity = " + this.Port_Type_capacity + "\n"); return out.toString(); }       public Object clone() { Port_type cloned = new Port_type();   cloned.setID_Port_Type(this.ID_Port_Type); if (this.Port_Type_Name != null) cloned.setPort_Type_Name(new String(this.Port_Type_Name)); cloned.setPort_Type_capacity(this.Port_Type_capacity); return cloned; }       public String getDaogenVersion() {   return "**********************************"; }   }

---

Voici l'objet DAO :

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335

package port_type_daogen;   import java.sql.*; import java.util.*; import java.math.*;           public class Port_typeDao {   // Cache contents: private boolean cacheOk; private List cacheData;       public Port_typeDao() { resetCache(); }     public void resetCache() { cacheOk = false; cacheData = null; }         public Port_type createValueObject() { return new Port_type(); }       public Port_type getObject(Connection conn, int ID_Port_Type) throws NotFoundException, SQLException {   Port_type valueObject = createValueObject(); valueObject.setID_Port_Type(ID_Port_Type); load(conn, valueObject); return valueObject; }       public void load(Connection conn, Port_type valueObject) throws NotFoundException, SQLException {   String sql = "SELECT * FROM port_type WHERE (ID_Port_Type = ? ) "; PreparedStatement stmt = null;   try { stmt = conn.prepareStatement(sql); stmt.setInt(1, valueObject.getID_Port_Type());   singleQuery(conn, stmt, valueObject);   } finally { if (stmt != null) stmt.close(); } }       public List loadAll(Connection conn) throws SQLException {   // Check the cache status and use Cache if possible. if (cacheOk) { return cacheData; }   String sql = "SELECT * FROM port_type ORDER BY ID_Port_Type ASC "; List searchResults = listQuery(conn, conn.prepareStatement(sql));   // Update cache and mark it ready. cacheData = searchResults; cacheOk = true;   return searchResults; }         public synchronized void create(Connection conn, Port_type valueObject) throws SQLException {   String sql = ""; PreparedStatement stmt = null; ResultSet result = null;   try { sql = "INSERT INTO port_type ( ID_Port_Type, Port_Type_Name, Port_Type_capacity) VALUES (?, ?, ?) "; stmt = conn.prepareStatement(sql);   stmt.setInt(1, valueObject.getID_Port_Type()); stmt.setString(2, valueObject.getPort_Type_Name()); stmt.setInt(3, valueObject.getPort_Type_capacity());   int rowcount = databaseUpdate(conn, stmt); if (rowcount != 1) { //System.out.println("PrimaryKey Error when updating DB!"); throw new SQLException("PrimaryKey Error when updating DB!"); }   } finally { if (stmt != null) stmt.close(); }     }       public void save(Connection conn, Port_type valueObject) throws NotFoundException, SQLException {   String sql = "UPDATE port_type SET Port_Type_Name = ?, Port_Type_capacity = ? WHERE (ID_Port_Type = ? ) "; PreparedStatement stmt = null;   try { stmt = conn.prepareStatement(sql); stmt.setString(1, valueObject.getPort_Type_Name()); stmt.setInt(2, valueObject.getPort_Type_capacity());   stmt.setInt(3, valueObject.getID_Port_Type());   int rowcount = databaseUpdate(conn, stmt); if (rowcount == 0) { //System.out.println("Object could not be saved! (PrimaryKey not found)"); throw new NotFoundException("Object could not be saved! (PrimaryKey not found)"); } if (rowcount > 1) { //System.out.println("PrimaryKey Error when updating DB! (Many objects were affected!)"); throw new SQLException("PrimaryKey Error when updating DB! (Many objects were affected!)"); } } finally { if (stmt != null) stmt.close(); } }       public void delete(Connection conn, Port_type valueObject) throws NotFoundException, SQLException {   String sql = "DELETE FROM port_type WHERE (ID_Port_Type = ? ) "; PreparedStatement stmt = null;   try { stmt = conn.prepareStatement(sql); stmt.setInt(1, valueObject.getID_Port_Type());   int rowcount = databaseUpdate(conn, stmt); if (rowcount == 0) { //System.out.println("Object could not be deleted (PrimaryKey not found)"); throw new NotFoundException("Object could not be deleted! (PrimaryKey not found)"); } if (rowcount > 1) { //System.out.println("PrimaryKey Error when updating DB! (Many objects were deleted!)"); throw new SQLException("PrimaryKey Error when updating DB! (Many objects were deleted!)"); } } finally { if (stmt != null) stmt.close(); } }       public void deleteAll(Connection conn) throws SQLException {   String sql = "DELETE FROM port_type"; PreparedStatement stmt = null;   try { stmt = conn.prepareStatement(sql); int rowcount = databaseUpdate(conn, stmt); } finally { if (stmt != null) stmt.close(); } }       public int countAll(Connection conn) throws SQLException {   // Check the cache status and use Cache if possible. if (cacheOk) { return cacheData.size(); }     String sql = "SELECT count(*) FROM port_type"; PreparedStatement stmt = null; ResultSet result = null; int allRows = 0;   try { stmt = conn.prepareStatement(sql); result = stmt.executeQuery();   if (result.next()) allRows = result.getInt(1); } finally { if (result != null) result.close(); if (stmt != null) stmt.close(); } return allRows; }       public List searchMatching(Connection conn, Port_type valueObject) throws SQLException {   List searchResults;   boolean first = true; StringBuffer sql = new StringBuffer("SELECT * FROM port_type WHERE 1=1 ");   if (valueObject.getID_Port_Type() != 0) { if (first) { first = false; } sql.append("AND ID_Port_Type = ").append(valueObject.getID_Port_Type()).append(" "); }   if (valueObject.getPort_Type_Name() != null) { if (first) { first = false; } sql.append("AND Port_Type_Name LIKE '").append(valueObject.getPort_Type_Name()).append("%' "); }   if (valueObject.getPort_Type_capacity() != 0) { if (first) { first = false; } sql.append("AND Port_Type_capacity = ").append(valueObject.getPort_Type_capacity()).append(" "); }     sql.append("ORDER BY ID_Port_Type ASC ");   // Prevent accidential full table results. // Use loadAll if all rows must be returned. if (first) searchResults = new ArrayList(); else searchResults = listQuery(conn, conn.prepareStatement(sql.toString()));   return searchResults; }       public String getDaogenVersion() { return "******************************"; }       protected int databaseUpdate(Connection conn, PreparedStatement stmt) throws SQLException {   int result = stmt.executeUpdate();   resetCache();   return result; }         protected void singleQuery(Connection conn, PreparedStatement stmt, Port_type valueObject) throws NotFoundException, SQLException {   ResultSet result = null;   try { result = stmt.executeQuery();   if (result.next()) {   valueObject.setID_Port_Type(result.getInt("ID_Port_Type")); valueObject.setPort_Type_Name(result.getString("Port_Type_Name")); valueObject.setPort_Type_capacity(result.getInt("Port_Type_capacity"));   } else { //System.out.println("Port_type Object Not Found!"); throw new NotFoundException("Port_type Object Not Found!"); } } finally { if (result != null) result.close(); if (stmt != null) stmt.close(); } }       protected List listQuery(Connection conn, PreparedStatement stmt) throws SQLException {   ArrayList searchResults = new ArrayList(); ResultSet result = null;   try { result = stmt.executeQuery();   while (result.next()) { Port_type temp = createValueObject();   temp.setID_Port_Type(result.getInt("ID_Port_Type")); temp.setPort_Type_Name(result.getString("Port_Type_Name")); temp.setPort_Type_capacity(result.getInt("Port_Type_capacity"));   searchResults.add(temp); }   } finally { if (result != null) result.close(); if (stmt != null) stmt.close(); }   return (List)searchResults; }     }

---

2) une table qui contient un foriegn key vers une autre table. je suis arrivé à résoudre ce probème et voici les codes.

Objet métier:

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352

/*  * To change this template, choose Tools | Templates  * and open the template in the editor.  */   package port_type_daogen;   import java.io.*; import java.sql.*; import java.util.*; import java.math.*;   /**   * Board_ref Value Object.   * This class is value object representing database table board_ref   * This class is intented to be used together with associated Dao object.   */       public class Board_ref implements Cloneable, Serializable {   /**      * Persistent Instance variables. This data is directly      * mapped to the columns of database table.      */ private int ID_Board_Ref; private String Board_Ref; private String Board_Ref_Name; private Boardclass Board_Class = new Boardclass(); private int Board_Slothoused; private Port_type Board_Port_type1 = new Port_type(); private int Board_Port_Type1_number; private Port_type Board_Port_type2 = new Port_type(); private int Board_Port_Type2_number; private Port_type Board_Port_type3 = new Port_type(); private int Board_Port_Type3_number; private int NeededService_Board; private Eng_rule_board_valid_slot Board_Slot_rule = new Eng_rule_board_valid_slot();       /**      * Constructors. DaoGen generates two constructors by default.      * The first one takes no arguments and provides the most simple      * way to create object instance. The another one takes one      * argument, which is the primary key of the corresponding table.      */   public Board_ref () {   }   public Board_ref (int ID_Board_RefIn) {   this.ID_Board_Ref = ID_Board_RefIn;   }     /**      * Get- and Set-methods for persistent variables. The default      * behaviour does not make any checks against malformed data,      * so these might require some manual additions.      */   public int getID_Board_Ref() { return this.ID_Board_Ref; } public void setID_Board_Ref(int ID_Board_RefIn) { this.ID_Board_Ref = ID_Board_RefIn; }   public String getBoard_Ref() { return this.Board_Ref; } public void setBoard_Ref(String Board_RefIn) { this.Board_Ref = Board_RefIn; }   public String getBoard_Ref_Name() { return this.Board_Ref_Name; } public void setBoard_Ref_Name(String Board_Ref_NameIn) { this.Board_Ref_Name = Board_Ref_NameIn; }   public Boardclass getBoard_Class() { return this.Board_Class; } public void setBoard_Class(Boardclass Board_ClassIn) { this.Board_Class = Board_ClassIn; }   public int getBoard_Slothoused() { return this.Board_Slothoused; } public void setBoard_Slothoused(int Board_SlothousedIn) { this.Board_Slothoused = Board_SlothousedIn; }   public Port_type getBoard_Port_type1() { return this.Board_Port_type1; } public void setBoard_Port_type1(Port_type Board_Port_type1In) { this.Board_Port_type1 = Board_Port_type1In; }   public int getBoard_Port_Type1_number() { return this.Board_Port_Type1_number; } public void setBoard_Port_Type1_number(int Board_Port_Type1_numberIn) { this.Board_Port_Type1_number = Board_Port_Type1_numberIn; }   public Port_type getBoard_Port_type2() { return this.Board_Port_type2; } public void setBoard_Port_type2(Port_type Board_Port_type2In) { this.Board_Port_type2 = Board_Port_type2In; }   public int getBoard_Port_Type2_number() { return this.Board_Port_Type2_number; } public void setBoard_Port_Type2_number(int Board_Port_Type2_numberIn) { this.Board_Port_Type2_number = Board_Port_Type2_numberIn; }   public Port_type getBoard_Port_type3() { return this.Board_Port_type3; } public void setBoard_Port_type3(Port_type Board_Port_type3In) { this.Board_Port_type3 = Board_Port_type3In; }   public int getBoard_Port_Type3_number() { return this.Board_Port_Type3_number; } public void setBoard_Port_Type3_number(int Board_Port_Type3_numberIn) { this.Board_Port_Type3_number = Board_Port_Type3_numberIn; }   public int getNeededService_Board() { return this.NeededService_Board; } public void setNeededService_Board(int NeededService_BoardIn) { this.NeededService_Board = NeededService_BoardIn; }   public Eng_rule_board_valid_slot getBoard_Slot_rule() { return this.Board_Slot_rule; } public void setBoard_Slot_rule(Eng_rule_board_valid_slot Board_Slot_ruleIn) { this.Board_Slot_rule = Board_Slot_ruleIn; }       /**      * setAll allows to set all persistent variables in one method call.      * This is useful, when all data is available and it is needed to      * set the initial state of this object. Note that this method will      * directly modify instance variales, without going trough the      * individual set-methods.      */   public void setAll(int ID_Board_RefIn, String Board_RefIn, String Board_Ref_NameIn, Boardclass Board_ClassIn, int Board_SlothousedIn, Port_type Board_Port_type1In, int Board_Port_Type1_numberIn, Port_type Board_Port_type2In, int Board_Port_Type2_numberIn, Port_type Board_Port_type3In, int Board_Port_Type3_numberIn, int NeededService_BoardIn, Eng_rule_board_valid_slot Board_Slot_ruleIn) { this.ID_Board_Ref = ID_Board_RefIn; this.Board_Ref = Board_RefIn; this.Board_Ref_Name = Board_Ref_NameIn; this.Board_Class = Board_ClassIn; this.Board_Slothoused = Board_SlothousedIn; this.Board_Port_type1 = Board_Port_type1In; this.Board_Port_Type1_number = Board_Port_Type1_numberIn; this.Board_Port_type2 = Board_Port_type2In; this.Board_Port_Type2_number = Board_Port_Type2_numberIn; this.Board_Port_type3 = Board_Port_type3In; this.Board_Port_Type3_number = Board_Port_Type3_numberIn; this.NeededService_Board = NeededService_BoardIn; this.Board_Slot_rule = Board_Slot_ruleIn; }     /**      * hasEqualMapping-method will compare two Board_ref instances      * and return true if they contain same values in all persistent instance      * variables. If hasEqualMapping returns true, it does not mean the objects      * are the same instance. However it does mean that in that moment, they      * are mapped to the same row in database.      */ public boolean hasEqualMapping(Board_ref valueObject) {   if (valueObject.getID_Board_Ref() != this.ID_Board_Ref) { return(false); } if (this.Board_Ref == null) { if (valueObject.getBoard_Ref() != null) return(false); } else if (!this.Board_Ref.equals(valueObject.getBoard_Ref())) { return(false); } if (this.Board_Ref_Name == null) { if (valueObject.getBoard_Ref_Name() != null) return(false); } else if (!this.Board_Ref_Name.equals(valueObject.getBoard_Ref_Name())) { return(false); } if (valueObject.getBoard_Class() != this.Board_Class) { return(false); } if (valueObject.getBoard_Slothoused() != this.Board_Slothoused) { return(false); } if (valueObject.getBoard_Port_type1() != this.Board_Port_type1) { return(false); } if (valueObject.getBoard_Port_Type1_number() != this.Board_Port_Type1_number) { return(false); } if (valueObject.getBoard_Port_type2() != this.Board_Port_type2) { return(false); } if (valueObject.getBoard_Port_Type2_number() != this.Board_Port_Type2_number) { return(false); } if (valueObject.getBoard_Port_type3() != this.Board_Port_type3) { return(false); } if (valueObject.getBoard_Port_Type3_number() != this.Board_Port_Type3_number) { return(false); } if (valueObject.getNeededService_Board() != this.NeededService_Board) { return(false); } if (valueObject.getBoard_Slot_rule() != this.Board_Slot_rule) { return(false); }   return true; }       /**      * toString will return String object representing the state of this      * valueObject. This is useful during application development, and      * possibly when application is writing object states in textlog.      */ public String toString() { StringBuffer out = new StringBuffer(this.getDaogenVersion()); // StringBuffer out = new StringBuffer(); out.append("\nclass Board_ref, mapping to table board_ref\n"); out.append("Persistent attributes: \n"); out.append("ID_Board_Ref = " + this.ID_Board_Ref + "\n"); out.append("Board_Ref = " + this.Board_Ref + "\n"); out.append("Board_Ref_Name = " + this.Board_Ref_Name + "\n");   //out.append("Board_Class = " + this.Board_Class + "\n"); out.append(this.Board_Class.toString()); //out.append(Board_Class.toString());   out.append("Board_Slothoused = " + this.Board_Slothoused + "\n"); //out.append("Board_Port_type1 = " + this.Board_Port_type1.toString() + "\n"); out.append(this.Board_Port_type1.toString()); out.append("Board_Port_Type1_number = " + this.Board_Port_Type1_number + "\n"); //out.append("Board_Port_type2 = " + this.Board_Port_type2 + "\n"); out.append(this.Board_Port_type2.toString()); out.append("Board_Port_Type2_number = " + this.Board_Port_Type2_number + "\n"); //out.append("Board_Port_type3 = " + this.Board_Port_type3 + "\n"); out.append(this.Board_Port_type3.toString()); out.append("Board_Port_Type3_number = " + this.Board_Port_Type3_number + "\n"); out.append("NeededService_Board = " + this.NeededService_Board + "\n"); //out.append("Board_Slot_rule = " + this.Board_Slot_rule + "\n"); out.append(this.Board_Slot_rule.toString()); return out.toString();   // trial avec str   // String str = "\nclass Board_ref, mapping to table board_ref\n"; // str += "Persistent attributes: \n"; // str += "ID_Board_Ref = " + this.ID_Board_Ref + "\n"; // str += "Board_Ref = " + this.Board_Ref + "\n"; // str += "Board_Ref_Name = " + this.Board_Ref_Name + "\n"; // str += this.Board_Class.toString(); // str += "Board_Slothoused = " + this.Board_Slothoused + "\n"; // str += this.Board_Port_type1.toString(); // str += "Board_Port_Type1_number = " + this.Board_Port_Type1_number + "\n" ; // str += this.Board_Port_type2.toString(); // str += "Board_Port_Type2_number = " + this.Board_Port_Type2_number + "\n"; // str += this.Board_Port_type3.toString(); // str += "Board_Port_Type3_number = " + this.Board_Port_Type3_number + "\n"; // str += "NeededService_Board = " + this.NeededService_Board + "\n"; // str += this.Board_Slot_rule.toString(); // // return str;   }     /**      * Clone will return identical deep copy of this valueObject.      * Note, that this method is different than the clone() which      * is defined in java.lang.Object. Here, the retuned cloned object      * will also have all its attributes cloned.      */ public Object clone() { Board_ref cloned = new Board_ref();   cloned.setID_Board_Ref(this.ID_Board_Ref); if (this.Board_Ref != null) cloned.setBoard_Ref(new String(this.Board_Ref)); if (this.Board_Ref_Name != null) cloned.setBoard_Ref_Name(new String(this.Board_Ref_Name)); cloned.setBoard_Class(this.Board_Class); cloned.setBoard_Slothoused(this.Board_Slothoused); cloned.setBoard_Port_type1(this.Board_Port_type1); cloned.setBoard_Port_Type1_number(this.Board_Port_Type1_number); cloned.setBoard_Port_type2(this.Board_Port_type2); cloned.setBoard_Port_Type2_number(this.Board_Port_Type2_number); cloned.setBoard_Port_type3(this.Board_Port_type3); cloned.setBoard_Port_Type3_number(this.Board_Port_Type3_number); cloned.setNeededService_Board(this.NeededService_Board); cloned.setBoard_Slot_rule(this.Board_Slot_rule); return cloned; }       /**      * getDaogenVersion will return information about      * generator which created these sources.      */ public String getDaogenVersion() { // return "DaoGen version 2.4.1"; return "**********************************"; }   }

---

et l'objet DAO :

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656

/*  * To change this template, choose Tools | Templates  * and open the template in the editor.  */   package port_type_daogen;   import java.sql.*; import java.util.*; //import java.math.*; import java.sql.Connection;   /**   * Board_ref Data Access Object (DAO).   * This class contains all database handling that is needed to   * permanently store and retrieve Board_ref object instances.   */           public class Board_refDao {   // Cache contents: private boolean cacheOk; private List cacheData;     /**      * Constructor for Dao. This constructor will only reset cache.      * If extended Dao classes are generated, it is important to      * make sure resetCache() will be called in constructor.      */ public Board_refDao() { resetCache(); }   /**      * resetCache-method. This is important method when caching is used      * to keep data in Dao instance. This method must be called whenever      * the data in table has been changed. This method will mark current      * cache to be outdated and next time when cacheable data will be      * retrieved from database, the cache will be rebuilt. Please note      * that using Dao-cache can have remarkable performace boost or it may      * not help at all. It all depends on the amount of data and the rate      * that data is being changed.      */ public final void resetCache() { cacheOk = false; cacheData = null; }       /**      * createValueObject-method. This method is used when the Dao class needs      * to create new value object instance. The reason why this method exists      * is that sometimes the programmer may want to extend also the valueObject      * and then this method can be overrided to return extended valueObject.      * NOTE: If you extend the valueObject class, make sure to override the      * clone() method in it!      */ public Board_ref createValueObject() { return new Board_ref(); }     /**      * getObject-method. This will create and load valueObject contents from database      * using given Primary-Key as identifier. This method is just a convenience method      * for the real load-method which accepts the valueObject as a parameter. Returned      * valueObject will be created using the createValueObject() method.      */ public Board_ref getObject(Connection conn, int ID_Board_Ref) throws NotFoundException, SQLException {   Board_ref valueObject = createValueObject(); valueObject.setID_Board_Ref(ID_Board_Ref); load(conn, valueObject); return valueObject; }     /**      * load-method. This will load valueObject contents from database using      * Primary-Key as identifier. Upper layer should use this so that valueObject      * instance is created and only primary-key should be specified. Then call      * this method to complete other persistent information. This method will      * overwrite all other fields except primary-key and possible runtime variables.      * If load can not find matching row, NotFoundException will be thrown.      *      * @param conn         This method requires working database connection.      * @param valueObject  This parameter contains the class instance to be loaded.      *                     Primary-key field must be set for this to work properly.      */ public void load(Connection conn, Board_ref valueObject) throws NotFoundException, SQLException {   String sql = "SELECT * FROM board_ref WHERE (ID_Board_Ref = ? ) "; PreparedStatement stmt = null;   try { stmt = conn.prepareStatement(sql); stmt.setInt(1, valueObject.getID_Board_Ref());   singleQuery(conn, stmt, valueObject);   } finally { if (stmt != null) stmt.close(); } }     /**      * LoadAll-method. This will read all contents from database table and      * build a List containing valueObjects. Please note, that this method      * will consume huge amounts of resources if table has lot's of rows.      * This should only be used when target tables have only small amounts      * of data.      *      * @param conn         This method requires working database connection.      */ public List loadAll(Connection conn) throws SQLException {   // Check the cache status and use Cache if possible. if (cacheOk) { return cacheData; }   String sql = "SELECT * FROM board_ref ORDER BY ID_Board_Ref ASC "; List searchResults = listQuery(conn, conn.prepareStatement(sql));   // Update cache and mark it ready. cacheData = searchResults; cacheOk = true;   return searchResults; }       /**      * create-method. This will create new row in database according to supplied      * valueObject contents. Make sure that values for all NOT NULL columns are      * correctly specified. Also, if this table does not use automatic surrogate-keys      * the primary-key must be specified. After INSERT command this method will      * read the generated primary-key back to valueObject if automatic surrogate-keys      * were used.      *      * @param conn         This method requires working database connection.      * @param valueObject  This parameter contains the class instance to be created.      *                     If automatic surrogate-keys are not used the Primary-key      *                     field must be set for this to work properly.      */ public synchronized void create(Connection conn, Board_ref valueObject) throws SQLException {   String sql = ""; PreparedStatement stmt = null; ResultSet result = null;   // Connection conn = null; // conn = ConnectDatabaseDAO.getInstance(); // création des objets DAO //BoardclassDao boardclass_dao = new BoardclassDao (); try { sql = "INSERT INTO board_ref ( ID_Board_Ref, Board_Ref, Board_Ref_Name, " + "ID_Board_Class, Board_Slothoused, Board_Port_type1, " + "Board_Port_Type1_number, Board_Port_type2, Board_Port_Type2_number, " + "Board_Port_type3, Board_Port_Type3_number, NeededService_Board, " + "ID_Board_Slot_rule) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) "; stmt = conn.prepareStatement(sql); // créer un board class // if(valueObject.getBoard_Class().getID_BoardClass() == 0){ BoardclassDao boardclass_dao = new BoardclassDao (); //DAO<Langage> langageDAO = AbstractDAOFactory .getFactory(FactoryType.DAO_FACTORY) //.getLangageDAO(); // obj.setLangage(langageDAO.create(obj.getLangage())); // boardclass_dao.create(conn, valueObject.getBoard_Class()); //valueObject.setBoard_Class(boardclass_dao.create(conn, valueObject.getBoard_Class())); // }   //BoardclassDao boardclass_dao = new BoardclassDao ();   stmt.setInt(1, valueObject.getID_Board_Ref()); stmt.setString(2, valueObject.getBoard_Ref()); stmt.setString(3, valueObject.getBoard_Ref_Name()); // stmt.setInt(4, valueObject.getBoard_Class().getID_BoardClass()); // valueObject.setBoard_Class(boardclass_dao.create(conn, valueObject.getBoard_Class()));   // stmt.setBoard_Class(4, boardclass_dao.create(conn, valueObject.getBoard_Class())); // stmt.setBoard_Class (4, valueObject.getBoard_Class()); stmt.setInt(4, valueObject.getBoard_Class().getID_BoardClass()); stmt.setInt(5, valueObject.getBoard_Slothoused()); stmt.setInt(6, valueObject.getBoard_Port_type1().getID_Port_Type()); stmt.setInt(7, valueObject.getBoard_Port_Type1_number()); stmt.setInt(8, valueObject.getBoard_Port_type2().getID_Port_Type()); stmt.setInt(9, valueObject.getBoard_Port_Type2_number()); stmt.setInt(10, valueObject.getBoard_Port_type3().getID_Port_Type()); stmt.setInt(11, valueObject.getBoard_Port_Type3_number()); stmt.setInt(12, valueObject.getNeededService_Board()); stmt.setInt(13, valueObject.getBoard_Slot_rule().getEng_Rule_Board_Valid_Slot_ID());   int rowcount = databaseUpdate(conn, stmt); if (rowcount != 1) { //System.out.println("PrimaryKey Error when updating DB!"); throw new SQLException("PrimaryKey Error when updating DB!"); }   } finally { if (stmt != null) stmt.close(); }     }     /**      * save-method. This method will save the current state of valueObject to database.      * Save can not be used to create new instances in database, so upper layer must      * make sure that the primary-key is correctly specified. Primary-key will indicate      * which instance is going to be updated in database. If save can not find matching      * row, NotFoundException will be thrown.      *      * @param conn         This method requires working database connection.      * @param valueObject  This parameter contains the class instance to be saved.      *                     Primary-key field must be set for this to work properly.      */ public void save(Connection conn, Board_ref valueObject) throws NotFoundException, SQLException {   String sql = "UPDATE board_ref SET Board_Ref = ?, Board_Ref_Name = ?, ID_Board_Class = ?, " + "Board_Slothoused = ?, Board_Port_type1 = ?, Board_Port_Type1_number = ?, " + "Board_Port_type2 = ?, Board_Port_Type2_number = ?, Board_Port_type3 = ?, " + "Board_Port_Type3_number = ?, NeededService_Board = ?, ID_Board_Slot_rule = ? WHERE (ID_Board_Ref = ? ) "; PreparedStatement stmt = null;   try { stmt = conn.prepareStatement(sql); stmt.setString(1, valueObject.getBoard_Ref()); stmt.setString(2, valueObject.getBoard_Ref_Name()); stmt.setInt(3, valueObject.getBoard_Class().getID_BoardClass()); stmt.setInt(4, valueObject.getBoard_Slothoused()); stmt.setInt(5, valueObject.getBoard_Port_type1().getID_Port_Type()); stmt.setInt(6, valueObject.getBoard_Port_Type1_number()); stmt.setInt(7, valueObject.getBoard_Port_type2().getID_Port_Type()); stmt.setInt(8, valueObject.getBoard_Port_Type2_number()); stmt.setInt(9, valueObject.getBoard_Port_type3().getID_Port_Type()); stmt.setInt(10, valueObject.getBoard_Port_Type3_number()); stmt.setInt(11, valueObject.getNeededService_Board()); stmt.setInt(12, valueObject.getBoard_Slot_rule().getEng_Rule_Board_Valid_Slot_ID());   stmt.setInt(13, valueObject.getID_Board_Ref());   int rowcount = databaseUpdate(conn, stmt); if (rowcount == 0) { //System.out.println("Object could not be saved! (PrimaryKey not found)"); throw new NotFoundException("Object could not be saved! (PrimaryKey not found)"); } if (rowcount > 1) { //System.out.println("PrimaryKey Error when updating DB! (Many objects were affected!)"); throw new SQLException("PrimaryKey Error when updating DB! (Many objects were affected!)"); } } finally { if (stmt != null) stmt.close(); } }     /**      * delete-method. This method will remove the information from database as identified by      * by primary-key in supplied valueObject. Once valueObject has been deleted it can not      * be restored by calling save. Restoring can only be done using create method but if      * database is using automatic surrogate-keys, the resulting object will have different      * primary-key than what it was in the deleted object. If delete can not find matching row,      * NotFoundException will be thrown.      *      * @param conn         This method requires working database connection.      * @param valueObject  This parameter contains the class instance to be deleted.      *                     Primary-key field must be set for this to work properly.      */ public void delete(Connection conn, Board_ref valueObject) throws NotFoundException, SQLException {   String sql = "DELETE FROM board_ref WHERE (ID_Board_Ref = ? ) "; PreparedStatement stmt = null;   try { stmt = conn.prepareStatement(sql); stmt.setInt(1, valueObject.getID_Board_Ref());   int rowcount = databaseUpdate(conn, stmt); if (rowcount == 0) { //System.out.println("Object could not be deleted (PrimaryKey not found)"); throw new NotFoundException("Object could not be deleted! (PrimaryKey not found)"); } if (rowcount > 1) { //System.out.println("PrimaryKey Error when updating DB! (Many objects were deleted!)"); throw new SQLException("PrimaryKey Error when updating DB! (Many objects were deleted!)"); } } finally { if (stmt != null) stmt.close(); } }     /**      * deleteAll-method. This method will remove all information from the table that matches      * this Dao and ValueObject couple. This should be the most efficient way to clear table.      * Once deleteAll has been called, no valueObject that has been created before can be      * restored by calling save. Restoring can only be done using create method but if database      * is using automatic surrogate-keys, the resulting object will have different primary-key      * than what it was in the deleted object. (Note, the implementation of this method should      * be different with different DB backends.)      *      * @param conn         This method requires working database connection.      */ public void deleteAll(Connection conn) throws SQLException {   String sql = "DELETE FROM board_ref"; PreparedStatement stmt = null;   try { stmt = conn.prepareStatement(sql); int rowcount = databaseUpdate(conn, stmt); } finally { if (stmt != null) stmt.close(); } }     /**      * coutAll-method. This method will return the number of all rows from table that matches      * this Dao. The implementation will simply execute "select count(primarykey) from table".      * If table is empty, the return value is 0. This method should be used before calling      * loadAll, to make sure table has not too many rows.      *      * @param conn         This method requires working database connection.      */ public int countAll(Connection conn) throws SQLException {   // Check the cache status and use Cache if possible. if (cacheOk) { return cacheData.size(); }     String sql = "SELECT count(*) FROM board_ref"; PreparedStatement stmt = null; ResultSet result = null; int allRows = 0;   try { stmt = conn.prepareStatement(sql); result = stmt.executeQuery();   if (result.next()) allRows = result.getInt(1); } finally { if (result != null) result.close(); if (stmt != null) stmt.close(); } return allRows; }     /**      * searchMatching-Method. This method provides searching capability to      * get matching valueObjects from database. It works by searching all      * objects that match permanent instance variables of given object.      * Upper layer should use this by setting some parameters in valueObject      * and then  call searchMatching. The result will be 0-N objects in a List,      * all matching those criteria you specified. Those instance-variables that      * have NULL values are excluded in search-criteria.      *      * @param conn         This method requires working database connection.      * @param valueObject  This parameter contains the class instance where search will be based.      *                     Primary-key field should not be set.      */ public List searchMatching(Connection conn, Board_ref valueObject) throws SQLException {   List searchResults;   boolean first = true; StringBuffer sql = new StringBuffer("SELECT * FROM board_ref WHERE 1=1 ");   if (valueObject.getID_Board_Ref() != 0) { if (first) { first = false; } sql.append("AND ID_Board_Ref = ").append(valueObject.getID_Board_Ref()).append(" "); }   if (valueObject.getBoard_Ref() != null) { if (first) { first = false; } sql.append("AND Board_Ref LIKE '").append(valueObject.getBoard_Ref()).append("%' "); }   if (valueObject.getBoard_Ref_Name() != null) { if (first) { first = false; } sql.append("AND Board_Ref_Name LIKE '").append(valueObject.getBoard_Ref_Name()).append("%' "); }   if (valueObject.getBoard_Class().getID_BoardClass() != 0) { if (first) { first = false; } sql.append("AND ID_Board_Class = ").append(valueObject.getBoard_Class().getID_BoardClass()).append(" "); }   if (valueObject.getBoard_Slothoused() != 0) { if (first) { first = false; } sql.append("AND Board_Slothoused = ").append(valueObject.getBoard_Slothoused()).append(" "); }   if (valueObject.getBoard_Port_type1().getID_Port_Type() != 0) { if (first) { first = false; } sql.append("AND Board_Port_type1 = ").append(valueObject.getBoard_Port_type1().getID_Port_Type()).append(" "); }   if (valueObject.getBoard_Port_Type1_number() != 0) { if (first) { first = false; } sql.append("AND Board_Port_Type1_number = ").append(valueObject.getBoard_Port_Type1_number()).append(" "); }   if (valueObject.getBoard_Port_type2().getID_Port_Type() != 0) { if (first) { first = false; } sql.append("AND Board_Port_type2 = ").append(valueObject.getBoard_Port_type2().getID_Port_Type()).append(" "); }   if (valueObject.getBoard_Port_Type2_number() != 0) { if (first) { first = false; } sql.append("AND Board_Port_Type2_number = ").append(valueObject.getBoard_Port_Type2_number()).append(" "); }   if (valueObject.getBoard_Port_type3().getID_Port_Type() != 0) { if (first) { first = false; } sql.append("AND Board_Port_type3 = ").append(valueObject.getBoard_Port_type3().getID_Port_Type()).append(" "); }   if (valueObject.getBoard_Port_Type3_number() != 0) { if (first) { first = false; } sql.append("AND Board_Port_Type3_number = ").append(valueObject.getBoard_Port_Type3_number()).append(" "); }   if (valueObject.getNeededService_Board() != 0) { if (first) { first = false; } sql.append("AND NeededService_Board = ").append(valueObject.getNeededService_Board()).append(" "); }   if (valueObject.getBoard_Slot_rule().getEng_Rule_Board_Valid_Slot_ID() != 0) { if (first) { first = false; } sql.append("AND ID_Board_Slot_rule = ").append(valueObject.getBoard_Slot_rule().getEng_Rule_Board_Valid_Slot_ID()).append(" "); }     sql.append("ORDER BY ID_Board_Ref ASC ");   // Prevent accidential full table results. // Use loadAll if all rows must be returned. if (first) searchResults = new ArrayList(); else searchResults = listQuery(conn, conn.prepareStatement(sql.toString()));   return searchResults; }     /**      * getDaogenVersion will return information about      * generator which created these sources.      */ public String getDaogenVersion() { return "DaoGen version 2.4.1"; }     /**      * databaseUpdate-method. This method is a helper method for internal use. It will execute      * all database handling that will change the information in tables. SELECT queries will      * not be executed here however. The return value indicates how many rows were affected.      * This method will also make sure that if cache is used, it will reset when data changes.      *      * @param conn         This method requires working database connection.      * @param stmt         This parameter contains the SQL statement to be excuted.      */ protected int databaseUpdate(Connection conn, PreparedStatement stmt) throws SQLException {   int result = stmt.executeUpdate();   resetCache();   return result; }       /**      * databaseQuery-method. This method is a helper method for internal use. It will execute      * all database queries that will return only one row. The resultset will be converted      * to valueObject. If no rows were found, NotFoundException will be thrown.      *      * @param conn         This method requires working database connection.      * @param stmt         This parameter contains the SQL statement to be excuted.      * @param valueObject  Class-instance where resulting data will be stored.      */ protected void singleQuery(Connection conn, PreparedStatement stmt, Board_ref valueObject) throws NotFoundException, SQLException {   ResultSet result = null;   try { result = stmt.executeQuery(); // à ajouter ************************************************************* BoardclassDao board_class_dao = new BoardclassDao(); Port_typeDao port_type_dao = new Port_typeDao () ; Port_typeDao port_type_dao2 = new Port_typeDao () ; Port_typeDao port_type_dao3 = new Port_typeDao () ; Eng_rule_board_valid_slotDao eng_rule_board_valid_slot_dao = new Eng_rule_board_valid_slotDao();   Boardclass bc = new Boardclass () ; Port_type pt1 = new Port_type () ; Port_type pt2 = new Port_type () ; Port_type pt3 = new Port_type () ; Eng_rule_board_valid_slot valid_slot = new Eng_rule_board_valid_slot(); // fin de l'ajout *********************************************   // br = board_class_dao.getObject(conn, result.getInt("ID_Board_Class")); if (result.next()) { // à ajouter ****************************************************************************************** bc = board_class_dao.getObject(conn, result.getInt("ID_Board_Class")); pt1 = port_type_dao.getObject(conn, result.getInt("Board_Port_type1")); pt2 = port_type_dao2.getObject(conn, result.getInt("Board_Port_type2")); pt3 = port_type_dao3.getObject(conn, result.getInt("Board_Port_type3")); valid_slot = eng_rule_board_valid_slot_dao.getObject(conn, result.getInt("ID_Board_Slot_rule")); // fin de l'ajout *************************************************************************************   valueObject.setID_Board_Ref(result.getInt("ID_Board_Ref")); valueObject.setBoard_Ref(result.getString("Board_Ref")); valueObject.setBoard_Ref_Name(result.getString("Board_Ref_Name")); // valueObject.getBoard_Class().setID_BoardClass((result.getInt("ID_Board_Class"))); valueObject.getBoard_Class().setID_BoardClass(bc.getID_BoardClass()); // un point à suivre******************************************************************************   // ceci permet d'avoir 2 comme valeur pour boardclass_name //valueObject.getBoard_Class().setBoardClass_Name(result.getString("ID_Board_Class")); // ceci permet d'avoir null comme valeur pour boardclass //valueObject.getBoard_Class().setBoardClass_Name(result.getInt("ID_Board_Class")); // ceci ne fonctionne pas //valueObject.getBoard_Class().setBoardClass_Name((getBoard_Class(result.getInt("ID_Board_Class")).getBoardClass_Name())); //***********************************************************************************************   // ceci permet de mettre la valeur de setBoardClass_Name valueObject.getBoard_Class().setBoardClass_Name(bc.getBoardClass_Name());   valueObject.setBoard_Slothoused(result.getInt("Board_Slothoused")); // avec set all // valueObject.getBoard_Class().setAll(bc.getID_BoardClass(), bc.getBoardClass_Name());   // valueObject.getBoard_Port_type1().setID_Port_Type((result.getInt("Board_Port_type1"))); // à ajouter ***************************************************** valueObject.getBoard_Port_type1().setID_Port_Type(pt1.getID_Port_Type()); valueObject.getBoard_Port_type1().setPort_Type_Name(pt1.getPort_Type_Name()); valueObject.getBoard_Port_type1().setPort_Type_capacity(pt1.getPort_Type_capacity()); // fin de l'ajout ************************************************ valueObject.setBoard_Port_Type1_number(result.getInt("Board_Port_Type1_number")); // valueObject.getBoard_Port_type2().setID_Port_Type((result.getInt("Board_Port_type2")));   valueObject.getBoard_Port_type2().setID_Port_Type(pt2.getID_Port_Type()); valueObject.getBoard_Port_type2().setPort_Type_Name(pt2.getPort_Type_Name()); valueObject.getBoard_Port_type2().setPort_Type_capacity(pt2.getPort_Type_capacity());   valueObject.setBoard_Port_Type2_number(result.getInt("Board_Port_Type2_number"));   //valueObject.getBoard_Port_type3().setID_Port_Type((result.getInt("Board_Port_type3")));   valueObject.getBoard_Port_type3().setID_Port_Type(pt3.getID_Port_Type()); valueObject.getBoard_Port_type3().setPort_Type_Name(pt3.getPort_Type_Name()); valueObject.getBoard_Port_type3().setPort_Type_capacity(pt3.getPort_Type_capacity());   valueObject.setBoard_Port_Type3_number(result.getInt("Board_Port_Type3_number")); valueObject.setNeededService_Board(result.getInt("NeededService_Board"));   //valueObject.getBoard_Slot_rule().setEng_Rule_Board_Valid_Slot_ID((result.getInt("ID_Board_Slot_rule")));   valueObject.getBoard_Slot_rule().setEng_Rule_Board_Valid_Slot_ID(valid_slot.getEng_Rule_Board_Valid_Slot_ID()); valueObject.getBoard_Slot_rule().setBoard_Ref(valid_slot.getBoard_Ref()); valueObject.getBoard_Slot_rule().setBoard_valid_slot_numbers(valid_slot.getBoard_valid_slot_numbers()); valueObject.getBoard_Slot_rule().setID_NeType(valid_slot.getID_NeType()); valueObject.getBoard_Slot_rule().setSlot_count(valid_slot.getSlot_count());     } else { //System.out.println("Board_ref Object Not Found!"); throw new NotFoundException("Board_ref Object Not Found!"); } } finally { if (result != null) result.close(); if (stmt != null) stmt.close(); } }     /**      * databaseQuery-method. This method is a helper method for internal use. It will execute      * all database queries that will return multiple rows. The resultset will be converted      * to the List of valueObjects. If no rows were found, an empty List will be returned.      *      * @param conn         This method requires working database connection.      * @param stmt         This parameter contains the SQL statement to be excuted.      */ protected List listQuery(Connection conn, PreparedStatement stmt) throws SQLException {   ArrayList searchResults = new ArrayList(); ResultSet result = null;   try { result = stmt.executeQuery();   while (result.next()) { Board_ref temp = createValueObject();   temp.setID_Board_Ref(result.getInt("ID_Board_Ref")); temp.setBoard_Ref(result.getString("Board_Ref")); temp.setBoard_Ref_Name(result.getString("Board_Ref_Name")); temp.getBoard_Class().setID_BoardClass((result.getInt("ID_Board_Class"))); temp.setBoard_Slothoused(result.getInt("Board_Slothoused")); temp.getBoard_Port_type1().setID_Port_Type((result.getInt("Board_Port_type1"))); temp.setBoard_Port_Type1_number(result.getInt("Board_Port_Type1_number")); temp.getBoard_Port_type2().setID_Port_Type((result.getInt("Board_Port_type2"))); temp.setBoard_Port_Type2_number(result.getInt("Board_Port_Type2_number")); temp.getBoard_Port_type3().setID_Port_Type((result.getInt("Board_Port_type3"))); temp.setBoard_Port_Type3_number(result.getInt("Board_Port_Type3_number")); temp.setNeededService_Board(result.getInt("NeededService_Board")); temp.getBoard_Slot_rule().setEng_Rule_Board_Valid_Slot_ID((result.getInt("ID_Board_Slot_rule")));   searchResults.add(temp); }   } finally { if (result != null) result.close(); if (stmt != null) stmt.close(); }   return (List)searchResults; }     }

---

3) une table qui contient un foriegn key vers la clé primaire de la meme table. je ne suis toujours pas arrivé à résoudre ce probème!!

voici un site générateur automatique de classes objet et classes DAO :
http://titaniclinux.net/daogen .

Merci.