05.07.2020, 18:29. Показов 738. Ответов 1
Добрый день. Пытаюсь с помощью данной библиотеки сформировать отчет и сохранить его в PDF.
Нашел пример в интернете и на основе его пытаюсь реализовать задачу.
Первый класс который создал для хранения данных отчета. Так же реализовал функцияю которая запросам получает данные из БД.
| Java |
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
| package Sempel.Reports.PriceNomen;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import sql.SelectPost;
import sql.SettingConnectSQL;
public class PersenReportPriceNomen {
private Integer NP;
private String NomenName;
private Integer SumNomen;
public PersenReportPriceNomen(Integer NP, String NomenName, Integer SumNomen){
this.NP = NP;
this.NomenName = NomenName;
this.SumNomen = SumNomen;
}
public void setNP(Integer value) {this.NP = value;}
public Integer getNP() {return this.NP;}
public void setNomenName(String value) {this.NomenName = value;}
public String getNomenName() {return this.NomenName;}
public void setSumNomen(Integer value) {this.SumNomen = value;}
public Integer getSumNomen() {return this.SumNomen;}
public static ObservableList<PersenReportPriceNomen> getMassivReportPrice(SettingConnectSQL SetCon) throws SQLException {
ObservableList<PersenReportPriceNomen> Mass = FXCollections.observableArrayList();
Integer linePer = 0;
String TextSQL = "SELECT Nom.name_nomen, RP.price_rp\n" +
" FROM public.\"RegistrPrice\" RP, public.\"Nomenclature\" Nom\n" +
" WHERE Nom.id_nomen = RP.id_nomen;";
Connection Conn = SetCon.CreatConnect();
SelectPost SelPos = new SelectPost();
ResultSet ResSet = SelPos.SelectInfoBase(Conn, TextSQL);
while(ResSet.next()) {
linePer++;
Mass.add(new PersenReportPriceNomen(linePer, ResSet.getString(1), ResSet.getInt(2)));
}
Conn.close();
return Mass;
}
} |
|
Потом создал класс где пытаюсь уже сформировать отчет и сохранить его на диск.
| Java |
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
| package Sempel.Reports.PriceNomen;
import java.io.File;
import java.sql.SQLException;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.xml.JRXmlLoader;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.data.JRBeanCollectionDataSource;
import javafx.collections.ObservableList;
import sql.SettingConnectSQL;
public class DataReportPriceNomen {
private File reportPattern;
private Map<String, Object> parameters;
private JRBeanCollectionDataSource beanColDataSource;
private ObservableList<PersenReportPriceNomen> dataBeanList;
private JasperDesign jasperDesign;
private JasperReport jasperReport;
private JasperPrint jasperPrint ;
public void creatREportPriceNomen(SettingConnectSQL SetCon) throws SQLException, JRException {
ObservableList<PersenReportPriceNomen> dataBeanList = PersenReportPriceNomen.getMassivReportPrice(SetCon);
parameters = new HashMap<String, Object>();
parameters.put("DataReport", new Date());
reportPattern = new File("/Sempel/Reports/PriceNomen/ReportsPriceA4.jrxml");
jasperDesign = JRXmlLoader.load(reportPattern);
jasperReport = JasperCompileManager.compileReport(jasperDesign);
jasperPrint = JasperFillManager.fillReport(jasperReport,
parameters,
beanColDataSource);
JasperExportManager.exportReportToPdfFile(jasperPrint,
"/home/dggrom/Документы/java/EclipseProject/PostgreSQL/src/Sempel/Reports/PriceNomen/reportPDF.pdf");
}
} |
|
Но почему то программа подает в ошибку на строчке
jasperDesign = JRXmlLoader.load(reportPattern);
Вот лог ошибки.
| Java |
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
| Exception in thread "JavaFX Application Thread" java.lang.NoClassDefFoundError: org/apache/commons/digester/Digester
at Sempel.Reports.PriceNomen.DataReportPriceNomen.creatREportPriceNomen(DataReportPriceNomen.java:47)
at Sempel.MainForm.ControllerMainForm.lambda$5(ControllerMainForm.java:121)
at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
at javafx.event.Event.fireEvent(Event.java:198)
at javafx.scene.control.MenuItem.fire(MenuItem.java:462)
at com.sun.javafx.scene.control.skin.ContextMenuContent$MenuItemContainer.doSelect(ContextMenuContent.java:1405)
at com.sun.javafx.scene.control.skin.ContextMenuContent$MenuItemContainer.lambda$createChildren$6(ContextMenuContent.java:1358)
at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
at javafx.event.Event.fireEvent(Event.java:198)
at javafx.scene.Scene$MouseHandler.process(Scene.java:3757)
at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)
at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)
at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:394)
at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:295)
at java.security.AccessController.doPrivileged(Native Method)
at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$2(GlassViewEventHandler.java:432)
at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:410)
at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:431)
at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
at com.sun.glass.ui.View.notifyMouse(View.java:937)
at com.sun.glass.ui.gtk.GtkApplication._runLoop(Native Method)
at com.sun.glass.ui.gtk.GtkApplication.lambda$null$10(GtkApplication.java:245)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.ClassNotFoundException: org.apache.commons.digester.Digester
at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
... 44 more |
|
Файл с шаблоном находится там где я указываю, в чем может быть проблема ?
(
Сообщение от dggrom
