How fetch data from Sqlite database and creates a pdf report with using Strts2 + Jasper

1.Create a database

2.Download jar files dependencies with using pom.xml

3.Configure Log4j.properties for generating log.

4.Create Jasper Report Templates (*.jrxml) manually or by using iReport.

5.Connect to Sqlite database with proper jdbc driver configuration.

6.Initialize logging framework and then pass report parameters and database connection to your report template because SQL statements in your templates needs this connection.

How to fetch data from Sqlite database and show them in a JSP using Struts2

1.Create an Action class. (Actions are like POJOs )

2.Confgure the controller (struts.xml)

3.Create a JSP file corresponding to your action class

4.Run the application and see the results.

5.If you need any dependencies you can find their signature in mvnrepository.com and add them in you pom.xml.

download sqlite driver

configure a servlet for showing image in web.xml

create a java class for database handling

create a java class for pojo

create a java class for bean

create a jsf

You can also download source code and related documents from this