CategorieServiceJDBCImpl.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package Physique;

import Metier.Categorie;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

public class CategorieServiceJDBCImpl implements CategorieServiceJDBC {

    ConnectionService conn;

    protected CategorieServiceJDBCImpl() {
        try {
            conn = ConnectionService.getInstance(PhysiqueFactory.getBase(), PhysiqueFactory.getHost(), PhysiqueFactory.getNomBase(), PhysiqueFactory.getDbDriver(), PhysiqueFactory.getNdc(), PhysiqueFactory.getMdp());
        } catch (Exception ex) {
            System.err.println("Erreur CategorieServiceJDBCImpl constructeur" + ex);
        }
    }

    @Override
    public ArrayList<Categorie> getAll() {
        ArrayList<Categorie> categories = new ArrayList();
        try {
            Statement st = conn.getStatement();
            ResultSet rs = st.executeQuery("SELECT * FROM categorie");
            while (rs.next()) {
                Categorie categorie = new Categorie(rs.getString("categorie"));
                categorie.setId(rs.getInt("id"));
                categories.add(categorie);
            }
            rs.close();
        } catch (Exception ex) {
            System.err.println("Erreur categorie getall" + ex);
        }
        return categories;
    }

    @Override
    public Categorie getById(int id) {
        Categorie categorie = null;
        try {
            Statement st = conn.getStatement();
            ResultSet rs = st.executeQuery("SELECT * FROM categorie WHERE id ='" + id + "'");
            while (rs.next()) {
                categorie = new Categorie(rs.getString("categorie"));
                categorie.setId(id);
            }
            rs.close();
        } catch (Exception ex) {
            System.err.println("Erreur categorie getbyid" + ex);
        }
        return categorie;
    }

    @Override
    public void add(Categorie categorie) {
        try {
            Statement st = conn.getStatement();
            st.executeUpdate("INSERT INTO categorie(categorie) VALUES ('" + categorie.getNomCategorie() + "')");
            ResultSet rs = st.executeQuery("SELECT * FROM categorie WHERE categorie ='" + categorie.getNomCategorie() + "'");
            while (rs.next()) {
                categorie.setId(rs.getInt("id"));
            }
            rs.close();
        } catch (Exception ex) {
            System.err.println("Erreur categorie add" + ex);
        }
    }

    @Override
    public void remove(Categorie categorie) {
        try {
            Statement st = conn.getStatement();
            st.executeUpdate("DELETE FROM categorie WHERE id ='" + categorie.getId() + "'");
        } catch (Exception ex) {
            System.err.println("Erreur categorie update" + ex);
        }
    }

    @Override
    public Categorie getByNom(String nomCategorie) {
        Categorie categorie = null;
        try {
            Statement st = conn.getStatement();
            ResultSet rs = st.executeQuery("SELECT * FROM categorie WHERE categorie ='" + nomCategorie + "'");
            while (rs.next()) {
                categorie = new Categorie(nomCategorie);
                categorie.setId(rs.getInt("id"));
            }
            rs.close();
        } catch (Exception ex) {
            System.err.println("Erreur categorie getbynom" + ex);
        }
        return categorie;
    }
}