defaultdbmanagerimpl.java

基于struts框架编写的在线考试系统

package examonline.service.impl;

import java.sql.SQLException;
import java.sql.Connection;
import javax.sql.DataSource;
import javax.servlet.http.*;
import examonline.service.*;
import org.apache.struts.action.*;
import org.apache.struts.config.*;
import javax.servlet.*;
import examonline.utils.*;


public class DefaultDBManagerImpl implements DBManager
{
  private static DataSource dataSource;
  private Connection conn;
  public DefaultDBManagerImpl()
  {
  }

  public void init(DataSource dataSource)
  {
    this.dataSource = dataSource;
  }

  public Connection openConnection()
  {
    try
    {
      if (dataSource != null)
        conn = dataSource.getConnection();
      if(conn!=null)
        conn.setAutoCommit(true);
    }
    catch (SQLException ex)
    {
      ex.printStackTrace();
    }
    finally
    {
      return conn;
    }
  }

  public void closeConnection()
  {
    try
    {
      if (conn != null)
        conn.close();
    }
    catch (SQLException ex)
    {
      ex.printStackTrace();
    }

  }

  public void destroy()
  {
    closeConnection();

  }

}