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