Gan ane kan udah buat file laporan.jrxml, trus udah ane buat parameter dan untuk querynya udah ane ubah pake klausa "where = $P{parameter} gitu,,
Setelah itu ane buat form inputan parameter nya di netbeans..
dengan coding pada form nya seperti ini :
Quote:
package teslaporan;
import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
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 FormPrint extends javax.swing.JFrame {
JasperReport JasRep;
JasperPrint JasPri;
Map<String, Object> param = new HashMap<String, Object>();
JasperDesign JasDes;
private String url = "jdbc:mysql://localhost:3306/projecttugas";
private String username = "root";
private String password = "";
private Connection koneksi;
private Statement sttmt;
public FormPrint() {
initComponents();
}
public void Koneksi() {
// 1 - Memanggil DRIVER JDBC
try {
Class.forName("org.gjt.mm.mysql.Driver");
} catch (ClassNotFoundException ex) {
System.out.println("DRIVER Error");
}
}
// 3 - Buat Metode Koneksi
public void bukaKoneksi() {
try {
koneksi = DriverManager.getConnection(url, username, password);
sttmt = koneksi.createStatement();
} catch (SQLException ex) {
System.out.println("KONEKSI Error");
}
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try {
File reprt = new File("C:/Users/hp/Documents/NetBeansProjects/e-raport/src/teslaporan/LaporanNilai.jrxml");
JasDes = JRXmlLoader.load(reprt);
String fnim = nis.getText();
param.put("parameter", fnim);
JasRep = JasperCompileManager.compileReport(JasDes);
JasPri = JasperFillManager.fillReport(JasRep, param, koneksi);
JasperViewer.viewReport(JasPri, true);
// JasperPrintManager.printReport(JasPri, true);
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e.getMessage());
}
}
tapi kenapa malah ketika di run ndak bisa nampil dan bilang nya the document has no pages gitu..?
trus pesan error nya seperti ini gan :
Quote:
INFO: Overriding bean definition for bean 'stackedAreaType': replacing [Generic bean: class [org.springframework.beans.factory.config.FieldRetrievingFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with [Generic bean: class [org.springframework.beans.factory.config.FieldRetrievingFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null]
07 Feb 13 11:58:28 org.springframework.beans.factory.support.DefaultListableBeanFactory registerBeanDefinition
INFO: Overriding bean definition for bean 'ganttType': replacing [Generic bean: class [org.springframework.beans.factory.config.FieldRetrievingFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null] with [Generic bean: class [org.springframework.beans.factory.config.FieldRetrievingFactoryBean]; scope=; abstract=false; lazyInit=false; autowireMode=0; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=null; factoryMethodName=null; initMethodName=null; destroyMethodName=null]
07 Feb 13 11:58:28 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from URL [jar:file:/C:/Users/hp/Documents/NetBeansProjects/Project%20Database%20Klinik/lib/jasperreports-fonts-3.6.1.jar!/net/sf/jasperreports/fonts/fonts.xml]
07 Feb 13 11:58:33 net.sf.jasperreports.engine.query.JRJdbcQueryExecuter <init>
WARNING: The supplied java.sql.Connection object is null.
Ane bingung apa yang harus di benerin gan..