package common;

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

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

public class JdbcUtil {
	private static Log log = LogFactory.getLog(JdbcUtil.class); 
	public static Connection getConnection() {
		
		Connection conn = null;
		try {

			Class.forName(Constants.DB_CLASS);
			conn = DriverManager.getConnection(Constants.DB_URL,Constants.DB_USER, Constants.DB_PASSWORD);
		} catch (SQLException e) {
			log.error(e);
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			log.fatal(e);
			e.printStackTrace();
		}
		return conn;
	}

	public static void CommitDb(Connection conn){
		try {
			conn.commit();
		} catch (SQLException e) {
			log.error(e);
			e.printStackTrace();
		}
	}
	
	public static void BackDb(Connection conn) {
		try {
			conn.rollback();
		} catch (SQLException e) {
			log.error(e);
			e.printStackTrace();
		}
	}

	public static void ShutDownDB(Connection conn) {
		try {
			conn.close();
		} catch (SQLException e) {
			log.error(e);
			e.printStackTrace();
		}
	}
}