Hi friend,


Java DAO Implementation
This tutorial shows, how to create the source code of Dao and DaoImpl class.
The Data Access Object (DAO) is an important component in business applications. 
Business applications almost always need access to data from relational or object databases and the Java platform offers many techniques for accessing this data. 
The Data Access Object design pattern provides a technique for separating object persistence and data access logic from any particular persistence mechanism or API.
The Java Database Connectivity (JDBC) API, provides the capability to execute SQL queries against a database and then fetch the results, one column at a time.
The Java DAO approach provides flexibility to change an application's persistence mechanism over time without the need to re-engineer application logic that interacts with the Data Access Object tier.
The Data Access Object design pattern also provides a simple, consistent API for data access that does not require knowledge of JDBC, EJB, Hibernate, or Spring interfaces.
Use a Data Access Object (DAO) to abstract and encapsulate all access to the data source. The DAO manages the connection with the data source to obtain and store data.

Source Code of Dao.java
package com.roseindia.portal.dao;

import org.springframework.transaction.annotation.Transactional;
import org.springframework.transaction.annotation.Propagation;

import java.util.List;

import com.roseindia.portal.model.*;

/**
 * @author Sandeep Kumar Suman
 */

@Transactional (propagation = Propagation.REQUIRED, readOnly = false)

public interface Dao{

    public List<Emp> findByName(String name);
    
  public void addEmp(Emp user);

  public void updateEmp(Emp chatEmp);

  public List<Emp> loginEmp(String username, String password);
  
  public void deleteEmp(Emp removeEmp);

}

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

Source Code of DaoImpl.java
package com.roseindia.portal.dao.impl;

import com.roseindia.portal.dao.*;
import javax.persistence.EntityTransaction;


import java.util.*;
import java.text.*;
import java.util.ArrayList;
import java.util.Collection;
import java.sql.*;

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

import com.roseindia.portal.dao.BaseDao;
import com.roseindia.portal.model.*;

import org.springframework.orm.jpa.vendor.HibernateJpaDialect;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.transaction.annotation.Propagation;

/**
* @author Sandeep Kumar Suman
*/

@Transactional (propagation = Propagation.REQUIRED, readOnly = false)
public class DaoImpl implements Dao {


public List<Emp> findByName(String name){
Query query = this.getEntityManager().createQuery("select u FROM
Emp u where u.userName='" + name +"'");
return query.getResultList();
}

private EntityManager entityManager;
/**
* Set the JPA EntityManager to use.
*/
@PersistenceContext
public void setEntityManager(EntityManager entityManager) {
this.entityManager = entityManager;
}

/**
* Return the JPA EntityManager to use.
*/
public EntityManager getEntityManager() {
return entityManager;
}

public void addEmp(Emp user){
this.getEntityManager().persist(user);
}

public void updateEmp(Emp user){
this.getEntityManager().merge(user);
}

public List<Emp> loginEmp(String username, String password){
System.out.println("Login Emp in Emp Service DAO");
Query query = this.getEntityManager().createQuery("select u FROM
Emp u where u.userName='" + username +"' and u.password='" + password +"'");
return query.getResultList();
}

public void deleteUser(User removeUser){
System.out.println("Removing User: "+removeUser.getFirstName());
this.getEntityManager().remove(removeUser);
}
}
---------------------------------------------------

Visit for more information:

http://www.roseindia.net/struts/struts2/

Thanks