Help to Developer

Jasper report printing at client side,Java,Struts,jasper reports, print at client side,Ajax

2011-12-20T09:56:00.000-08:00

Jasper report printing at client side,Java,Struts,jasper reports, print at client side,Ajax

Calling Procedures from Java

2011-01-25T06:05:00.000-08:00

In Java :

       String authPostingQry = "call fn_authorise_cust_rcpt(?,?)";
               System.out.println("authPostingQry : " + authPostingQry);

                callStatement =connection.prepareCall(authPostingQry);
               callStatement.setString(1, mst.getCrNum());
                callStatement.registerOutParameter(2, Types.TINYINT);

                int postingStatus = callStatement.executeUpdate();
                succesMsg=callStatement.getInt(2);
                    System.out.println("succesMsg: " + succesMsg);

Mysql Procedure:

/*====================================================
TEST:
call fn_authorise_cust_rcpt('CR0001391',@s);
select @s;
====================================================*/
--
-- variable declarartion to hold cursor values
--
declare vcust_rcpt_no varchar(15);
declare vtran_type varchar(20);
declare vcurr_adjust_amt decimal(18,3);
declare vcust_code varchar(12);
declare vinv_db_note_no varchar(20);
DECLARE vcust_rcpt_status VARCHAR(20);
DECLARE not_found condition FOR 1329;
--
-- cursor declaration to get the details of given cust_rcpt_no
--

declare cur_cust_rcpt cursor for
    select d.cust_rcpt_no,
    d.tran_type,
    d.curr_adjust_amt,
    d.inv_db_note_no,
    m.cust_code,
    m.cust_rcpt_status
    from fn_tr_cust_rcpt_main m
    join fn_tr_cust_rcpt_dets d on m.cust_rcpt_no = d.cust_rcpt_no
    where m.cust_rcpt_no = pcust_rcpt_no;
--
-- decalring exit handler if no rows are fetched
--

declare exit handler for not_found

begin
    if(pstatus = 1)then
    update fn_tr_cust_rcpt_main m,fn_tr_cust_rcpt_dets d
    set m.ttl_adj_amt = m.ttl_adj_amt + vcurr_adjust_amt,m.cust_rcpt_status='Authorised',d.unadjust_amt=d.unadjust_amt - d.curr_adjust_amt
    where d.cust_rcpt_no = m.cust_rcpt_no and m.cust_rcpt_no = pcust_rcpt_no;
        set pstatus = 0;
    else
            set pstatus = 0;
            ROLLBACK;
    end if;
end;
start transaction;
open cur_cust_rcpt;-- opening the cursor
loop -- loop
fetch   cur_cust_rcpt into vcust_rcpt_no,vtran_type,vcurr_adjust_amt,vinv_db_note_no,vcust_code,vcust_rcpt_status;-- fetching cursor variables
--
-- condition to check status and transaction type of the given cust_rcpt_no
--
    if(vtran_type = 'Customer Invoice' and vcust_rcpt_status = 'Fresh') then -- if cust_rcpt_no is customer invoice and in fresh state then updates fn_cust_inv_dets

        update fn_cust_inv_mst
        set tot_adj_amt = tot_adj_amt + vcurr_adjust_amt
        where cust_code = vcust_code and inv_no = vinv_db_note_no;

        set pstatus = 1;
    elseIF(vtran_type = 'DEBIT NOTE' and vcust_rcpt_status = 'Fresh') THEN -- if cust_rcpt_no is debit note and in fresh state then updates fn_tr_cust_dr_cr_note_dets

        update fn_tr_cust_dr_cr_note_main
        set amt_adj = amt_adj +vcurr_adjust_amt
        where cust_note_no = vinv_db_note_no;
        set pstatus = 1;
    ELSE -- if the given cust_rcpt_no is already authorised
    SET pstatus = 0;
end if; -- ending if
end loop; -- ending the loop
close cur_cust_rcpt; -- closing the cursor
commit;
END$$

DELIMITER ;

Comparing collection objects

2010-11-09T04:46:00.001-08:00

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/

package javaapplication1;

import java.util.ArrayList;
import java.util.List;

/**
*
* @author sowjanya.g
*/
public class compare {

    public static void main(String args[]){

        employee e = null;
        List al=new ArrayList();
        e=new employee("sowji","sowji@gmail.com",24);
        al.add(e);
        e=new employee("sowji1","sowji1@gmail.com",30);
        al.add(e);
        boolean checkFlag = false;
        for(employee emp: al){
            if(emp.getMailId().equals("sowji1@gmail.com")){
                checkFlag = true;
                break;
            }
        }
        System.out.println("Check Flag:=="+checkFlag);
        if(!checkFlag){
            e=new employee("sowji2","sowji1@gmail.com",40);
            al.add(e);
        }

        for(employee emp: al){
            System.out.println("email Id:=="+emp.getMailId());
        }

    }

}
class employee
{
    String name;
    String mailId;
    int age;

    public employee(String name,String mail,int age)
    {
        this.name=name;
        this.mailId=mail;
        this.age=age;
    }
    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getMailId() {
        return mailId;
    }

    public void setMailId(String mailId) {
        this.mailId = mailId;
    }

    public String getName() {
        return name;
    }

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

}

Java Code for sorting objects in collection classes using Comparator

2010-11-09T04:45:00.000-08:00

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/

package javaapplication1;

/**
*
* @author sowjanya.g
*/

import java.util.Arrays;
import java.util.Comparator;

/**
* @author amoram
*
*/
   /*

   Java Comparator example.
   This Java Comparator example describes how java.util.Comparator
   interface is implemented to compare Java user defined classe's objects.
   These Java Comparator is passed to Collection's sorting
   method ( for example Collections.sort method)to perform sorting of Java user defined classe's objects.

   */

   /*

   java.util.Comparator interface declares two methods,
   1) public int compare(Object object1, Object object2) and
   2) boolean equals(Object object)

   */

   /*
   We will compare objects of the Person class using custom comparators
   on the basis of person age and name.
   */

class Person{
   private int age;
   private String name;
   public void setAge(int age){
       this.age=age;
   }

   public int getAge(){
       return this.age;
   }

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

   public String getName(){
       return this.name;
   }
}

/*

User defined java comaprator.
To create custom java comparator Implement Comparator interface and
define compare method.
The below given comparator compares persons on the basis of their age.

*/

class AgeComparator implements Comparator{

   public int compare(Object emp1, Object emp2){
       //parameter are of type Object, so we have to downcast it to Person objects
       int emp1Age = ( (Person) emp1).getAge();
       int emp2Age = ( (Person) emp2).getAge();
       if( emp1Age > emp2Age ){
           return 1;
       }
       else if( emp1Age < emp2Age ){
           return -1;
       }
       else{
           return 0;
       }
   }

}

/* The below given comparator compares persons on the basis of their name. */

class NameComparator implements Comparator{

   public int compare(Object emp1, Object emp2){
       //parameter are of type Object, so we have to downcast it to Person objects
       String emp1Name = ( (Person) emp1 ).getName();
       String emp2Name = ( (Person) emp2 ).getName();
       //uses compareTo method of String class to compare names of the person
       return emp1Name.compareTo(emp2Name);
   }

}

/*

This Java comparator example compares persons on the basis of

their age and name and sort it in that order.

*/

public class JavaComparatorExample{

   public static void main(String args[]){

       /*   Person array which will hold persons */

       Person person[] = new Person[2];
       //set different attributes of the individual person.
       person[0] = new Person();
       person[0].setAge(40);
       person[0].setName("Joe");

       person[1] = new Person();
       person[1].setAge(20);
       person[1].setName("Mark");

       System.out.println("Order of person before sorting is");
       //print array as is.
       for(int i=0; i < person.length; i++){
           System.out.println( "Person " + (i+1) + " name :: " +
                   "" + person[i].getName() + ", Age :: " + person[i].getAge());
       }

       /*

       Sort method of the Arrays class sorts the given array.
       Signature of the sort method is,
       static void sort(Object[] object, Comparator comparator)
       IMPORTANT: All methods defined by Arrays class are static. Arrays class
       serve as a utility class.

       */

       /*   Sorting array on the basis of person age by passing AgeComparator   */

       Arrays.sort(person, new AgeComparator());
       System.out.println("\n\nOrder of person after sorting by person age is");
       for(int i=0; i < person.length; i++){
           System.out.println( "Person " + (i+1) + " name :: " +
                   "" + person[i].getName() + ", Age :: " + person[i].getAge());
       }

       /*   Sorting array on the basis of person Name by passing NameComparator */

       Arrays.sort(person, new NameComparator());
       System.out.println("\n\nOrder of person after sorting by person name is");
       for(int i=0; i < person.length; i++){
           System.out.println( "Person " + (i+1) + " name :: " +
                   "" + person[i].getName() + ", Age :: " + person[i].getAge());
       }
   }

}

Java Code for sorting objects in collection classes using Comparable interface

2010-11-09T04:31:00.000-08:00

package javaapplication1;

import java.util.ArrayList;
import java.util.Collections;

/**
*
* @author sowjanya.g
*/
public class Main {

public static void main(String[] args) {
ArrayList al=new ArrayList();

person p1=new person("sowjanya","sowji1.gutla@gmail.com","24");
person p2=new person("lavanya","ll.gutla@gmail.com","24");
person p3=new person("chaithu","chaithu1.gutla@gmail.com","24");
person p4=new person("avinash","zzzzi.moram@gmail.com","24");

al.add(p1);
al.add(p4);
al.add(p3);
al.add(p2);

System.out.println("al---before--"+al);

Collections.sort(al);

System.out.println("al----after---"+al);
}
}

class person implements Comparable
{
String name;
String mailId;
String age;

public int compareTo(Object o)
{
person per=(person)o;
return mailId.compareTo(per.getMailId());
}

person(String name1,String mail,String age1)
{
name=name1;
mailId=mail;
age=age1;
}
// method used to know the o/p as strings instead objects
@Override
public String toString()
{
return "Name: "+name+"---mailId--"+mailId+"---age--"+age;
}

public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public String getMailId() {
return mailId;
}
public void setMailId(String mailId) {
this.mailId = mailId;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}

}

Google Map with multiple markers

2010-10-06T01:19:00.000-07:00

Google Map with multiple Markers used to locate different locations .
We can show a map with image and contact details like following

Sending JSON object to Java and processing

2010-10-04T02:05:00.000-07:00

In java script :

function adjustments()
{
    //validation
    var st1="";
    var st2="";
    var gridsData;
    var mygridOne=new Array();
    var mygridTwo=new Array();
    var mygrid1Arry=null;
    var mygrid2Arry=null;

       if(document.getElementById("adjNature").value!='FIFO')
        {
     mygrid1Arry=mygrid1.getSelectedRecords();
     mygrid2Arry=mygrid2.getSelectedRecords();
        }
        else
            {

                mygrid1Arry=Sigma.Grid.getAllRows(mygrid1);
                mygrid2Arry=Sigma.Grid.getAllRows(mygrid2);
                }

       if(mygrid1Arry.length>0 && mygrid2Arry.length>0)
    {

         if(beforeAdjustvalidate())
        {
        for(var i=0;i
        {
            var docType1= mygrid1Arry[i].doctype;
            if(docType1==undefined) { docType1=mygrid1.getColumnValue('doctype', i);}
            var docNum1= mygrid1Arry[i].docno;
              if(docNum1==undefined) { docNum1=mygrid1.getColumnValue('docno', i);}
            var docDate1= mygrid1Arry[i].docdate;
             if(docDate1==undefined) { docDate1=mygrid1.getColumnValue('docdate', i);}
            var docAmount1= mygrid1Arry[i].docamt;
             if(docAmount1==undefined) { docAmount1=mygrid1.getColumnValue('docamt', i);}
               var amtAdjusted1= mygrid1Arry[i].amtadjusted;
             if(amtAdjusted1==undefined) { amtAdjusted1=mygrid1.getColumnValue('amtadjusted', i);}
            var balance1= mygrid1Arry[i].balance;
             if(balance1==undefined) { balance1=mygrid1.getColumnValue('balance', i);}
            var currentAdjustment1= mygrid1Arry[i].curradj;
             if(currentAdjustment1==undefined) { currentAdjustment1=mygrid1.getColumnValue('curradj', i);}
            if(i==(mygrid1Arry.length-1))
            {
                st1+="{docType:'"+docType1+"',docNum:'"+docNum1+"',docDate:'"+docDate1+"',docAmount:'"+docAmount1+"',amtAdjusted:'"+amtAdjusted1+"',balance:'"+balance1+"',currentAdjustment:'"+currentAdjustment1+"'}";

            }else
                st1+="{docType:'"+docType1+"',docNum:'"+docNum1+"',docDate:'"+docDate1+"',docAmount:'"+docAmount1+"',amtAdjusted:'"+amtAdjusted1+"',balance:'"+balance1+"',currentAdjustment:'"+currentAdjustment1+"'},";
        }
        for(var j=0;j
        {
            var docType2= mygrid2Arry[j].doctype;
             if(docType2==undefined) { docType2=mygrid2.getColumnValue('doctype', j);}
            var docNum2= mygrid2Arry[j].docno;
             if(docNum2==undefined) { docNum2=mygrid2.getColumnValue('docno', j);}
            var docDate2= mygrid2Arry[j].docdate;
             if(docDate2==undefined) { docDate2=mygrid2.getColumnValue('docdate', j);}
            var docAmount2= mygrid2Arry[j].docamt;
             if(docAmount2==undefined) { docAmount2=mygrid2.getColumnValue('docamt', j);}
            var amtAdjusted2= mygrid2Arry[j].amtadjusted;
             if(amtAdjusted2==undefined) { amtAdjusted2=mygrid2.getColumnValue('amtadjusted', j);}
            var balance2= mygrid2Arry[j].balance;
             if(balance2==undefined) { balance2=mygrid2.getColumnValue('balance', j);}
            var currentAdjustment2= mygrid2Arry[j].curradj;
             if(currentAdjustment2==undefined) { currentAdjustment2=mygrid2.getColumnValue('curradj', j);}

            if(j==(mygrid2Arry.length-1))
            { //alert("docType2-----"+docType2+"---");
                st2+="{docType:'"+docType2+"',docNum:'"+docNum2+"',docDate:'"+docDate2+"',docAmount:'"+docAmount2+"',amtAdjusted:'"+amtAdjusted2+"',balance:'"+balance2+"',currentAdjustment:'"+currentAdjustment2+"'}";
            }
            else
                st2+="{docType:'"+docType2+"',docNum:'"+docNum2+"',docDate:'"+docDate2+"',docAmount:'"+docAmount2+"',amtAdjusted:'"+amtAdjusted2+"',balance:'"+balance2+"',currentAdjustment:'"+currentAdjustment2+"'},";
        }

        st1="["+st1+"],";
        st2="["+st2+"]";
        gridsData='{"grid1-dr":'+ st1;
        gridsData+='"grid2-cr":'+ st2+'}';

        var toServer=gridsData;

        /* code started sending JSON Object to server */
        xmlhttp = false;
        if (window.XMLHttpRequest) {// code for Firefox, Opera, IE7, etc.
            xmlhttp=new XMLHttpRequest();
        } else if (window.ActiveXObject) {// code for IE6, IE5
            xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
        }
        if (xmlhttp!=null) {
            url=appsPath+"/finance/adjustCrDrdocs?adjNature="+encodeURIComponent(document.getElementById("adjNature").value);
            xmlhttp.onreadystatechange= function () {
                getAdjDetailsCallback(xmlhttp);
            };
            xmlhttp.open("POST", url, true);
            xmlhttp.setRequestHeader("Content-Type","application/x-www-form-urlencoded");
            xmlhttp.send(toServer);

        } else {
            alert("Your browser does not support XMLHTTP.");
        }

        }
    /* code ended sending JSON Object to server */

    }


    else
    {
        alert("Please select corresponding Cr/Dr documents");
        return false;
    }

}

function getAdjDetailsCallback()
{
    if (xmlhttp.readyState == 4)
    { // Complete
        alert(xmlhttp.responseText);
     var message=xmlhttp.responseXML;
      var recordlength=message.getElementsByTagName("grid").length;
      var docsArray=new Array();
      var amtAdjustedArray=new Array();
              var amtadjusted1=0;
      for(var i=0;i
          {
             var amtadjusted="";
              var record=message.getElementsByTagName("grid");
              var docnum=record[i].getElementsByTagName("docnum")[0].childNodes[0].nodeValue;
              amtadjusted=record[i].getElementsByTagName("amtadjusted")[0].childNodes[0].nodeValue;
              var balance=record[i].getElementsByTagName("balance")[0].childNodes[0].nodeValue;


                      var index;
                            var totaldrRecords = Sigma.Grid.getAllRows(mygrid1).size();
                           for(var t=0;t
                               {
                                  var docNumDr= mygrid1.getColumnValue("docno",t);
                                  if(docnum==docNumDr)
                                      {
                                        index=t;
                                         mygrid1.setColumnValue("amtadjusted", index,amtadjusted);
                                         mygrid1.setColumnValue("balance", index,balance);
                                        mygrid1.refresh();

                                      }
                               }



                           var index1;
                          var totalcrRecords = Sigma.Grid.getAllRows(mygrid2).size();
                           for(var t1=0;t1
                               {
                                  var docNumDr= mygrid2.getColumnValue("docno",t1);
                                  if(docnum==docNumDr)
                                      {
                                        index1=t1;
                                       mygrid2.setColumnValue("amtadjusted", index1,amtadjusted);
                               mygrid2.setColumnValue("balance", index1,balance);
                               mygrid2.refresh();
                                      }
                               }
     }

    }
}

In Java :

public ActionForward execute(ActionMapping mapping, ActionForm form,
            HttpServletRequest request, HttpServletResponse response)
            throws Exception {

        System.out.println("-----------------in AdjustmentAction--execute");
        String gridsData = readJSON(request);
        String adjNature = request.getParameter("adjNature") != null ? request.getParameter("adjNature") : "";
        System.out.println("adjNature---------"+adjNature);
        //Use the JSON-Java binding library to create a JSON object in Java
        JSONObject jsonObject = null;
        StringBuffer sb = new StringBuffer();
        response.setContentType("text/xml");
        JSONArray gridOneArray;
        JSONArray gridOneTwo;
        try {
            jsonObject = new JSONObject(gridsData);
            System.out.println("jsonObject-----" + jsonObject);

            System.out.println("grid1------" + jsonObject.get("grid1-dr"));
            System.out.println("grid2------" + jsonObject.get("grid2-cr"));
            System.out.println("grid1-getJSONArray-----" + jsonObject.getJSONArray("grid1-dr"));
            System.out.println("grid2--getJSONArray----" + jsonObject.getJSONArray("grid2-cr"));
            gridOneArray = jsonObject.getJSONArray("grid1-dr");
            gridOneTwo = jsonObject.getJSONArray("grid2-cr");

            sb.append("<message>");
            sb.append("<grids>");
            for (int i = 0; i < gridOneArray.length(); i++) {
                System.out.println("outer for loop 1");
                JSONObject record1 = (JSONObject) gridOneArray.get(i);
                String docType1 = record1.getString("docType");
                Double balance1 = record1.getDouble("balance");
                Double currentAdjustment1;
                try{
                     currentAdjustment1= record1.getDouble("currentAdjustment");
                }catch(Exception e){ currentAdjustment1=0.0d;}
                Double docAmount1 = record1.getDouble("docAmount");
                Double amtAdjusted1 = record1.getDouble("amtAdjusted");
                String docDate1 = record1.getString("docDate");
                String docNum1 = record1.getString("docNum");
                System.out.println("outer for loop 2");

                for (int j = 0; j < gridOneTwo.length(); j++) {
                    JSONObject record2 = (JSONObject) gridOneTwo.get(j);
                    String docType2 = record2.getString("docType");
                    Double balance2 = record2.getDouble("balance");
                  Double currentAdjustment2;
                try{
                     currentAdjustment2= record2.getDouble("currentAdjustment");
                }catch(Exception e){ currentAdjustment2=0.0d;}
                    Double docAmount2 = record2.getDouble("docAmount");
                    Double amtAdjusted2 = record2.getDouble("amtAdjusted");
                    String docDate2 = record2.getString("docDate");
                    String docNum2 = record2.getString("docNum");
                    System.out.println("inner for loop");
                    /*
                     * Respose XML
                    <message><grids>
                    <grid><docnum>CR0000081</docnum><amtadjusted>9000.0</amtadjusted><balance>3000.0</balance><adjustedDoc>CI0000061</adjustedDoc></grid>
                    <grid><docnum>CI0000061</docnum><amtadjusted>19000.0</amtadjusted><balance>0.0</balance></grid>
                    <grid><docnum>CR0000051</docnum><amtadjusted>10000.0</amtadjusted><balance>10000.0</balance><adjustedDoc>CI0000061</adjustedDoc></grid>
                    </grids></message>
                     *
                     */
                    //business logic for manual adjustment starts here
                    if (adjNature != null && adjNature.equals("manual")) {
                        if (currentAdjustment1 <= currentAdjustment2) {    // Step 1 : deduct currentadj1 in balance2,then if balance1=0 then close the status of doctype1
                            //Step 2 : if balance1!=0,then go to next credit document

                            //Step 1 execution starts here
                            System.out.println("if currentAdjustment1<=balance2--strats");
                            balance2 = balance2 - currentAdjustment2;
                            amtAdjusted2 = amtAdjusted2 + currentAdjustment2;
                            amtAdjusted1 += currentAdjustment1;
                            balance1 = balance1 - currentAdjustment1;
                            sb.append("<grid>");
                            sb.append("<docnum>" + docNum1 + "</docnum>");
                            sb.append("<amtadjusted>" + amtAdjusted1 + "</amtadjusted>");
                            sb.append("<balance>" + balance1 + "</balance>");
                            sb.append("</grid>");
                            sb.append("<grid>");
                            sb.append("<docnum>" + docNum2 + "</docnum>");
                            sb.append("<amtadjusted>" + amtAdjusted2 + "</amtadjusted>");
                            sb.append("<balance>" + balance2 + "</balance>");
                            sb.append("<adjustedDoc>" + docNum1 + "</adjustedDoc>");
                            sb.append("</grid>");
                            System.out.println("if currentAdjustment1<=balance2--ends");
                        } else if (currentAdjustment1 > currentAdjustment2) {
                            //Step 1 : deduct balance2 in currentAdjustment1 then if balance2=0, then close doctype2
                            System.out.println("if currentAdjustment1>balance2--strats");
                            amtAdjusted2 = amtAdjusted2 + currentAdjustment2;
                            amtAdjusted1 += currentAdjustment2;
                            currentAdjustment1 = currentAdjustment1 - currentAdjustment2;
                            System.out.println("currentAdjustment1-2--" + currentAdjustment1);
                            balance1 = balance1 - currentAdjustment2;
                            balance2 = balance2 - currentAdjustment2;
                            sb.append("<grid>");
                            sb.append("<docnum>" + docNum2 + "</docnum>");
                            sb.append("<amtadjusted>" + amtAdjusted2 + "</amtadjusted>");
                            sb.append("<balance>" + balance2 + "</balance>");
                            sb.append("<adjustedDoc>" + docNum1 + "</adjustedDoc>");
                            sb.append("</grid>");
                            System.out.println("if currentAdjustment1>balance2--ends");

                        }
                    // manual end

                    }// END MANUAL IF
                    // FIFO STARTS
                    else if (adjNature != null && adjNature.equals("FIFO")) {
                      if(balance1<=balance2)
                        {    // Step 1 : deduct balance1 in balance2,then if balance1=0 then close the status of doctype1
                        //Step 2 : if balance1!=0,then go to next credit document

                        //Step 1 execution starts here
                        System.out.println("if balance1<=balance2--strats");
                        balance2=balance2-balance1;
                        amtAdjusted2=amtAdjusted2+balance1;
                        amtAdjusted1+=balance1;
                        balance1=balance1-balance1;
                        sb.append("<grid>");
                        sb.append("<docnum>"+docNum1+"</docnum>");
                        sb.append("<amtadjusted>"+amtAdjusted1+"</amtadjusted>");
                        sb.append("<balance>"+balance1+"</balance>");
                        sb.append("</grid>");

                        sb.append("<grid>");
                        sb.append("<docnum>"+docNum2+"</docnum>");
                        sb.append("<amtadjusted>"+amtAdjusted2+"</amtadjusted>");
                        sb.append("<balance>"+balance2+"</balance>");
                        sb.append("<adjustedDoc>"+docNum1+"</adjustedDoc>");
                        sb.append("</grid>");
                        System.out.println("if currentAdjustment1<=balance2--ends");
                        }
                        else if(balance1>balance2)
                        {
                        //Step 1 : deduct balance2 in currentAdjustment1 then if balance2=0, then close doctype2
                        System.out.println("if currentAdjustment1>balance2--strats");
                        amtAdjusted2=amtAdjusted2+balance2;
                        amtAdjusted1+=balance2;
                        currentAdjustment1=currentAdjustment1-balance2;
                        System.out.println("currentAdjustment1-2--"+currentAdjustment1);
                        balance1=balance1-balance2;
                        balance2=balance2-balance2;
                         sb.append("<grid>");
                        sb.append("<docnum>"+docNum1+"</docnum>");
                        sb.append("<amtadjusted>"+amtAdjusted1+"</amtadjusted>");
                        sb.append("<balance>"+balance1+"</balance>");
                        sb.append("</grid>");
                        sb.append("<grid>");
                        sb.append("<docnum>"+docNum2+"</docnum>");
                        sb.append("<amtadjusted>"+amtAdjusted2+"</amtadjusted>");
                        sb.append("<balance>"+balance2+"</balance>");
                        sb.append("<adjustedDoc>"+docNum1+"</adjustedDoc>");
                        sb.append("</grid>");
                        System.out.println("if currentAdjustment1>balance2--ends");

                        }

                    } //FIFO end

                } //inner for loop

            } //outer for loop
            sb.append("</grids>");
            sb.append("</message>");
        } //try
        catch (Exception pe) {
            pe.printStackTrace();
        }

        System.out.println("sb.toString()-----" + sb.toString());
        response.getWriter().write(sb.toString());
        return null;

    }

    private String readJSON(HttpServletRequest request) {
        StringBuffer json = new StringBuffer();
        String line = null;
        try {
            BufferedReader reader = request.getReader();
            while ((line = reader.readLine()) != null) {
                json.append(line);
            }
        } catch (Exception e) {
            System.out.println("Error reading JSON String: " + e.toString());
        }
        return json.toString();
    }

Quartz Scheduler example in Java using Spring

2010-05-30T23:05:00.000-07:00

Requirement: Run a task (process) without user intervention at customized regular intervals of time and perform service to your application.

Solution: Quartz Scheduler has this feature of scheduling jobs at specified intervals of time mentioning from seconds to years called cron expression.

1. In spring framework scheduling package we have this Quartz included, so just download the jar spring-context-support.jar into your application.

2. Now we need to identify and configure the Class and the method that needs to be triggered at regular intervals with the cron expression.

Let us move forward with a requirement scenario, say you have an application which brings all the stocks details from another service provider and you want to get those details every afternoon at 2:30 pm.

Say you already have the functionality with the help of a class StocksScheduler.class which extends ContextLoaderPlugIn in spring-webmvc-struts.jar, we have to extend ContextLoaderPlugIn because we want the scheduler to start working on my application start.

Step 1: Define your bean (Class) in which your task is implemented that you want to perform

Step 2: Define the method which has the functionality that you have implemented in the targetMethod property and your class in targetObject property

</bean>

Step 3: Define the cron expression, i.e. the interval that you want your getDailyStocks to run and save in your application, the jobDetail and the cropnExpression

</bean>

Step 4: The scheduling.stocksCronExpression is a property in the property file scheduling.properties file which is defined in your app-context.xml as below

<bean id="propertyConfigurer"

class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

<list>

<value>scheduling.properties</value>

</list>

</property>

</bean>

Step 5: Scheduling.properties file will contain this property scheduling.stocksCronExpression as follows. The cron expression has to be changed according your required interval. The following cron expression will make the stocksScheduler run every day at 2:30 pm.

scheduling.stocksCronExpression = 0 30 14 ? * *

Step 6: We have to include this following plugin into the struts-config.xml file for making our scheduler when the context is loaded.

<plug-in className="com.app.stocks.StocksLoader" >

<set-property property="contextConfigLocation" value="/WEB-INF/app-context.xml"/>

</plug-in>

page break when printing

2010-04-16T03:23:00.000-07:00

Page breaks between the content. I have so many vouchers to print. I need one voucher in one page with page break. I have developed like, i have placed the content in a div which has height and width as A4 size.

"<div style='height:900px;border:0px solid #000000'> " .So i got vocuhers as page wise

My code is

function getdataforprinting(val){


        xmlhttp = false;
        if (window.XMLHttpRequest) {// code for Firefox, Opera, IE7, etc.
            xmlhttp=new XMLHttpRequest();
        } else if (window.ActiveXObject) {// code for IE6, IE5
            xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
        }
        /* ========== AJAX Initializtion ========== */

        if (xmlhttp!=null) {
            url="/getdataforedit"+"?ion="+ion;

            xmlhttp.onreadystatechange= function () { getprint(xmlhttp); };
            xmlhttp.open("POST", url, true);
            xmlhttp.setRequestHeader("Cache-Control","no-cache, private, max-age=0");
            xmlhttp.send(null);

        } else {
            alert("Your browser does not support XMLHTTP.");
        }
    }

    function getprint(httpRequest1)
    {

        if(httpRequest1.readyState==4)
        {

            if(httpRequest1.status==200)
            {

                var rest="";
                var result = httpRequest1.responseXML;
               var suplength=result.getElementsByTagName("supplier").length;
               if(suplength>0)
                   {
                       var msg=result.getElementsByTagName("supplier");
                       for(var t=0;t<suplength;t++)
                           {
                              var suppname=result.getElementsByTagName("suppname")[t].childNodes[0].nodeValue;
                              var billdate=result.getElementsByTagName("billdate")[t].childNodes[0].nodeValue;
                              var paymode=result.getElementsByTagName("paymode")[t].childNodes[0].nodeValue;
                               var ionno=result.getElementsByTagName("ionno")[t].childNodes[0].nodeValue;
                               var bbrcode=result.getElementsByTagName("bbrcode")[t].childNodes[0].nodeValue;
                                var instno=result.getElementsByTagName("instno")[t].childNodes[0].nodeValue;
                                  var instdate=result.getElementsByTagName("instdate")[t].childNodes[0].nodeValue;
                                var billno=result.getElementsByTagName("billno")[t].childNodes[0].nodeValue;
                                 var billamount=result.getElementsByTagName("billamount")[t].childNodes[0].nodeValue;
                                  var amount=result.getElementsByTagName("payamt")[t].childNodes[0].nodeValue;
                                  var suppid=result.getElementsByTagName("suppid")[t].childNodes[0].nodeValue;

                      rest+="<div style='height:900px;border:0px solid #000000'>";

   rest+="<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width=\"60%\"><tr>";
rest+="<td class=\"text_bg\">Inter Office Document Number</td>";
   rest+="<td class=\"text_bg\">"+ionno+"</td>";
   rest+="</tr><tr><td class=\"text_bg\">Supplier payment voucher number</td>";
   rest+="<td class=\"text_bg\">"+suppid+"</td></tr>";
   rest+="<tr><td class=\"text_bg\">Supplier name</td>";
   rest+="<td class=\"text_bg\">"+suppname+"</td></tr><tr><td class=\"text_bg\">Supplier Bill date</td>";
   rest+="<td class=\"text_bg\">"+billdate+"</td></tr><tr><td class=\"text_bg\">Supplier Bill amount</td>";
   rest+="<td class=\"text_bg\">"+billamount+"</td></tr><tr><td class=\"text_bg\">Pay mode</td><td class=\"text_bg\">"+paymode+"</td>";

      rest+="</tr><tr><td class=\"text_bg\">Bank Name</td><td class=\"text_bg\">bnk</td></tr><tr>";
   rest+="<td class=\"text_bg\">Branch</td><td class=\"text_bg\">br</td></tr><tr>";
       rest+="<td class=\"text_bg\">Instrument Number</td>";
      rest+="<td class=\"text_bg\">"+instno+"</td></tr><tr><td class=\"text_bg\">Instrument Date</td>";
      rest+="<td class=\"text_bg\">"+instdate+"</td></tr> </table>";
   rest+="</div>";

                           }   //for close

    var disp_setting="toolbar=yes,location=no,directories=yes,menubar=yes,";
   disp_setting+="scrollbars=yes,width=650, height=600, left=100, top=25";

   var docprint= window.open("", "", disp_setting);
   docprint.document.open();
   docprint.document.write('<html>');
   docprint.document.write('<body onLoad="self.print()"><center>');

   docprint.document.write(rest);
   docprint.document.write('</center></body></html>');
   docprint.document.close();
   docprint.focus();
                }
        }

    }}

Crystal reports integration with Java

2010-04-06T21:22:00.001-07:00

Crystal Report integration with java.

All samples available in the following URL. Hava a look.It is very useful to you.

http://www.sdn.sap.com/irj/boc/index?rid=/webcontent/uuid/909355da-5b84-2b10-76a4-eed3ccf9e650

Alternate record coloring in jasper reports

2010-03-23T01:10:00.000-07:00

Alternate record styles in jasper reports

in .jrxml file

we need to write one style like this

     <style name="Row" isDefault="false" mode="Transparent">
        <conditionalStyle>
            <conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
            <style isDefault="false" style="Row" backcolor="#E6DAC3"/>
        </conditionalStyle>
    </style>

Need to give this style name for each record

<reportElement style="Row" mode="Opaque" x="0" y="0" width="555" height="15"/>

So my .jrxml file is like this

<?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="null" language="groovy" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
    <property name="ireport.zoom" value="1.0"/>
    <property name="ireport.x" value="0"/>
    <property name="ireport.y" value="0"/>
    <style name="Title" isDefault="false" fontName="Times New Roman" fontSize="50" isBold="true" pdfFontName="Times-Bold"/>
    <style name="SubTitle" isDefault="false" forecolor="#736343" fontName="Arial" fontSize="18"/>
    <style name="Column header" isDefault="false" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/>
    <style name="Detail" isDefault="false" fontName="Arial" fontSize="12"/>
    <style name="Row" isDefault="false" mode="Transparent">
        <conditionalStyle>
            <conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
            <style isDefault="false" style="Row" backcolor="#E6DAC3"/>
        </conditionalStyle>
    </style>
    <queryString language="SQL">
        <![CDATA[SELECT
     bp_indent.`indent_id` AS bp_indent_indent_id,
     bp_indent.`indent_no` AS bp_indent_indent_no,
     bp_indent.`req_emp_id` AS bp_indent_req_emp_id,
     bp_indent.`indent_date` AS bp_indent_indent_date,
     bp_indent.`indent_status` AS bp_indent_indent_status
FROM
     `bp_indent` bp_indent]]>
    </queryString>
    <field name="bp_indent_indent_id" class="java.lang.Integer">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="bp_indent_indent_no" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="bp_indent_req_emp_id" class="java.lang.Integer">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="bp_indent_indent_date" class="java.sql.Timestamp">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <field name="bp_indent_indent_status" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
    <background>
        <band splitType="Stretch"/>
    </background>
    <title>
        <band height="31" splitType="Stretch"/>
    </title>
    <pageHeader>
        <band splitType="Stretch"/>
    </pageHeader>
    <columnHeader>
        <band height="16" splitType="Stretch">
            <line>
                <reportElement positionType="FixRelativeToBottom" x="0" y="15" width="555" height="1"/>
                <graphicElement>
                    <pen lineWidth="0.5" lineColor="#999999"/>
                </graphicElement>
            </line>
            <staticText>
                <reportElement style="Column header" x="0" y="0" width="111" height="15" forecolor="#736343"/>
                <textElement/>
               <text><![CDATA[bp_indent_indent_id]]></text>
            </staticText>
            <staticText>
                <reportElement style="Column header" x="111" y="0" width="111" height="15" forecolor="#736343"/>
                <textElement/>
                <text><![CDATA[bp_indent_indent_no]]></text>
            </staticText>
            <staticText>
                <reportElement style="Column header" x="222" y="0" width="111" height="15" forecolor="#736343"/>
                <textElement/>
                <text><![CDATA[bp_indent_req_emp_id]]></text>
            </staticText>
            <staticText>
                <reportElement style="Column header" x="333" y="0" width="111" height="15" forecolor="#736343"/>
                <textElement/>
                <text><![CDATA[bp_indent_indent_date]]></text>
            </staticText>
            <staticText>
                <reportElement style="Column header" x="444" y="0" width="111" height="15" forecolor="#736343"/>
                <textElement/>
                <text><![CDATA[bp_indent_indent_status]]></text>
            </staticText>
        </band>
    </columnHeader>
    <detail>
        <band height="15" splitType="Stretch">
            <frame>
                <reportElement style="Row" mode="Opaque" x="0" y="0" width="555" height="15"/>
                <textField isStretchWithOverflow="true">
                    <reportElement style="Detail" x="0" y="0" width="111" height="15"/>
                    <textElement/>
                    <textFieldExpression class="java.lang.Integer"><![CDATA[$F{bp_indent_indent_id}]]></textFieldExpression>
                </textField>
                <textField isStretchWithOverflow="true">
                    <reportElement style="Detail" x="111" y="0" width="111" height="15"/>
                    <textElement/>
                    <textFieldExpression class="java.lang.String"><![CDATA[$F{bp_indent_indent_no}]]></textFieldExpression>
                </textField>
                <textField isStretchWithOverflow="true">
                    <reportElement style="Detail" x="222" y="0" width="111" height="15"/>
                    <textElement/>
                    <textFieldExpression class="java.lang.Integer"><![CDATA[$F{bp_indent_req_emp_id}]]></textFieldExpression>
                </textField>
                <textField isStretchWithOverflow="true">
                    <reportElement style="Detail" x="333" y="0" width="111" height="15"/>
                    <textElement/>
                    <textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{bp_indent_indent_date}]]></textFieldExpression>
                </textField>
                <textField isStretchWithOverflow="true">
                    <reportElement style="Detail" x="444" y="0" width="111" height="15"/>
                    <textElement/>
                    <textFieldExpression class="java.lang.String"><![CDATA[$F{bp_indent_indent_status}]]></textFieldExpression>
                </textField>
            </frame>
        </band>
    </detail>
    <columnFooter>
        <band height="45" splitType="Stretch">
            <line>
                <reportElement positionType="FixRelativeToBottom" x="0" y="3" width="555" height="1"/>
                <graphicElement>
                    <pen lineWidth="0.5" lineColor="#999999"/>
                </graphicElement>
            </line>
        </band>
    </columnFooter>
    <pageFooter>
        <band height="25" splitType="Stretch">
            <frame>
                <reportElement mode="Opaque" x="-21" y="1" width="597" height="24" forecolor="#D0B48E" backcolor="#F2EBDF"/>
                <textField evaluationTime="Report">
                    <reportElement style="Column header" x="533" y="0" width="40" height="20" forecolor="#736343"/>
                    <textElement verticalAlignment="Middle">
                        <font size="10" isBold="false"/>
                    </textElement>
                    <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
                </textField>
                <textField>
                    <reportElement style="Column header" x="453" y="0" width="80" height="20" forecolor="#736343"/>
                    <textElement textAlignment="Right" verticalAlignment="Middle">
                        <font size="10" isBold="false"/>
                    </textElement>
                    <textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
                </textField>
                <textField pattern="EEEEE dd MMMMM yyyy">
                    <reportElement style="Column header" x="22" y="1" width="197" height="20" forecolor="#736343"/>
                    <textElement verticalAlignment="Middle">
                        <font size="10" isBold="false"/>
                    </textElement>
                    <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
                </textField>
            </frame>
        </band>
    </pageFooter>
    <summary>
        <band splitType="Stretch"/>
    </summary>
</jasperReport>

Returning multiple result sets from stored procedure

2010-03-11T21:03:00.000-08:00

Handling multiple result sets from stored procedure as follows

My Procedure in Mysql

DELIMITER $$
DROP PROCEDURE IF EXISTS `mms`.`get_items`$$

CREATE DEFINER=`root`@`%` PROCEDURE `get_items`(IN pi_id int)
BEGIN
    /*    Call get_items(0); */

    /* ----------Result Set 1 ---------- */
    select     i_id, i_no, date_format(i_date,'%d/%m/%Y') as i_date,comments,i_status
            from bindent    where     i_id = pi_id ;

        /* ----------Result Set 2 ---------- */
    select     i_id, line_no, item_no,(select item_name from b_items where item_no = b_i_items.item_no )
                 as item_name,floor(req_qty) as req_qty, uom, app_qty, date_format(priority_date,'%d/%m/%Y') as
                  priority_date , wm_approved, vp_approved, comments,
                 (select uom_desc from b_uom where uom = b_i_items.uom) as uom_desc
             from b_i_items where i_id = pi_id ;
    END$$

DELIMITER ;

My Java Code function is

public static InVO getItemDetails(String id)
{
        List IndentDetList = null;
        Connection connection = null;
        CallableStatement callStatement = null;
        ResultSet rs = null, rsItems = null;
        Boolean queryResult = false;
        InVO invo = new InVO();
        try {
            // get the connection to the DB

            connection = MDB.getConnection();
            IndentDetList = new ArrayList();


            String query = "{Call get_items(?)}";
            callStatement = connection.prepareCall(query);

            callStatement.setString(1, id);
            rs = callStatement.executeQuery();

            while (rs.next()) {
                invo.setIndentid(rs.getString(1));
                invo.setIndentno(rs.getString(2));
                invo.setSysDate(rs.getString(3));
                invo.setIndentComment(rs.getString(4));
                invo.setStatus(rs.getString(5));
            }

            ItemVO itemobject = null;

            if (callStatement.getMoreResults())
        {
                rsItems = callStatement.getResultSet();

                 while (rsItems.next())
                {
                    itemobject = new ItemVO();
                    itemobject.setLineno(rsItems.getInt(2));
                    itemobject.setItemId(rsItems.getString(3));
                    itemobject.setItemName(rsItems.getString(4));
                    itemobject.setUnits(rsItems.getString(5));
                    itemobject.setUom(rsItems.getString(6));
                    itemobject.setPrioritydate(rsItems.getString("priority_date"));
                    itemobject.setUomDesc(rsItems.getString("uom_desc"));
                    IndentDetList.add(itemobject);
                }
                invo.setItemsList(IndentDetList);

            }

        } catch (Exception e) {
            indentvo = null;
            if (logger.isEnabledFor(Level.ERROR)) {
                logger.error("Error while getting Connection from DB: " + e.getMessage());
           }
        }
           finally {
            MDB.close(connection);
        }

        return indentvo;

    }// function closed

Basic struts example implemented in NetBeans IDE

2010-03-05T02:02:00.000-08:00

Hi friends,

This is a demo for basic example of struts framework implementation in NetBeans IDE.

It is helpful to the developers who are looking for basic struts implementation. I have a step by step procedure with screen shots.

Have a look.

I) Create a project. File -> New Project

II) Give the project name and add the server. If server is not configured already then add the server like this

Tools -> servers ->
"add server"

Add the server if server is configured to the new project.

For NEW Apple iPod Nano 5th Generation 5G (With Camera) 8GB 16GB Silicone Skin Soft Clear Rubber Case

Click finish button

III)

Create a folder called “form” in “web pages” in the project

Create jsps welcomeStruts .jsp , succ.jsp and fail.jsp.

Creating welcomeStruts.jsp

Code:

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>

<%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-html" prefix="html" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-logic" prefix="logic" %>

<html:html locale="true">
<body>

   <html:form action="/register">

        User Name <html:text property="userName"/>
        Password <html:password property="password"/>
        <html:submit/>

</html:form>

</body>
</html:html>

Creating succ.jsp

Creating fail.jsp

Creating Action form bean class

Right click on the package and select new action form bean class

Select those fields and right click on it. You can find like this.

Click “select all” and refactor button to get getters and setters.

Now Action form bean is like this

Creating Action class

Click Next

Click “Finish”

Type the action code like this. This

If u hit . (dot) after the object it will show auto suggested methods like

Final action class is code

package com.myapp.struts;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.Action;

import org.apache.struts.action.ActionForm;

import org.apache.struts.action.ActionMapping;

import org.apache.struts.action.ActionForward;

public class registerAction extends org.apache.struts.action.Action

{

private final static String SUCCESS = "success";

public ActionForward execute(ActionMapping mapping, ActionForm form,

HttpServletRequest request, HttpServletResponse response)

throws Exception {

registerForm rf=(registerForm)form;

String username=rf.getUserName();

String password=rf.getPassword();

if(username.equals("sowjiavi") || password.equals("sowjiavi"))

{

return mapping.findForward(SUCCESS);

}else

return mapping.findForward("fail");

}

Struts-Config.xml

Step 1: Open the struts-config .xml file

Step 2: Add following content

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

<struts-config>
    <form-beans>
       <form-bean name="registerForm" type="com.myapp.struts.registerForm"/>
    </form-beans>

<action-mappings>

   <action input="/" name="registerForm" path="/register" scope="session" type="com.myapp.struts.registerAction">
      <forward name="success" path="/form/succ.jsp"/>
<forward name="fail" path="/form/fail.jsp"/>
     </action>

    </action-mappings>

</struts-config>

Then your struts-config.xml file look like this

web.xml

Step 1: Open web.xml file

Step 2: Modify the file like this.

Web.xml code is:

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
    <servlet>
        <servlet-name>action</servlet-name>
        <servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
        <init-param>
           <param-name>config</param-name>
            <param-value>/WEB-INF/struts-config.xml</param-value>
       </init-param>
         <load-on-startup>2</load-on-startup>
        </servlet>
    <servlet-mapping>
        <servlet-name>action</servlet-name>
       <url-pattern>*.do</url-pattern>
    </servlet-mapping>

    <welcome-file-list>
        <welcome-file>/form/welcomeStruts.jsp</welcome-file>
        </welcome-file-list>
   </web-app>

My directory structure is

Then compile and run the application

It automatically opens the browser if server is configured.

Oracle job scheduling

2010-02-25T20:54:00.000-08:00

In my project , the requirement is inserting records into main database from child databases.

I have created one Job in Oracle. It automatically inserting record which is not yet inserted into main database.

The status of each record which is not yet inserted or already inserted is maintained in one table called “update status” .

If “updaterecord” column is “True” then that record is not yet inserted in main database.

Otherwise that record is already inserted.

I have created one procedure which will checks and inserting the record. Created one Job (Oracle scheduler) and set the interval as 1 minute. That’s it. This job will be executed the procedure for every minute.

Step I :

The following is the procedure for inserting pending registrations of main database

CREATE OR REPLACE PROCEDURE updatejobproc IS

CURSOR x_cur IS

SELECT registrationno FROM abc.updatestatus@Child_Database WHERE updaterecord ='true';

BEGIN

FOR x_rec IN x_cur

LOOP

Insert into abc.contactdetails@Main_Database(aliasname,password,

hintquestion,hintanswer)

select userid,password,hintquestion,hintanswer from contactinformation@Child_Database where

registrationno=x_rec.registrationno;

update abc.updatestatus@Child_Database set updaterecord='false' where registrationno=x_rec.registrationno;

END LOOP;

COMMIT;

END updatejobproc;

Steps included in above procedure:

1) Getting all the registration numbers from child database which has updaterecord = true;

2) For each registration number from child database, corresponding record will be inserted into main database

3) Updating updaterecord flag in child database to “FALSE”

Step II:

Compile and run the procedure.

Step III:

Created one Job internally in child database to insert the record which has “updaterecord “ flag is “TRUE” for every minute.

SQL> declare
2 job integer;
3 begin
4 dbms_job.submit(job, ‘updatejobproc;',sysdate,'sysdate+1/1440');

5 commit;
6 end;
7 /

Step IV:

Execute following queries.

1)ALTER SYSTEM DISABLE RESTRICTED SESSION;



2)ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 10;

Jasper Reports with pagination

2010-02-22T21:28:00.000-08:00

Jasper Reports with pagination

I have added one more concept of adding pagination to Jasper Reports.
Adding pagination functionality to the jasper reports is very simple.
It has few steps to get it .
Have a look.
Following example is very simple.We can modify it as well for good UI.

IN MY jsp (reportview.jsp)
------------------------------
<% JRHtmlExporter export = (JRHtmlExporter)request.getAttribute("exportIndentObject"); session.setAttribute("exportIndentObject", export); JRHtmlExporter export1=(JRHtmlExporter)session.getAttribute("exportIndentObject"); Integer st1 = (Integer) request.getAttribute("repoprt.size"); %>
<head>
<script language="javascript">
var value=0;
function showpageview(val)
{

value=val;
var len=<%=st1%>;
if(val>=len){
value=len-1;
alert("No more pages");
} else if (val<0){
value=0;
alert("No Previous pages");
}else{
showPage(val);
}
}

function showPage(val)
{

xmlhttp = false;
if (window.XMLHttpRequest) {// code for Firefox, Opera, IE7, etc.
xmlhttp=new XMLHttpRequest();
} else if (window.ActiveXObject) {// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
/* ========== AJAX Initializtion ========== */

if (xmlhttp!=null) {
url="<%=request.getContextPath()%>/report/view?pageNo="+val;
xmlhttp.onreadystatechange= function () { getReport(xmlhttp); };
xmlhttp.open("POST", url, true);
xmlhttp.setRequestHeader("Cache-Control","no-cache, private, max-age=0");
xmlhttp.send(null);

} else {
alert("Your browser does not support XMLHTTP.");
}

}
function getReport(httpRequest1)
{
if(httpRequest1.readyState==4)
{
if(httpRequest1.status==200)
{
var result = httpRequest1.responseText;
document.getElementById("reportdiv").innerHTML=result;
}
}

}
</script>

</head>
<body onLoad="showPage(0)">
<html:form action="/export/action">
<%
Integer st = (Integer) request.getAttribute("repoprt.size");

if (st > 0) {
%>
<table>
<tr>
<td colspan="3">
<select id="exportName" name="exportName" class="select_box" >
<option value="PDF">PDF</option>
<option value="EXCEL">EXCEL</option>
<option value="TEXT">TEXT</option>
</select>

<html:submit value="Export" styleClass="button_submit"/>

<input type="button" class="button_submit" value="print" onClick="javascript:print();"/>

</td>
</tr>
<tr><td colspan="3" align="center">

<div id="reportdiv" style="display:block"></div>
</td> </tr>
</table>

<table width="100%" border="0" cellspacing="0" cellpadding="0" id="pagintable3">
<tr>

<td width="17%" height="35" align="right" class="extreme"><a href="javascript:showpageview(value-1)"><b>< Prev</b> </a></td>
<td width="17%" align="left" class="extreme"><a href="javascript:showpageview(value+1)"> <b>Next ></b></a> </td>
</tr>
</table>

<%} else {
%>
<div class="warn"> <h3>No Records Found</h3></div>

<% }
%>
</html:form>

</body>

In my Struts-Config file
----------------------------

<action
path="/report/view"
name="IndentReportForm"
type="com.jsperReports.ReportViewAction">
<forward name="success" path="reports.view"/>
<forward name="success1" path="/WEB-INF/jsp/jasperReports/reportshow.jsp"/>
</action>

In my struts Action class(ReportViewAction.java)
--------------------------------------------------

String pg=request.getParameter("pageNo");
if(pg!=null)
{
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRHtmlExporterParameter.OUTPUT_WRITER, out);
exporter.setParameter(JRHtmlExporterParameter.PAGE_INDEX, new Integer(pg));
HashMap fontMap = new HashMap();
exporter.setParameter(JRHtmlExporterParameter.FONT_MAP, fontMap);
exporter.setParameter(JRHtmlExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE);
exporter.setParameter(JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN, Boolean.FALSE);
exporter.setParameter(JRHtmlExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE);
exporter.setParameter(JRHtmlExporterParameter.IS_WRAP_BREAK_WORD,Boolean.TRUE);
JasperExportManager.exportReportToHtmlFile(jasperPrint,request.getRealPath("/reports") + "/" + "Report.html");
request.setAttribute("exportPrintObject", exporter);
List sizeList=(ArrayList)jasperPrint.getPages();
Integer repoerSize=sizeList.size();
if(repoerSize==0){
request.setAttribute("repoprt.size",repoerSize);
map="success1";
}
try{
//closing connection
SDB.close(con);
}catch(Exception e){e.printStackTrace();}

In my reportshow.jsp
---------------------
<% JRHtmlExporter export = (JRHtmlExporter) request.getAttribute("exportPrintObject"); export.exportReport(); %>

See the following screen shot(We can do modification as we require)

Design Japser Report in Net beans

2010-02-11T05:55:00.000-08:00

Design Jasper Report in Net beans IDE

We can design the jasper report in Netbeans IDE. So, at one place(IDE) we can design Java,PHP , Reports and etc..

The following JAR files needed to add the plugin of Jasper Reports

1) iReport-nb-3.5.2.nbm

2) jasperreports-components-plugin-nb-3.5.2.nbm

3) jasperreports-extensions-plugin-nb-3.5.2.nbm

4) jasperserver-plugin-nb-3.5.2.nbm

You just add these jar files to the Netbeans like this

Tools--->Plugins--->downloaded--->Add Plugins-- Browse and give the path of jar files located.

See the screen shot.

The Australian Directory

Exporting Jasper Reports into Pdf,Excel(.xls) and Text (.txt) format with Save As dialog box

2010-02-08T00:59:00.000-08:00

Hi friends,

Way of exporting jasper Reports into .pdf, .xls and .txt format with "Save As" dialog to download at client side

my .jrxml file is like this.( ListOfItems.jrxml)

<?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="null" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
<queryString language="SQL">
<![CDATA[select inventory_id,
item_no,
(select item_name from bp_items where item_no= bp_inventory.item_no) as item_name,
quantity,
shelf_time,
optimum_shelf_time
from
bp_inventory
order by item_name]]>
</queryString>
<field name="inventory_id" class="java.lang.Integer">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="item_no" class="java.lang.Integer">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="item_name" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="quantity" class="java.math.BigDecimal">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="shelf_time" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<field name="optimum_shelf_time" class="java.lang.String">
<fieldDescription><![CDATA[]]></fieldDescription>
</field>
<background>
<band/>
</background>
<title>
<band height="55">
<staticText>
<reportElement x="65" y="13" width="424" height="35" backcolor="#0000FF"/>
<textElement textAlignment="Center">
<font size="16" isBold="true"/>
</textElement>
<text><![CDATA[Items Report]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band/>
</pageHeader>
<columnHeader>
<band height="18">
<staticText>
<reportElement mode="Opaque" x="0" y="0" width="79" height="18" forecolor="#FFFFFF" backcolor="#4661C2"/>
<textElement textAlignment="Center">
<font fontName="verdana" size="12" isBold="true"/>
</textElement>
<text><![CDATA[Inventory No]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="79" y="0" width="68" height="18" forecolor="#FFFFFF" backcolor="#4661C2"/>
<textElement textAlignment="Center">
<font fontName="verdana" size="12" isBold="true"/>
</textElement>
<text><![CDATA[Item No]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="147" y="0" width="79" height="18" forecolor="#FFFFFF" backcolor="#4661C2"/>
<textElement textAlignment="Center">
<font fontName="verdana" size="12" isBold="true"/>
</textElement>
<text><![CDATA[Item Name]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="226" y="0" width="77" height="18" forecolor="#FFFFFF" backcolor="#4661C2"/>
<textElement textAlignment="Center">
<font fontName="verdana" size="12" isBold="true"/>
</textElement>
<text><![CDATA[Quantity]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="303" y="0" width="103" height="18" forecolor="#FFFFFF" backcolor="#4661C2"/>
<textElement textAlignment="Center">
<font fontName="verdana" size="12" isBold="true"/>
</textElement>
<text><![CDATA[Shelf Time]]></text>
</staticText>
<staticText>
<reportElement mode="Opaque" x="406" y="0" width="147" height="18" forecolor="#FFFFFF" backcolor="#4661C2"/>
<textElement>
<font fontName="verdana" size="12" isBold="true"/>
</textElement>
<text><![CDATA[OptimumShelfTime]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="20">
<textField>
<reportElement x="0" y="0" width="79" height="20"/>
<textElement textAlignment="Center">
<font fontName="Verdana" size="12"/>
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$F{inventory_id}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="79" y="0" width="68" height="20"/>
<textElement textAlignment="Center">
<font fontName="Verdana" size="12"/>
</textElement>
<textFieldExpression class="java.lang.Integer"><![CDATA[$F{item_no}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="147" y="0" width="79" height="20"/>
<textElement textAlignment="Center">
<font fontName="Verdana" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{item_name}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="226" y="0" width="77" height="20"/>
<textElement textAlignment="Center">
<font fontName="Verdana" size="12"/>
</textElement>
<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{quantity}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="303" y="0" width="103" height="20"/>
<textElement textAlignment="Center">
<font fontName="Verdana" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{shelf_time}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="406" y="0" width="147" height="20"/>
<textElement textAlignment="Center">
<font fontName="Verdana" size="12"/>
</textElement>
<textFieldExpression class="java.lang.String"><![CDATA[$F{optimum_shelf_time}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band/>
</columnFooter>
<pageFooter>
<band height="54">
<textField>
<reportElement x="410" y="15" width="80" height="20"/>
<textElement textAlignment="Right"/>
<textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
</textField>
<textField evaluationTime="Report">
<reportElement x="490" y="15" width="40" height="20"/>
<textElement/>
<textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
</textField>
</band>
</pageFooter>
<summary>
<band/>
</summary>
</jasperReport>

Code in Action class

//filename is the .jrxml file ( ListOfItems.jrxml)
String filename=request.getParameter("file");
// title is the title of the report.Here we are passing dynamically.So that this class is useful to remaining reports also.
String title=request.getParameter("title");
Connection con = MMSDB.getConnection();
String jrept = filename;
String reportFileName = JasperCompileManager.compileReportToFile(request.getRealPath("/reports") + "/" + jrept);

java.util.Map parameters = new java.util.HashMap();
parameters.put("ReportTitle", title);

File reportFile = new File(reportFileName);
if (!reportFile.exists()) {
throw new JRRuntimeException("File WebappReport.jasper not found. The report design must be compiled first.");
}
JasperPrint jasperPrint = JasperFillManager.fillReport(reportFileName, parameters, con);

//Maintaining request.----

JRHtmlExporter exporter = new JRHtmlExporter();
exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
HashMap fontMap = new HashMap();
exporter.setParameter(JRHtmlExporterParameter.FONT_MAP, fontMap);
exporter.setParameter(JRHtmlExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
exporter.setParameter(JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN, Boolean.FALSE);
exporter.setParameter(JRHtmlExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
exporter.setParameter(JRHtmlExporterParameter.IS_WRAP_BREAK_WORD, Boolean.TRUE);

request.setAttribute("exportObject", exporter);

if (!reportFile.exists()) {
throw new JRRuntimeException("File WebappReport.jasper not found. The report design must be compiled first.");
}

if (fileType.equals("PDF"))
{
response.setContentType("application/pdf");

JasperExportManager.exportReportToPdfFile(jasperPrint, request.getRealPath("/reports") + "/" +title+".pdf");
File f=new File(request.getRealPath("/reports") + "/" +title+".pdf");
FileInputStream fin = new FileInputStream(f);
ServletOutputStream outStream = response.getOutputStream();
// SET THE MIME TYPE.
response.setContentType("application/pdf");
// set content dispostion to attachment in with file name.
// case the open/save dialog needs to appear.
response.setHeader("Content-Disposition", "attachment;filename='"+title+"'.pdf");

byte[] buffer = new byte[1024];
int n = 0;
while ((n = fin.read(buffer)) != -1) {
outStream.write(buffer, 0, n);
System.out.println(buffer);
}

outStream.flush();
fin.close();
outStream.close();

}
else
if (fileType.equals("EXCEL"))
{
JRXlsExporter exporterXLS = new JRXlsExporter();
exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, jasperPrint);
exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);
exporterXLS.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
exporterXLS.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
exporterXLS.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, request.getRealPath("/reports") + "/" +title+".xls");
exporterXLS.exportReport();
File f=new File(request.getRealPath("/reports") + "/" +title+".xls");
FileInputStream fin = new FileInputStream(f);
ServletOutputStream outStream = response.getOutputStream();
// SET THE MIME TYPE.
response.setContentType("application/vnd.ms-excel");
// set content dispostion to attachment in with file name.
// case the open/save dialog needs to appear.
response.setHeader("Content-Disposition", "attachment;filename="+title+".xls");

byte[] buffer = new byte[1024];
int n = 0;
while ((n = fin.read(buffer)) != -1) {
outStream.write(buffer, 0, n);
System.out.println(buffer);
}

outStream.flush();
fin.close();
outStream.close();

}
else
if (fileType.equals("TEXT"))
{

JRTextExporter exporterTxt = new JRTextExporter();
exporterTxt.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);

exporterTxt.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, request.getRealPath("/reports") + "/" +title+".txt");
exporterTxt.setParameter(JRTextExporterParameter.CHARACTER_WIDTH, new Integer(7));

exporterTxt.setParameter(JRTextExporterParameter.CHARACTER_HEIGHT, new Integer(11));

exporterTxt.exportReport();

File f=new File(request.getRealPath("/reports") + "/" + title+".txt");
FileInputStream fin = new FileInputStream(f);
ServletOutputStream outStream = response.getOutputStream();
// SET THE MIME TYPE.
response.setContentType("application/text");
// set content dispostion to attachment in with file name.
// case the open/save dialog needs to appear.
response.setHeader("Content-Disposition", "attachment;filename="+title+".txt");

byte[] buffer = new byte[1024];
int n = 0;
while ((n = fin.read(buffer)) != -1) {
outStream.write(buffer, 0, n);
System.out.println(buffer);
}

outStream.flush();
fin.close();
outStream.close();

Way of printing Jasper Report at client side

2010-02-04T22:20:00.000-08:00

Hi friends,

I have developed one project which is customised Jasper Reports with export and print options.
I haven't get any problem for export options.
Coming to Print, i found that it is printing at server end.
So to eliminate that problem i found one solution that will be printing at client side.

For this solution i have used Jasper Report object and Ajax functionality.
The code is like this:
1) In my JSP

<input type="button" class="button_submit" value="print" onclick="javascript:print();">

Handler: For a "Print" Button you need to add onclick listener function print();

function print()
{
/* ========== AJAX Initializtion ========== */
xmlhttp = false;
if (window.XMLHttpRequest) {// code for Firefox, Opera, IE7, etc.
xmlhttp=new XMLHttpRequest();
} else if (window.ActiveXObject) {// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
/* ========== AJAX Initializtion ========== */

if (xmlhttp!=null) {
url = "/mms/reports";
xmlhttp.onreadystatechange= function () { getWorkReqDivs(xmlhttp); };
xmlhttp.open("POST", url, true);
xmlhttp.setRequestHeader("Cache-Control","no-cache, private, max-age=0");
xmlhttp.send(null);

} else {
alert("Your browser does not support XMLHTTP.");
}
}
function getWorkReqDivs(httpRequest1)
{
if(httpRequest1.readyState==4)
{
if(httpRequest1.status==200)
{
var result = httpRequest1.responseText;
var disp_setting="toolbar=yes,location=no,directories=yes,menubar=yes,";
disp_setting+="scrollbars=yes,width=650, height=600, left=100, top=25";
var content_vlue=result;
var docprint= window.open("", "", disp_setting);
docprint.document.open();
docprint.document.write(&lthtml>);
docprint.document.write(<body onLoad="self.print()">&lt/body>&lt/html>);
docprint.document.write(content_vlue);
docprint.document.close();
docprint.focus();

}
}
}

This script is used to get the Jasper Report in HTML format as responseText. So this text is added in window.open().It looks like print preview.In onload itself print dialog box will come to ask print.

Struts-config.xml

<action path="/mms/reports" type="com.km.bp.mms.jsperReports.printAction">
<forward name="print" path="/WEB-INF/jsp/jasperReports/print.jsp"/>
</action>

Java Class: (printAction.java)

JRHtmlExporter exporter = new JRHtmlExporter();
String jrept = "indentReport.jrxml";
String reportFileName = JasperCompileManager.compileReportToFile(request.getRealPath("/reports") + "/" + jrept);

java.util.Map parameters = new java.util.HashMap();

Connection con = MMSDB.getConnection();
String fromDatet="01/01/2010";
String toDate="28/02/2010";

parameters.put("fromDate", fromDatet);
parameters.put("toDate", toDate);

File reportFile = new File(reportFileName);
if (!reportFile.exists()) {
throw new JRRuntimeException("File WebappReport.jasper not found. The report design must be compiled first.");
}
JasperPrint jasperPrint = JasperFillManager.fillReport(reportFileName, parameters, con);

PrintWriter out = response.getWriter();
response.setContentType("text/html");

exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
exporter.setParameter(JRHtmlExporterParameter.OUTPUT_WRITER, out);
HashMap fontMap = new HashMap();
exporter.setParameter(JRHtmlExporterParameter.FONT_MAP, fontMap);
exporter.setParameter(JRHtmlExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
exporter.setParameter(JRHtmlExporterParameter.IS_USING_IMAGES_TO_ALIGN, Boolean.FALSE);
exporter.setParameter(JRHtmlExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
exporter.setParameter(JRHtmlExporterParameter.IS_WRAP_BREAK_WORD, Boolean.TRUE);

request.setAttribute("exportIndentObject", exporter);
return mapping.findForward("print");
}

}

Jsp File :(print.jsp)( The following Jsp is the responseText of the Ajax Call)

<%@page import="net.sf.jasperreports.engine.export.JRHtmlExporter" %>

< % JRHtmlExporter export = (JRHtmlExporter) request.getAttribute("exportIndentObject"); session.setAttribute("exportIndentObject", export); JRHtmlExporter export1 = (JRHtmlExporter) session.getAttribute("exportIndentObject"); export.exportReport(); %>