Create iReport variable for database

Question

I need to create a report of the selected month with the information contained in the database, for this I intend to create a variable in iReport that receives the month (by netbens) which will be compared with the existing sql in Ireport that is directly connected to the bank.

Metrodo iReport:

public void imprimir() {
    try {

        JasperPrint print = JasperFillManager.fillReport("C:\\Users\\costa\\OneDrive\\Documentos\\NetBeansProjects\\Relatorio\\Estoque.jasper", null, conexao);

        JasperViewer.viewReport(print, false);

    } catch (Exception e) {
        JOptionPane.showMessageDialog(null, e);
    }
}

SQL present in iReport:

select * from Hospede h where DATE_FORMAT(h.horaini,'%m') = variavel

Answer 1

In this case you will have to create a parameter. In iReport do the following:

It will create a new parameter named "parameter1", you will need to go into properties and edit its name and type.

To use it in your query the notation will be the following $P{parameter name}

select * from Hospede h where DATE_FORMAT(h.horaini,'%m') = $P{nomeparametro}

In java code:

HashMap params = new HashMap<>();
params.put("nomeparametro", parametro);
JasperPrint print = JasperFillManager.fillReport("C:\\Users\\costa\\OneDrive\\Documentos\\NetBeansProjects\\Relatorio\\Estoque.jasper", params, conexao);