public static ArrayList getPesquisa3(String prod, String data_in, String data_fim, Integer gmp) throws SQLException, ClassNotFoundException {
        ArrayList<bConsulta> sts = new ArrayList<bConsulta>();
        Connection conPol = conMgr.getConnection("PD");
        ResultSet rs;
        if (conPol == null) {
            throw new SQLException("Numero Maximo de Conexoes Atingida!");
        }
        try {
            call = conPol.prepareCall("{call sp_consulta2_totais3(?,?,?,?)}");
            call.setString(1, prod);
            call.setString(2, data_in);
            call.setString(3, data_fim);
            call.setInt(4, gmp);
            rs = call.executeQuery();
            while (rs.next()) {
                bConsulta reg = new bConsulta();
                //reg.setCod_prod(rs.getString("f1"));
                reg.setDia(rs.getString("f2"));
                reg.setNok(rs.getInt("f3"));
                reg.setOk(rs.getInt("f4"));
                //  reg.setProduzidos(rs.getInt("produzidos"));
                reg.setYield(rs.getFloat("f5"));
                
                sts.add(reg);
            }
        } finally {
            if (conPol != null) {
                conMgr.freeConnection("PD", conPol);
            }
        }
        return sts;
    }