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());
} |
