membuat laporan dengan dynamic report

FormLaporan.java

package demodynamicreport;

/**
 *
 * @author baguza
 */

import java.sql.*;
import javax.swing.table.DefaultTableModel;
import net.sf.dynamicreports.examples.Templates;
import net.sf.dynamicreports.jasper.builder.export.JasperXlsExporterBuilder;
import net.sf.dynamicreports.jasper.constant.JasperProperty;
import static net.sf.dynamicreports.report.builder.DynamicReports.*;
import net.sf.dynamicreports.report.builder.column.TextColumnBuilder;
import net.sf.dynamicreports.report.datasource.DRDataSource;
import net.sf.dynamicreports.report.exception.DRException;
import net.sf.jasperreports.engine.JRDataSource;


public class FormLaporan extends javax.swing.JFrame {
    int baris = 0;
    static Object kolom[] = {" I D ","       Nama       ","Tanggal Daftar"} ;
    DefaultTableModel mdl = new DefaultTableModel(kolom,baris);
    private String nim,nama;
    private Date tglDaftar; 
    
    public FormLaporan() {
        initComponents();
        isiTable();
    }

    
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        jLabel1 = new javax.swing.JLabel();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        jButton1.setText("Laporan JTable");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });

        jButton2.setText("laporan Database");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });

        jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        jScrollPane1.setViewportView(jTable1);

        jLabel1.setText("//newbieilmu.wordpress.com");

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                        .addContainerGap()
                        .addComponent(jScrollPane1))
                    .addGroup(layout.createSequentialGroup()
                        .addGap(25, 25, 25)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jLabel1)
                            .addGroup(layout.createSequentialGroup()
                                .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 162, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                .addComponent(jButton2)))
                        .addGap(0, 0, Short.MAX_VALUE)))
                .addContainerGap())
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 275, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton1)
                    .addComponent(jButton2))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 22, Short.MAX_VALUE)
                .addComponent(jLabel1)
                .addContainerGap())
        );

        pack();
    }// </editor-fold>                        

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
try {
			JasperXlsExporterBuilder xlsExporter = export.xlsExporter("laporan.xls") // membuat laporan excel dengan nama "laporan.xls"
			                                             .setDetectCellType(true)
			                                             .setIgnorePageMargins(true)
			                                             .setWhitePageBackground(false)
			                                             .setRemoveEmptySpaceBetweenColumns(true);

			TextColumnBuilder itemColumn = col.column("I D", "nim", type.stringType())// membuat kolom pertama dengan label NIM, yang mengambil data dari datasource nim
			                                          .setFixedWidth(30)
			                                          .setStretchWithOverflow(false)
			                                          .addProperty(JasperProperty.PRINT_KEEP_FULL_TEXT, "true");

			report()
			  .setColumnTitleStyle(Templates.columnTitleStyle)
			  .addProperty(JasperProperty.EXPORT_XLS_FREEZE_ROW, "2")
			  .ignorePageWidth()
			  .ignorePagination()
			  .columns(
			  	itemColumn,
			  	col.column("Nama",   "nama",  type.stringType()).setFixedWidth(200),// menambah kolom ke-2, dengan label Nama yang mengambil data dari datasource nama
			  	col.column("Tanggal Daftar", "tgl_daftar", type.dateType()).setFixedWidth(250))// menambah kolom ke-3, dengan label Tanggal Daftar yang mengambil data dari datasource tanggalDaftar
                          .title(cmp.text("").setStyle(Templates.bold12CenteredStyle))// memberi jarak
                          .title(cmp.text("").setStyle(Templates.bold12CenteredStyle))// memberi jarak
                          .title(cmp.text("LAPORAN DATA MAHASISWA").setStyle(Templates.bold12CenteredStyle)) // menulis judul
                          .title(cmp.text("").setStyle(Templates.bold12CenteredStyle)) // memberi jarak
			  .setDataSource(createDataSourceTable())// mengambil data dari metode createDataSourceTable
			  .toXls(xlsExporter); // mengkonversi laporan jadi excel
		} catch (DRException e) {
			e.printStackTrace();
		}       
        
    }                                        

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         
     try {  // keterangan sama dengan diatas
			JasperXlsExporterBuilder xlsExporter = export.xlsExporter("laporan.xls")
			                                             .setDetectCellType(true)
			                                             .setIgnorePageMargins(true)
			                                             .setWhitePageBackground(false)
			                                             .setRemoveEmptySpaceBetweenColumns(true);

			TextColumnBuilder itemColumn = col.column("I D", "nim", type.stringType())
			                                          .setFixedWidth(30)
			                                          .setStretchWithOverflow(false)
			                                          .addProperty(JasperProperty.PRINT_KEEP_FULL_TEXT, "true");

			report()
			  .setColumnTitleStyle(Templates.columnTitleStyle)
			  .addProperty(JasperProperty.EXPORT_XLS_FREEZE_ROW, "2")
			  .ignorePageWidth()
			  .ignorePagination()
			  .columns(
			  	itemColumn,
			  	col.column("Nama",   "nama",  type.stringType()).setFixedWidth(200),
			  	col.column("Tanggal Daftar", "tgl_daftar", type.dateType()).setFixedWidth(250))
                          .title(cmp.text("").setStyle(Templates.bold12CenteredStyle))
                          .title(cmp.text("").setStyle(Templates.bold12CenteredStyle))
                          .title(cmp.text("LAPORAN DATA MAHASISWA").setStyle(Templates.bold12CenteredStyle))
                          .title(cmp.text("").setStyle(Templates.bold12CenteredStyle))
			  .setDataSource(createDataSourceDatabase())
			  .toXls(xlsExporter);
		} catch (DRException e) {
			e.printStackTrace();
		}   // TODO add your handling code here:
    }                                        

    
    private void isiTable() { // untuk memngambil data dari database ke jtable
        try {
            // Setting Driver MySQL
            Class.forName("com.mysql.jdbc.Driver") ;
            // Buat Connection cn
            Connection cn = DriverManager.getConnection("jdbc:mysql:" +
            "///laporan","root","root");
            Statement smt = cn.createStatement();
            ResultSet rs = smt.executeQuery("select * from mahasiswa order by nim");
            while (rs.next()){
                  mdl.addRow(new Object[]{
                  rs.getString("nim"),
                  rs.getString("nama"),
                  rs.getDate("tgl_daftar")
                });
            }
            jTable1.setModel(mdl);
        } catch (Exception e) {
            e.printStackTrace();
        }

    }private JRDataSource createDataSourceTable() { // mengambil data dari jtable, untuk dimasukkan ke laporan
	DRDataSource dataSource = new DRDataSource("nim", "nama", "tgl_daftar");//membuat datasource yang akan dijadikan "variabel name" kolom pada laporan
	int jumlahBaris = jTable1.getRowCount()-1; // mengetahui jumlah kolom pada jtable
        for ( int i=0;i<=jumlahBaris;i++) {
            nim = (String)mdl.getValueAt(i,0);
            nama= (String)mdl.getValueAt(i, 1);
            tglDaftar = (Date) mdl.getValueAt(i, 2);
            dataSource.add(nim,nama,tglDaftar); // mengisi datasource dari data jtable         
        }
        return dataSource; // mengirim nilai datasource
    } private JRDataSource createDataSourceDatabase() { // mengambil data dari database, untuk dimasukkan ke laporan
	DRDataSource dataSource = new DRDataSource("nim", "nama", "tgl_daftar");//membuat datasource yang akan dijadikan "variabel name" kolom pada laporan
	try {
            // Setting Driver MySQL
            Class.forName("com.mysql.jdbc.Driver") ;
            // Buat Connection cn
            Connection cn = DriverManager.getConnection("jdbc:mysql:" +
            "///laporan","root","root");
            Statement smt = cn.createStatement();
            ResultSet rs = smt.executeQuery("select * from mahasiswa order by nim");
            while (rs.next()){
                  nim = rs.getString("nim");
                  nama = rs.getString("nama");
                  tglDaftar = rs.getDate("tgl_daftar");
                  dataSource.add(nim,nama,tglDaftar); // mengisi datasource dari data database
            }

        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
        return dataSource; // mengirim nilai datasource
    }
    
    public static void main(String args[]) {
        /*
         * Set the Nimbus look and feel
         */
        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
        /*
         * If Nimbus (introduced in Java SE 6) is not available, stay with the
         * default look and feel. For details see
         * http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
         */
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(FormLaporan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(FormLaporan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(FormLaporan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(FormLaporan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>

        /*
         * Create and display the form
         */
        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {
                new FormLaporan().setVisible(true);
            }
        });
    }
    // Variables declaration - do not modify                     
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTable jTable1;
    // End of variables declaration                   
}