Struts with jasper Report Example

Hello Friends hope you all are fine.now its time to move towards struts framework.i will update about struts . i hope you all have basic understanding of struts framework.in this example i will be using Struts 2.x.


Struts  is also MVC Framework  like Spring.in this Example i will be integrating Jasper Report with Struts Framework. Enjoy Code guys.

Apart from struts 2.x distribution ,jasper Jars also required to  make application runnable.you can get jasper jars from http://community.jaspersoft.com/project/jasperreports-library/releases.

one additional jar is required struts2-jasperreports-plugin-2.3.jar


Project Structure will look like given below :

in Spring mvc we have model ,view,controller. where as Struts is also mvc. but we call controller as Action Class.

Action Class is given below :
package org.jasper;
import java.util.HashMap;
import java.util.Map;
import com.opensymphony.xwork2.ActionSupport;

public class StudentJasperAction extends ActionSupport {

/**
*
*/
private static final long serialVersionUID = 1L;

private Map<String, Object> param=null;

private String studId;
private String rptFmt;
 
public String getRptFmt() {
return rptFmt;
}

public void setRptFmt(String rptFmt) {
this.rptFmt = rptFmt;
}





public String getStudId() {
return studId;
}

public void setStudId(String studId) {
this.studId = studId;
}

public Map<String, Object> getParam() {
return param;
}


public void setParam(Map<String, Object> param) {
this.param = param;
}


public String execute() throws Exception {
   
        try {
    param = new HashMap<String,Object>();
   
    param.put("studid", new Integer(studId));
    param.put("Title", "Student  Details");
        } catch (Exception e) {
            e.printStackTrace();
            return ERROR;
        }

        return SUCCESS;
    }

 
}


 I have used StrutsResultSupport to  customize view.the below code render jasper report .
package org.jasper;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.HashMap;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.design.JasperDesign;
import net.sf.jasperreports.engine.query.JRQueryExecuterFactory;
import net.sf.jasperreports.engine.util.JRProperties;
import net.sf.jasperreports.engine.xml.JRXmlLoader;

import org.apache.struts2.ServletActionContext;
import org.apache.struts2.dispatcher.StrutsResultSupport;

import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionInvocation;
import com.opensymphony.xwork2.util.ValueStack;

public class LoadJasperReportAction extends StrutsResultSupport {

protected String parameters;
protected String rptFormat;

protected String studId;

public String getRptFormat() {
return rptFormat;
}

public void setRptFormat(String rptFormat) {
this.rptFormat = rptFormat;
}

public String getParameters() {
return parameters;
}

public void setParameters(String parameters) {
this.parameters = parameters;
}

public String findParam(String key, Map<String, Object> params) {
Object obj = params.get(key);
if (obj != null) {
String[] values = (String[]) obj;
return values.length > 0 ? values[0] : null;
}
return (String) obj;
}

@Override
protected void doExecute(String arg0, ActionInvocation arg1)
throws Exception {
ActionContext context = ActionContext.getContext();
Map<String, Object> params = context.getParameters();
String studentId = findParam("studId", params);

try {
String reportFileName = "StudentReport";
Connection conn = null;

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager
.getConnection("jdbc:mysql://localhost:3306/studentdb",
"root", "admin!@#");

HttpServletRequest request = ServletActionContext.getRequest();

ValueStack stack = arg1.getStack();


parameters = conditionalParse(parameters, arg1);
String contextPath = request.getSession().getServletContext()
.getRealPath("/report/" + reportFileName + ".jrxml");
try {

InputStream input = new FileInputStream(new File(contextPath));

System.out.println("Context Path is  : =" + contextPath);
JasperDesign jasperDesign = JRXmlLoader.load(input);

System.out.println("Compiling Report Designs");

JasperReport jasperReport = JasperCompileManager
.compileReport(jasperDesign);

jasperReport.setProperty(
"net.sf.jasperreports.query.executer.factory.plsql",
"com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory");

JRProperties.setProperty(
JRQueryExecuterFactory.QUERY_EXECUTER_FACTORY_PREFIX
+ "plsql",
"com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory");
System.out.println("Creating JasperPrint Object");
Map<String, Object> parameters = new HashMap<String, Object>();
parameters.put("studId", studentId);

JasperPrint jasperPrint = JasperFillManager.fillReport(
jasperReport, parameters, conn);

int pages = jasperPrint.getPages().size();
if (pages != 0) {
File f = new File("d:\\struts1.pdf");
f.createNewFile();

// Exporting the report
OutputStream output = new FileOutputStream(f);

JasperExportManager.exportReportToPdfStream(jasperPrint,
output);

System.out.println("Report Generation Complete");
} else {
System.out.println(" NO DATA FOUND TO EXPORT .....");
}
conn.close();
} catch (Exception e) {
e.printStackTrace();
}

} catch (Exception e) {
e.printStackTrace();
}
}

}

Configration file is given below.

struts.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
    "http://struts.apache.org/dtds/struts-2.0.dtd">

<struts>
<constant name="struts.enable.DynamicMethodInvocation" value="false" />
<constant name="struts.devMode" value="false" />

<package name="default" extends="struts-default" namespace="/">
 
  <result-types>
    <result-type name="jasper1" class="org.jasper.LoadJasperReportAction"/>
  </result-types>

  <action name="studentJasperCall" class="org.jasper.StudentJasperAction">
        <result name="success" type="jasper1">
            <param name="parameters">parameters</param>
            <param name="rptFormat">rptFmt</param>
        </result>
    </action>

</package>



</struts>

JSP PAGE : 

Student.jsp

<%@ page contentType="text/html; charset=UTF-8"%>
<%@ taglib prefix="s" uri="/struts-tags"%>
<html>
<head>
<title>Jasper Report Using struts 2.x</title>

</head>
<body>

<s:actionerror/>

<s:form name="reportForm" action="studentJasperCall.action" metod="post" >

<TABLE id="reptbl" width="400px" border="2">
  <TR>
  <td>
Enter Student id : <s:textfield name="studId" label="stud" /> <s:submit  value="Generate Student Report" type="button"/>
 </td>
 <td>
 <s:radio label="format" name="rptFmt" list="#{'pdf':'PDF'}" value="pdf" />
 </td>

</TR>

</TABLE>

</s:form>

</body>

</html>

Deployment Descriptor File
web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
  <display-name>Struts2JasperExample</display-name>
  <welcome-file-list>
    <welcome-file>/Student.jsp</welcome-file>
  </welcome-file-list>
 <filter>
    <filter-name>struts2</filter-name>
    <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
</filter>
<filter-mapping>
    <filter-name>struts2</filter-name>
    <url-pattern>/*</url-pattern>

</filter-mapping>


</web-app>

i am putting .jrxml file also .you can check and change according to your need using Ireport Tool :
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="StudentReport" pageWidth="500" pageHeight="600" columnWidth="450" leftMargin="5" rightMargin="5" topMargin="10" bottomMargin="1" uuid="71627f29-0436-4965-9e9b-c02d851e0893">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<style name="Arial" isDefault="true" fontName="Arial" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
<parameter name="Title" class="java.lang.String"/>
<parameter name="studid" class="java.lang.Integer"/>
<queryString>
<![CDATA[select id,name,college from student]]>
</queryString>
<field name="id" class="java.lang.String"/>
<field name="name" class="java.lang.String"/>
<field name="college" class="java.lang.String"/>
<title>
<band height="50" splitType="Stretch">
<textField isBlankWhenNull="true">
<reportElement style="Arial" x="40" y="0" width="370" height="30" uuid="aab52a34-7a15-413b-812b-0f5413d160cf"/>
<textElement textAlignment="Center">
<font size="22"/>
</textElement>
<textFieldExpression><![CDATA[$P{Title}]]></textFieldExpression>
</textField>
</band>
</title>
<pageHeader>
<band height="20" splitType="Stretch">
<textField>
<reportElement style="Arial" mode="Opaque" x="0" y="5" width="490" height="15" forecolor="#999999" backcolor="#777765" uuid="221943d8-6682-4b54-9096-de22d99fde6a"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA["Student Details "]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="20" splitType="Stretch">
<staticText>
<reportElement style="Arial" mode="Opaque" x="0" y="4" width="170" height="15" backcolor="#e3d9b4" uuid="4f05471d-ee17-42bc-afc7-4e474112b80f"/>
<textElement textAlignment="Left"/>
<text><![CDATA[ID]]></text>
</staticText>
<staticText>
<reportElement style="Arial" positionType="Float" mode="Opaque" x="170" y="4" width="170" height="15" backcolor="#e3d9b4" uuid="eb3e1f67-d402-432f-9faa-4174561d41cd"/>
<text><![CDATA[Name]]></text>
</staticText>
<staticText>
<reportElement style="Arial" positionType="Float" mode="Opaque" x="340" y="4" width="150" height="15" backcolor="#CBB453" uuid="ed2ace5c-9d4f-4c2d-baa9-c3a304949b60"/>
<text><![CDATA[College]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="20" splitType="Stretch">
<textField>
<reportElement x="0" y="4" width="170" height="15" uuid="818a285b-f0a1-42a0-95e5-04e630bf965e"/>
<textElement textAlignment="Left"/>
<textFieldExpression><![CDATA[$F{id}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement positionType="Float" x="170" y="4" width="170" height="15" uuid="8d258287-9e74-44d6-9756-a5dfe7b98c25"/>
<textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement positionType="Float" x="340" y="4" width="150" height="15" uuid="cb56f92e-f5ab-4510-891b-8c2d8f864f33"/>
<textFieldExpression><![CDATA[$F{college}]]></textFieldExpression>
</textField>
</band>
</detail>
<pageFooter>
<band height="40" splitType="Stretch">
<textField>
<reportElement x="200" y="20" width="85" height="15" uuid="a22dda99-774c-497f-9295-fe2a487b7373"/>
<textElement textAlignment="Right"/>
<textFieldExpression><![CDATA["Page " + String.valueOf($V{PAGE_NUMBER})]]></textFieldExpression>
</textField>
<textField evaluationTime="Report">
<reportElement x="285" y="20" width="75" height="15" uuid="51a9c0af-8bd0-447e-a492-ef0e7df1fdd8"/>
<textElement textAlignment="Left"/>
<textFieldExpression><![CDATA[" of " + String.valueOf($V{PAGE_NUMBER})]]></textFieldExpression>
</textField>
</band>
</pageFooter>
<summary>
<band height="35" splitType="Stretch">
<textField isStretchWithOverflow="true">
<reportElement style="Arial" x="175" y="20" width="165" height="15" uuid="87b3c116-0ea9-4bcc-b3f4-9cbb1a5f5e2b"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA["Total Number of Students : " +
String.valueOf($V{REPORT_COUNT})]]></textFieldExpression>
</textField>
</band>
</summary>
</jasperReport>


snapshot of application :

Any Suggetion will be appreciated.Thanks for reading this article.
For any Query get in touch with me on npjava90@gmail.com

Procedure Call Using Jasper Reports ,Spring MVC

Hello friends.today i am going to demonstrate you how we can call procedure through Jasper reports.

The Project Structure is given below :

The Code is as given below.

MODEL CLASS 

package org.demo.model;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;


@Entity
@Table(name="student")
public class Student
{

@Id @Column(name="id")
private String studentid;
@Column
private String name;



public Student(){}
public String getStudentid() {
return studentid;
}


public void setStudentid(String studentid) {
this.studentid = studentid;
}


public String getName() {
return name;
}


public void setName(String name) {
this.name = name;
}





}

CONTROLLER:

package org.demo.controller;

import java.sql.SQLException;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.validation.Validator;

import org.apache.commons.dbcp.BasicDataSource;

import org.dao.StudentDAO;

import org.demo.model.Student;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.beans.factory.annotation.Qualifier;

import org.springframework.stereotype.Controller;

import org.springframework.ui.Model;

import org.springframework.validation.BindingResult;

import org.springframework.validation.annotation.Validated;

import org.springframework.web.bind.annotation.ModelAttribute;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestMethod;

import org.springframework.web.bind.annotation.ResponseBody;

import org.springframework.web.context.WebApplicationContext;

import org.springframework.web.context.support.WebApplicationContextUtils;

import org.springframework.web.servlet.ModelAndView;

import org.springframework.web.servlet.mvc.support.RedirectAttributes;

@Controller

public class StudentController

{

    

   @RequestMapping(value="/show_student", method=RequestMethod.GET)

   public String showStudent(@ModelAttribute("student1") Student student) {

      

       return "show_student";

   }

   

   @RequestMapping(method = RequestMethod.POST , value = "/GenerateReport")

   public @ResponseBody void generatePdfReport(ModelAndView modelAndView,HttpServletRequest request,HttpServletResponse response) throws SQLException{

 

WebApplicationContext context =WebApplicationContextUtils.getWebApplicationContext(request.getServletContext());

StudentDAO dao=(StudentDAO)context.getBean("studentDAO");

BasicDataSource dataSource = (BasicDataSource)context.getBean("myDataSource");

String contextPath = request.getServletContext().getRealPath("report/StudentReport.jrxml");

dao.generatePdfReport(dataSource,contextPath);

      

    }

   }

DAO LAYER:

package org.dao;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.InputStream;

import java.io.OutputStream;

import java.sql.Connection;

import java.sql.SQLException;

import java.util.HashMap;

import java.util.Iterator;

import java.util.List;

import java.util.Map;

import net.sf.jasperreports.engine.JasperCompileManager;

import net.sf.jasperreports.engine.JasperExportManager;

import net.sf.jasperreports.engine.JasperFillManager;

import net.sf.jasperreports.engine.JasperPrint;

import net.sf.jasperreports.engine.JasperReport;

import net.sf.jasperreports.engine.design.JasperDesign;

import net.sf.jasperreports.engine.query.JRQueryExecuterFactory;

import net.sf.jasperreports.engine.util.JRProperties;

import net.sf.jasperreports.engine.xml.JRXmlLoader;

import org.apache.commons.dbcp.BasicDataSource;

import org.codehaus.jackson.map.ObjectMapper;

import org.demo.model.Student;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;

import org.springframework.jdbc.core.namedparam.SqlParameterSource;

import org.springframework.jdbc.core.simple.SimpleJdbcCall;

import org.springframework.orm.hibernate3.HibernateTemplate;

@SuppressWarnings("deprecation")

public class StudentDAO {

private HibernateTemplate template;

@Autowired

private BasicDataSource myDataSource;

public HibernateTemplate getTemplate() {

return template;

}

public void setTemplate(HibernateTemplate template) {

this.template = template;

}

public StudentDAO(HibernateTemplate template) {

this.template = template;

}

public void insert(Student student) {

template.save(student);

}

public List<Student> getStudents() {

return template.find("from student");

}

public void generatePdfReport(BasicDataSource dataSource, String contextPath)

throws SQLException {

Connection conn = dataSource.getConnection();

try {

InputStream input = new FileInputStream(new File(contextPath));

System.out.println("Context Path is  : =" + contextPath);

JasperDesign jasperDesign = JRXmlLoader.load(input);

System.out.println("Compiling Report Designs");

JasperReport jasperReport = JasperCompileManager

.compileReport(jasperDesign);

jasperReport.setProperty(

"net.sf.jasperreports.query.executer.factory.plsql",

"com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory");

JRProperties.setProperty(

JRQueryExecuterFactory.QUERY_EXECUTER_FACTORY_PREFIX

+ "plsql",

"com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory");

System.out.println("Creating JasperPrint Object");

Map<String, Object> parameters = new HashMap<String, Object>();

parameters.put("studId", "1");

JasperPrint jasperPrint = JasperFillManager.fillReport(

jasperReport, parameters, conn);

int pages=jasperPrint.getPages().size();

if(pages != 0)

{

File f = new File("d:\\Studentnew.pdf");

f.createNewFile();

// Exporting the report

OutputStream output = new FileOutputStream(f);

JasperExportManager.exportReportToPdfStream(jasperPrint, output);

System.out.println("Report Generation Complete");

}

else

{

System.out.println(" NO DATA FOUND TO EXPORT .....");

}

conn.close();

} catch (Exception e) {

e.printStackTrace();

}

}

public void callStoredProcedure(BasicDataSource datasource) {

ObjectMapper m = new ObjectMapper();

JdbcTemplate template = new JdbcTemplate(datasource);

SimpleJdbcCall simpleJdbcCall = new SimpleJdbcCall(template)

.withProcedureName("getStudent");

Map<String, Object> inParamMap = new HashMap<String, Object>();

inParamMap.put("int_stockcode", 1);

SqlParameterSource in = new MapSqlParameterSource(inParamMap);

Map<String, Object> simpleJdbcCallResult = simpleJdbcCall.execute(in);

System.out.println(simpleJdbcCallResult);

System.out.println(simpleJdbcCallResult.get("name"));

// Student anotherBean = m.convertValue(simpleJdbcCallResult,

// Student.class);

// System.out.println(anotherBean.getStudentid());

// System.out.println(anotherBean.getName());

Iterator iterator = simpleJdbcCallResult.entrySet().iterator();

while (iterator.hasNext()) {

Student student = new Student();

/*

* 

* student.setStudentid((String)simpleJdbcCallResult.get("id"));

* student.setName((String)simpleJdbcCallResult.get("name"));

* System.out.println("st5udent : =>"+student.getName());

*/

/*

* System.out.println("The key is: " + mapEntry.getKey() +

* ",value is :" + mapEntry.getValue());

*/

}

}

public static void main(String[] args) {

ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext(

"/context-conf.xml");

BasicDataSource datasource = (BasicDataSource) context

.getBean("myDataSource");

StudentDAO dao = (StudentDAO) context.getBean("studentDAO");

dao.callStoredProcedure(datasource);

}

}

WEB.XML

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">

  <display-name>ProcCallJasperSpring</display-name>

  <welcome-file-list>

    <welcome-file>add_student.jsp</welcome-file>

  </welcome-file-list>

  <listener>

    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

  </listener>

  <context-param>

    <param-name>contextConfigLocation</param-name>

    <param-value>WEB-INF/context-conf.xml</param-value>

  </context-param>

  <servlet>

    <servlet-name>dispatcher</servlet-name>

    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

    <load-on-startup>1</load-on-startup>

  </servlet>

  <servlet-mapping>

    <servlet-name>dispatcher</servlet-name>

    <url-pattern>*.html</url-pattern>

  </servlet-mapping>

</web-app>

context-conf.xml

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xmlns:context="http://www.springframework.org/schema/context"

    xmlns:mvc="http://www.springframework.org/schema/mvc"

    xsi:schemaLocation="http://www.springframework.org/schema/beans 

    http://www.springframework.org/schema/beans/spring-beans.xsd 

    http://www.springframework.org/schema/context  

    http://www.springframework.org/schema/context/spring-context.xsd

     http://www.springframework.org/schema/mvc 

     http://www.springframework.org/schema/mvc/spring-mvc.xsd

      http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.0.xsd"

        >

     

    

    

    

        <bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

<property name="driverClassName" value="com.mysql.jdbc.Driver" />

<property name="url" value="jdbc:mysql://localhost:3306/studentdb" />

<property name="username" value="root" />

<property name="password" value="admin!@#"/>

</bean>

<bean id="mySessionFactory"

class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">

<property name="dataSource" ref="myDataSource" />

<property name="annotatedClasses">

<list>

<value>org.demo.model.Student</value>

</list>

</property>

<property name="hibernateProperties">

<props>

<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>

<prop key="hibernate.show_sql">true</prop>

<prop key="hibernate.hbm2ddl.auto">none</prop>

</props>

</property>

</bean>

<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">

<constructor-arg ref="mySessionFactory" />

</bean> 

<bean id="studentDAO" class="org.dao.StudentDAO">

   <constructor-arg ref="hibernateTemplate" />

</bean>

      

    

     

    <bean id="messageSource"

        class="org.springframework.context.support.ReloadableResourceBundleMessageSource">

        <property name="basename" value="classpath:message" />

        <property name="defaultEncoding" value="UTF-8" />

    </bean>

    

    

     </beans>

InitStudent.js

function InitStudent()

{

$('#AddStudent').click(function()

{   

 

 AddStudent();

 

});

 

$('#GenerateReport').click(function()

{   

 

GenerateReport();

 

});

 

}

StudentLogic.js

function  AddStudent()

{

$.ajax({

  url: "add_student.html",

  dataType:'json',

  type:'post',

  data:  $('#StudentDetail').serialize(),

beforeSend: function() {

$.blockUI();

},

  success: function (dataCheck)

  {

  },

  error: function (xhr, ajaxOptions, thrownError) {}

});  

}

function GenerateReport()

{

$.ajax({

  url: "GenerateReport.html",

  dataType:'json',

  type:'post',

  data:  {},

beforeSend: function() {

$.blockUI();

},

  success: function (dataCheck)

  {

  },

  error: function (xhr, ajaxOptions, thrownError) {}

});  

}

add_student.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<%@ taglib uri="http://www.springframework.org/tags/form"

    prefix="springForm"%>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>ADD STUDENT FORM </title>

<style>

.error {

    color: #ff0000;

    font-style: italic;

    font-weight: bold;

}

</style>

</head>

<script type="text/javascript" src="script/jquery-1.11.0.min.js"></script>

<script type="text/javascript" src="script/bootstrap.js"></script>

<script type="text/javascript" src="script/jquery-ui.min.js"></script>

<script type="text/javascript" src="script/jquery.layout-latest.js"></script>

<script type="text/javascript" src="script/local/grid.locale-en.js" ></script>

<script type="text/javascript" src="script/jquery.blockUI.js"></script>

<script type="text/javascript" src="script/js/javascript.js"></script>

<script type="text/javascript" src="script/js/InitStudent.js"></script>

<script type="text/javascript" src="script/js/StudentLogic.js"></script>

<script type="text/javascript">

$(document).ready(function(){

InitStudent();

});

</script>

<body>

 

    <%-- <springForm:form method="POST" commandName="student"

        action="ValidateRequest"> --%>

        

        <form action="ValidateRequest" method="POST"></form>

        <table>

            <tr>

                <td>ID:</td>

                <td><input type="text" id="txtid" name="txtid">   </td>

               <%--  <td><springForm:errors path="txtid" cssClass="error" /></td> --%>

            </tr>

           

           <tr>

                <td>NAME:</td>

                <td><input type="text" id="txtname" name="txtname"></td>

                <%-- <td><springForm:errors path="txtname" cssClass="error" /></td> --%>

            </tr>

            

          

            <tr>

                <td colspan="3"><input type="submit"  id="AddStudent"  name="AddStudent" value="Submit"></td>

                <td colspan="3"><input type="submit"  id="GenerateReport"  name="GenerateReport" value="Generate Report"></td>

                

            </tr>

        </table>

 

  

 

</body>

</html>

 Procedure that i call from Java code is given below :

DELIMITER $$

DROP PROCEDURE IF EXISTS `getStudent` $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `getStudent`(studid VARCHAR(20))

BEGIN

SELECT id,name,college FROM student WHERE id = studid;

END $$

DELIMITER ;

Report will look like given below :

Happy Learning..!!

for any query ping me on pathak.nisarg@yahoo.com

Thanks for Reading..!

Spring Batch Xml Generation

Hi Friends ,i will going to demosntrate how we can generate xml using spring batch application .

In this example i have used maven project structure ,

Project Structure is look like given below

The Code is as given below :
database script :: 

(1)

DROP TABLE IF EXISTS `studentdb`.`batchstrn`;
CREATE TABLE  `studentdb`.`batchstrn` (
  `BATCHRUNID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `BATCHID` int(10) unsigned NOT NULL,
  `REQDATE` datetime NOT NULL,
  `PROCSTARTDATE` datetime NOT NULL,
  `STATUSCODE` varchar(45) NOT NULL,
  PRIMARY KEY (`BATCHRUNID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;


Main Class  :
package org.zip;

import java.util.HashMap;
import java.util.Map;

import org.springframework.batch.core.Job;
import org.springframework.batch.core.JobExecution;
import org.springframework.batch.core.JobParameter;
import org.springframework.batch.core.JobParameters;
import org.springframework.batch.core.launch.JobLauncher;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
//@Component
public class App {

public static void main(String[] args) {

App obj = new App();
obj.run();


}
//batchstrn
private void run() {

String[] springConfig = { "spring/batch/jobs/student_excelList.xml" };

ApplicationContext context = new ClassPathXmlApplicationContext(springConfig);

JobLauncher jobLauncher = (JobLauncher) context.getBean("jobLauncher");
Job job = (Job) context.getBean("XML_GEN");

Map<String, JobParameter> mapofParam = new  HashMap<String, JobParameter>();

mapofParam.put("BATCHID", new JobParameter("3"));

JobParameters jobparam= new JobParameters(mapofParam);

try {

JobExecution execution = jobLauncher.run(job, jobparam);
System.out.println("Exit Status : " + execution.getStatus());
System.out.println("Exit Status : " + execution.getAllFailureExceptions());

} catch (Exception e) {
e.printStackTrace();

}

System.out.println("Done");

}


}

The Configuration file for job is as given below :

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:batch="http://www.springframework.org/schema/batch"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:task="http://www.springframework.org/schema/task" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/batch
http://www.springframework.org/schema/batch/spring-batch-2.2.xsd
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.2.xsd
http://www.springframework.org/schema/task
    http://www.springframework.org/schema/task/spring-task-3.2.xsd
">

<context:annotation-config />
<context:component-scan base-package="org.batch" />


<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/studentdb" />
<property name="username" value="root" />
<property name="password" value="admin!@#" />
</bean>

<bean id="readListener" class="org.batch.listener.XmlReadListener" />

<batch:job id="XML_GEN" >
<batch:step id="XML_GEN_STEP1"  next="XML_GEN_STEP2">
<batch:tasklet ref="XML_GEN_batchinit" >


</batch:tasklet>
</batch:step>


<batch:step id="XML_GEN_STEP2" >
<batch:tasklet>
<batch:chunk reader="XML_GEN_itemreader" writer="XML_GEN_itemwriter"
processor="XML_GEN_itemprocessor" commit-interval="10">

<batch:listeners>
<batch:listener ref="readListener"/>
</batch:listeners>
</batch:chunk>
</batch:tasklet>
</batch:step>


</batch:job>



<!-- TASKLET -->
<bean id="XML_GEN_batchinit" class="org.batch.tasklet.Student_InitTasklet"
scope="step">
<property name="batchId" value="#{jobParameters['BATCHID']}" />

</bean>




<!-- READ -->
<bean id="XML_GEN_itemreader"
class="org.springframework.batch.item.database.JdbcCursorItemReader"
scope="step">
<property name="dataSource" ref="dataSource" />
<property name="sql"
value="select * from student where status='A'"
/>
<property name="rowMapper">
<bean class="org.batch.mapper.Student_RowMapper" />
</property>
  </bean>


<!-- PROCESS -->
<bean id="XML_GEN_itemprocessor" class="org.batch.processor.Student_Processor"
scope="step" >

<property name="batchRunId" value="#{jobExecutionContext['BATCHRUNID']}" />

</bean>


<!-- WRITE -->
<bean id="XML_GEN_itemwriter" class="org.batch.writer.StudentGeneration_Writer" scope="step">
<property name="dataSource" ref="dataSource" />
<property name="batchRunId" value="#{jobExecutionContext['BATCHRUNID']}" />
</bean>

<bean id="jobLauncher" class="org.springframework.batch.core.launch.support.SimpleJobLauncher">
        <property name="jobRepository" ref="jobRepository"/>
    </bean>
 
<bean id="jobRepository" class="org.springframework.batch.core.repository.support.MapJobRepositoryFactoryBean">
        <property name="transactionManager" ref="transactionManager"/>
    </bean>
 
     <bean id="transactionManager" class="org.springframework.batch.support.transaction.ResourcelessTransactionManager
     "/>


</beans>

 
CONTEXT.XML

<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.2.xsd">

<!-- stored job-meta in memory -->
<bean id="jobRepository"
class="org.springframework.batch.core.repository.support.MapJobRepositoryFactoryBean">
<property name="transactionManager" ref="transactionManager" />
</bean>
 
<bean id="transactionManager"
class="org.springframework.batch.support.transaction.ResourcelessTransactionManager" />

<bean id="jobLauncher"
class="org.springframework.batch.core.launch.support.SimpleJobLauncher">
<property name="jobRepository" ref="jobRepository" />
</bean>



<!-- Read environment property -->

<bean id="envProperties"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<list>
<value>classpath:META-INF/i18n/zip-batch.properties</value>
</list>
</property>
</bean>



</beans>

PROCESSOR:

package org.batch.processor;

import org.batch.model.Student;

import org.springframework.batch.item.ItemProcessor;

public class Student_Processor implements ItemProcessor<Student, Student> {

private int batchRunId;

@Override

public Student process(Student stdent) throws Exception {

// TODO Auto-generated method stub

return stdent;

}

public int getBatchRunId() {

return batchRunId;

}

public void setBatchRunId(int batchRunId) {

this.batchRunId = batchRunId;

}

}

WRITER :

package org.batch.writer;

/*import org.apache.commons.beanutils.PropertyUtils;*/

import java.io.File;

import java.util.ArrayList;

import java.util.List;

import javax.sql.DataSource;

import javax.xml.parsers.DocumentBuilder;

import javax.xml.parsers.DocumentBuilderFactory;

import javax.xml.transform.Transformer;

import javax.xml.transform.TransformerFactory;

import javax.xml.transform.dom.DOMSource;

import javax.xml.transform.stream.StreamResult;

import org.batch.model.Student;

import org.springframework.batch.core.ExitStatus;

import org.springframework.batch.core.StepExecution;

import org.springframework.batch.core.StepExecutionListener;

import org.springframework.batch.item.ItemWriter;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.jdbc.core.JdbcTemplate;

import org.w3c.dom.Attr;

import org.w3c.dom.Document;

import org.w3c.dom.Element;

public class StudentGeneration_Writer  implements ItemWriter<Student>,StepExecutionListener{

private JdbcTemplate jdbcTemplate;

int batchRunId;

@Autowired

public void setDataSource(DataSource dataSource) {

this.jdbcTemplate = new JdbcTemplate(dataSource);

}

@Override

public ExitStatus afterStep(StepExecution stepExecution) {

// TODO Auto-generated method stub

String sqlUpdate="UPDATE batchstrn SET STATUSCODE='S' WHERE BATCHRUNID=?";

jdbcTemplate.update(sqlUpdate,batchRunId);

return ExitStatus.COMPLETED;

}

@Override

public void beforeStep(StepExecution arg0) {

// TODO Auto-generated method stub

}

@Override

public void write(List<? extends Student> studentList) throws Exception {

// TODO Auto-generated method stub

List<Student> listStudent = new  ArrayList<Student>();

for(Student dto:studentList)

{

Student studentObj = new Student();

studentObj.setId(dto.getId());

studentObj.setName(dto.getName());

studentObj.setCollege(dto.getCollege());

studentObj.setStatus(dto.getStatus());

listStudent.add(studentObj);

}

createXml(listStudent);

}

public int getBatchRunId() {

return batchRunId;

}

public void setBatchRunId(int batchRunId) {

this.batchRunId = batchRunId;

}

//new

public static void  createXml(List<? extends Student> studentList)

{

/*

private String id ;

private String name;

private String college;

private String status;

*/

try {

DocumentBuilderFactory docFactory = DocumentBuilderFactory.newInstance();

DocumentBuilder docBuilder = docFactory.newDocumentBuilder();

// root elements

Document doc = docBuilder.newDocument();

Element rootElement = doc.createElement("college");

doc.appendChild(rootElement);

// staff elements

for (Student student : studentList) {

Element staff = doc.createElement("Student");

rootElement.appendChild(staff);

// set attribute to staff element

Attr attr = doc.createAttribute("id");

attr.setValue(student.getId());

staff.setAttributeNode(attr);

Element firstname = doc.createElement("name");

firstname.appendChild(doc.createTextNode(student.getName()));

staff.appendChild(firstname);

Element lastname = doc.createElement("college");

lastname.appendChild(doc.createTextNode(student.getCollege()));

staff.appendChild(lastname);

Element nickname = doc.createElement("status");

nickname.appendChild(doc.createTextNode(student.getStatus()));

staff.appendChild(nickname);

// write the content into xml file

TransformerFactory transformerFactory = TransformerFactory.newInstance();

Transformer transformer = transformerFactory.newTransformer();

DOMSource source = new DOMSource(doc);

StreamResult result = new StreamResult(new File("D:\\file.xml"));

// Output to console for testing

// StreamResult result = new StreamResult(System.out);

transformer.transform(source, result);

System.out.println("File saved!");

 } 

}

catch (Exception pce) {

pce.printStackTrace();

 }

}

}

THANKS for reading this article.for any query ping me on pathak.nisarg@yahoo.com

Happy Learning!!