CANCERDUCUL

package fr.ynov.beaumont.zoo.stockage;

import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.mysql.jdbc.Statement;

import fr.ynov.beaumont.zoo.model.metier.Animal;
import fr.ynov.beaumont.zoo.service.CagePOJO;

public class DaoJDBC {


    private Connection conn;
    private Statement st;

    public DaoJDBC() {
        //DaoJDBC
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/zoo","root","");
            //JDBCImpl
            st = (Statement) conn.createStatement();

        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }


    public List<CagePOJO> lireTous(){
        List<CagePOJO> cagesPOJO = new ArrayList<CagePOJO>();
        try {
            ResultSet res = st.executeQuery("SELECT * FROM animal;");
            //for(CagePOJO c : cagesPOJO)
            while(res.next())
                cagesPOJO.add(new CagePOJO(res.getInt("age"),res.getString("codeAnimal"),res.getInt("idAnimal"),res.getString("nom"),res.getDouble("poids"),res.getInt("x"),res.getInt("y")));
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return cagesPOJO;
    }

    public CagePOJO lire(int cle) {
        CagePOJO cagePOJO = null;
        try {
            ResultSet res = st.executeQuery("SELECT * FROM animal WHERE idAnimal="+cle+";");
            while(res.next())
                cagePOJO = new CagePOJO(res.getInt("age"),res.getString("codeAnimal"),res.getInt("idAnimal"),res.getString("nom"),res.getDouble("poids"),res.getInt("x"),res.getInt("y"));
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return cagePOJO;
    }

    public void inserer(CagePOJO cage) {
        try {
            st.executeUpdate("INSERT INTO animal VALUES ('"+cage.getIdAnimal()+"', '"+cage.getCodeAnimal()+"', '"+cage.getNom()+"', '"+cage.getAge()+"', '"+cage.getPoids()+"', '"+cage.getX()+"', '"+cage.getY()+"');");
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    public void update(int index, CagePOJO cage) {
        try {
            st.executeUpdate("UPDATE animal SET idAnimal='"+cage.getIdAnimal()+"' ,codeAnimal='"+cage.getCodeAnimal()+"',nom='"+cage.getNom()+"',age='"+cage.getAge()+"',poids='"+cage.getPoids()+"',x='"+cage.getX()+"',y='"+cage.getY()+"'  WHERE idAnimal="+index+";");
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    public void effacer(int cle) {
        try {
            st.executeUpdate("DELETE FROM animal WHERE idAnimal="+cle+";");
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    public void effacer(CagePOJO obj) {
        int cle = obj.getIdAnimal();
        try {
            st.executeUpdate("DELETE FROM animal WHERE idAnimal="+cle+";");
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

}