Learn J2EE: JasperReports with Hibernate

This blog explains you to generate Reports in your Web applications using the 2 Powerful Frameworks in Java Enterprise.

Hibernate 3.0
Jasper Reports 3.0

We will see the Entire process of adding objects to database using Hibernate Framework and then listing all the inserted items in Jasper Reports. Lets decide it into 2 Modules

1) Using Hibernate Framework to perform Database operations

2) Using JasperReports to display information from database

Module 1 :

I am using Netbeans 6.8 which comes with Hibernate Library.All you have to do it is just include the Hibernate Library in your Project's Library.

STEP 1 :

Create 2 tables in database "StudentReports". Am using SQL Server 2005,you can use Mysql as well.

Department

create table Department(ID bigint PRIMARY KEY,name varchar(100) NOT NULL UNIQUE);

Student

create table Student(ID bigint PRIMARY KEY,firstName varchar(50),lastName varchar(50),email varchar(50) NOT NULL UNIQUE,DepartmentID bigint FOREIGN KEY REFERENCES DEPARTMENT("ID"));

STEP 2 :

After creating the tables in the database, we create 2 Entity classes matching the database tables.Our class files are kept in package com.report.beans

Department.java
Student.java

Department.java

package com.report.beans;

public class Department implements java.io.Serializable {

private long id;

private String name;

public long getId() {

return this.id;

}

public void setId(long id) {

this.id = id;

}

public String getName() {

return this.name;

}

public void setName(String name) {

this.name = name;

}

Student.java

package com.report.beans;

public class Student implements java.io.Serializable {

private long id;

private Department department;

private String firstName;

private String lastName;

private String email;

public long getId() {

return this.id;

}

public void setId(long id) {

this.id = id;

}

public Department getDepartment() {

return this.department;

}

public void setDepartment(Department department) {

this.department = department;

}

public String getFirstName() {

return this.firstName;

}

public void setFirstName(String firstName) {

this.firstName = firstName;

}

public String getLastName() {

return this.lastName;

}

public void setLastName(String lastName) {

this.lastName = lastName;

}

public String getEmail() {

return this.email;

}

public void setEmail(String email) {

this.email = email;

}

STEP 3 :

After creating the beans , we will create 2 hibernate mapping xml files which acts an interface between the database tables and the java class files.I am putting these files under the package com.report.mappings

Department.java

<hibernate-mapping>

</id>

</property>

</class>

</hibernate-mapping>

Student.java

<hibernate-mapping>

</id>

<many-to-one name="department" class="com.report.beans.Department" fetch="select">

</many-to-one>

</property>

</property>

</property>

</class>

</hibernate-mapping>

STEP 4 :

After creating the beans and mapping files, we will create a hibernate configuration file and include the Database credentials and Mapping files. I am placing this configuration file in the default package

hibernate.cfg.xml

<hibernate-configuration>

<session-factory>

com.microsoft.sqlserver.jdbc.SQLServerDriver

</property>

jdbc:sqlserver://localhost:1433;databaseName=StudentReports

</property>

</property>

sa1@#$

</property>

</session-factory>

</hibernate-configuration>

STEP 6 :

Now i will create 2 data access object files for the 2 Entity bean classes. I will put these file in the package com.reports.dao

DepartmentDAO.java

package com.report.dao;

import com.report.beans.Department;

import org.hibernate.Session;

import org.hibernate.Criteria;

import org.hibernate.criterion.Expression;

import java.util.ArrayList;

public class DepartmentDAO{

public String saveDepartment(Department department)

{

Session session = HibernateSessionFactory.getSession();

String Result = "";

try

{

session.beginTransaction();

session.save(department);

session.getTransaction().commit();

session.close();

Result = "Department Saved Successfully";

}

catch(Exception e)

{

e.printStackTrace();

session.close();

Result = "Department was not saved due to the above Exception";

}

return Result;

}

public Department getDepartmentByName(String name)

{

Department department = new Department();

Session session = HibernateSessionFactory.getSession();

Criteria criteria = session.createCriteria(Department.class);

criteria.add(Expression.eq("name", name));

ArrayList listOfMatchingDepartments = (ArrayList)criteria.list();

if(listOfMatchingDepartments.size()==1)

department = listOfMatchingDepartments.get(0);

return department;

}

StudentDAO.java

package com.report.dao;

import com.report.beans.Student;

import org.hibernate.Session;

public class StudentDAO{

public String saveStudent(Student student)

{

Session session = HibernateSessionFactory.getSession();

String Result = "";

try

{

session.beginTransaction();

session.save(student);

session.getTransaction().commit();

session.close();

Result = "Student Saved Successfully";

}

catch(Exception e)

{

e.printStackTrace();

session.close();

Result = "Student was not saved due to the above Exception";

}

return Result;

}

STEP 7 :

Create your Main class files from which you will start inserting objects into databases, i am placing these files in the package com.report.test

AddDepartments.java

package com.report.test;

import com.report.beans.Department;

import com.report.dao.DepartmentDAO;

public class AddDepartments

{

public static void main(String args[])

{

Department electronics = new Department();

electronics.setName("Electronics Engineering");

Department computerScience = new Department();

computerScience.setName("Computer science Engineering");

Department civil = new Department();

civil.setName("Civil Engineering");

String Result1 = new DepartmentDAO().saveDepartment(electronics);

System.out.println(Result1);

String Result2 = new DepartmentDAO().saveDepartment(computerScience);

System.out.println(Result2);

String Result3 = new DepartmentDAO().saveDepartment(civil);

System.out.println(Result3);

}

AddStudents.java

package com.report.test;

import com.report.beans.Department;

import com.report.beans.Student;

import com.report.dao.DepartmentDAO;

import com.report.dao.StudentDAO;

public class AddStudents

{

public static void main(String args[])

{

Student student1 = new Student();

student1.setFirstName("John");

student1.setLastName("Mathew");

student1.setEmail("john@abc.com");

Department department = new DepartmentDAO().getDepartmentByName("Computer science Engineering");

student1.setDepartment(department);

String Result = new StudentDAO().saveStudent(student1);

System.out.println(Result);

}

STEP 8 :

Now your Database Tables will be populated with the objects that you added. Below my are database tables

Departments Table

----------------------------------------

ID | Name

----------------------------------------

1 | Electronics Engineering

2 | Computer science Engineering

3 | Civil Engineering

----------------------------------------

StudentsTable

-----------------------------------------------------------------------------------

ID | FirstName | LastName | Email | DepartmentID

-----------------------------------------------------------------------------------

1	\| John	\| Mathew	\| john@abc.com	\| 2
2	\| Robert	\| Langton	\| robert@abc.com	\| 1
3	\| Gill	\| Christ	\| gchrist@abc.com	\| 1
4	\| Michael	\| Jones	\| mjones@abc.com	\| 1
5	\| Tom	\| Hanks	\| hanks@abc.com	\| 1
6	\| Steve	\| Waugh	\| steve@abc.com	\| 3
7	\| Brian	\| Adams	\| brian@abc.com	\| 3
8	\| Bill	\| Guarnere	\| bill@abc.com	\| 3
9	\| Buck	\| Comptons	\| compton@abc.com	\| 3
10	\| Carwood	\| Lipton	\| lipton@abc.com	\| 2
11	\| Richard	\| Winters	\| winters@abc.com	\| 2
---	---------------	----------------	--------------------------	-----------------

Pages

JasperReports with Hibernate - Module 1

No comments:

Post a Comment

Was this Blog Helpful?