1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
|
try{
JasperDesign jdesign;
jdesign = JRXmlLoader.load("D:\\NetBeansProjects\\DEMANDE\\src\\main\\java\\sonabel\\demande\\RportDemande.jrxml");
String num;
num = jTextNumero.getText();
String query;
query = "Select demande.dm_numero, demande.dm_date, demande.dm_just, demande.dm_benef, demande.dm_imp, "
+ "signataires.sig_signat_1, signataires.sig_signat_2, signataires.sig_signat_3, materiel.ma_qte, centre.c_libelle, "
+ "materiel.ma_pu, materiel.ma_desig, materiel.ma_obs, materiel.ma_num, Round(sum(ma_qte * ma_pu)) as ma_montant, "
+ "fournis.fr_nom"
+ "from demande, materiel, centre, signataires, fournis"
+ "where trim(demande.dm_numero) ='" + num + "'"
+ "and trim(materiel.dm_numero) ='" + num + "'"
+ "and demande.dm_numero = materiel.dm_numero"
+ "And demande.sig_option = signataires.sig_option"
+ "And demande.fr_code = fournis.fr_code"
+ "and centre.c_type'" + "A" + "'"
+ "Group by demande.dm_numero, dm_date, dm_just, dm_benef, dm_imp, c_libelle, sig_signat_1, sig_signat_2, sig_signat_3, "
+ "ma_qte, ma_pu, ma_desig, ma_obs, ma_num, fr_nom"
+ "Order by ma_num";
JRDesignQuery updateQuery = new JRDesignQuery();
updateQuery.setText(query);
jdesign.setQuery(updateQuery);
JasperReport ireport = JasperCompileManager.compileReport(jdesign);
JasperPrint jprint = JasperFillManager.fillReport(ireport,null,getOracleConnection());
JasperViewer.viewReport(jprint, false);
}catch(ClassNotFoundException | SQLException | JRException e){
JOptionPane.showMessageDialog(this, e.getMessage());
} |
Partager