Sanka's Knowledge Repository

Future of Flex

2011-11-26T10:13:00.000-08:00

This are the hottest articles I found about Flex new status.
http://goo.gl/1GAhe
http://goo.gl/g4p2W
http://goo.gl/qSk25
http://goo.gl/h5L6w
http://goo.gl/B86du

As a Flex developer I also scared future flex.Because future of flex will effect in to my pocket/salary/demand/career/what ever/etc...

If you have any idea please post it as a comment.

Understanding EJB components

2011-11-10T05:52:00.000-08:00

Understanding EJB
Hi,everybody today I am writing about EJB.Understanding each bean in very important.

Session bean
Session bean is about client-server interactive session.As we know EJB deployed on J2EE application server,
in here client may be a servlet or what ever.
For example suppose google.com is a servlet when we type on search box and hit search button,then
it invoke EJB session beans methods.That session bean is for client(servlet).
it is not shaired.Others can't view your search results.

Now you can understand what session bean do.It do your business tasks inside the server but as a separete unit of force.Servlet don't need to perform database related task or business logic.Servlet get data from front end and pass to EJB and backword.Actually it reduce complexity.

There are two types of session beans: stateful and stateless.

Stateful Session Beans
Servelt can talk with EJB.That is call conversation. Stateful session bean is keeping the state(values of variables) in the conversational session.It retained until client-bean session.

Stateless Session Beans
Stateless sesion bean keep state only on inside the method call. As we talk earlier getName() and getEmail() both method calls are not in same session in stateless bean.

Message Driven Beans
Message Driven beans are asynchronous.All other beans are synchronous. In above example we invoke
bean.getName();
bean.getEmail();

In synchronous once name is return then bean will return email.In session bean there is a queue or sequence.
But in asynchronous no wating,no queue,email can be recieved first or name can be received first there is no queue or sequence.

session in flex

2011-05-17T10:27:00.000-07:00

As you know there is not variables like session in flex.But i have created a class call session that can perform the task of session in our day to day programming life.Class have two basic methods setAttribute and getAttribute.we can keep any type value as key and value.
What is inside happening? I used singleton design pattern,generic and dictionary for the work.
You can Use the following class as a session in flex.


[Bindable]
private var session:Session = Session.getInstance();

//How to insert data to session
session.setAttribute('username','sanka')

//How to retrive data from session
var userName:String=session.getAttribute('username');

download the class from here.
http://dl.dropbox.com/u/7375335/Session.as

I have create a link in forum for questions
http://forums.adobe.com/thread/799057?tstart=0

spring flex sample application

2011-04-15T03:22:00.000-07:00

This sample application was develop by me for ceylon electricity board(CEB).application alow user to

· Insert/enter data

· Retrive/view data

· Edit/upate data and

· upload bulk data such as excel sheet

· Reporting & graphs

· Loging system(spring security)

Sample Application URL
http://dl.dropbox.com/u/7375335/sample%20ceb/TestApplication.swf

Screens


Transaction Screen

SQL Injection Attacks and Defense In Java System

2010-10-31T08:14:00.000-07:00

Sometimes you may have following questions
Question:How to hacking? How to hacking in JPA? How to hacking in native query?How to hack Database in java?How to hack system? How to hack system using SQL injection?How to defense from sql injection?how attach using sql injection?what about SQL Injection Attacks and Defense?
Answer:following is the way of hacking the system.

suppose system has the following kind of java method.JPA Spring integrated one.

@Transactional
@Override
public List listByNativeSQL(String id) {
return em.createNativeQuery("SELECT * FROM AREA WHERE id='"+id+"'",Area.class).getResultList();//sql injection query
}

If user enter the following as the input for the function
user input =anything' OR 'x'='x
value of id==anything' OR 'x'='x

Following is the out put SQL that run in database server

SELECT * FROM AREA WHERE id=anything OR x=x

Note : SQL query need to be true in where condition and it is always true

Hack using query string

http://localhost:8400/server-repo/reports/Area.jsp?id=anything' OR 'x'='x

Question : How to prevent sql injection?How to avoid sql injection?How to avoid hacking database?
Answer :this is the secure way to avoid sql injection.use paramters to query

@Transactional
@Override
public List listByNativeSQL(String id) {
return em.createNativeQuery("SELECT * FROM AREA WHERE id=?1",Area.class).setParameter(1, id).getResultList();
}

Those who interest in hacking,this are the books for Hacking

How to create flex component and best practices

2010-10-30T18:44:00.003-07:00

Intercommunication with flex components

Application Flow

App.mxml à Component .mxml

Data passing

Component àCustomEvent Object à Application

Why we say loosly couple?

Component properties aren’t accessed directly by Application.Otherwose when component change some id property or something, we have to update all the refered applications.

app.mxml is the main application.GetKey.mxml is the component and GetKeyEvent.as is the custom event class that transfer the data.

There is a variable in GetKeyEvent.as and that is public as you can see.This is the one that access both GetKey.mxml component and app.mxml application.

[Bindable]

public var key:String=null;

GetKey.mxml push the data to key and app.mxml read the data from key in GetKeyEvent.as.

GetKey.mxml push the data to key

var getKeyEvent:GetKeyEvent= new GetKeyEvent("getKey",txtKey.text);

getKeyEvent.key=txtKey.text;

dispatchEvent(getKeyEvent);

app.mxml read the data from key in GetKeyEvent.as

var getKey:GetKey =new GetKey();

getKey.addEventListener("getKey",getkey1_getKeyHandler);

How to registering an event

As following we have to register an event in our component.getKey is the name of event that visible to main app.

[Event(name="getKey",type="events.GetKeyEvent")]

How to Access the component and it’s events from main app

You can download the sample project from here

http://dl.dropbox.com/u/7375335/components.fxp

NamedNativeQuery For Retriving Full Entity

2010-10-29T10:20:00.000-07:00

If you don't have big idea about SqlResultSetMapping,Before you read this Please read my Previous Article.Click Here
Second Article
Third Article

I have heard more and more complaints regarding issues of how to use NativeQuery or NamedNativeQuery in JPA.Most of blient users are complaint that native query can’t return entity,it is returning index based Object class object only.
In @NamedNativeQuery normally most people don’t use the property resultClass.But that is the problem also.SQL query can’t find the mapping entity class.You have to specify it on your native query.If you specified resultClass property,then query will return the result you expect.

@NamedNativeQuery(name="NativeSQL", query="SELECT * FROM Finvdet",resultClass=Finvdet.class)

Problem :How to get results as entity from native SQL?
Solution:specify the resultClass property value

DAO Code

List list=new ArrayList();
list=em.createNamedQuery("NativeSQL").getResultList();

in above code there will be an issue. You cant retrive result as you wish because of the bug of eclipseLink.

Column Uppercase Issue Solution
Add the following code to persistance.xml

@NamedNativeQuery(name="NativeSQL", query="SELECT * FROM Finvdet",resultClass=Finvdet.class)

DAO Code

list=em.createNamedQuery("NativeSQL").getResultList();

Java SMS Send & Read With smslib

2010-10-25T08:32:00.000-07:00

In this post I will expose how I send/received or read SMS in my final year mobile classified project.

Problem:

What is the programming language?What is the API?

Answer:

Java,library I used smslib, please visit www.smslib.org web site for more details about lib.

Problem:

What are the devices you have used?

Answer:

3G USB dongle

Question :

What are the other configuration?

Answer :

Good question.When we are working with hardwares we have to configure them.

Follow this instructions.

To Check COM port Go in following path in Windows7.
Control Panel\Hardware and Sound\Bluetooth and Local COM.
Watch your appropriate configurations and setup the following code in SendMessage Class.

new CService("COM4",9600,"huawei","E220")

For more visit http://smslib.org/doc/smslib/quickstart/>

Send Message/SMS Code

package SMSEngine;
import org.smslib.*;
class SendMessage
{
public static void sendMessage(String number, String message)
{ 
CService srv = new CService("COM4",9600,"huawei","E220");
try
{
srv.setSimPin("0000");
srv.setSimPin2("0000");
srv.setSmscNumber("");
srv.connect();
COutgoingMessage msg = new COutgoingMessage(number, message); 
msg.setMessageEncoding(CMessage.MessageEncoding.Enc7Bit);
msg.setStatusReport(true);
msg.setValidityPeriod(8);
srv.sendMessage(msg);
srv.disconnect();
}
catch (Exception e)
{
e.printStackTrace();
}
System.exit(0);
}
}

Read Message/SMS Codes

package SMSEngine;
import org.smslib.*;
import java.util.*;
class ReadMessages
{
static CService srv;
public static LinkedList receiveMessage()
{
LinkedList msgList = new LinkedList();
/*
To Check COM port Go in following path in Windows7
Control Panel\Hardware and Sound\Bluetooth and Local COM

*/
srv = new CService("COM4",9600,"huawei","E220");//"COM1", 57600, "Nokia", ""
try
{
srv.setSimPin("0000");
srv.setSimPin2("0000");
srv.connect();
srv.readMessages(msgList, CIncomingMessage.MessageClass.Unread);
srv.disconnect();
return msgList;
}
catch (Exception e)
{
e.printStackTrace();
}
System.exit(0);
return msgList;
}
}

Client Codes

//read the messages
LinkedList msgList =  ReadMessages.receiveMessage();
//send the sms
SendMessage.sendMessage("+94772945997","msg");

NamedNativeQuery Code Example For Retriving Columns Or Part of Entity Using Entity

2010-10-24T10:10:00.000-07:00

If you don't have big idea about SqlResultSetMapping,Before you read this Please read my Previous Article.Click Here

@SqlResultSetMapping(name="finvdetResult2", entities={@EntityResult(entityClass=Finvdet.class,
  fields={
 @FieldResult(name="id.itemcode",column="itemcode"),
 @FieldResult(name="id.refno",column="refno"),
 @FieldResult(name="amt",column="amt"),
 @FieldResult(name="qty",column="qty")})
})
@NamedNativeQuery(name="NativeFinvdetListAll2", query="SELECT * FROM Finvdet",resultSetMapping="finvdetResult2")

DAO Code

List list=new ArrayList();
list=em.createNamedQuery("NativeFinvdetListAll2").getResultList();//succcess

JPQL Union using SqlResultSetMapping

2010-10-24T09:58:00.000-07:00

If you dont have big idea about SqlResultSetMapping,Before you read this Please read my Previous Article.Click Here

Sometimes you may don’t know in JPQL there are no subtitue for query SQL Union.SqlResultSetMapping Can be used as SQL Union as Following demo.

Problem :
I need to list & query 7 fields from defferent 4 tables.Like SQL union. I need to do union in JPA. How can I achieve it?

Solution:
Use SqlResultSetMapping.Frist of all you have to create Templete Class that have 7 fields(getters/setters) that you need.Then write your Native SQL Union Query with specifing SqlResultSetMapping.Write SqlResultSetMapping for mapping data to your Templete Class.

See the code example.

Result class: StockDetail
Query class:Finvdet, Fgrndet, Fgrnrdet

LHS(name): result class fields
RHS(column):sql query column names

@SqlResultSetMapping(name="ListAllTransaction", entities={
@EntityResult(
entityClass=StockDetail.class,
fields={
@FieldResult(name="refno",column="refno"),
@FieldResult(name="itemcode",column="itemcode"),
@FieldResult(name="costprice",column="costprice"),
@FieldResult(name="sellprice",column="sellprice"),
@FieldResult(name="txndate",column="txndate"),
@FieldResult(name="txntype",column="txntype"),
@FieldResult(name="qty",column="qty")
})
})

@NamedNativeQuery(
name="ListAllFinvdet",
query="SELECT refno,itemcode,txndate,txntype,qty,sellprice as costprice FROM Finvdet WHERE txndate BETWEEN :fromDate AND :toDate AND itemcode IN :items"
+" UNION "
+"SELECT refno,itemcode,txndate,txntype,qty,costprice FROM Fgrndet WHERE txndate BETWEEN :fromDate AND :toDate AND itemcode IN :items"
+" UNION "
+"SELECT refno,itemcode,txndate,txntype,qty,costprice FROM Fgrnrdet WHERE txndate BETWEEN :fromDate AND :toDate AND itemcode IN :items"
,
resultSetMapping="ListAllTransaction")

DAO Code

Query query =em.createNamedQuery("ListAllFinvdet").setParameter("fromDate", fromDate).setParameter("toDate", toDate).setParameter("items", lstFitems);

SqlResultSetMapping Simple Code Examples

2010-10-24T09:44:00.000-07:00

In OOP languages Object Oriented concept there are no part of entity or field or property concept.That mean find operation/getResultList/getSingleResult or what ever operation design for return full entity,we can’t simply retrive part of entity in ORM Frameworks like JPA.
Suppose there is a class called Finvdet that contain 100 fields(refno,itemcode,costprice,sellprice,txn..etc).
If I query

Query 1: SELECT f FROM Finvdet f

That will return 100 fields contain Finvdet class object list.If I query as follows that will return 2 fields contain Object class object list. If we need to propergate through the object we have to use

object[“1”]

like notation

Query 2: SELECT f.refno,f.itemcode FROM Finvdet f

Problem: In above sample,If I need only 2 fields how can I optimized memory usage and query?
Solution :use SqlResultSetMapping for that.

Problem:What is SqlResultSetMapping? What it do for me?
Solution : SqlResultSetMapping convert your native sql query result in to entity and pick the values in to domain. As it named it do mapping.

Question: what is the query language?
Answer: native sql

Problem:what are the properties entityClass ,name and column in SqlResultSetMapping?
Solution : entityClass mean mapped class,name mean fileds in your mapped entity,column mean the name of column in your sql query.

Example: SqlResultSetMapping is use@FieldResult(name="classField1",column="sqlCol1").

Java + Crystal Report + Eclipse

2010-10-05T09:31:00.000-07:00

In here I have written about crystal report +java +eclipse integration.And I am doing pojo data binding,Dynamic image viewing features in Crystal report plugin for eclipse.
Original article has been moved. click here to read

My Favorite Ares

2010-07-13T02:48:00.001-07:00

Favorite Technologies

Spring BlazeDS Integration

BlazeDS is a solution for Java Flex remoting complexity.My favorite research area.Spring BlazeDS Integration project is written Spring Source.But not supporting for Lazy loading.That mean fetch entire object graph at once and it reduce performance tharerly.

EJB 2 & 3

EJB earlier versions talk about remote/local & home interface.But new version talk about Local and Remote interface with annotation and about dependency injection.For example @EJB annotation.This use core of java RMI concept.To run EJB you need EJB container that mean your server should be application server.You can't run EJB in tomcat.Thats why we said it's too heavy.Because tomcat is very lightweight server.Use Service Locater design pattern for calling to EJB from controller.Act as a model in MVC that hold business logic of application.

Struts

Basically struts 1 have struts-config.xml file but in struts 2.0 it renamed as struts.xml.Action class act as controller and there is a new word in struts 2.0 that called action support class.

Spring

He is the hero of MVC.You can found he on java or .Net.Concept by rod Johnson who is an article.Spring doing Inversion of controller.Or in other word Dependency Injection.In simply framework inject instances,no need to create objects using new keyword.Use annotations for this process.

Flex

One of the hero of Rich Client Internet Application.Platform is flash player.Flex compiler convert mxml into swf and thats it.

Hibernate

Old hero of ORM technology.But after arrival of JPA(java Persistence API) it be not peak as it was.

About Author

My School : primary-Punewa Maha Vidyalaya,Secondary-Central College Anuradhapura

My University:University of Moratuwa,Sri Lanka

Internship :IT Department Of Sampath Bank Head Office for 6 Month Period & RDB Bank 6 month After A/L

Specialized Technologies:Spring,Hibernate,Struts and EJB like java frameworks

Other Interest Technologies:.Net and Parsly like flex frameworks

About Current Working Station: @ www.datamation.lk Technologies :Java,Flex Web based ERP System

Projects

Project Name	Technologies
GreenPlease(Microsoft Imagine Cup)	ASP.NET,C#,AJAX, SQL Server
Automated Rent Management System	ASP.NET, C#, AJAX, Oracle
Libsys Library System	Java, JSP, Struts, EJB, AJAX, MySql
Automated Pharmacist System	Java, MySql
National Cancer Control Program (NCCP)	C#.NET, MS SQL Server
Mobile Classified	Java, MySql

HIbernate - JSP/Servlet Simple Example

2010-06-15T19:59:00.000-07:00

HIbernate - JSP/Servlet Simple Example

You can download full code example from here.

This example use Hibernate 3.5 and JPA 2.0 Annotatyion base classes.

You can see how to use JPA entities as HIbernate entities.

This example use Derby database.

hibernate-configuration file is as Following

This example is using annotated entity classes that genarated from eclipse.So no need to write xml mapping files for each entity.









 
 jdbc:derby://localhost:1527/catalogueDB;create=true
 org.apache.derby.jdbc.ClientDriver
 app
 app
 

   
 
 
 
 thread

 
 org.hibernate.dialect.DerbyDialect
 
 create
 org.hibernate.cache.NoCacheProvider
 true
 org.hibernate.transaction.JDBCTransactionFactory


package com.snk.model;


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

// Generated May 30, 2009 6:49:31 AM by Hibernate Tools 3.2.4.GA

/**
*  This class contains the course details.
* 
*/
@Entity
public class Course implements java.io.Serializable {

@Id
@GeneratedValue
private long courseId;
@Column
private String courseName;

public Course() {
}

public Course(String courseName) {
 this.courseName = courseName;
}

public long getCourseId() {
 return this.courseId;
}

public void setCourseId(long courseId) {
 this.courseId = courseId;
}

public String getCourseName() {
 return this.courseName;
}

public void setCourseName(String courseName) {
 this.courseName = courseName;
}

}


package com.snk.frontend;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.Iterator;
import java.util.List;

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

import com.snk.controler.ServiceLocator;
import com.snk.model.Course;


/**
* Servlet implementation class View
*/
/**
* @author Administrator
*
*/
public class View extends HttpServlet {
private static final long serialVersionUID = 1L;
     
   /**
    * @see HttpServlet#HttpServlet()
    */
   public View() {
       super();
       // TODO Auto-generated constructor stub
   }

/**
 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
 */
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 PrintWriter out=response.getWriter();
 out.println("sanka do get");
 doPorocess(request, response);
}

/**
 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
 */
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 PrintWriter out=response.getWriter();
 out.println("sanka do post");
 doPorocess(request, response);
}


protected void doPorocess(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 PrintWriter out=response.getWriter();
 ServiceLocator obj = new ServiceLocator();
 out.println("Before Insert three records\n");
 Long courseId1 = obj.saveCourse("Physics");
 Long courseId2 = obj.saveCourse("Chemistry");
 Long courseId3 = obj.saveCourse("Maths");

 showCourse(obj.listCourse(),out);
 out.println("End of Insert three records\n\n\n\n");
 obj.updateCourse(courseId3, "Mathematics");
 showCourse(obj.listCourse(),out);
 out.println("End of update three records\n\n\n\n");
 obj.deleteCourse(courseId2);
 out.println("End of delete chemistry records\n\n\n\n");
 showCourse(obj.listCourse(),out);

}

private void showCourse(List courses,PrintWriter out)
{
 for (Iterator iterator = courses.iterator(); iterator.hasNext();)
 {
  Course course = (Course) iterator.next();
  out.println("Cource name : "+course.getCourseName());
 }
}

}




package com.snk.controler;
import java.util.List;
import java.util.Iterator;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.snk.model.Course;
import com.snk.util.HibernateUtil;

public class ServiceLocator {


public Long saveCourse(String courseName)
{
 Session session = HibernateUtil.getSessionFactory().openSession();
 Transaction transaction = null;
 Long courseId = null;
 try {
  transaction = session.beginTransaction();
  Course course = new Course();
  course.setCourseName(courseName);
  courseId = (Long) session.save(course);
  transaction.commit();
 } catch (HibernateException e) {
  transaction.rollback();
  e.printStackTrace();
 } finally {
  session.close();
 }
 return courseId;

/* //Following Are the code in JPA for insert query
    EntityManagerFactory emf=Persistence.createEntityManagerFactory("hibernate-servlet");
    EntityManager em=emf.createEntityManager();
 Course course = new Course();
 course.setCourseName(courseName);
 course.setCourseId(200);
 Long courseId = 200L;
 em.persist(course);
 System.out.println("Afetr Save");*/


}

public List listCourse()
{
 Session session = HibernateUtil.getSessionFactory().openSession();
 Transaction transaction = null;
 try {
  transaction = session.beginTransaction();
  List courses = session.createQuery("from Course").list();
  for (Iterator iterator = courses.iterator(); iterator.hasNext();)
  {
   Course course = (Course) iterator.next();
   System.out.println(course.getCourseName());
  }
  transaction.commit();
  return courses;
 } catch (HibernateException e) {
  transaction.rollback();
  e.printStackTrace();
  return null;
 } finally {
  session.close();
 }
}

public void updateCourse(Long courseId, String courseName)
{
 Session session = HibernateUtil.getSessionFactory().openSession();
 Transaction transaction = null;
 try {
  transaction = session.beginTransaction();
  Course course = (Course) session.get(Course.class, courseId);
  course.setCourseName(courseName);
  transaction.commit();
 } catch (HibernateException e) {
  transaction.rollback();
  e.printStackTrace();
 } finally {
  session.close();
 }
}

public void deleteCourse(Long courseId)
{
 Session session = HibernateUtil.getSessionFactory().openSession();
 Transaction transaction = null;
 try {
  transaction = session.beginTransaction();
  Course course = (Course) session.get(Course.class, courseId);
  session.delete(course);
  transaction.commit();
 } catch (HibernateException e) {
  transaction.rollback();
  e.printStackTrace();
 } finally {
  session.close();
 }
}

}


package com.snk.util;

import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;

public class HibernateUtil {
private static final SessionFactory sessionFactory;
static {
 try {
//   sessionFactory = new Configuration().configure().buildSessionFactory();//Default configuration
  sessionFactory =  new AnnotationConfiguration().configure().buildSessionFactory();//Annotation Configuration
 
 } catch (Throwable ex) {
  System.err.println("Initial SessionFactory creation failed." + ex);
  throw new ExceptionInInitializerError(ex);
 }
}

public static SessionFactory getSessionFactory() {
 return sessionFactory;
}
}




 hibernate-servlet
 
   index.jsp
 

 
   
   View
   View
   com.snk.frontend.View
 
 
   View
   /View

Spring BlazeDS Integration

2010-06-01T20:17:00.000-07:00

Spring BlazeDS Integration

1. Configuring and Using the BlazeDS

MessageBroker with Spring

MessageBroker is the heart of the Spring BlazeDS Integration.
When HTTP messages come from Flex client will be routed through the
Spring DispatcherServlet to the Spring-managed MessageBroker.

There is no need to configure the BlazeDS MessageBrokerServlet when using the
Spring-managed MessageBroker.

2. Configuring the Spring DispatcherServlet

web.xml is the heart of the j2ee web project.So we have to configure it because
each an every request is map to web.xml.

The DispatcherServlet must be configured in web.xml to bootstrap a Spring
WebApplicationContext. For example:



Spring MVC Dispatcher Servlet
org.springframework.web.servlet.DispatcherServlet

contextConfigLocation
/WEB-INF/config/web-application-config.xml

1

3. Configuring the MessageBroker in Spring

A simplified Spring XML config namespace is provided for configuring the MessageBroker in
your WebApplicationContext. To use the namespace support you must add the schema location
in your Spring XML config files. A typical config will look something like the following:

...

Following XML config namespace tags makes the Spring BlazeDS Integration configuration tags available under the flex
namespace in your configuration files. The above setup will be assumed for the rest of the
configuration examples to follow. For the full detail of every attribute and tag available in the

config namespace, be sure to refer to the spring-flex-1.0.xsd as every element and attribute is
fully documented there. Using an XSD-aware XML editor such as the one in Eclipse should
bring up the documentation automatically as you type.

At a minimum, the MessageBrokerFactoryBean must be configured as a bean in your
Spring WebApplicationContext in order to bootstrap the MessageBroker, along with a
MessageBrokerHandlerAdapter and an appropriate HandlerMapping (usually a
SimpleUrlHandlerMapping) to route incoming requests to the Spring-managed
MessageBroker.

These beans will be registered automatically by using the provided message-broker tag in
your bean definition file. For example, in its simplest form:

This will set up the MessageBroker and necessary supporting infrastructure using sensible
defaults. The defaults can be overriden using the provided attributes of the message-broker
tag and its associated child elements. For example, the default location of the BlazeDS XML
configuration file (/WEB-INF/flex/services-config.xml) can be overridden using the
services-config-path attribute. The MessageBrokerFactoryBean uses Spring's
ResourceLoader abstraction, so that typical Spring resource paths may be used. For
example, to load the configuration from the application's classpath:

The equivalent MessageBrokerFactoryBean definition using vanilla Spring configuration
would be:

Note especially that with the message-broker tag, it is not necessary to assign a custom id to
the MessageBroker, and it is in fact discouraged so that you won't have to continually reference
it later. The only reason you would ever need to provide a custom id is if you were bootstrapping
more than one MessageBroker in the same WebApplicationContext.

How to navigating through the Data using Flex form

2010-05-30T22:39:00.002-07:00

How to navigating through the Data or ArrayCollection using Flex form

I know you guys have a problem of having navigating through tha data of ArrayCollection by using the Flex Form
Here is the solution for viewing data, or navigating data of Flec ArrayColletion that contain bean objects....












  selectedMember)
   {
    selectedMember = selectedMember + 1;
    tiDebAddress1.text=lststatus.getItemAt(selectedMember).status;
    cmdPrevious.enabled=true;
    if(lststatus.length-1 == selectedMember)
    {
    cmdNext.enabled=false;
    cmdPrevious.enabled=true;
    }
    else
    cmdNext.enabled=true;
   }
  }
 
  private function prevousItem():void
  {
   if(lststatus.length > 0 && selectedMember > 0)
   {
    selectedMember = selectedMember - 1;
    tiDebAddress1.text=lststatus.getItemAt(selectedMember).status;
    if(selectedMember==0)
    {
    cmdPrevious.enabled=false;
    cmdNext.enabled=true;
    }
    else
    cmdPrevious.enabled=true;
   }
  }
 
 ]]>

Send Email in Java

2010-05-13T03:22:00.000-07:00

Send Email in Java

Here is the code for send email in java
Note:you have to have gmail account and password

/*Author-sanka dilmadu senvirathna*/

import java.security.Security;
import java.util.Properties;
import javax.mail.Message;
import javax.mail.PasswordAuthentication;
import javax.mail.Session;
import javax.mail.Transport;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeMessage;
import com.sun.net.ssl.internal.ssl.Provider;

public class MailtoVender
{
private String mailhost = "smtp.gmail.com";
public synchronized void sendMail(String subject, String body, String sender, String recipients)throws Exception
{

Security.addProvider(new com.sun.net.ssl.internal.ssl.Provider());
Properties props = new Properties();
props.setProperty("mail.transport.protocol", "smtp");
props.setProperty("mail.host", mailhost);
props.put("mail.smtp.auth", "true");
props.put("mail.smtp.port", "465");
props.put("mail.smtp.socketFactory.port", "465");
props.put("mail.smtp.socketFactory.class","javax.net.ssl.SSLSocketFactory");
props.put("mail.smtp.socketFactory.fallback", "false");
props.setProperty("mail.smtp.quitwait", "false");

Session session = Session.getDefaultInstance(props,
new javax.mail.Authenticator()
{
protected PasswordAuthentication getPasswordAuthentication()
{ return new PasswordAuthentication("username","password"); }//username,password
});

MimeMessage message = new MimeMessage(session);
message.setSender(new InternetAddress(sender));
message.setSubject(subject);
message.setContent(body, "text/plain");
if (recipients.indexOf(',') > 0)
message.setRecipients(Message.RecipientType.TO, InternetAddress.parse(recipients));
else
message.setRecipient(Message.RecipientType.TO, new InternetAddress(recipients));


Transport.send(message);

}


public static void main(String args[]) throws Exception
{
String message="reply me when you receive message";
MailtoVender mailutils = new MailtoVender();
mailutils.sendMail("subject", message, "idbkatubadda@gmail.com", "sankadil@gmail.com");

}

}

Free E-Books

How to Access Spring Service From JSP/Servlet

2010-05-13T02:59:00.000-07:00

Spring Service Call JSP/Servlet

Question : How to access/call Spring service from JSP or servlet?
Question : How to get a Instance Spring service to JSP or servlet?
Question : How to call Spring service from JSP or servlet?

Answer:

import the following classes to JSP/servlet page

org.springframework.web.context.WebApplicationContext
org.springframework.web.context.support.WebApplicationContextUtils

WebApplicationContext wac = WebApplicationContextUtils.getRequiredWebApplicationContext(this.getServletContext());
MySpringService srvObject = (MySpringService) wac.getBean("mySpringService");//mySpringService mean bean id of MySpringService in spring configuration xml file
List lst= srvObject.listAll();

Note : mySpringService mean bean id of MySpringService in spring configuration xml file

Flex : How to calculate Datagrid column total

2010-05-12T20:12:00.000-07:00

How to calculate Datagrid column total
Manipulating flex datagrid colomns

Select a colomn name from comboBox and hit the button and enjoy...

Happy coding.....

you can download the code from here

Flex Dynamically popup searchable Datagrid

2010-05-11T21:22:00.001-07:00

Flex Dynamically popup searchable Data-grid For Demo purpose I have create non DB version as following.Full code example is following... Check it and get idea...No need to describe this.

mainApp.mxml

PopUpGrid.as

package com.dspl.component
{
import com.iwobanas.controls.MDataGrid;
import com.iwobanas.controls.dataGridClasses.MDataGridColumn;
import com.iwobanas.controls.dataGridClasses.filterEditors.SliderFilterEditor;
import com.iwobanas.controls.dataGridClasses.filterEditors.WildcardFilterEditor;
import com.iwobanas.core.ISearchable;
import flash.events.Event;
import flash.events.MouseEvent;
import mx.collections.ArrayCollection;
import mx.containers.HBox;
import mx.containers.TitleWindow;
import mx.controls.Alert;
import mx.controls.Button;
import mx.controls.Label;
import mx.controls.TextInput;
import mx.core.Application;
import mx.core.ClassFactory;
import mx.events.DataGridEvent;
import mx.events.DragEvent;
import mx.events.FlexEvent;
import mx.managers.DragManager;
import mx.managers.PopUpManager;

public class PopUpGrid
{

 var mygrid:MDataGrid;
 var tt:TitleWindow;
 var txt:TextInput;
 var columnName:String;
 var txtSearch:TextInput;

 [Bindable]
 public var target:ISearchable;

 public function PopUpGrid(listCollectionFCurrencies:ArrayCollection,txt:TextInput,app:Application,columnName:String,columnsNameList:Array,columnsFilterList:Array)
 {
  this.txt=txt;
  this.columnName=columnName;
  tt=new TitleWindow()
  mygrid =new MDataGrid();
  mygrid.dataProvider=listCollectionFCurrencies;
  mygrid.columns =getDataGridColumns(columnsNameList,columnsFilterList);

  mygrid.editable=true;
  mygrid.dragEnabled=true;
  mygrid.width=500;

/*    //Following code is the call to component
  var mySearch:SearchBox=new SearchBox();
  mySearch.target=mygrid;
  tt.addChild(mySearch); */

//Following code segment is for SearchBox facility
   var hBoxSearch:HBox=new HBox();
   target=mygrid;
   var lblSearch:Label=new Label();
   lblSearch.text="Search:"
   txtSearch=new TextInput();
   txtSearch.addEventListener(Event.CHANGE,function() {target.find(txtSearch.text);});
   //txtSearch.addEventListener(Event.CHANGE,function() {mouseOverListener('Print This');});
   txtSearch.setStyle('backgroundColor','{!target.searchString || target.found ? 0xffffff:0xff0000}');
   txtSearch.addEventListener(FlexEvent.ENTER,function() {target.findNext();});
   txtSearch.toolTip="Live search";

   var previousButton:Button=new Button();
   previousButton.enabled='{target.searchString != null}';
   previousButton.label="<"     previousButton.toolTip="Previous"     previousButton.addEventListener(MouseEvent.CLICK,function() {target.findPrevious();});      var nextButton:Button=new Button();     nextButton.enabled='{target.searchString != null}';     nextButton.label=">"
   nextButton.toolTip="Next"
   nextButton.addEventListener(MouseEvent.CLICK,function() {target.findNext();});

   hBoxSearch.addChild(lblSearch);
   hBoxSearch.addChild(txtSearch);
   hBoxSearch.addChild(previousButton);
   hBoxSearch.addChild(nextButton);
   tt.addChild(hBoxSearch);

//Above code segment is for SearchBox facility

   tt.addChild(mygrid);
  PopUpManager.addPopUp(tt, app, false);
  PopUpManager.centerPopUp(tt);//this is only set location :center
  mygrid.addEventListener(DataGridEvent.ITEM_EDIT_BEGINNING,clickRow);
  this.txt.addEventListener(DragEvent.DRAG_ENTER,fndragEnterHandler);//grag and drop facility
  this.txt.addEventListener(DragEvent.DRAG_OVER,fndragOverHandler);//grag and drop facility
  this.txt.addEventListener(DragEvent.DRAG_DROP,fndragDropHandler);//grag and drop facility

 }

           private function getDataGridColumns(columnsNameList:Array,columnsFilterList:Array):Array {
            var dataGridColumnList:Array =new Array();

            for (var i:String in columnsNameList)
   {

    //Type of Filters : MultipleChoiceFilterEditor,SliderFilterEditor,WildcardFilterEditor,NumberRangeFilter,DateRangeFilter(new one)
       var dgc:MDataGridColumn = new MDataGridColumn(columnsNameList[i]);
       if("String"==columnsFilterList[i]){dgc.filterEditor=new ClassFactory(WildcardFilterEditor);}
       else if("Integer"==columnsFilterList[i]){dgc.filterEditor=new ClassFactory(SliderFilterEditor); }
      // else if("Date"==columnsFilterList[i]){dgc.filterEditor=new ClassFactory(DateRangeFilterEditor); }
       dataGridColumnList.push(dgc);
   }
   return dataGridColumnList;
           }

  private function clickRow(event:DataGridEvent):void
  {
  try{
   //this.txt.text=mygrid.selectedItem.curCode;//event.rowIndex.toString();
   this.txt.text=mygrid.selectedItem[columnName];//event.rowIndex.toString();
   PopUpManager.removePopUp(tt);
   }
  catch (e:Error) {
     Alert.show( e.message);
   }
  }

  private function fndragEnterHandler(event:DragEvent):void
           {
            if (event.dragSource.hasFormat("items"))
            DragManager.acceptDragDrop(TextInput(event.currentTarget));
           }

           private function fndragOverHandler(event:DragEvent):void
           {
            if (event.dragSource.hasFormat("items"))
            DragManager.showFeedback(DragManager.COPY);
           }

           private function fndragDropHandler(event:DragEvent):void
           {
           event.preventDefault();
           var itemsArray:Array = event.dragSource.dataForFormat("items") as Array;
               TextInput(event.currentTarget).text=itemsArray[0].(this.columnName);
           }


}
}

This is non Database program MXML file

This is non Database program .as file

package com.dspl.component
{
import com.iwobanas.controls.MDataGrid;
import com.iwobanas.controls.dataGridClasses.MDataGridColumn;
import com.iwobanas.controls.dataGridClasses.filterEditors.SliderFilterEditor;
import com.iwobanas.controls.dataGridClasses.filterEditors.WildcardFilterEditor;
import com.iwobanas.core.ISearchable;
import flash.events.Event;
import flash.events.MouseEvent;
import mx.collections.ArrayCollection;
import mx.containers.HBox;
import mx.containers.TitleWindow;
import mx.controls.Alert;
import mx.controls.Button;
import mx.controls.Label;
import mx.controls.TextInput;
import mx.core.Application;
import mx.core.ClassFactory;
import mx.events.DataGridEvent;
import mx.events.DragEvent;
import mx.events.FlexEvent;
import mx.managers.DragManager;
import mx.managers.PopUpManager;

public class PopUpGrid
{

 var mygrid:MDataGrid;
 var tt:TitleWindow;
 var txt:TextInput;
 var columnName:String;
 var txtSearch:TextInput;

 [Bindable]
 public var target:ISearchable;

 public function PopUpGrid(listCollectionFCurrencies:ArrayCollection,txt:TextInput,app:Application,columnName:String,columnsNameList:Array,columnsFilterList:Array)
 {
  this.txt=txt;
  this.columnName=columnName;
  tt=new TitleWindow()
  mygrid =new MDataGrid();
  mygrid.dataProvider=listCollectionFCurrencies;
  mygrid.columns =getDataGridColumns(columnsNameList,columnsFilterList);

  mygrid.editable=true;
  mygrid.dragEnabled=true;
  mygrid.width=400;

/*    //Following code is the call to component
  var mySearch:SearchBox=new SearchBox();
  mySearch.target=mygrid;
  tt.addChild(mySearch); */

//Following code segment is for SearchBox facility
   var hBoxSearch:HBox=new HBox();
   target=mygrid;
   var lblSearch:Label=new Label();
   lblSearch.text="Search:"
   txtSearch=new TextInput();
   txtSearch.addEventListener(Event.CHANGE,function() {target.find(txtSearch.text);});
   //txtSearch.addEventListener(Event.CHANGE,function() {mouseOverListener('Print This');});
   txtSearch.setStyle('backgroundColor','{!target.searchString || target.found ? 0xffffff:0xff0000}');
   txtSearch.setStyle('border-color','{#EDF5FE}');
   txtSearch.addEventListener(FlexEvent.ENTER,function() {target.findNext();});
   txtSearch.toolTip="Live search";

   var previousButton:Button=new Button();
   previousButton.enabled='{target.searchString != null}';
   previousButton.label="<"     previousButton.toolTip="Previous"     previousButton.addEventListener(MouseEvent.CLICK,function() {target.findPrevious();});      var nextButton:Button=new Button();     nextButton.enabled='{target.searchString != null}';     nextButton.label=">"
   nextButton.toolTip="Next"
   nextButton.addEventListener(MouseEvent.CLICK,function() {target.findNext();});

   hBoxSearch.addChild(lblSearch);
   hBoxSearch.addChild(txtSearch);
   hBoxSearch.addChild(previousButton);
   hBoxSearch.addChild(nextButton);
   tt.addChild(hBoxSearch);

//Above code segment is for SearchBox facility

   tt.addChild(mygrid);
  PopUpManager.addPopUp(tt, app, false);
  PopUpManager.centerPopUp(tt);//this is only set location :center
  mygrid.addEventListener(DataGridEvent.ITEM_EDIT_BEGINNING,clickRow);
  this.txt.addEventListener(DragEvent.DRAG_ENTER,fndragEnterHandler);//grag and drop facility
  this.txt.addEventListener(DragEvent.DRAG_OVER,fndragOverHandler);//grag and drop facility
  this.txt.addEventListener(DragEvent.DRAG_DROP,fndragDropHandler);//grag and drop facility

 }

           private function getDataGridColumns(columnsNameList:Array,columnsFilterList:Array):Array {
            var dataGridColumnList:Array =new Array();

            for (var i:String in columnsNameList)
   {

    //Type of Filters : MultipleChoiceFilterEditor,SliderFilterEditor,WildcardFilterEditor,NumberRangeFilter,DateRangeFilter(new one)
       var dgc:MDataGridColumn = new MDataGridColumn(columnsNameList[i]);
       if("String"==columnsFilterList[i]){dgc.filterEditor=new ClassFactory(WildcardFilterEditor);}
       else if("Integer"==columnsFilterList[i]){dgc.filterEditor=new ClassFactory(SliderFilterEditor); }
      // else if("Date"==columnsFilterList[i]){dgc.filterEditor=new ClassFactory(DateRangeFilterEditor); }
       dataGridColumnList.push(dgc);
   }
   return dataGridColumnList;
           }

  private function clickRow(event:DataGridEvent):void
  {
  try{
   //this.txt.text=mygrid.selectedItem.curCode;//event.rowIndex.toString();
   this.txt.text=mygrid.selectedItem[columnName];//event.rowIndex.toString();
   PopUpManager.removePopUp(tt);
   }
  catch (e:Error) {
     Alert.show( e.message);
   }
  }

  private function fndragEnterHandler(event:DragEvent):void
           {
            if (event.dragSource.hasFormat("items"))
            DragManager.acceptDragDrop(TextInput(event.currentTarget));
           }

           private function fndragOverHandler(event:DragEvent):void
           {
            if (event.dragSource.hasFormat("items"))
            DragManager.showFeedback(DragManager.COPY);
           }

           private function fndragDropHandler(event:DragEvent):void
           {
           event.preventDefault();
           var itemsArray:Array = event.dragSource.dataForFormat("items") as Array;
               TextInput(event.currentTarget).text=itemsArray[0].(this.columnName);
           }


}
}

Reinstall Ubuntu Grub Bootloader After Windows Wipes it Out

2010-04-25T22:34:00.000-07:00

Reinstall Ubuntu Grub Bootloader After Windows Wipes it Out
Following is the way and it was work for me.But you have to have a CD Rom and live CD for ubuntu.
Note: when you use terminal,tab key will help you to hit the command properly.
Note: root (hd0,0) --->parameters of this command will change accoding to your installation and computer disk. tab key will help you to find it.
1) Boot off the LiveCD and go to terminal
sudo grub

root (hd0,0)

setup (hd0)

exit

Detect Prevent and Protect From Viruses

2010-04-20T02:40:00.000-07:00

How to avoid coming viruses pen drive

Run > gpEdit.msc
User Configuration > Administrative Templates > System > Turn Off Autoplay.
Enable > All drives

How to Enable Task Manager?

There are 2 ways

one way

You can download another task manager from here and kill the virus processes and delete viruses.
http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx

Another way(best way)

Run > gpEdit.msc
User Configuration > Administrative Templates > System > Ctrl+Alt+Del Options > Remove Task Manger. Disable > Enable

How to Enable Registry Accessing?

There are 2 ways

one way

download the following file and install is by right click on it and selelct install
http://securityresponse.symantec.com/avcenter/UnHookExec.inf

Another way(best way)

Windows > Run > gpEdit.msc
User Configuration > Administrative Templates >
System > Disable -> Enable

SBI Simple Code Example

2010-04-02T19:41:00.000-07:00

web-application-config.xml




   

   




   
   
 
   
   
 
     
   
   
   

   
      
      
      
   

   
       
       
   
 
   
   
       
       
        
       
   
 
   

   
       
       
           /WEB-INF/classes/META-INF/persistence.xml

web-security-config.xml

flex-servlet.xml



   
       
       
       
       
       

   
 
   
   
   
   
 
   
       
           
               /*=_messageBroker

web.xml






   SBI template Configured by Sanka 
   SBI template Configured by Sanka

        
          
          
          contextConfigLocation
          /WEB-INF/config/*-config.xml
   
   
       springSecurityFilterChain
       org.springframework.web.filter.DelegatingFilterProxy
   
 
   
       springSecurityFilterChain
       /*
   
 

   
   
       flex.messaging.HttpFlexSession
   

   
       org.springframework.web.context.ContextLoaderListener
   

   
        flex
       org.springframework.web.servlet.DispatcherServlet
       1
   

   
       
       
       flex
       /messagebroker/*
   


   
   bin-debug/testApp.html

   

 
 
   jdbc/catalogueDB
   javax.sql.DataSource
   Container

context.xml

persistence.xml



   
       com.abccompany.domain.Book

Services


package com.abccompany.service;

import java.util.List;

import com.abccompany.domain.Book;

public interface BookService {
List getListBooks();
}


////////


package com.abccompany.service;
import java.util.List;
import javax.annotation.Resource;
import com.abccompany.dao.BookDao;
import com.abccompany.domain.Book;

public class BookServiceImpl implements BookService {

   @Resource(name="jpaBookDao")
   BookDao bookDao;
 
   @Override
   public List getListBooks() {      
       return bookDao.getListBooks();
   }

}

DAOs

package com.abccompany.dao;
import java.util.List;
import com.abccompany.domain.Book;

public interface BookDao {
List getListBooks();
}


////////////////////

package com.abccompany.dao;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import com.abccompany.domain.Book;
@Repository
public class JpaBookDao implements BookDao {

   @PersistenceContext
   EntityManager em;
 
   @Transactional(readOnly=true)
   @Override
   public List getListBooks() {      
       return(em.createNamedQuery("listBooks").getResultList());
   }

}

Domain Objects(JPA Enities / SQL Tables)

package com.abccompany.domain;

import java.io.Serializable;
import java.lang.Float;
import java.lang.Long;
import java.lang.String;
import javax.persistence.*;

/**
* Entity implementation class for Entity: Book
*
*/
@Entity
@NamedQuery(name="listBooks", query="SELECT b FROM Book b")
public class Book implements Serializable {

    
   @Id
   @Column(name="Id")
   private Long bookId;
   private String title;
   private Float price;
   private String description;
   private String isbn;
   private Integer nbOfPage;
   private Boolean illustrations;
   private static final long serialVersionUID = 1L;

   public Book() {
       super();
   } 
   public Long getId() {
       return this.bookId;
   }
   public void setId(Long bookId) {
       this.bookId = bookId;
   } 
   public String getTitle() {
       return this.title;
   }
   public void setTitle(String title) {
       this.title = title;
   } 
   public Float getPrice() {
       return this.price;
   }
   public void setPrice(Float price) {
       this.price = price;
   } 
   public String getDescription() {
       return this.description;
   }
   public void setDescription(String description) {
       this.description = description;
   }
   public String getIsbn() {
       return isbn;
   }
   public void setIsbn(String isbn) {
       this.isbn = isbn;
   }
   public Integer getNbOfPage() {
       return nbOfPage;
   }
   public void setNbOfPage(Integer nbOfPage) {
       this.nbOfPage = nbOfPage;
   }
   public Boolean getIllustrations() {
       return illustrations;
   }
   public void setIllustrations(Boolean illustrations) {
       this.illustrations = illustrations;
   }

}

Exception Translaters

package com.abccompany.flex.exception;

import org.springframework.flex.core.ExceptionTranslator;
import org.springframework.security.access.AccessDeniedException;
import org.springframework.util.ClassUtils;

import flex.messaging.MessageException;

public class AccessException implements ExceptionTranslator {

   //AccessDeniedException cannot use because BlazeDS handle it.
   //JRException like exceptions can be handle.What have to do is throws new JRException
   @Override
   public boolean handles(Class clazz) {
       return (ClassUtils.isAssignable(AccessDeniedException.class,clazz));
   }

   @Override
   public MessageException translate(Throwable th) {
       MessageException ex =new MessageException();
       ex.setCode("Application.Service");
       ex.setMessage("Access Denied");
       ex.setRootCause(th);
       return null;
   }

}


////////////////

package com.abccompany.flex.exception;
import org.springframework.flex.core.ExceptionTranslator;
import org.springframework.util.ClassUtils;
import flex.messaging.MessageException;

public class GenaricNullPointerException implements ExceptionTranslator {

   @Override
   public boolean handles(Class clazz) {
       return (ClassUtils.isAssignable(NullPointerException.class, clazz));
   }

   @Override
   public MessageException translate(Throwable th) {
       MessageException ex =new MessageException();
       ex.setCode("Application.Service");
       ex.setMessage("Empty Feild");
       ex.setRootCause(th);
       return ex;
   }
}



/////////////////////



package com.abccompany.flex.exception;

import java.io.IOException;

import org.springframework.flex.core.ExceptionTranslator;
import org.springframework.util.ClassUtils;

import flex.messaging.MessageException;
import flex.messaging.messages.ErrorMessage;

public class GlobalGenericException implements ExceptionTranslator {

   @Override
   public boolean handles(Class clazz) {
       return (ClassUtils.isAssignable(IOException.class, clazz));
   }

   @Override
   public MessageException translate(Throwable th) {
       MessageException ex =new MessageException();
       ex.setCode("Application.Service");
       ex.setMessage("Empty field found");
       ex.setRootCause(th);
       System.out.println("---------sanka's MessageException  GlobalGenericException----------");
       return ex;
   }

}

Security

package com.abccompany.security;

import java.util.Map;

import org.springframework.flex.security3.AuthenticationResultUtils;

public class Security3Helper {

   public Map getAuthentication() {
       return AuthenticationResultUtils.getAuthenticationResult();
   }
}

EJB 3.0 to Servlet then Servlet to Flex

2010-01-12T22:30:00.000-08:00

EJB 3.0 and Servlet client code with MySql and Glassfish server

If you have any problem contact me sankadil@gmail.com 0713331611 in srilanka

package com.datamation.frontend.servlet;
import com.datamation.ejb.statless.EmployeDetails;
import com.datamation.ejb.statless.NewInterface;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.Vector;
import javax.ejb.EJB;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
*
* @author Sanka Dilmadu Senavirathna
*/
@WebServlet(name="EmpWorkHours", urlPatterns={"/EmpWorkHours"})
public class EmpWorkHours extends HttpServlet {
      @EJB
   private NewInterface empInstance;

   protected void processRequest(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
       response.setContentType("text/html;charset=UTF-8");
       PrintWriter out = response.getWriter();
       try {
         Vector empList=empInstance.getEmpWorkHoursInfo();
           out.println(empList);
                   out.println("<?xml version=\"1.0\"?>\n");
                   out.println("<catalog>");
               for (int i=0; i<empList.size();i++) {
                   out.println("<employe employeId=\"" + ((EmployeDetails)empList.get(i)).getEmp_id()+ "\">");
                   out.println("<name>" + ((EmployeDetails)empList.get(i)).getEmp_name() + "</name>");
                   out.println("<workhours>" + ((EmployeDetails)empList.get(i)).getEmp_work_hours()+ "</workhours>");
                   out.println("<month>" + ((EmployeDetails)empList.get(i)).getEmp_work_month()+ "</month>");
                   out.println("<avgworkhours>" + ((EmployeDetails)empList.get(i)).getEmp_workHoursAvg() + "</avgworkhours>");
                   out.println("</employe>");
               }
                   out.println("</catalog>");
       } finally {
           out.close();
       }
   }

   // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
   /**
    * Handles the HTTP <code>GET</code> method.
    * @param request servlet request
    * @param response servlet response
    * @throws ServletException if a servlet-specific error occurs
    * @throws IOException if an I/O error occurs
    */
   @Override
   protected void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
       processRequest(request, response);
   }

   /**
    * Handles the HTTP <code>POST</code> method.
    * @param request servlet request
    * @param response servlet response
    * @throws ServletException if a servlet-specific error occurs
    * @throws IOException if an I/O error occurs
    */
   @Override
   protected void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
       processRequest(request, response);
   }

   /**
    * Returns a short description of the servlet.
    * @return a String containing servlet description
    */
   @Override
   public String getServletInfo() {
       return "Short description";
   }// </editor-fold>

}


package com.datamation.ejb.statless;
import javax.ejb.Stateless;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

@Stateless
public class Employe implements NewInterface {


   private Connection CreateCon() {
       Connection con = null;
       try {
           InitialContext ic = new InitialContext();
           DataSource ds = (DataSource) ic.lookup("jdbc/mysqltest");
           con = ds.getConnection();
           System.out.println("Connection to tutorialApn Successfull");

       } catch (NamingException e) {
           e.printStackTrace();
           System.out.println("Connection to tutorialApn UNSuccessfull");
       } catch (SQLException e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
           System.out.println("Connection to tutorialApn UNSuccessfull");
       }
       return con;
   }

   private boolean CloseAll(Connection con, ResultSet rs, PreparedStatement st) {
       boolean closed = true;
       try {
           st.close();
       } catch (Exception ex) {
           ex.printStackTrace();
           System.out.println("Connection not closed properly");
           closed = false;
       }
       try {
           rs.close();
       } catch (Exception ex) {
           ex.printStackTrace();
           System.out.println("Connection not closed properly");
           closed = false;
       }
       try {
           con.close();
       } catch (Exception ex) {
           ex.printStackTrace();
           System.out.println("Connection not closed properly");
           closed = false;
       }
       return closed;
   }

   private boolean CloseAll(Connection con, PreparedStatement st) {
       boolean closed = true;
       try {
           st.close();
       } catch (Exception ex) {
           ex.printStackTrace();
           System.out.println("PreparedStatement not closed properly");
           closed = false;
       }

       try {
           con.close();
       } catch (Exception ex) {
           ex.printStackTrace();
           System.out.println("Connection not closed properly");
           closed = false;
       }
       return closed;
   }

   public int setEmpInfo(EmployeDetails employeInstance) {

       Connection con = CreateCon();
       PreparedStatement ps = null;
       int rs = 0;
       try {
             ps = con.prepareStatement("INSERT INTO emp_information (emp_name,emp_address_town,emp_address_street,emp_address_no) VALUES (?,?,?,?)");
              ps.setString(1, employeInstance.getEmp_name());
              ps.setString(2, employeInstance.getEmp_address_town());
              ps.setString(3, employeInstance.getEmp_address_street());
              ps.setString(4, employeInstance.getEmp_address_no());
              rs = ps.executeUpdate();

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

       } finally {
           CloseAll(con,ps);
       }

       return rs;
   }

   public int setEditEmpInfo(EmployeDetails employeInstance) {

       Connection con = CreateCon();
       PreparedStatement ps = null;
       int rs = 0;
       try {
           //UPDATE table_name SET column1=value, column2=value2 WHERE some_column=some_value
           ps = con.prepareStatement("UPDATE emp_information SET emp_name=?,emp_address_town=?,emp_address_street=?,emp_address_no=? WHERE emp_id=?");
           ps.setString(1, employeInstance.getEmp_name());
           ps.setString(2, employeInstance.getEmp_address_town());
           ps.setString(3, employeInstance.getEmp_address_street());
           ps.setString(4, employeInstance.getEmp_address_no());
           ps.setInt(5, employeInstance.getEmp_id());
           rs = ps.executeUpdate();

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

       } finally {
           CloseAll(con,ps);
       }

       return rs;
   }

   public Vector getEmpInfo(String key) {

       Vector employeList = new Vector();
       Connection con = CreateCon();
       PreparedStatement ps = null;
       ResultSet rs = null;
       try {
             ps = con.prepareStatement("SELECT emp_id,emp_name,emp_address_town,emp_address_street,emp_address_no FROM emp_information WHERE emp_name LIKE  ?");
           // ps.setString(1, key);
            ps.setString(1, key + "%");
           //ps = con.prepareStatement("SELECT  emp_id,emp_name,emp_address_town,emp_address_street,emp_address_no FROM emp_information WHERE emp_name LIKE '" + key + "%'");
           // ps.setString(0, key);
           // WHERE emp_name LIKE '"+key+"%'
           rs = ps.executeQuery();
           while (rs.next()) {
               EmployeDetails employeInstance = new EmployeDetails();
               employeInstance.setEmp_id(rs.getInt("emp_id"));
               employeInstance.setEmp_name(rs.getString("emp_name"));
               employeInstance.setEmp_address_no(rs.getString("emp_address_no"));
               employeInstance.setEmp_address_street(rs.getString("emp_address_street"));
               employeInstance.setEmp_address_town(rs.getString("emp_address_town"));
               employeList.add(employeInstance);
               System.out.println("vector is : " + employeList);
               System.out.println("vector size is : " + employeList.size());
           }

       } catch (Exception ex) {
           ex.printStackTrace();
       } finally {
           CloseAll(con, rs, ps);
       }

       return employeList;
   }



   public Vector getEmpWorkHoursInfo() {

       Vector employeList = new Vector();
       Connection con = CreateCon();
       PreparedStatement ps = null;
       ResultSet rs = null;
       try {
           //SELECT * FROM `emp_workhours` WHERE 1
           //SELECT emp_workhours.emp_id,MONTH , workhours, emp_information.emp_name, AVG( workhours ) AS workhoursAverage FROM emp_workhours, emp_information WHERE emp_information.emp_id = emp_workhours.emp_id
           //,AVG(workhours) AS workhoursAverage
           // (AVG(workhours) - workhours) AS workhoursAverage
           ps = con.prepareStatement("SELECT emp_workhours.emp_id,month,workhours,emp_information.emp_name FROM emp_workhours, emp_information WHERE emp_information.emp_id=emp_workhours.emp_id");
           // ps.setString(1, key);
           // ps.setString(1, key + "%");
           //ps = con.prepareStatement("SELECT  emp_id,emp_name,emp_address_town,emp_address_street,emp_address_no FROM emp_information WHERE emp_name LIKE '" + key + "%'");
           // ps.setString(0, key);
           // WHERE emp_name LIKE '"+key+"%'
           rs = ps.executeQuery();
           while (rs.next()) {
               EmployeDetails employeInstance = new EmployeDetails();
               employeInstance.setEmp_id(rs.getInt("emp_id"));
               employeInstance.setEmp_work_month(rs.getString("month"));
               employeInstance.setEmp_work_hours(rs.getString("workhours"));
               employeInstance.setEmp_name(rs.getString("emp_name"));
               //employeInstance.setEmp_workHoursAvg(rs.getString("workhoursAverage"));
               employeList.add(employeInstance);
               System.out.println("vector is : " + employeList);
               System.out.println("vector size is : " + employeList.size());
           }

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

       } finally {
           CloseAll(con, rs, ps);
       }

       return employeList;
   }


   public String getName() {
       Connection conc = CreateCon();
       PreparedStatement ps = null;
       ResultSet rs = null;
       String name = "";

       try {
           ps = conc.prepareStatement("select emp_id ,emp_name from emp_information ");
           rs = ps.executeQuery();
           while (rs.next()) {
               name = rs.getString("emp_name");
           }
       } catch (Exception ex) {
           ex.printStackTrace();
       } finally {
           CloseAll(conc, rs, ps);
       }

       return name;
   }


}

package com.datamation.ejb.statless;

import java.util.Vector;

/**
*
* @author Administrator
*/
public interface NewInterface extends EmployeLocal, EmployeRemote {

   Vector getEmpInfo(String key);
   int setEmpInfo(EmployeDetails employeInstance) ;
   String getName();
   int setEditEmpInfo(EmployeDetails employeInstance);
   Vector getEmpWorkHoursInfo();
}

package com.datamation.ejb.statless;

import java.util.Vector;
import javax.ejb.Remote;

/**
*
* @author Administrator
*/
@Remote
public interface EmployeRemote {
   public String getName();
   public Vector getEmpInfo(String key);
   public int setEmpInfo(EmployeDetails employeInstance);
   public int setEditEmpInfo(EmployeDetails employeInstance);
   public Vector getEmpWorkHoursInfo();
}






package com.datamation.ejb.statless;
import java.io.Serializable;
public class EmployeDetails implements Serializable {

   private int emp_id =0;
   private String emp_name=null;
   private String emp_address_town=null;
   private String emp_address_street=null;
   private String emp_address_no=null;
   private String emp_work_hours=null;
   private String emp_work_month=null;
   private String emp_workHoursAvg=null;
   /**
    * @return the emp_id
    */
   public int getEmp_id() {
       return emp_id;
   }

   /**
    * @param emp_id the emp_id to set
    */
   public void setEmp_id(int emp_id) {
       this.emp_id = emp_id;
   }

   /**
    * @return the emp_name
    */
   public String getEmp_name() {
       return emp_name;
   }

   /**
    * @param emp_name the emp_name to set
    */
   public void setEmp_name(String emp_name) {
       this.emp_name = emp_name;
   }

   /**
    * @return the emp_address_town
    */
   public String getEmp_address_town() {
       return emp_address_town;
   }

   /**
    * @param emp_address_town the emp_address_town to set
    */
   public void setEmp_address_town(String emp_address_town) {
       this.emp_address_town = emp_address_town;
   }

   /**
    * @return the emp_address_street
    */
   public String getEmp_address_street() {
       return emp_address_street;
   }

   /**
    * @param emp_address_street the emp_address_street to set
    */
   public void setEmp_address_street(String emp_address_street) {
       this.emp_address_street = emp_address_street;
   }

   /**
    * @return the emp_address_no
    */
   public String getEmp_address_no() {
       return emp_address_no;
   }

   /**
    * @param emp_address_no the emp_address_no to set
    */
   public void setEmp_address_no(String emp_address_no) {
       this.emp_address_no = emp_address_no;
   }

   /**
    * @return the emp_work_hours
    */
   public String getEmp_work_hours() {
       return emp_work_hours;
   }

   /**
    * @param emp_work_hours the emp_work_hours to set
    */
   public void setEmp_work_hours(String emp_work_hours) {
       this.emp_work_hours = emp_work_hours;
   }

   /**
    * @return the emp_work_month
    */
   public String getEmp_work_month() {
       return emp_work_month;
   }

   /**
    * @param emp_work_month the emp_work_month to set
    */
   public void setEmp_work_month(String emp_work_month) {
       this.emp_work_month = emp_work_month;
   }

   /**
    * @return the emp_workHoursAvg
    */
   public String getEmp_workHoursAvg() {
       return emp_workHoursAvg;
   }

   /**
    * @param emp_workHoursAvg the emp_workHoursAvg to set
    */
   public void setEmp_workHoursAvg(String emp_workHoursAvg) {
       this.emp_workHoursAvg = emp_workHoursAvg;
   }

}

-- phpMyAdmin SQL Dump
-- version 3.0.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 13, 2010 at 05:28 AM
-- Server version: 5.1.30
-- PHP Version: 5.2.7

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `employe`
--

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

--
-- Table structure for table `emp_information`
--

CREATE TABLE `emp_information` (
 `emp_id` int(5) NOT NULL AUTO_INCREMENT,
 `emp_name` varchar(50) NOT NULL,
 `emp_address_town` varchar(50) NOT NULL,
 `emp_address_street` varchar(50) NOT NULL,
 `emp_address_no` varchar(10) NOT NULL DEFAULT '',
 PRIMARY KEY (`emp_id`),
 UNIQUE KEY `emp_name` (`emp_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

--
-- Dumping data for table `emp_information`
--

INSERT INTO `emp_information` (`emp_id`, `emp_name`, `emp_address_town`, `emp_address_street`, `emp_address_no`) VALUES
(1, 'sanka', 'a/pura', 'samagi mawatha', '1'),
(2, 'alex', 'newyork', 'maya mawatha', '2'),
(3, 'suresh', 'colombo', 'wijaya mawatha', '3'),
(4, 'saliya', 'kandy', 'wijayarama mawatha', '4'),
(5, 'samaranayaka', 'rathnapura', 'rahula mawatha', '5'),
(6, 'samarasekera', 'abilipitiya', 'anandharama mawatha', '6'),
(7, 'sakura', 'tokiyo', 'molpe', '7'),
(8, 'shrawashthi', 'jafna', '8th lane', '8'),
(9, 'anura', 'anuradhapura', '9th lane', '9'),
(10, 'abaya', 'abepussa', '1st lane', '10'),
(11, 'balasuriya', 'gampaha', '2nd lane', '11'),
(12, 'bharana', 'homagama', '3rd lane', '12'),
(13, 'bhathiya', 'siyabalapura', '4th lane', '13'),
(14, 'santhush', 'siyabalawewa', 'A1', '14'),
(15, 'kamal', 'kundasale', 'A2', '15'),
(16, 'kamani', 'katugasthota', 'A3', '16'),
(17, 'kumudu', 'kuliyapitiya', 'A5', '17'),
(18, 'kumara', 'kumana', 'A6', '18'),
(19, 'null', 'null', 'null', 'null'),
(20, '1', '1', '1', '1'),
(21, 'arjuna', '1', 'banadaranayaka mawatha', 'weyangoda'),
(22, 'sanath', 'mathara', 'uyanwaththa', '101'),
(23, 'sangakkara kumara', 'colombo 07', 'agulana mw', '154'),
(24, 'K.sangakkara', '1', 'mal renu mawatha', 'udu nuwara'),
(25, 'Arnold Swasanager', 'calfornia', 'back', '22'),
(26, 'murali', 'kandy', 'asasa mw', '1'),
(27, 'wilson', 'welinton', 'wilson wkins', '43'),
(28, 'charmara', 'hambanthota', 'nuwan mw', '34'),
(29, 'elton jhon', 'newyork', 'eminum mw', '76'),
(30, 'tom and jerry', 'losangalies', 'nikodo mw', '54'),
(31, 'JQuery', 'showtland', 'black berry', '37'),
(32, 'mihira', 'anytown', 'any', '23'),
(33, 'Jenaral SF', 'saliyapura', 'gajaba', '12'),
(34, 'jasica alba', 'newyork', 'black bery', '123');

you have to download ResizableTitleWindow.swc from internet

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml"
backgroundColor="#FFFFFF"
layout="absolute"
xmlns:adobe="http://www.adobe.com/2006/fc">

<mx:HTTPService id="httpXmlDataService"
url="http://localhost:8080/EmpEntApp-war/EmployeView"
resultFormat="e4x"
result="resultHandler(event)"
fault="faultHandler(event)"
useProxy="false">
<mx:request>
<first>{first.text}</first>
</mx:request>
</mx:HTTPService>

<mx:HTTPService id="httpDataServiceInsert"
url="http://localhost:8080/EmpEntApp-war/EmployeCreate"
resultFormat="e4x"
result="resultHandler(event)"
fault="faultHandler(event)"
useProxy="false">
<mx:request>
<name>{name1.text}</name>
<!--<address>{address.text}</address>-->
<no>{no.text}</no>
<street>{street.text}</street>
<town>{town.text}</town>
</mx:request>
</mx:HTTPService>

<mx:HTTPService id="httpDataServiceEdit"
url="http://localhost:8080/EmpEntApp-war/EmployeEdit"
resultFormat="e4x"
result="resultHandler(event)"
fault="faultHandler(event)"
useProxy="false">
<mx:request>
<nameEdit>{nameEdit.text}</nameEdit>
<noEdit>{noEdit.text}</noEdit>
<streetEdit>{streetEdit.text}</streetEdit>
<townEdit>{townEdit.text}</townEdit>
<employeIdEdit>{employeIdEdit.text}</employeIdEdit>
</mx:request>
</mx:HTTPService>

<mx:ApplicationControlBar dock="true">
<mx:Label text="Background Color:"/>
<mx:ColorPicker id="colorPicker"
creationComplete="colorPicker_creationComplete(event)"
change="colorPicker_change(event)"/>
<mx:Button id="cmdViewTEmpitleWindow"
label="Employe Details"
click="titleWindow_open()"/>

</mx:ApplicationControlBar>

<adobe:ResizableTitleWindow id="empView"
x="134"
y="39"
showEffect="true"
addedEffect="zoomEmpAnimation"
height="335"
width="750">
<mx:ApplicationControlBar horizontalAlign="left"
width="250">
<mx:Button id="viewCmd"
label="switch view"
width="120"
click="changeView()"
x="500"/>

<mx:TextInput width="100"
id="first"
enter="retrive_data();"/>
</mx:ApplicationControlBar>
<mx:ViewStack id="viewstack1"
width="700"
height="250"
x="0"
y="41">
<mx:Canvas label="gride"
width="100%"
height="100%"
showEffect="{showEffect}"
id="gride">

<!-- this is the Rotate animation code  addedEffect="down" -->
<mx:DataGrid showEffect="true"
addedEffect="down"
x="9"
width="682"
height="220"
editable="true"
headerHeight="20"
dataProvider="{xmldata.employe}"
y="4">
<mx:columns>
<!--<mx:DataGridColumn headerText="ID"
dataField="@employeId"
id="employeId"
width="75"/>-->

<mx:DataGridColumn headerText="Name"
dataField="name"
editable="false"/>
<mx:DataGridColumn headerText="No"
labelFunction="displayAddressNo"
editable="true"
width="75"/>
<mx:DataGridColumn headerText="Street"
labelFunction="displayAddressStreet"
editable="true"/>
<mx:DataGridColumn headerText="Town"
labelFunction="displayAddressTown"
editable="true"/>
<mx:DataGridColumn headerText="Address"
width="200"
labelFunction="displayFullAddress"
editable="true"/>
<!--<mx:DataGridColumn headerText="URL"  itemRenderer="urlRenderer"/>
<mx:DataGridColumn headerText="URL"  itemEditor="{inlineEditor}"  editorDataField="@employeId"  dataField="@employeId"/>-->
<mx:DataGridColumn dataField="@employeId"
width="50"
editable="false"
headerText="Edit">

<mx:itemRenderer>
<mx:Component>
<mx:LinkButton click="handleClick();"
label="{data.@employeId}">
<mx:Script>
<![CDATA[
import mx.controls.Text;
import mx.controls.Alert;
import flash.profiler.showRedrawRegions;
import mx.core.Container;
import mx.core.Application;
import mx.events.CloseEvent;

public function handleClick():void
{
Alert.yesLabel="Edit";
Alert.noLabel="Back";
Alert.show("Do you want to edit details of\n Mr:" + data.name + "\n employe id :" + data.@employeId, "Employe Information", Alert.YES | Alert.NO, null, handleAlert, null, Alert.YES);
}

public function handleAlert(event:Object):void
{
if (event.detail == Alert.YES)
{
Application.application.viewstack1.selectedIndex=2;
//Alert.show("Name : "+data.name+"\nAddress : "+data.address.no+data.address.street+data.address.town+"\nEmploye ID : "+data.@employeId);
Application.application.nameEdit.text=data.name;
//Alert.show("acheived... Application.application.name1.text=data.name;");
Application.application.streetEdit.text=data.address.street;
Application.application.townEdit.text=data.address.town;
Application.application.noEdit.text=data.address.no;
Application.application.employeIdEdit.text=data.@employeId;
//Alert.show("changeView acheived...");

// YES button was clicked
}
else if (event.detail == Alert.NO)
{
// NO button was clicked
}
}
]]>
</mx:Script>
</mx:LinkButton>
</mx:Component>
</mx:itemRenderer>
</mx:DataGridColumn>

<!--    //navigateToURL(new URLRequest(data.url))
<mx:LinkButton textAlign="center"
label="Edit"
click="{navigateToURL(new URLRequest('http://localhost:8080/EmpEntApp-war/EmployeView?first='+xmldata.employe.@employeId));}"/>
//click="navigateToURL(new URLRequest('http://localhost:8080/EmpEntApp-war/EmployeView?first='+data.@employeId))"

-->


</mx:columns>
</mx:DataGrid>


</mx:Canvas>
<mx:Canvas label="detail"
width="100%"
height="100%"
showEffect="{showEffect}"
id="detail">
<mx:Form x="8"
y="4"
label="Create Employe Profile"
width="300">
<mx:FormItem label="Name:">
<mx:TextInput id="name1"
width="100"/>
</mx:FormItem>

<mx:FormItem label="No:">
<mx:TextInput id="no"
width="100"/>
</mx:FormItem>
<mx:FormItem label="Street">
<mx:TextInput id="street"
width="100"/>
</mx:FormItem>
<mx:FormItem label="Town">
<mx:TextInput id="town"
width="100"/>
</mx:FormItem>
<mx:FormItem>
<mx:TextInput visible="true"
editable="false"
id="employeId"
width="100"/>
</mx:FormItem>
<mx:FormItem>
<mx:Button label="Create"
width="100"
id="submitCmd"
click="sendToServer();"/>
</mx:FormItem>
</mx:Form>
</mx:Canvas>
<mx:Canvas label="Edit"
width="100%"
height="100%"
showEffect="{showEffect}"
id="detailEdit">
<mx:Form x="8"
y="4"
label="Edit Employe Profile"
width="300">
<mx:FormItem label="Name:">
<mx:TextInput id="nameEdit"
width="100"/>
</mx:FormItem>

<mx:FormItem label="No:">
<mx:TextInput id="noEdit"
width="100"/>
</mx:FormItem>
<mx:FormItem label="Street">
<mx:TextInput id="streetEdit"
width="100"/>
</mx:FormItem>
<mx:FormItem label="Town">
<mx:TextInput id="townEdit"
width="100"/>
</mx:FormItem>

<mx:FormItem label="Employe ID">
<mx:TextInput visible="true"
editable="false"
id="employeIdEdit"
width="100"/>
</mx:FormItem>
<mx:FormItem>
<mx:Button label="Save"
width="100"
id="submitCmdEdit"
click="sendEditToServer();"/>
</mx:FormItem>
</mx:Form>
</mx:Canvas>

</mx:ViewStack>

<mx:Image id="animateImage"
visible="false"
includeInLayout="false"/>

</adobe:ResizableTitleWindow>

<adobe:ResizableTitleWindow id="graphView"
x="736"
y="284"
showEffect="true"
addedEffect="zoomEmpAnimation"
height="235"
width="250">


<mx:Script>
<![CDATA[
import mx.charts.*;
import mx.controls.Alert;
import mx.charts.series.items.*;
import mx.graphics.*;
import mx.collections.ArrayCollection;
[Bindable]
public var expensesAC:ArrayCollection=new ArrayCollection([{Month: "January", Profit: 2000, Expenses: 1500, Amount: 195}, {Month: "February", Profit: 1000, Expenses: 200, Amount: 160}, {Month: "March", Profit: 800, Expenses: 500, Amount: 230}, {Month: "April", Profit: 500, Expenses: 300, Amount: 150}, {Month: "May", Profit: 700, Expenses: 450, Amount: 210}, {Month: "June", Profit: 900, Expenses: 500, Amount: 179}]);

[Bindable]
private var expensesAC1:ArrayCollection=new ArrayCollection([{Month: "Jan", Profit: 2000, Expenses: 1500, Amount: 450}, {Month: "May", Profit: 2400, Expenses: 1575, Amount: 500}, {Month: "April", Profit: 1500, Expenses: 1300, Amount: 350}, {Month: "May", Profit: 1700, Expenses: 1450, Amount: 260}, {Month: "June", Profit: 1900, Expenses: 1200, Amount: 399}]);

private function labelFunc(v:BarSeriesItem, index:int):String
{
return BarSeries(v.element).displayName + ":" + v.xNumber;
}
]]>
</mx:Script>

<mx:Panel title="Bar chart showing per item labels"
width="100%"
height="100%"
layout="horizontal">
<mx:BarChart id="Barchartold"
height="100%"
width="100%"
paddingLeft="5"
paddingRight="5"
showDataTips="true"
dataProvider="{expensesAC}">

<mx:verticalAxis>
<mx:CategoryAxis categoryField="Month"/>
</mx:verticalAxis>

<mx:series>
<mx:BarSeries id="profitseries1"
xField="Profit"
displayName="Profit"
labelPosition="inside"
labelFunction="labelFunc"/>
<mx:BarSeries id="expenseseries1"
xField="Expenses"
displayName="Expenses"
labelPosition="inside"
labelFunction="labelFunc"/>
<mx:BarSeries id="amountseries1"
xField="Amount"
displayName="Amount"
labelPosition="inside"
labelFunction="labelFunc"/>
</mx:series>
</mx:BarChart>
<mx:BarChart id="Barchartout"
height="100%"
width="100%"
paddingLeft="5"
paddingRight="5"
showDataTips="true"
dataProvider="{expensesAC}">

<mx:verticalAxis>
<mx:CategoryAxis categoryField="Month"/>
</mx:verticalAxis>

<mx:series>
<mx:BarSeries id="profitseries2"
xField="Profit"
displayName="Profit"
labelPosition="outside"
labelFunction="labelFunc"/>
<mx:BarSeries id="expenseseries2"
xField="Expenses"
displayName="Expenses"
labelPosition="outside"
labelFunction="labelFunc"/>
<mx:BarSeries id="amountseries2"
xField="Amount"
displayName="Amount"
labelPosition="outside"
labelFunction="labelFunc"/>
</mx:series>
</mx:BarChart>

</mx:Panel>


</adobe:ResizableTitleWindow>


<mx:Style source="my.css"/>


<mx:Script>
<![CDATA[
import mx.rpc.events.ResultEvent;
import mx.rpc.events.FaultEvent;
import mx.rpc.*;
import mx.controls.Alert;
import mx.events.ColorPickerEvent;
import mx.events.CloseEvent;
import mx.controls.Button;
import mx.managers.PopUpManager;
import mx.managers.PopUpManager;
import mx.containers.TitleWindow;
import flash.geom.Point;

[Bindable]
public var xmldata:XML;

private function sendToServer():void
{
insert_data();
changeView();
retrive_data();
retrive_data();
}

private function sendEditToServer():void
{
edit_data();
viewstack1.selectedIndex=0;
retrive_data();
retrive_data();
}

private function displayAddressNo(row:Object, column:DataGridColumn):String
{
return row.address.no;
}

private function displayAddressTown(row:Object, column:DataGridColumn):String
{
return row.address.town;
}

private function displayAddressStreet(row:Object, column:DataGridColumn):String
{
return row.address.street;
}

private function displayFullAddress(row:Object, column:DataGridColumn):String
{
return row.address.no + "," + row.address.street + "," + row.address.town;
}

public function changeView():void
{
animate();

//viewstack1.selectedIndex=0
if (viewstack1.selectedChild == detail)
{
viewstack1.selectedChild=gride;
//viewCmd.label="Detail View";
first.visible=true;
//set to insert mode,create all as empty fields
//mode.text="insert";
//name1.text="";
//no.text="";
//town.text="";
//street.text="";
//employeId.text="";
}
else if (viewstack1.selectedChild == detailEdit)
{
viewstack1.selectedChild=gride;
}
else
{

viewstack1.selectedChild=detail;
//viewCmd.label="Gride view";
first.visible=false;
}
}

private function retrive_data():void
{
httpXmlDataService.send();
}

private function insert_data():void
{
httpDataServiceInsert.send();
}

private function edit_data():void
{
httpDataServiceEdit.send();
}

private function faultHandler(event:FaultEvent):void
{
mx.controls.Alert.show(event.fault.message, "Error in getting result");
}

private function resultHandler(event:ResultEvent):void
{
xmldata=event.result as XML;
}

private function titleWindow_close():void
{
PopUpManager.removePopUp(this);

}

private function titleWindow_open():void
{
PopUpManager.addPopUp(empView, this, false); //false--true is lock background
PopUpManager.centerPopUp(empView);

//animation effect code
//customMove.end();
//customMove.play();
//animation effect code

//animation effect code
//zoomEmpAnimation.play();
//blurAnimation.play();
//over.play();
//animation effect code

}

private function colorPicker_creationComplete(evt:Event):void
{
colorPicker.selectedColor=Application.application.getStyle("backgroundColor");
}

private function colorPicker_change(evt:ColorPickerEvent):void
{
Application.application.setStyle("backgroundColor", colorPicker.selectedColor);
}
]]>
</mx:Script>


<mx:Parallel id="customMove"
target="{empView}">
<mx:Move duration="1000"
xTo="{(stage.width  - empView.width) / 2}"
yTo="{(stage.height - empView.height) / 2}"/>
<mx:WipeRight duration="1000"/>
</mx:Parallel>

<mx:Parallel id="zoomEmpAnimation"
target="{empView}">
<mx:Zoom id="zoomEmp"
duration="500"
zoomHeightFrom="0.01"
zoomHeightTo="1.0"
zoomWidthFrom="0.01"
zoomWidthTo="1.0"/>
</mx:Parallel>

<mx:Dissolve alphaFrom="1.0"
alphaTo="0.1"
color="#ffff00"/>

<mx:Blur id="blurAnimation"
duration="300"
blurYFrom="1.0"
blurYTo="20.0"/>

<mx:Parallel id="over">
<mx:Zoom duration="100"
zoomHeightTo="1.3"
zoomWidthTo="1.3"/>
<mx:Blur duration="1000"/>
</mx:Parallel>
<mx:Rotate id="down"
angleFrom="0"
angleTo="360"
duration="1500"/>
<mx:Zoom id="out"
duration="200"
zoomHeightTo="1"
zoomWidthTo="1"/>








<mx:Script>
<![CDATA[
import mx.effects.easing.Exponential;
import mx.graphics.ImageSnapshot;

private function animate():void
{
animateImage.width=viewstack1.width;
animateImage.height=viewstack1.height;
animateImage.source=new Bitmap(ImageSnapshot.captureBitmapData(viewstack1));
animateImage.visible=true;
animateImage.includeInLayout=true;

switch ("down")
{
case "up":
contentMove.xFrom=0;
contentMove.xTo=0;
contentMove.yFrom=viewstack1.height;
contentMove.yTo=0;

imageMove.xFrom=0;
imageMove.xTo=0;
imageMove.yFrom=0;
imageMove.yTo=-viewstack1.height;
break;

case "down":
contentMove.xFrom=0;
contentMove.xTo=0;
contentMove.yFrom=-viewstack1.height;
contentMove.yTo=0;

imageMove.xFrom=0;
imageMove.xTo=0;
imageMove.yFrom=0;
imageMove.yTo=viewstack1.height;
break;

case "left":
contentMove.xFrom=viewstack1.width;
contentMove.xTo=0;
contentMove.yFrom=0;
contentMove.yTo=0;

imageMove.xFrom=0;
imageMove.xTo=-viewstack1.width;
imageMove.yFrom=0;
imageMove.yTo=0;
break;

default: //right
contentMove.xFrom=-viewstack1.width;
contentMove.xTo=0;
contentMove.yFrom=41;
contentMove.yTo=41;

imageMove.xFrom=0;
imageMove.xTo=viewstack1.width;
imageMove.yFrom=41;
imageMove.yTo=41;
break;
}

// toggleVisibility();
}

private function toggleVisibility():void
{
viewstack1.selectedIndex=(viewstack1.selectedIndex + 1) % viewstack1.numChildren;
contentMove.target=viewstack1.selectedChild;
}
]]>
</mx:Script>


<mx:Parallel id="showEffect">
<mx:Move id="contentMove"/>
<mx:Move id="imageMove"
target="{animateImage}"/>
<mx:effectEnd>
<![CDATA[
animateImage.visible=false;
animateImage.includeInLayout=false;
]]>
</mx:effectEnd>
</mx:Parallel>



<mx:Style>
Alert {
modalTransparencyBlur: 5;
modalTransparency: 0.6;
modalTransparencyColor:#ffffff;
modalTransparencyDuration: 300;
}
</mx:Style>

</mx:Application>

Unit Test with JUnit

2009-08-18T01:41:00.000-07:00

JUnit is a fancy term like AJAX which is used in java for testing purpose methods.
Please dont get afraid this code segment will tell you how it is simple.

dont think about code,get the concept.It is very simple.

I will show you one of the best answer I found from googling.

package real;

public class Real {

public String realMethod() {

return "Real, world";

}

public static void main(String[] args) {

Real h = new Real();

System.out.println(h.realMethod());

}

}

package real;

import junit.framework.TestCase;

public class TestReal extends TestCase {

public void testReal()

{

Real h = new Real();

assertEquals(h.realMethod(), "Real, world");

}

}

Free proxy servers

2009-03-09T04:20:00.000-07:00

I know everybody have the problem of blocking the some of important websites like facebook.So this is the solution you ca use following proxy servers.

How to hacking Firefox users

2009-03-09T02:50:00.000-07:00

How to hacking Firefox users.

I know Some of my friends are using remember password feature in firefox. This is the way hacking their passwords.
Remember don't save your passwords any more in Firefox, if you are sharing your owner computer.

This is the way to View anyone stored passwords in Firefox:

To view all the saved passward in Firefox.Go to
Tools -> Options -> Security -> Saved Passwords.
And there you have all the passwords that you ever asked Firefox to remember for you.

To Enable Or Disable Remember me Option from yours Firefox Go to

Tools -> Options -> Security

Check or Uncheck Remember passward for sites as per yours requirement , See below screenshot. for details.

You can also Control remember me passward feature by disable this feature for some website and enabling for some website , Check Exception Tab for more details

Lets consider how to get dotted passwords

if you have this kind of browser page you can easily view this passwords by pasting following script in address bar (insted of url) and hit Enter

A dialog box will prompt and your password is shown!

How to fast your Internet connection.

And there is another thing that I found from another site to improve you firefox effiency

1.Type “about:config” into the address bar and hit.

then scrol down and
Set “network.http.pipelining” to “true”

Set “network.http.proxy.pipelining” to “true”

Set “network.http.pipelining.maxrequests” to some number like 30(will make 30 requests at once).

Finally right-click anywhere and
select New-> Integer.
Name it “nglayout.initialpaint.delay” and set its value to “0″.
This value is the amount of time the browser waits before it acts on information it receives.
Now you’re broadband connection will load pages MUCH faster!

Sanka's photos

2009-03-04T21:10:00.001-08:00

Sanka's photos

Difference between String and StringBuilder

2009-03-04T19:52:00.000-08:00

What is the difference between String and StringBuilder?

Learn more about how to manage resources in the project. Try to reduce memory consumson of variables. Self study about StringBuilder.

Both String and StringBuilder are classes used to handle strings.
The most common operation with a string is concatenation. This activity has to be performed very efficiently. When we use the "String" object to concatenate two strings, the first string is combined to the other string by creating a new copy in the memory as a string object, and then the old string is deleted. This process is a little long. Hence we say "Strings are immutable".

When we make use of the "StringBuilder" object, the Append method is used. This means, an insertion is done on the existing string. Operation on StringBuilder object is faster than String operations, as the copy is done to the same location. Usage of StringBuilder is more efficient in case large amounts of string manipulations have to be performed.

String Class

Once the string object is created, its length and content cannot be modified. Slower

StringBuilder

Even after object is created, it can be able to modify length and content. Faster

All operation are in this site

select * from BANK_CODE_TABLE k, BRANCH_CODE_TABLE c where k.bank_code = c.bank_code order by c.bank_code






public static StringBuilder getOwnerName(String ownerId){

levelBusiness.utilities.LogFileCreater.writeToFile("Owner.cs/public static OwnerDetails getOwnerDetails(String ownerId)", 'E');
OleDbConnection con = Cntion.setConnectionDb();
con.Open();
String sql = "select TITLE, OWNER_FIRST_NAME, OWNER_LAST_NAME, OWNER_ID from ARM_OWNER_TABLE where OWNER_ID = '" + ownerId + "'";

OleDbCommand cmd = new OleDbCommand(sql, con);

OleDbDataReader dr;

dr = cmd.ExecuteReader();

StringBuilder ownerName = new StringBuilder();

if (dr.Read())
{
ownerName.Append(dr["TITLE"].ToString());
ownerName.Append(" ");
ownerName.Append( dr["OWNER_FIRST_NAME"].ToString());
ownerName.Append(" ");
ownerName.Append( dr["OWNER_LAST_NAME"].ToString());
}
return ownerName;
}

Avoiding SQL Injection by sanka dilmadu

2009-01-14T18:46:00.000-08:00

Avoiding SQL Injection

If you are a web developer this article is very important regarding Data security of your application. Actually to avoid hacking your database you have to learn how to hacking database. So sanka will teach you how to hacking database by SQL injection.

following is very interresting...check it..I think it is not more a hacking method,bcz all are know about htis by my articles.

’, ‘’); drop table MyTable;--

most of fu..ing web developers are doing following incorrect idiot type of coding..



string cmdStr =
"insert into Shippers (CompanyName, Phone) values ('" +
txtCompanyName.Text + "', '" + txtPhone.Text + "')";

So my friends do the following type of thing here

insert into Shippers (CompanyName, Phone) values ('', ''); drop table MyTable;--', '')

user name :

The first part of this statement adds a new row with blank values to the Shippers table. The second part, after the first semicolon (;), removes the MyTable table from the database. The rest of the statement, after the second semicolon, is commented out to prevent errors.

As you can see, attackers can do a lot of damage to your system or view information they aren’t supposed to see. Even worse, although it may not be totally obvious by this example, through SQL injection an attacker could potentially take over your entire system.

So this is the solution for that


string surname = this.surnameTb.Text.Replace("'", "''");
string cmdStr =
"insert into Shippers (CompanyName, Phone) values (" +
"@CompanyName, @Phone)";
using (SqlConnection conn = new SqlConnection(connStr))
using (SqlCommand cmd = new SqlCommand(cmdStr, conn))
{
// add parameters
cmd.Parameters.AddWithValue
("@CompanyName", txtCompanyName.Text);
cmd.Parameters.AddWithValue("@Phone", txtPhone.Text);
conn.Open();
cmd.ExecuteNonQuery();
}

Gridview command argumnet and name usage

2009-01-06T21:57:00.000-08:00

Gridview -command argumnet and name usage

This code will teach you to use command argumant and command name

this code in in ASP.NET file

<br><br><asp:TemplateField><br><ItemTemplate><br><asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%# BIND("branch_code") %>'<br>CommandName="branch_code" Text='<%# BIND("branch_code") %>'></asp:LinkButton><br><asp:Label ID="Label3" runat="server" Text='<%# Eval("branch_name","BRANCH NAME IS:{0}") %>'></asp:Label><br></ItemTemplate><br></asp:TemplateField><br>

this code in c# class that code behind genaration

<br><br>protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e)<br>{<br>if (e.CommandName == "branch_name")<br>{<br>String index= e.CommandArgument.ToString();<br>Label2.Text ="branch_name :"+ index;<br>}<br>if (e.CommandName == "branch_code")<br>{<br>String index = e.CommandArgument.ToString();<br>Label2.Text ="branch_code :"+ index;<br>}<br>}<br><br>

Grid view command argumant and name usage

2009-01-06T21:42:00.000-08:00

Grid view command argumant and name in data binding

in c# class type this code




CommandName="branch_code" Text='<%# BIND("branch_code") %>'>

in c# class type this code


protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "branch_name")
{
String index= e.CommandArgument.ToString();
Label2.Text ="branch_name :"+ index;
}
if (e.CommandName == "branch_code")
{
String index = e.CommandArgument.ToString();
Label2.Text ="branch_code :"+ index;
}
}

Introduction to Sorting a Gridview,Introduction to sotring Dataset

2009-01-05T19:16:00.000-08:00

Sorting

The GridView sorting features allow the user to reorder the results in the GridView by clicking a column header. It’s convenient—and easy to implement. Although you may not realize it, when you bind to a DataTable, you actually use another object called the DataView. The DataView sits between the ASP.NET web page binding and your DataTable.
To enable sorting, you must set the GridView.AllowSorting property to true. Next, you
need to define a SortExpression for each column that can be sorted. In theory, a sort expression can use any syntax that’s understood by the data source control. In practice, a sort expression almost always takes the form used in the ORDER BY clause of a SQL query. This means the sort expression can include a single field or a list of comma-separated fields, optionally with the word ASC or DESC added after the column name to sort in ascending or descending order. Here’s how you could define the ProductName column so it sorts by alphabetically ordering rows:

This note from book.

This is working code example

   <br>DataSet data=null;<br>DataAccess ds = new DataAccess();<br>ds.OpenDBConnection();<br>data = ds.Retrive("SELECT * FROM branchDetails");<br>DataView dv = new DataView(data.Tables[0]);<br>dv.Sort = "branchCode DESC";<br>//dv.Sort = e.SortExpression.ToString();<br>GridView1.DataSource = dv;<br>//GridView1.DataBind();<br>// GridView1.DataSource = data;<br>GridView1.DataBind();<br><br>

this code for Caching dataset

<br>   This is the code example from Internet<br>        DataSet ds = new DataSet();<br>        ds = (DataSet)Cache["MyDataSet"];<br>        DataView dv = new DataView(ds.Tables[0]);<br>        dv.Sort = e.SortExpression.ToString();<br>        GridView1.DataSource = dv;<br>        GridView1.DataBind();<br>

Downloads code exapmles

click here to download code example searching

click here to download code example sorting

server side validation class for Email,NIC Telephone number in srilanka

2009-01-05T00:27:00.000-08:00

Server side validation class for Srilankan NIC and Srilankan Telephone number and Email address and Date in ASP and C# .net

 public class Validation
   {

       //Created by Sanka
       #region EmailAddressValidation
       public static bool IsValidEmail(string email)
       {
           //THIS IS CASE SENSITIVE IF U DONT WONT CASE SENSITIVE PLEASE USE FOLLOWING CODE
          // email = email.ToLower();

           string pattern = @"^[-a-zA-Z0-9][-.a-zA-Z0-9]*@[-.a-zA-Z0-9]+(\.[-.a-zA-Z0-9]+)*\.
(com|edu|info|gov|int|mil|net|org|biz|name|museum|coop|aero|pro|tv|[a-zA-Z]{2})$";
           // ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"
           Regex check = new Regex(pattern, RegexOptions.IgnorePatternWhitespace);
           //boolean variable to return to calling method
           bool valid = false;
           //make sure an email address was provided
           if (string.IsNullOrEmpty(email))
           {
               valid = false;
           }
           else
           {
               //use IsMatch to validate the address
               valid = check.IsMatch(email);
           }

           //return the value to the calling method
           return valid;
       }
       #endregion
       //Created by Sanka

       //Created by Sanka
       #region TelephoneNumberValidation
       public static bool IsValidTelephone(string telephoneNumber)
       {
           bool valid = false;
           telephoneNumber = telephoneNumber.Replace("-", "").Replace("/", "").Trim();           
           if (telephoneNumber.Trim().Length == 10)
           {
               try
               {
                   Int64.Parse(telephoneNumber);
                   valid = true;
               }
               catch (Exception)
               {
                   valid = false;
               }
           }
           else
           {
               valid = false;
           }
           return valid;
       }
       #endregion
       //Created by Sanka

       //Created by Sanka
       #region RequiredFieldValidation
       public static bool IsEmpty(string input)
       {
           bool valid = false;
           if ((input.Length == 0) || (input == null) || (input.Equals("")))
           {
               valid = false;
           }
           else
           {
               valid = true;
           }
           return valid;
       }
       #endregion
       //Created by Sanka

       //Created by Sanka
       #region NICnumberValidation
       public static bool IsValidNIC(string email)
       {
           //THIS IS CASE SENSITIVE IF U DONT WONT CASE SENSITIVE PLEASE USE FOLLOWING CODE
           // email = email.ToLower();

           string pattern = @"\d{9}[V|v|x|X]";
           Regex check = new Regex(pattern, RegexOptions.IgnorePatternWhitespace);
           //boolean variable to return to calling method
           bool valid = false;
           //make sure an email address was provided
           if (string.IsNullOrEmpty(email))
           {
               valid = false;
           }
           else
           {
               //use IsMatch to validate the address
               valid = check.IsMatch(email);
           }

           //return the value to the calling method
           return valid;
       }
       #endregion
       //Created by Sanka

       //Created by Sanka
       public static bool IsValidDate(string date)
       {
           string input = @"07/14/2007";
           string pattern = @"(-)|(/)";
           Regex regex = new Regex(pattern);
           foreach (string result in regex.Split(input))
           {
               Console.WriteLine("'{0}'", result);
           }
           return true;
       }
       //Created by Sanka


   }

Introduction to Logic Iterate Tag

2009-01-04T23:40:00.000-08:00

Introduction to Logic Iterate Tag


There should be a vector in session call CollectionName


 Element Value: 



Is it available in session scope?..You Check by this code
<%Vector vector=(Vector)session.getAttribute("CollectionName ");%>

CollectionName    
• This name shloud be equal to a Session vector or ArrayList or some Collection that in a Session
• Remember that it should be in session scope

Introduction to Logic Equal Tag

2009-01-04T23:38:00.001-08:00

Introduction to Logic Equal Tag

• This mean if age equal to 1 then it will out put in

Introduction to Struts by hello world code example

2009-01-04T23:17:00.000-08:00

Introduction to Struts by hello world example

First.jsp

This is form class

package strutappweb.forms;
public class FormFirst extends ActionForm {

 private String age = null;
 private String name = null;
 private String password = null; 
//generate getters and setters
 }

Action class ActionFirst.java

public class ActionFirst extends Action {

 public ActionForward execute(
  ActionMapping mapping,
  ActionForm form,
  HttpServletRequest request,
  HttpServletResponse response)
  throws Exception {
  ActionErrors errors = new ActionErrors();
  ActionForward forward = new ActionForward(); // return value
  FormFirst formFirst = (FormFirst) form;
  try {
   // do something here
   String name=formFirst.getName();
   String age=formFirst.getAge();
   String password=formFirst.getPassword();
   Vector v=new Vector();
   v.add(name);
   v.add(age);
   v.add(password);
   HttpSession s=request.getSession(true);
   s.setAttribute("result",v);
   //response.sendRedirect("")   

  } catch (Exception e) {
   errors.add("name", new ActionError("id"));
  }
  if (!errors.isEmpty()) {
   saveErrors(request, errors);
  }  
  forward = mapping.findForward("ActionFirst");
  
  return (forward);

 }
}

Second.jsp

<%Vector v=(Vector)session.getAttribute("result");%>




  





Name  Age  Password    
      
   
         
   
            
   
    
    in

            
            
     
    out

Name	Age	Password
		in out

Another way to do that




 
  

   






Movie  Movie id  Status    
   
   
      
    in

    
    out

Movie	Movie id	Status
		in out

SeconAction.java

 public ActionForward execute(
  ActionMapping mapping,
  ActionForm form,
  HttpServletRequest request,
  HttpServletResponse response)
  throws Exception {
  ActionErrors errors = new ActionErrors();
  ActionForward forward = new ActionForward(); // return value
  SecondForm secondForm = (SecondForm) form;
  try {
   String keyId=request.getParameter("keyId");
   System.out.println("keyId.......= "+keyId);    
  }

How to work with Eval function / How to call a method from aspx page

2009-01-04T21:40:00.000-08:00

This method paist in partial class(code behind genaration class)
this will return String to display in this way you can return bool
value for visible true or false or you can use this for
onbehalf of SQL DECODE function


this is the way to call to method in aspx page.

TEXT='<%# GenerateOwnershipTypeString(Container.DataItem) %>'
       protected string GenerateOwnershipTypeString(object dataItem)
       {
           string ownership_type = (string)DataBinder.Eval(dataItem, "OWNERSHIP_TYPE");
           string text = string.Empty;
           if (ownership_type == "JOIN")
           {
               text = "SHOW OTHERS";
           }
           else
           {
               text = "";
           }
           return text;
       }

You can easyly done it in this way



Text='<%# ( ((string)Eval("OWNERSHIP_TYPE"))=="JOIN" ) ? "SHOW OTHERS" : "" %>'

How to get grideview click row index

2009-01-02T01:34:00.000-08:00

This example

• When you click the link pass the index value
• Then cacth it in another page and
• access values in Dataset


This example

•    When you click the link pass the index value
•    Then cacth it in another page and
•     access values in Dataset

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Increase")
{
int index = Convert.ToInt32(e.CommandArgument);
//catch THE ="<%# ((GridViewRow) Container).RowIndex %>" VALUE
Label1.Text = index.ToString();
String val = GridView1.Rows[index].Cells[0].Text.ToString();
Label1.Text += " cell value is-" + val;
val = GridView1.Rows[index].Cells[1].Text.ToString();
string App_Type=GridView1.DataKeys[index].Values[0].ToString();
Label1.Text += " \n-(data key is)MOVIE ID -" + App_Type;
}
}

This code in Gridview link button

ASP Databinding

2008-12-18T18:45:00.000-08:00


































· This is important part you can use CommandArgument and CommandName for parse data.











asp:LinkButton>



ItemTemplate>



asp:TemplateField>



Columns>



asp:GridView>



asp:Label>







GridView3.DataSource = ds;



GridView3.DataBind();



protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e) {



String index= e.CommandArgument.ToString();



Label2.Text = index;



//String x= GridView3.DataKeyNames.ElementAt(Int32.Parse(index)); }



Another way to get commandArgument or commandName



LinkButton l = (LinkButton)e.CommandSource;



string ll = l.Text;



if (string.Compare(e.CommandName, "owner_id", true) == 0)



{



String ownerId = e.CommandArgument.ToString();



Session["ownerId"] = ownerId;



setOwnerDetails(ownerId);



}









2008.12.18



sankadilmadu@gmail.com/sankadil@gmail.com



Parsing values through commandArgument and ????????????













<%--Eval("FileName", "images/{0}")--%>











CommandName="branch_name" Text='<%# BIND("branch_name") %>'>asp:LinkButton>



ItemTemplate>



asp:TemplateField>







































CommandName="branch_code" Text='<%# BIND("branch_code") %>'>asp:LinkButton>



asp:Label>



ItemTemplate>



asp:TemplateField>



Columns>



asp:GridView>



protected void GridView3_RowCommand(object sender, GridViewCommandEventArgs e)



{



if (e.CommandName == "branch_name")



{



String index= e.CommandArgument.ToString();



Label2.Text ="branch_name :"+ index;



}



if (e.CommandName == "branch_code")



{



String index = e.CommandArgument.ToString();



Label2.Text ="branch_code :"+ index;



}



}



protected void GridView3_PageIndexChanging(object sender, GridViewPageEventArgs e)



{



GridView3.PageIndex = e.NewPageIndex;



Label2.Text = GridView3.PageIndex.ToString();



DataSet ds = (DataSet)Session["ds"];



GridView3.DataSource = ds;



GridView3.DataBind();



}

AJAX with JAVA struts by Sanka Dilmadu Senavirathna

2008-12-08T19:16:00.000-08:00

input.jsp

BODY

BODY
html:html

InputAction.java

package ajaxandstrutsweb.actions;

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

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import ajaxandstrutsweb.forms.InputForm;

/**
* @version  1.0
* @author
*/
public class InputAction extends Action {

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

  ActionErrors errors = new ActionErrors();
  ActionForward forward = new ActionForward(); // return value
  InputForm inputForm = (InputForm) form;

  try {
  String txt=inputForm.getTxt();
  HttpSession s=request.getSession(true);
  s.setAttribute("txt",txt);
  
   // do something here

  } catch (Exception e) {

   // Report the error using the appropriate name and ID.
   errors.add("name", new ActionError("id"));

  }

  // If a message is required, save the specified key(s)
  // into the request for use by the  tag.

  if (!errors.isEmpty()) {
   saveErrors(request, errors);
  }
  // Write logic determining how the user should be forwarded.
  forward = mapping.findForward("InputAction");

  // Finish with
  return (forward);

 }
}

output.jsp

var xmlHttp

function showHint(str)
{
if (str.length==0)
{
document.getElementById("txtHint").innerHTML=""
return
}
xmlHttp=GetXmlHttpObject()
if (xmlHttp==null)
{
alert ("Browser does not support HTTP Request")
return
}
var url="output.jsp"
url=url+"?q="+str
url=url+"&sid="+Math.random()
xmlHttp.onreadystatechange=stateChanged
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}

function stateChanged()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
document.getElementById("txtHint").innerHTML=xmlHttp.responseText
}
}

function GetXmlHttpObject()
{
var objXMLHttp=null
if (window.XMLHttpRequest)
{
objXMLHttp=new XMLHttpRequest()
}
else if (window.ActiveXObject)
{
objXMLHttp=new ActiveXObject("Microsoft.XMLHTTP")
}
return objXMLHttp
}

HOW TO SEND SMS IN .C#.NET

2008-12-06T08:42:00.000-08:00

this is a vbs file but u can run it in c# action. Option Explicit


// create by sanka
Dim objGsmProtocol, objSmsMessage, objConstants, objDeliveryStatus
Dim strPin, strReference
Dim bContinueQueryStatus

Set objGsmProtocol          = CreateObject ( "ActiveXperts.SmsProtocolGsm" )
Set objSmsMessage           = CreateObject ( "ActiveXperts.SmsMessage" )
Set objConstants            = CreateObject ( "ActiveXperts.SmsConstants" )



objGsmProtocol.Device       = AskDevice( objGsmProtocol )

objSmsMessage.Clear
objSmsMessage.Recipient        = "+94713331611"
objSmsMessage.Format           = objConstants.asMESSAGEFORMAT_UNICODE  
objSmsMessage.Data             = "Tree ID:- GP001     Your Tree is added to tree sharemarket.. -GreenPlease-"
objSmsMessage.ValidityPeriod   = 0                         

objSmsMessage.Format           = objConstants.asMESSAGEFORMAT_TEXT  

strReference               = objGsmProtocol.Send( objSmsMessage )

If( objGsmProtocol.LastError <> 0 ) Then
 WScript.Quit
End If 



' ***************************************************************************
' Function AskDevice
' ***************************************************************************
Function AskDevice( objDevice )
  Dim strMessage, strDevice, strDefaultDevice, i, n
 
 ' n              = objDevice.GetDeviceCount()
  'strMessage     = "*** Enter one of the following device names *** " & vbCrLf & vbCrLf
  'For i = 0 To n - 1
  '   strMessage = strMessage & objDevice.GetDevice( i )
  '   strMessage = strMessage & vbCrLf
  'Next
  'strMessage     = strMessage & "COM1" & vbCrLf & "COM2" & vbCrLf & "COM3" & vbCrLf & "COM4" & vbCrLf
 
  'If( n > 0 ) Then
  '   strDefaultDevice = objDevice.GetDevice( 0 )
 ' Else
     strDefaultDevice = "COM1"
 ' End If
 ' Do
 '    strDevice = InputBox( strMessage, "Input", strDefaultDevice )
 ' Loop until strDevice <> ""
 
  AskDevice = "COM1"    'strDevice
End Function


' ***************************************************************************
' Function ReadInput
' ***************************************************************************
Function ReadInput( ByVal strTitle, ByVal strDefault, ByVal bAllowEmpty )

  Dim strInput, strReturn
 
  Do
     strInput = inputbox( strTitle, "Enter value", strDefault )
     If ( strInput <> "" ) Then
        strReturn = strInput
     End If
  Loop until strReturn <> "" Or bAllowEmpty
 
  ReadInput = strReturn
End Function

// create by sanka

AND WRITE THIS IN ur c# code btn action

System.Diagnostics.Process.Start("C:/Program Files/Internet Explorer/IEXPLORE.EXE");

This is ASP .net cording for Databinding Database connection Gride view bata binding

2008-12-06T08:14:00.000-08:00

<br><br>ASP.NET document for cording <br></span>Usercount programe<span style="color: rgb(51, 255, 255);"><br></span>First u hv to create Global.asax file<span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"> </span><span style="color: rgb(51, 255, 255);"><br></span>Then add this code for web pages partial class<span style="color: rgb(51, 255, 255);"><br></span>    protected void Page_Load(object sender, EventArgs e)<span style="color: rgb(51, 255, 255);"><br></span>    {<span style="color: rgb(51, 255, 255);"><br></span>        if (Page.IsPostBack == false)<span style="color: rgb(51, 255, 255);"><br></span>        {<span style="color: rgb(51, 255, 255);"><br></span>            TextBox1.Text = "";<span style="color: rgb(51, 255, 255);"><br></span>            Page.Response.Write("userCount is :"+Application.Get("userCount").ToString());<span style="color: rgb(51, 255, 255);"><br></span>        }<span style="color: rgb(51, 255, 255);"><br></span>    }<span style="color: rgb(51, 255, 255);"><br></span>    protected void Button1_Click(object sender, EventArgs e)<span style="color: rgb(51, 255, 255);"><br></span>    {<span style="color: rgb(51, 255, 255);"><br></span>        TextBox2.Text = TextBox1.Text;<span style="color: rgb(51, 255, 255);"><br></span>    }<span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">}</span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"> </span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span>State of application <span style="color: rgb(51, 255, 255);"><br></span>    protected void Page_Load(object sender, EventArgs e)<span style="color: rgb(51, 255, 255);"><br></span>    {<span style="color: rgb(51, 255, 255);"><br></span>        if (Page.IsPostBack == false)<span style="color: rgb(51, 255, 255);"><br></span>        {<span style="color: rgb(51, 255, 255);"><br></span>            ViewState.Add("viewState", "hello world");<span style="color: rgb(51, 255, 255);"><br></span>        }<span style="color: rgb(51, 255, 255);"><br></span>    }<span style="color: rgb(51, 255, 255);"><br></span>    protected void Button1_Click(object sender, EventArgs e)<span style="color: rgb(51, 255, 255);"><br></span>    {<span style="color: rgb(51, 255, 255);"><br></span>        resultLabel.Text = ViewState["viewState"].ToString();<span style="color: rgb(51, 255, 255);"><br></span>    }<span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span>State of Application<span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span>-----------------------------------------------------------------------------<span style="color: rgb(51, 255, 255);"><br></span>Global.aspx file<span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span>    void Session_Start(object sender, EventArgs e) <span style="color: rgb(51, 255, 255);"><br></span>    {       <span style="color: rgb(51, 255, 255);"><br></span>        Session.Add("someValue", Session.SessionID); }<span style="color: rgb(51, 255, 255);"><br></span>Page behind class file<span style="color: rgb(51, 255, 255);"><br></span>  <span style="color: rgb(51, 255, 255);"><br></span>  protected void Button1_Click(object sender, EventArgs e)<span style="color: rgb(51, 255, 255);"><br></span>    {<span style="color: rgb(51, 255, 255);"><br></span>       resultLabel.Text = Session["someValue"].ToString();<span style="color: rgb(51, 255, 255);"><br></span>    }<span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span>Add this code to web.config file<span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">    </span><anonymousidentification enabled="true"><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">    </span><profile enabled="true"><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">      </span><properties><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">        </span><add name="MyNewProperty" allowanonymous="true"><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span>         <span style="color: rgb(51, 255, 255);"><br></span>    <span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span>    protected void Page_Load(object sender, EventArgs e)<span style="color: rgb(51, 255, 255);"><br></span>    {<span style="color: rgb(51, 255, 255);"><br></span>        if (Page.IsPostBack == false)<span style="color: rgb(51, 255, 255);"><br></span>        {<span style="color: rgb(51, 255, 255);"><br></span>            Profile.MyNewProperty = "red";<span style="color: rgb(51, 255, 255);"><br></span>        }<span style="color: rgb(51, 255, 255);"><br></span>    }<span style="color: rgb(51, 255, 255);"><br></span>    protected void Button1_Click(object sender, EventArgs e)<span style="color: rgb(51, 255, 255);"><br></span>    {<span style="color: rgb(51, 255, 255);"><br></span>        resultLabel.Text = Profile.MyNewProperty;<span style="color: rgb(51, 255, 255);"><br></span>    }    <span style="color: rgb(51, 255, 255);"><br></span>Retrieving the query string <span style="color: rgb(51, 255, 255);"><br></span>       TextBox1.Text = Request["name"].ToString();<span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span> If button postback url set :<span style="color: rgb(51, 255, 255);"><br></span> Label1.Text = Request["TextBox1"].ToString();<span style="color: rgb(51, 255, 255);"><br></span>   <span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span>  Parsing variable page to page <span style="color: rgb(51, 255, 255);"><br></span>      Session.Add("name", submitName.Text);<span style="color: rgb(51, 255, 255);"><br></span>        Response.Redirect("Default2.aspx?name=" + submitName.Text + "&country=" + DropDownList1.Text);<span style="color: rgb(51, 255, 255);"><br></span>    }<span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span>    protected void Page_Load(object sender, EventArgs e)<span style="color: rgb(51, 255, 255);"><br></span>    {<span style="color: rgb(51, 255, 255);"><br></span>        String name = Request["name"].ToString();<span style="color: rgb(51, 255, 255);"><br></span>        String country = Request["country"].ToString();<span style="color: rgb(51, 255, 255);"><br></span>        String country = Request.QueryString["country"];<span style="color: rgb(51, 255, 255);"><br></span>        Request.QueryString["name"];<span style="color: rgb(51, 255, 255);"><br></span>       String Session_name="kohomada..ithin.."+(String)Session["name"];<span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">       Label1.Text = "name :" + name + " </span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">  country is :" + country + "</span><span style="color: rgb(51, 255, 255);"><br></span> name : " + Session_name;<span style="color: rgb(51, 255, 255);"><br></span>    }<span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span>ASP.NET DataBinding to grid view<span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">            </span><asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring=""><span style="color: rgb(51, 255, 255);">"</span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">            SelectCommand="SELECT * FROM [Items]"></span></asp:sqldatasource><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">    </span><div><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">        </span><asp:gridview runat="server" autogeneratecolumns="False"><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">            </span><columns><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">                </span><asp:templatefield><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">                    </span><itemtemplate><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">                         </span><asp:button runat="server" postbackurl="'<%#">' Text='<%# Bind("url") %>' /><span style="color: rgb(51, 255, 255);"><br></span>                    <span style="color: rgb(51, 255, 255);"><br></span>                <span style="color: rgb(51, 255, 255);"><br></span>            <span style="color: rgb(51, 255, 255);"><br></span>        <span style="color: rgb(51, 255, 255);"><br></span>    <span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);">    </span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span><span style="color: rgb(51, 255, 255);"></span><span style="color: rgb(51, 255, 255);"><br></span>    protected void Page_Load(object sender, EventArgs e)<span style="color: rgb(51, 255, 255);"><br></span>    {<span style="color: rgb(51, 255, 255);"><br></span>        DataSet ds = null;<span style="color: rgb(51, 255, 255);"><br></span>        string sqlQuery = "select Name, url from items";<span style="color: rgb(51, 255, 255);"><br></span>        DataAccess dac = new DataAccess();<span style="color: rgb(51, 255, 255);"><br></span>        dac.OpenDBConnection();<span style="color: rgb(51, 255, 255);"><br></span>        ds = dac.Retrive(sqlQuery);<span style="color: rgb(51, 255, 255);"><br></span>        dac.CloseDBConnection();<span style="color: rgb(51, 255, 255);"><br></span>        GridView1.DataSource = ds;<span style="color: rgb(51, 255, 255);"><br></span>        GridView1.DataBind();<span style="color: rgb(51, 255, 255);"><br></span><p><span style="color: rgb(51, 255, 255);">    }</span></p></asp:button></itemtemplate></asp:templatefield></columns></asp:gridview></div></add></properties></profile></anonymousidentification><span style="color: rgb(0, 153, 0);"><anonymousidentification enabled="true"><profile enabled="true"><properties><add name="MyNewProperty" allowanonymous="true"></add></properties></profile></anonymousidentification></span><div><asp:gridview runat="server" autogeneratecolumns="False"><columns><asp:templatefield><itemtemplate><asp:button runat="server" postbackurl="'<%#"><p><span style="color: rgb(0, 153, 0);"><span style="color: rgb(0, 153, 0);"><br></span></span></p><span style="color: rgb(0, 153, 0);"><span style="font-size:180%;"><span style="color: rgb(51, 51, 255);"> ASP.NET DataBinding to grid view</span></span><span style="color: rgb(204, 0, 0);"><br><br>            <asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="">"<br>            SelectCommand="SELECT * FROM [Items]"></asp:sqldatasource><br>    <div><br>        <asp:gridview runat="server" autogeneratecolumns="False"><br>            <columns><br>                <asp:templatefield><br>                    <itemtemplate><br>                         <asp:button runat="server" postbackurl="'<%#">' Text='<%# Bind("url") %>' /><br>                 <br>             <br>         <br>     <br>   <br> <br><br></asp:button></itemtemplate></asp:templatefield></columns></asp:gridview><span style="color: rgb(255, 204, 51);"><asp:gridview runat="server" autogeneratecolumns="False"><columns><asp:templatefield><itemtemplate><asp:button runat="server" postbackurl="'<%#">     protected void Page_Load(object sender, EventArgs e)<br>    {<br>        DataSet ds = null;<br>        string sqlQuery = "select Name, url from items";<br>        DataAccess dac = new DataAccess();<br>        dac.OpenDBConnection();<br>        ds = dac.Retrive(sqlQuery);<br>        dac.CloseDBConnection();<br>        GridView1.DataSource = ds;<br>        GridView1.DataBind();<br>    }</asp:button></itemtemplate></asp:templatefield></columns></asp:gridview></span><asp:gridview runat="server" autogeneratecolumns="False"><columns><asp:templatefield><itemtemplate><asp:button runat="server" postbackurl="'<%#"><br><p><span style="color: rgb(204, 0, 0);"> </span></p><p><br></p></asp:button></itemtemplate></asp:templatefield></columns></asp:gridview></div></span></span></asp:button></itemtemplate></asp:templatefield></columns></asp:gridview></div><span style="color: rgb(0, 153, 0);"></span><anonymousidentification enabled="true"><profile enabled="true"><properties><add name="MyNewProperty" allowanonymous="true"><div><asp:gridview id="GridView1" runat="server" autogeneratecolumns="False"><columns><asp:templatefield><itemtemplate><asp:button id="Button1" runat="server" postbackurl="'<%#"><div><asp:gridview id="GridView1" runat="server" autogeneratecolumns="False"><columns><asp:templatefield><itemtemplate><asp:button id="Button1" runat="server" postbackurl="'<%#"><span style="font-size:180%;"><strong><span style="color: rgb(255, 255, 204);">this is Database conection class for sql</span></strong></span><span style="color: rgb(255, 255, 204);"></span><span style="color: rgb(255, 255, 204);"><br></span>using System;<span style="color: rgb(255, 255, 204);"><br></span>using System.Data;<span style="color: rgb(255, 255, 204);"><br></span>using System.Configuration;<span style="color: rgb(255, 255, 204);"><br></span>using System.Web;<span style="color: rgb(255, 255, 204);"><br></span>using System.Web.Security;<span style="color: rgb(255, 255, 204);"><br></span>using System.Web.UI;<span style="color: rgb(255, 255, 204);"><br></span>using System.Web.UI.WebControls;<span style="color: rgb(255, 255, 204);"><br></span>using System.Web.UI.WebControls.WebParts;<span style="color: rgb(255, 255, 204);"><br></span>using System.Web.UI.HtmlControls;<span style="color: rgb(255, 255, 204);"><br></span>using System.Data.SqlClient;<span style="color: rgb(255, 255, 204);"><br></span><span style="color: rgb(255, 255, 204);"></span><span style="color: rgb(255, 255, 204);"><br></span>public class DataAccess<span style="color: rgb(255, 255, 204);"><br></span><span style="color: rgb(255, 255, 204);">{</span><span style="color: rgb(255, 255, 204);"><br></span><span style="color: rgb(255, 255, 204);"></span><span style="color: rgb(255, 255, 204);"><br></span>    private SqlConnection sqlConn = null;<span style="color: rgb(255, 255, 204);"><br></span>    private SqlCommand sqlComm = null;<span style="color: rgb(255, 255, 204);"><br></span>    private SqlDataAdapter sqlAdp = null;<span style="color: rgb(255, 255, 204);"><br></span><span style="color: rgb(255, 255, 204);"></span><span style="color: rgb(255, 255, 204);"><br></span>    public DataAccess()<span style="color: rgb(255, 255, 204);"><br></span>    {<span style="color: rgb(255, 255, 204);"><br></span><span style="color: rgb(255, 255, 204);"></span><span style="color: rgb(255, 255, 204);"><br></span>    }<span style="color: rgb(255, 255, 204);"><br></span>    public DataSet Retrive(string sqlQuery)<span style="color: rgb(255, 255, 204);"><br></span>    {<span style="color: rgb(255, 255, 204);"><br></span>        DataSet ds = new DataSet();<span style="color: rgb(255, 255, 204);"><br></span><span style="color: rgb(255, 255, 204);"></span><span style="color: rgb(255, 255, 204);"><br></span>        sqlComm = new SqlCommand(sqlQuery, sqlConn);<span style="color: rgb(255, 255, 204);"><br></span>        sqlComm.CommandType = CommandType.Text;<span style="color: rgb(255, 255, 204);"><br></span><span style="color: rgb(255, 255, 204);"></span><span style="color: rgb(255, 255, 204);"><br></span>        sqlAdp = new SqlDataAdapter(sqlComm);<span style="color: rgb(255, 255, 204);"><br></span>        try<span style="color: rgb(255, 255, 204);"><br></span>        {<span style="color: rgb(255, 255, 204);"><br></span>            sqlAdp.Fill(ds);<span style="color: rgb(255, 255, 204);"><br></span><span style="color: rgb(255, 255, 204);"></span><span style="color: rgb(255, 255, 204);"><br></span>        }<span style="color: rgb(255, 255, 204);"><br></span>        catch (Exception e)<span style="color: rgb(255, 255, 204);"><br></span>        {<span style="color: rgb(255, 255, 204);"><br></span>        }<span style="color: rgb(255, 255, 204);"><br></span>        return ds;<span style="color: rgb(255, 255, 204);"><br></span>    }<span style="color: rgb(255, 255, 204);"><br></span>    public int Update(string sqlQuery)<span style="color: rgb(255, 255, 204);"><br></span>    {<span style="color: rgb(255, 255, 204);"><br></span>        sqlComm = new SqlCommand(sqlQuery, sqlConn);<span style="color: rgb(255, 255, 204);"><br></span>        sqlComm.CommandType = CommandType.Text;<span style="color: rgb(255, 255, 204);"><br></span>        int update = sqlComm.ExecuteNonQuery();<span style="color: rgb(255, 255, 204);"><br></span>        return update;<span style="color: rgb(255, 255, 204);"><br></span>    }<span style="color: rgb(255, 255, 204);"><br></span><span style="color: rgb(255, 255, 204);"></span><span style="color: rgb(255, 255, 204);"><br></span>    public void OpenDBConnection()<span style="color: rgb(255, 255, 204);"><br></span>    {<span style="color: rgb(255, 255, 204);"><br></span>        sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());<span style="color: rgb(255, 255, 204);"><br></span>        sqlConn.Open();<span style="color: rgb(255, 255, 204);"><br></span>    }<span style="color: rgb(255, 255, 204);"><br></span><span style="color: rgb(255, 255, 204);"></span><span style="color: rgb(255, 255, 204);"><br></span><span style="color: rgb(255, 255, 204);"></span><span style="color: rgb(255, 255, 204);"><br></span><span style="color: rgb(255, 255, 204);"></span><span style="color: rgb(255, 255, 204);"><br></span>    public void CloseDBConnection()<span style="color: rgb(255, 255, 204);"><br></span>    {<span style="color: rgb(255, 255, 204);"><br></span>        if (ConnectionState.Open == sqlConn.State)<span style="color: rgb(255, 255, 204);"><br></span>        {<span style="color: rgb(255, 255, 204);"><br></span>            sqlConn.Close();<span style="color: rgb(255, 255, 204);"><br></span>        }<span style="color: rgb(255, 255, 204);"><br></span>    }<span style="color: rgb(255, 255, 204);"><br></span><p><span style="color: rgb(255, 255, 204);">}</span></p><span style="color: rgb(0, 153, 0);"><anonymousidentification enabled="true"><profile enabled="true"><properties><add name="MyNewProperty" allowanonymous="true"></add></properties></profile></anonymousidentification></span><div><asp:gridview runat="server" autogeneratecolumns="False"><columns><asp:templatefield><itemtemplate><asp:button runat="server" postbackurl="'<%#"><span style="color: rgb(0, 153, 0);"><span style="color: rgb(204, 0, 0);"><div><asp:gridview runat="server" autogeneratecolumns="False"><columns><asp:templatefield><itemtemplate><asp:button runat="server" postbackurl="'<%#"><p><span style="color: rgb(204, 153, 51);"><span style="font-size:180%;">this is connection class for oracle</span></span><span style="color: rgb(153, 51, 153);"><br></span></p></asp:button></itemtemplate></asp:templatefield></columns></asp:gridview><span style="color: rgb(255, 255, 51);"><asp:gridview runat="server" autogeneratecolumns="False"><columns><asp:templatefield><itemtemplate><asp:button runat="server" postbackurl="'<%#">using System;<br>using System.Data;<br>using System.Configuration;<br>using System.Linq;<br>using System.Web;<br>using System.Web.Security;<br>using System.Web.UI;<br>using System.Web.UI.HtmlControls;<br>using System.Web.UI.WebControls;<br>using System.Web.UI.WebControls.WebParts;<br>using System.Xml.Linq;<br>using System.Data.OleDb;<br>namespace ARMS.levelBusiness.dbCLasses<br>{<br>    public class Cntion<br>    {<br>        public static OleDbConnection setConnectionDb()<br>        {<br>            OleDbConnection con = new OleDbConnection();<br>            con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();<br>            //con.ConnectionString = Global.ConnectionStringDB.ToString();<br>            return con;<br>        }<br>        public static OleDbConnection setConnectionUpmDb()<br>        {<br>            OleDbConnection con = new OleDbConnection();<br>            con.ConnectionString = Global.ConnectionStringUPM.ToString();<br>            return con;<br>        }<br>        public static void removeConnectionDb(OleDbConnection con, OleDbDataReader dr)<br>        {<br>            con.Close();<br>            dr.Close();<br>        }<br>    }<br>}</asp:button></itemtemplate></asp:templatefield></columns></asp:gridview></span><asp:gridview runat="server" autogeneratecolumns="False"><columns><asp:templatefield><itemtemplate><asp:button runat="server" postbackurl="'<%#"><br><br><br><br><br><br><br><br><br><p><span style="color: rgb(153, 51, 153);"><br></span></p></asp:button></itemtemplate></asp:templatefield></columns></asp:gridview></div></span></span></asp:button></itemtemplate></asp:templatefield></columns></asp:gridview></div></asp:button></itemtemplate></asp:templatefield></columns><span style="color: rgb(0, 153, 0);"></span></asp:gridview></div></asp:button></itemtemplate></asp:templatefield></columns></asp:gridview></div></add></properties></profile></anonymousidentification><br><br><br><br><br>

EJB and servlet example

2008-07-20T23:52:00.000-07:00

This compleat EJB example

package pack;
import ....*;
public class firstBeanBean implements javax.ejb.SessionBean {  
private javax.ejb.SessionContext mySessionCtx;
//-------------------------------------------------------------------------
private Connection CreateCon() {
Connection con = null;
try {
 InitialContext ic = new InitialContext();
 DataSource ds = (DataSource) ic.lookup("jdbc/tutapn");
 con = ds.getConnection();
 System.out.println("Connection to tutorialApn Successfull");
} catch (NamingException e) {
 e.printStackTrace();
 System.out.println("Connection to tutorialApn UNSuccessfull");
} catch (SQLException e) {
 // TODO Auto-generated catch block
 e.printStackTrace();
 System.out.println("Connection to tutorialApn UNSuccessfull");
}
return con;
}
//-------------------------------------------------------------
 private Connection CreateConnection1(){
   Connection con=null;
  try{
  InitialContext ic=new InitialContext();
  DataSource ds=(DataSource)ic.lookup("jdbc/tutapn");
  con=ds.getConnection();
  System.out.println("Connection to tutorialapn is successful");
  }catch(Exception ex){
   ex.printStackTrace();
   System.out.println("Connection to tutorialapn is unsuccessful");
  }
  return con;
  }
//---------------------------------------------------------------------------
public Vector getMovie() {
Vector v = new Vector();
Connection con = CreateCon();
PreparedStatement ps = null;
ResultSet rs = null;
String name = "";
String status = "";
String movie_id = "";
try {
 ps =con.prepareStatement("SELECT * From movies");
 //ps.setString(1, id);
 rs = ps.executeQuery();
 while (rs.next()) {  
  Result res=new Result();
  name = rs.getString("name");
  movie_id = rs.getString("movie_id");
  status = rs.getString("status");  
 res.setN1(name);
 res.setN2(movie_id);
 res.setN3(status);
 v.add(res);  
 System.out.println("vector is : "+v);
 System.out.println("vector size is : "+v.size()); 
 }
} catch (Exception ex) {
 ex.printStackTrace();
} finally {
 CloseAll(con, rs, ps);
}
return v;
} 
//---------------------------------------------------------------------------

 public String getMovie1(String id){
  Connection conc = CreateCon();
  PreparedStatement ps = null;
  ResultSet rs =null;
  String name = ""; 
  try{
   ps = conc.prepareStatement("select name from movies where movie_id = ? ");
   //ps = conc.prepareStatement("select name from movies whe");
   ps.setString(1,id);
   rs = ps.executeQuery();
   //Vector v = new Vector();
   while (rs.next()){
    //Reso ress = new Reso();
    name = rs.getString("name");
    //v.addElement(rs.getString("name"));
    //System.out.println(v);
   }
  }
  catch(Exception ex){
   ex.printStackTrace();
  }
  finally{
   CloseAll(conc,rs,ps);
  }
  return name; 
 }
//-------------------------------------------------------------------------
 private boolean CloseAll(Connection con,ResultSet rs,PreparedStatement st)
 {
  boolean closed = true;
  try {
   st.close();
  } catch (Exception ex) {
   ex.printStackTrace();
   System.out.println("Connection not closed properly");
   closed = false;
  }
  try {
   rs.close();
  } catch (Exception ex) {
   ex.printStackTrace();
   System.out.println("Connection not closed properly");
   closed = false;
  }
  try {
   con.close();
  } catch (Exception ex) {
   ex.printStackTrace();
   System.out.println("Connection not closed properly");
   closed = false;
  }
  return closed;
 }

}



This is Remote interface

<br>package pack;<br>import java.rmi.RemoteException;<br>import java.util.Vector;<br>public interface firstBean extends javax.ejb.EJBObject {<br> public Vector getMovie() throws RemoteException;<br> public String getMovie1(String id)throws RemoteException;<br>}<br></pre><br><br><p>This is Result.java bean class</p><br><pre class="brush:java;"><br>package pack;<br>import java.io.Serializable;<br>public class Result implements Serializable {<br> <br>private String n1=null;<br>private String n2=null;<br>private String n3=null;<br><br>public String getN1() {<br> return n1;<br>}<br>public String getN2() {<br> return n2;<br>}<br>public String getN3() {<br> return n3;<br>}<br>public void setN1(String string) {<br> n1 = string;<br>}<br>public void setN2(String string) {<br> n2 = string;<br>}<br>public void setN3(String string) {<br> n3 = string;<br>}<br>}<br></pre><br><br><br><p>This is ServiceLocator.java class</p><br><pre class="brush: java;"><br>package common;<br>import javax.naming.InitialContext;<br>import javax.rmi.PortableRemoteObject;<br>import pack.firstBean;<br>import pack.firstBeanHome;<br>public class ServiceLocator {<br>public firstBean setFirstBean(){<br> firstBeanHome sHome;<br> firstBean sRemote=null;<br><br>try{<br>InitialContext ic=new InitialContext();<br>Object ob=ic.lookup("ejb/pack/firstBeanHome");<br>sHome=(firstBeanHome)PortableRemoteObject.narrow(ob,firstBeanHome.class);<br>sRemote=sHome.create();<br>}<br>catch(Exception ex){<br>ex.printStackTrace();<br>}<br>return sRemote;<br>}<br>}<br></pre><br><br><p>This is servlet get EJB by using service Locator</p><br><br><pre class="brush: java;"><br>package mypack;<br>import java.io.IOException;<br>import java.util.Vector;<br>import javax.servlet.ServletException;<br>import javax.servlet.http.HttpServlet;<br>import javax.servlet.http.HttpServletRequest;<br>import javax.servlet.http.HttpServletResponse;<br>import javax.servlet.http.HttpSession;<br>import common.ServiceLocator;<br>public class page1servlet extends HttpServlet {<br> public void doGet(HttpServletRequest req, HttpServletResponse resp)<br>  throws ServletException, IOException {<br>   doAction(req,resp);<br> }<br> public void doPost(HttpServletRequest req, HttpServletResponse resp)<br>  throws ServletException, IOException {<br>   doAction(req,resp);<br> }<br> public void doAction(HttpServletRequest req, HttpServletResponse resp)<br>  throws ServletException, IOException {   <br>   HttpSession se=req.getSession(true);<br>   //se.setAttribute("userid",userid);<br>   //resp.sendRedirect("second.jsp");<br>   ServiceLocator s=new ServiceLocator();<br>   Vector v=s.setFirstBean().getMovie();   <br>   se.setAttribute("film",v);<br>   resp.sendRedirect("page2.jsp");   <br>   System.out.println(v);<br>   <br> }<br>}<br><br></pre><br><br></p>

Crystal Report for Java Ecplise

2007-10-04T09:00:00.000-07:00

Crystal report for java eclipse
Click here to go in details tutorial with screen shots.

This article contain the following topics
Crystal report project facets enable in eclipse
Insert Picture to report/Dynamic image support in crystal report
Add conditional formula to image-->graphic location
sample :

Record Filter
Picture : Graphic Location
{Area.Area}

Add two POJO into report.

Multiple datasource report
Go-->Ecplice Project Explorer-->Databinding POJO --> expand it and click on "C" green color class mark-->then right click on it--> add to new report or existing report.

In JSP page access the Spring service

WebApplicationContext wac = WebApplicationContextUtils.getRequiredWebApplicationContext(this.getServletContext());
AreaService srv = (AreaService) wac.getBean("areaServiceImpl");
CustomerService csrv = (CustomerService) wac.getBean("customerServiceImpl");

Retriving data from service

List lst= srv.list();
List lst1= csrv.list();

Set datasource into report

cRJavaHelper.passPOJO(clientDoc,lst, className, tableAlias, "");
cRJavaHelper.passPOJO(clientDoc,lst1, className2, tableAlias2, "");

Export report as PDF

cRJavaHelper.exportPDF(clientDoc, response, true);

JPA Access non mapped result

2007-06-26T02:57:00.000-07:00

JPA retrieving data without SqlResultsetMapping or Entity.
JPA Access non mapped result
reading data from native query +JPA
JPA iterating non mapped result set

JPA return non mapped result as list of object array.
that mean each an every cell is a object.
database table row===array
table column index===array index
tuple is a object array,each cell is an object.

JPQL Query

List rowList =em.createQuery("SELECT a.id,a.area,a.val FROM Area a").getResultList();
for(Object[] row : rowList){
 Integer col1 = (Integer) row[0];
 String col2 = (String) row[1];
 Integer col3 = (Integer) row[2];
 System.out.println("id:"+col1+" area:"+col2+" val:"+col3);
}

SQL Native Query

List rowList =em.createNativeQuery("SELECT * FROM AREA").getResultList();
for(Object[] row : rowList){
 Integer col1 = (Integer) row[0];
  String col2 = (String) row[1];
  Integer col3 = (Integer) row[2];
  System.out.println("col1:"+col1);
  System.out.println("col2:"+col2);
  System.out.println("col3:"+col3);
}

Sanka's Knowledge Repository

Future of Flex

Understanding EJB components

session in flex

spring flex sample application

SQL Injection Attacks and Defense In Java System

How to create flex component and best practices

NamedNativeQuery For Retriving Full Entity

Java SMS Send & Read With smslib

Send Message/SMS Code

Read Message/SMS Codes

Client Codes

NamedNativeQuery Code Example For Retriving Columns Or Part of Entity Using Entity

Read More

JPQL Union using SqlResultSetMapping

SqlResultSetMapping Simple Code Examples

Java + Crystal Report + Eclipse

My Favorite Ares

Spring BlazeDS Integration

EJB 2 & 3

Struts

Spring

Flex

Hibernate

Projects

HIbernate - JSP/Servlet Simple Example

hibernate-configuration file is as Following

Spring BlazeDS Integration

Spring BlazeDS Integration

2. Configuring the Spring DispatcherServlet

3. Configuring the MessageBroker in Spring

How to navigating through the Data using Flex form

How to navigating through the Data or ArrayCollection using Flex form

Send Email in Java

How to Access Spring Service From JSP/Servlet

Spring Service Call JSP/Servlet

Flex : How to calculate Datagrid column total

Flex Dynamically popup searchable Datagrid

Reinstall Ubuntu Grub Bootloader After Windows Wipes it Out

Reinstall Ubuntu Grub Bootloader After Windows Wipes it Out

Detect Prevent and Protect From Viruses

SBI Simple Code Example

EJB 3.0 to Servlet then Servlet to Flex

EJB 3.0 and Servlet client code with MySql and Glassfish server

Unit Test with JUnit

Free proxy servers

How to hacking Firefox users

Sanka's photos

Sanka's photos

Difference between String and StringBuilder

What is the difference between String and StringBuilder?

String Class

StringBuilder

Avoiding SQL Injection by sanka dilmadu

Avoiding SQL Injection

’, ‘’); drop table MyTable;--

So this is the solution for that

Gridview command argumnet and name usage

Gridview -command argumnet and name usage

Grid view command argumant and name usage

Grid view command argumant and name in data binding

Introduction to Sorting a Gridview,Introduction to sotring Dataset

Sorting

Downloads code exapmles

server side validation class for Email,NIC Telephone number in srilanka

Introduction to Logic Iterate Tag

Introduction to Logic Equal Tag

Introduction to Struts by hello world code example

How to work with Eval function / How to call a method from aspx page

How to get grideview click row index

ASP Databinding

AJAX with JAVA struts by Sanka Dilmadu Senavirathna

HOW TO SEND SMS IN .C#.NET

This is ASP .net cording for Databinding Database connection Gride view bata binding

EJB and servlet example

Crystal Report for Java Ecplise

JPA Access non mapped result