package appletexemple;

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */



import java.applet.Applet;
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 net.sf.jasperreports.view.JasperViewer;
import com.microsoft.sqlserver.jdbc.SQLServerDriver ;


/**
 *
 * @author Amine
 */
public class test extends Applet {
	
	
    /**
     * Initialization method that will be called after the applet is loaded
     * into the browser.
     */
	
    public void init() {
    	
        // TODO start asynchronous download of heavy resources
             // - Paramètres de connexion à la base de données
       String url = "jdbc:sqlserver://Amine:1433;databaseName=dbcpi";
       String login = "sa";
       String password = "mot de passe ";

       try {
           // - Connexion à la base
    	   
    	   
           DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver());
            Connection connection = DriverManager.getConnection(url, login, password);
          
            // - Paramètres à envoyer au rapport
          Map parameters = new HashMap();
       
		parameters.put("Titre", "Titre");
          
		
         //  parametres.put("idStd","$F{idStd}");
         
           
          // Chargement et compilation du rapport
          
          //chargement et compilation du sous-rapport
          JasperDesign jasperDesign1 = JRXmlLoader.load ("C:\\Program Files\\JasperSoft\\iReport-3.7.0\\ireport\\modules\\ext\\RELEVE_DE_NOTES_S2.jrxml");
          JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign1);
          
          // - Execution du rapport
          JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, connection);
          
          // pour l'affichage
          JasperViewer.viewReport(jasperPrint);
         
          
          // - Création du rapport au format PDF
          JasperExportManager.exportReportToPdfFile(jasperPrint, "C:\\Program Files\\JasperSoft\\iReport-3.7.0\\ireport\\modules\\ext\\RELEVE_DE_NOTES_S2.pdf");
          } catch (JRException e) {
           e.printStackTrace();
          } catch (SQLException e) {
           e.printStackTrace();
          }
   }
 
   

  }


  
    // TODO overwrite start(), stop() and destroy() methods