Home / Questions / 11295
Accepted
Lina Cortés
Asked: 2020-05-30 09:43:47 +0800 CST 2020-05-30 09:43:47 +0800 CST

Date data problem in jsf method

  • 772

It may be a silly question but I have not been able to solve the problem I have the following methods:

public long contarPedidosMeses(int cedulaCliente, int codigoProducto, Date fechaIni, Date fechaFin){

    Query q;
    q = em.createNativeQuery("SELECT COUNT(*) FROM pedidos, pedidoproducto WHERE fechaDeSolicitud BETWEEN ? AND ? and pedidos.cedulaCliente=? and pedidoproducto.codigoProducto=? and pedidos.idPedido= pedidoproducto.idPedido");
    q.setParameter(1,fechaIni);
    q.setParameter(2, fechaFin);
    q.setParameter(3, cedulaCliente);
    q.setParameter(4, codigoProducto);
    long valor=Long.parseLong(q.getSingleResult().toString());
    return valor;
}


public long valoresMeses(Date fechaI, Date fechaF, int cedula, int codigo){

    long valores= productosf.contarPedidosMeses(cedula, codigo, fechaI, fechaF);
    return valores;
}

The problem I have is that I don't know how to pass the Date data when calling the method. So the query doesn't work for me.

I have tried as follows:

controladorProducto.valoresMeses('2016/01/01', '2016/01/31', controladorUsuario.objUsuarioLogin.idUsuario, 1)

Also changing the place of the numbers ie (dd/mm/yyyy), but it doesn't work either. In the MonthValues() method I have changed that it does not receive a Date but a String and I try to convert it with SimpleDateFormat but it sends me a very different date when converting it. I don't know what else to do, I would really appreciate your help.

I work in jsf, JPA and the database in MySQL.

mysql

1 Answers

  1. Best Answer

    Your parameters must be of type Date. If you want to construct type objects Datefrom a string (for your tests perhaps), I recommend using SimpleDateFormat:

    SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd");
Date fechaI = sdf.parse("2016/01/01");
Date fechaF = sdf.parse("2016/01/31");
int cedula = ...;
int codigo = ...;
valoresMeses(fechaI, fechaF, cedula, codigo);

    You can save yourself work by creating utility methods:

    //diseño básico, puede ser mejorado
public class MiDateUtils {
    public static Date parseaFecha(String fecha) {
        return parseaFecha(fecha, "yyyy/MM/dd");
    }
    //en caso que necesites utilizar otro formato como dd-MM-yyyy o dd/MM/yyyy o MM/dd/yyyy u otro
    public static Date parseaFecha(String fecha, String formato) {
        Date resultado = null;
        try {
            SimpleDateFormat sdf = new SimpleDateFormat(formato);
            resultado = sdf.format(fecha);
        } catch (Exception e) {
            //maneja la excepción, mandalo a un log o algo
        }
        return resultado;
    }
}

    So the above code reduces to:

    Date fechaI = MiDateUtils.parseaFecha("2016/01/01");
Date fechaF = MiDateUtils.parseaFecha("2016/01/31");
int cedula = ...;
int codigo = ...;
valoresMeses(fechaI, fechaF, cedula, codigo);
    • 1