package com.trendcom.base.util;

import java.sql.Connection;
import java.sql.SQLException;

import javax.sql.DataSource;

import org.hibernate.SessionFactory;
import org.springframework.orm.hibernate4.SessionFactoryUtils;
import org.springframework.web.context.ContextLoaderListener;

public class DataSourceUtil {

private static SessionFactory sessionFactory=null;
 
 static{  
  sessionFactory=(SessionFactory) ContextLoaderListener.getCurrentWebApplicationContext().getBean("sessionFactory");
 }

public static Connection getConnection(){
  try {
   return getDataSource().getConnection();
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return null;
 }

public static SessionFactory getSessionFactory() {
  return sessionFactory;
 }

public static void setSessionFactory(SessionFactory sessionFactory) {
  DataSourceUtil.sessionFactory = sessionFactory;
 }

private static DataSource getDataSource() {
  return SessionFactoryUtils.getDataSource(getSessionFactory());
 }

}