public ArrayList<Ressource> getAllRessources(int restypeID){
        
        ArrayList<Ressource> ressourceList = new ArrayList<>();
        String SQLString = "";
        PreparedStatement statement = null;
        if(restypeID==0){
        SQLString = "SELECT Rs.Ressourcetypeid, Rst.Typename,rs.StorageID, rs.qty   "
                + "FROM ressources rs, ressourceTypes rst WHERE Rst.Ressourcetypeid = Rs.Ressourcetypeid ORDER BY Rs.Ressourcetypeid";
        }
        else
            SQLString = "SELECT Rs.Ressourcetypeid, Rst.Typename,rs.StorageID, rs.qty   "
                + "FROM ressources rs, ressourceTypes rst WHERE Rst.Ressourcetypeid=? AND Rst.Ressourcetypeid = Rs.Ressourcetypeid ORDER BY Rs.Ressourcetypeid";
        
        
        try {
            
            statement = DBConnector.getInstance().getConnection().prepareStatement(SQLString);
            if(restypeID!=0){
                statement.setInt(1, restypeID);
            }
            
            ResultSet rs = statement.executeQuery();
            while(rs.next()){
                
                ressourceList.add(new Ressource(rs.getInt(1), rs.getString(2), rs.getInt(3), rs.getInt(4)));
                
            }
            
        } catch (Exception e) {
            System.out.println("Fail in ressourceMapper, getAllRessource1 " + e.toString());
        }
        
        
        
        return ressourceList;
    }