public ArrayList<Ressource> getRessourceList(int resTypeID){
        
        ArrayList<Ressource> ressourceList = new ArrayList<>();
        String SQLString = "";
        PreparedStatement statement = null;
        if(resTypeID==0){
        SQLString = "SELECT sum(qty), Rst.Typename, Rst.Ressourcetypeid FROM ressources rs, ressourceTypes rst "
                + "WHERE rs.ressourceTypeID = rst.ressourceTypeID "
                + "GROUP BY Rst.Typename, Rst.Ressourcetypeid "
                + "ORDER BY Rst.Ressourcetypeid";
        }
        else{
        SQLString = "SELECT sum(qty), Rst.Typename, Rst.Ressourcetypeid FROM ressources rs, ressourceTypes rst "
                + "WHERE rst.ressourceTypeID = ? AND rs.ressourceTypeID = rst.ressourceTypeID "
                + "GROUP BY Rst.Typename, Rst.Ressourcetypeid "
                + "ORDER BY Rst.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(3), rs.getString(2), 0, rs.getInt(1)));
                
            }
            
        } catch (Exception e) {
            System.out.println("Fail in ressourceMapper, getRessourceList1 " + e.toString());
        }
        
        
        
        return ressourceList;
    }