Intégration PHP/JasperReports

    rpm -i php-java-bridge-x.y.z-1-i386.rpm

    java.java_home={Répertoire d'installation JAVA}
    java.java={Répertoire d'installation JAVA}/java

    rpm -i php-java-bridge-tomcat-x.y.z-1.i386.rpm

    Extension=php_java.dll

    ; windows Extensions
    ; Note that ODBC support is built in, so no dll is nedded for it.
    ; Note that mny DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
    ...
    ...
    ;extension-php_mbstring.dll
    ;extension-php_bz2.dll
    ...
    ...
    extension-php_java.dll
    ...
    ...

    ;;;;;;;;;;;;;;;;;;;
    ; Module Settings ;
    ;;;;;;;;;;;;;;;;;;;
    
    [java]
    java.java_home = "c:\Program File\Java\jdk1.5.0_10\bin"
    java.java = "c:\Program File\Java\jdk1.5.0_10\bin\javaw.exe"
    java.class.path = "c:\php\ext\JavaBridge.jar"
    java.library.path = "c:\php\ext"
    ;java.hosts = "127.0.0.1:8080"
    ;java.servlet = On
    java.log_level = 2

    <?php
        phpinfo();
    ?>

    <?php
    // créer une instance de la classe Java java.lang.System dans PHP
    $system = new Java('java.lang.System');
    
    // accéder aux propriétés
    echo 'Java version=' . $system->getProperty('java.version') . ' <br />';
    echo 'Java vendor=' . $system->getProperty('java.vendor') . '<br />';
    echo 'OS=' . $system->getProperty('os.name') . ' ' .
             $system->getProperty('os.version') . ' on ' .
             $system->getProperty('os.arch') . '<br />';
    
    // Exemple avec java.util.Date
    $formater = new Java('java.text.SimpleDateFormat',
                  "EEEE, MMMM dd, yyyy 'at' h:mm:ss a zzzz");
    
    echo $formater->format(new Java('java.util.Date'));
    ?>

    <?php
        $reportsPath ="/home/ccharly/publichtml/utils/reports/";
        $reportFileName = "CommandesClients1";
        $jasperReportsLib = "/home/ccharly/publichtml/utils/jasperlib";
    
         if(extension_loaded('java')) {
        
            // lecture du répertoire où sont rangées les bibliothèques utiles à JasperReports
            $handle = @opendir($jasperReportsLib);
                
            // ajout de tous les fichiers jar au chemin de classe (Class Path)
            while(($new_item = readdir($handle))!==false) {
                
                $java_library_path .= 'file:'.$jasperReportsLib.'/'.$new_item .';';
            }
        
        
            try {
                // chargement des bibliothèques au classpath 
                java_require($java_library_path);
        
                // création de la connexion JDBC 
                $Conn = new Java("org.altic.jasperReports.JdbcConnection");
                // driver        
                $Conn->setDriver("com.mysql.jdbc.Driver");
                // url de connexion
                $Conn->setConnectString("jdbc:mysql://localhost/erpmart");
                // utilisateur
                $Conn->setUser("root");
                // mot de passe
                $Conn->setPassword(null);
        
                // Compilation du fichier JRXML en fichier Jasper        
                $sJcm = new JavaClass("net.sf.jasperreports.engine.JasperCompileManager");
                $report = $sJcm->compileReport($reportsPath .$reportFileName.".jrxml");
        
                // Remplir le modèle avec les données        
                $sJfm = new JavaClass("net.sf.jasperreports.engine.JasperFillManager");
                $print = $sJfm->fillReport(        
                $report, 
                new Java("java.util.HashMap"),
                $Conn->getConnection()
                );
        
                // Export du fichier au format pdf
                $sJem = new JavaClass("net.sf.jasperreports.engine.JasperExportManager");
                $sJem->exportReportToPdfFile($print, $reportsPath .$reportFileName.".pdf");
        
                if (file_exists($reportsPath .$reportFileName.".pdf")){
                     header('Content-disposition: attachment; filename="'.$reportFileName.'.pdf"');
                     header('Content-Type: application/pdf');
                     header('Content-Transfer-Encoding: binary');
                     header('Content-Length: '. @filesize($reportsPath . $reportFileName.".pdf"));
                     header('Pragma: no-cache');
                     header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
                     header('Expires: 0');
                     set_time_limit(0);
                     @readfile($reportsPath .$reportFileName.".pdf") or die("problem occurs.");
                 }
        
            } catch (JavaException $ex) {
                 $trace = new Java("java.io.ByteArrayOutputStream");
                $ex->printStackTrace(new Java("java.io.PrintStream", $trace));
                print "java stack trace: $trace\n";
            }
        }
        
        
        ?>

    package org.altic.jasperReports;
    
    import java.io.FileInputStream;
    import java.io.InputStream;
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import java.util.Properties;
    
    
    /**
     * @author ccharly
     *
     */
    public class JdbcConnection {
    
        private String driver;          // "oracle.jdbc.driver.OracleDriver";
        private String connectString;    // "jdbc:oracle:thin:@YOUR_ORACLE_HOST:1521:YOUR_SID";
        private String user;             //"YOUR_ORACLE_USER_NAME";
        private String password;         // "YOUR_ORACLE_PASSWORD";
        
        
        public JdbcConnection(){
            //loadPropertiesConnection();
        }
        
        public JdbcConnection(String driver, String connectString, String user, String password){
            this.driver = driver;
            this.connectString = connectString;
            this.user = user;
            this.password = password;
        }
        
        
        public void loadPropertiesConnection(){
        
        this.driver = "";
            this.connectString = "";
            this.user = "";
            this.password = "";
            
        try {
            Properties props = new Properties();
            InputStream resourceAsStream = getClass().getResourceAsStream("/connection.properties");
            props.load(resourceAsStream);
            this.setDriver(props.getProperty("driver"));
            this.setConnectString(props.getProperty("connectString"));
            this.setUser(props.getProperty("user"));
            this.setPassword(props.getProperty("password"));
        }catch(Exception e){
            e.printStackTrace();
        }
        }
        
        
        public Connection getConnection()
        {
        try {
            //Change these settings according to your local configuration
                Class.forName(this.getDriver());
                Connection conn = DriverManager.getConnection(
                        this.getConnectString(), 
                        this.getUser(), 
                        this.getPassword());
                return conn;
        }catch(ClassNotFoundException e){
            e.printStackTrace();
        }catch(SQLException e){
            e.printStackTrace();
        }
        return null;
        }
    
    
        public String toString(){
        return     " Driver : " + this.getDriver() + " | " + 
                " ConnectString : " + this.getConnectString()  + " | " +
                " User : " + this.getUser()  + " | " +
                " Password : " + this.getPassword();
        }
        
        public String getConnectString() {
            return connectString;
        }
    
    
        public void setConnectString(String connectString) {
            this.connectString = connectString;
        }
    
    
        public String getDriver() {
            return driver;
        }
    
    
        public void setDriver(String driver) {
            this.driver = driver;
        }
    
    
        public String getPassword() {
            return password;
        }
    
    
        public void setPassword(String password) {
            this.password = password;
        }
    
    
        public String getUser() {
            return user;
        }
    
    
        public void setUser(String user) {
            this.user = user;
        }
        
        
        
    }

    $Conn->setDriver("com.mysql.jdbc.Driver");

    $Conn->setConnectString("jdbc:mysql://{Nom du S}:{port}/{Nom de la Base de données}");

    $Conn->setUser({utilisateur};

    $Conn->setPassword({Mot de passe});