package ContohLaporan;

import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.HashMap;
import java.util.Map;
import javax.swing.JOptionPane;
import net.sf.jasperreports.engine.JasperCompileManager;
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;

public class menulaporan extends javax.swing.JFrame {

private Connection con;
    public menulaporan() {
        initComponents();
    }
    private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
        JasperReport jasRep;
        JasperPrint jasPri;
        Map<String, Object> kode = new HashMap<String, Object>();
        //Map<String, Object> kode=new HashMap<>();
        JasperDesign jasDes;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection
                ("jdbc:mysql://localhost:3306/db_supermarket_siti3", "root", "");
            String filename = System.getProperty("user.dir") + "/src/ContohLaporan/report3.jrxml";
            File report = new File(filename);
            jasDes = JRXmlLoader.load(report);
            kode.clear();
            jasRep = JasperCompileManager.compileReport(jasDes);
            jasPri = JasperFillManager.fillReport(jasRep, kode, con);
            JasperViewer.viewReport(jasPri, false);
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null,
                    "Gagal Menampilkan Laporan: \n"+ e.getMessage());
            //System.out.println(e.getMessage());
        }
    }
}