modul kelas programming : java report via jasperreport

Modul kelas Java programming.© FGroupIndonesia.com

Fungsi Report Library Konfigurasi Netbeans Penerapan Frame Log Warning Removal Source Code

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Report merupakan bentuk layout fixed yang siap diisi dengan multi value baik itu dariinput user maupun database.

Biasanya berupa rendering page html, pdf, ataupun format lain yang serupa.

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

JasperReport (OpenSource)

Berguna sebagai designer layout, maupunviewer yang akan muncul pada frame.

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Download :

Netbeans Plugin http://plugins.netbeans.org/plugin/4425/ireport

JasperReport Library https://sourceforge.net/projects/jasperreports/files/jasperreports/

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Netbeans Plugin

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Total 4Files

JasperReport Library

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Total 67 Files

JasperReport Library

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Tambah 1 File

MasukkanFile dari Distfolder

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Instalasi Netbeans Plugins

Langkahnya:

▪ Menu Tools | Plugins | Downloaded | Add Plugins

▪ Arahkan ke 4 files *.nbm tadi

▪ Klik Install

▪ Klik Next | Accept | Agree | Continue

▪ Restart IDE Now

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

PLUGINS SUKSES!

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Instalasi Library

Langkahnya:

▪ Menu Tools | Libraries | New Library

▪ Beri nama : JasperReport

▪ Lalu Klik Add JAR

▪ Klik add file *.jar (67 files) tadi.

▪ Lalu add file *.jar (1 file) dari Dist folder tadi.

▪ OK

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

LIBRARY SUKSES!

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Ingat!

Project akan terhubung dengan JasperReport jika:

1) Database Server (active)

2) Datasource/Database Configuration

3) File *.jasper dan *.jrxml telah siap

4) Add Library into Project

5) Code memanggil JasperReport Frame

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Database Server (active)

Jika pengguna Xampp :

▪ Aktifkan MySQL

Jika pengguna SQL Server :

▪ Aktifkan SQL

Jika pengguna SQLite:

▪ Pastikan ada file *.db

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Datasource/Database Configuration Berikan detail yg sesuai database masing-masing Diantaranya : database name, userlogin, dan password

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Persiapan *.jasper dan *.jrxml

Klik New File

Pilih Report | Empty Report

Pada Report Inspector Klik Kanan Edit Query

Lalu Tulis SQL statement yg sesuai

Drag & Drop Column dan Element yang diinginkan muncul pada Layout

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

1. Tulislah SQL statement

2. Ingat baik-baikNama-nama kolumField ini

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

3. Drag & Drop Column Field ke Layout

4. Drag & Drop Element ke Layout

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

5. Compile sebagaifinalisasi

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Add Library into Project

Klik Add Libraries (pada project masing2)

Pilih JasperReport Library tadi

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Code Pemanggil JasperReport Frame

Gunakan ResultSet dari Query dan Connection dari Java Code

Lalu arahkan kepada *.jrxml JasperReport ygdiinginkan

Ikuti pola Susunan Code (PemanggilJasper.java) untuk lebih jelas.

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

6. Lokasi ini harussesuai strukturpackage!

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

RENDER SUKSES

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Log Warning Removal

Kasus Log4J muncul bertubi-tubi

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

Solusi

Sisipkan:

▪ import org.apache.log4j.Level;

▪ import org.apache.log4j.Logger;

Dan juga:

▪ Logger.getRootLogger().setLevel(Level.OFF);

---------------------------------------------------------------------------Kursus Online / Offline di © FGroupIndonesia.com

DatabaseOperation.java

https://pastebin.com/zQiUwm86

PemanggilJasper.java

https://pastebin.com/UdWSPn3h

Complete Java Project (netbeans)

https://tinyurl.com/latihanJasperFGroup

FGroupIndonesia.com

Jl. Parahyangan no.18, Komp. Panghegar Permai IUjung Berung, Bandung 40614

(022) 92800446 / 95244964BBM. 7DF95683 / 7CD59179

WA. 085795569337 / 085721261437