1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102
| package action;
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.JREmptyDataSource;
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.JasperRunManager;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
import com.mysql.jdbc.Driver;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.hibernate.Session;
import data.Intervention;
import tableManager.InterventionManager;
import util.HibernateUtil;
public class ActionRapport_inter extends Action{
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException, SQLException {
String url = "jdbc:mysql://localhost/materiel";
String login = "root";
String password = "";
HttpSession x=request.getSession(true);
int id=(Integer) x.getAttribute("rapport_inter");
System.out.println("stroopp= "+id);
//int id = Integer.parseInt(str);
InterventionManager intervention = new InterventionManager();
Intervention inter = intervention.findInterevntion(id);
try {
// Driver monDriver = new com.mysql.jdbc.Driver();
// DriverManager.registerDriver(monDriver);
Connection connection =null; //DriverManager.getConnection(url, login, password);
JasperDesign jasperDesign = JRXmlLoader.load("C:\\Documents and Settings\\Administrateur.ADII-D70E1DC408\\Bureau\\intervention.jrxml");
// - Paramètres à envoyer au rapport
Map<String, String> parameters = new HashMap<String, String>();
String date_deb=(String) inter.getDate_debut();
parameters.put("date_deb", date_deb);
parameters.put("date_fin", inter.getDate_fin());
parameters.put("heure_deb", inter.getHeure_debut());
parameters.put("heure_fin", inter.getHeure_fin());
parameters.put("descrip_pb", inter.getDescrip_pb());
JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);
// - Execution du rapport
JasperPrint jasperPrint = JasperFillManager.fillReport (jasperReport, parameters,
connection);
// - Création du rapport au format PDF
JasperExportManager.exportReportToPdfFile(jasperPrint,
"C:\\Documents and Settings\\Administrateur.ADII-D70E1DC408\\Bureau\\intervention.pdf");
} catch (JRException e) {
e.printStackTrace();
}
return mapping.findForward("succes");
}
} |
Partager