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 rengés les librairies utiles à JasperReports
			$handle = @opendir($jasperReportsLib);
				
			// ajout de tous les fichier jar au chemin de classe (Class Path)
			while(($new_item = readdir($handle))!==false) {
				
				$java_library_path .= 'file:'.$jasperReportsLib.'/'.$new_item .';';
			}
		
		
			try {
				// chargement des librairies 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});
			

	$conn->getMySqlConnection({nom du Serveur}, {Port}, {Base de données}, {Utilisateur}, {Mot de passe});
			

	$conn->getConnection({Type de Base},{nom du Serveur}, {Port}, {Base de données}, {Utilisateur}, {Mot de passe});