package connection;
import java.io.Serializable;
import java.sql.*;

public class DbConn implements java.io.Serializable  //串行化單個連接類
{
  private Connection conn = null;//數據庫連接對象conn
  private boolean inuse = false;
  
  //構造函數
  public DbConn(){}
  public DbConn(Connection conn){
    if (conn!=null) this.conn = conn;
  }

  //獲取數據庫連接對象
  public Connection getConnection(){
    return conn;
  }
  
  //設置數據庫連接對象
  public void setConnection(Connection conn){
    this.conn = conn;
  }
  
  //設置連接的使用狀態
  public void setInuse(boolean inuse){
    this.inuse = inuse;
  }
  
  //獲取連接的使用狀態
  public boolean getInuse(){
    return inuse;
  }

  //關閉連接
  public void close(){
    try{
      conn.close();
    }catch (SQLException sqle){
      System.err.println(sqle.getMessage());
    }
  }
}