source: ether_eccad/trunk/ECCAD_INTERFACE/WEB-INF/src/org/medias/eccad/persistance/jdbc/CatParametreDAOjdbc.java @ 68

package org.medias.eccad.persistance.jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.LinkedList;
import java.util.List;

import org.medias.eccad.helpers.LoggerPerso;
import org.medias.eccad.modele.CatParametre;
import org.medias.eccad.persistance.dao.CatParametreDAO;
import org.medias.eccad.persistance.exception.PersistanceException;

public class CatParametreDAOjdbc extends GeneriqueDAOjdbc implements CatParametreDAO{
        
        public CatParametreDAOjdbc(SGBD_jdbc sgbd) {
                super (sgbd);
        }
        
        public CatParametreDAOjdbc() {
                super();
        }
        
        
        public List<CatParametre> getListcatParametre() throws PersistanceException {
                Connection conn = null;
                Statement requete;
                String sql;
                List<CatParametre> liste_catParam = new LinkedList<CatParametre>();
                ResultSet resultat = null;
                
                conn = getConnection();
                
                try {LoggerPerso.log(CatParametreDAOjdbc.class, LoggerPerso.DEBUG, "DAOjdbc youhou!!");
                        requete = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
                        sql = "select distinct id_categorieparametre, fullname_categorieparametre from categorieparametre join parametre using (id_categorieparametre) join grille using (id_param);";
                        
                        resultat = requete.executeQuery(sql);
                
                        
                        while (resultat.next()) {
                                liste_catParam.add(new CatParametre(resultat.getInt("id_categorieparametre"), resultat.getString("fullname_categorieparametre")));
                        }
                }
                catch (SQLException sqle){
                        throw new PersistanceException(sqle, "erreur lors de la requete :: CatParametreDAOjdbc.getListParametre");
                }
                finally {
                        closeConnection();
                }
                
                LoggerPerso.log(SGBD_jdbc.class, LoggerPerso.DEBUG, "getListCatParametre::taille::"+liste_catParam.size());

                return liste_catParam;
        }

        
        
        
        
}