CREATE DATABASE `jasper_database`;

CREATE TABLE `jasper_database`.`EMPLOYEE` (
  `NOM` VARCHAR(50) NOT NULL,
  `PRENOM` VARCHAR(50) NOT NULL,
  `AGE` NUMERIC NOT NULL,
  `VILLE` VARCHAR(50) NOT NULL,
  PRIMARY KEY(`NOM`)
) ;

insert into employee (NOM,PRENOM,AGE,VILLE) values ('DUPONT','Paul',25,'PARIS');
insert into employee (NOM,PRENOM,AGE,VILLE) values ('MARTIN','Fred',34,'PARIS');
insert into employee (NOM,PRENOM,AGE,VILLE) values ('WAGNER','Anne',45,'PARIS');
insert into employee (NOM,PRENOM,AGE,VILLE) values ('POLUX','Elea',64,'TOULOUSE');

select * from employee

Compiling to file... .\classic.jasper -> D:\iReport-1.2.1\classic.java
it.businesslogic.ireport.ReportClassLoader@120cb10 
Compilation running time : 25

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.xml.JRXmlLoader;

import com.mysql.jdbc.Driver;

public class GeneratePDF {

    public static void main(String[] args) {

        // - Paramètres de connexion à la base de données
        String url = "jdbc:mysql://localhost/jasper_database";
        String login = "root";
        String password = "root";
        Connection connection = null;

        try {
            // - Connexion à la base
            Driver monDriver = new com.mysql.jdbc.Driver();
            DriverManager.registerDriver(monDriver);
            connection = DriverManager.getConnection(url, login, password);

            // - Chargement et compilation du rapport
            JasperDesign jasperDesign = JRXmlLoader.load("D:\\iReport-1.2.1\\classic.jrxml");
            JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);

            // - Paramètres à envoyer au rapport
            Map parameters = new HashMap();
            parameters.put("Titre", "Titre");

            // - Execution du rapport
            JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, connection);

            // - Création du rapport au format PDF
            JasperExportManager.exportReportToPdfFile(jasperPrint, "D:\\iReport-1.2.1\\classic.pdf");
        } catch (JRException e) {

            e.printStackTrace();
        } catch (SQLException e) {

            e.printStackTrace();
        } finally {
            try {
                 connection.close();
                } catch (SQLException e) {

                        e.printStackTrace();
                }
        }

    }
}