www.pudn.com > StoreJava.rar > DBCon.java

package com.bitc.store;  
//定义Bean所属的套件  
  
import java.io.*;  
import javax.servlet.http.*;   
import java.sql.*;  
  
//定义DBCon类别实做HttpSessionBindingListener介面  
public class DBCon implements HttpSessionBindingListener  
{  
	//与资料库连结有关的Bean属性  
	private Connection con = null;  
  
	public DBCon()  //在建构子中完成资料库连结  
	{  
		BulidConnection();  
		//建立资料库连结  
	}  
	  
	//建立资料库连结的方法  
	private void BulidConnection()  
	{  
		try{  
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
			//载入驱动程式类别  
	  
			con = DriverManager.getConnection("jdbc:odbc:StoreDB");  
			//建立资料库连线			  
		}  
		catch(Exception ex)  
		{	  
			System.out.println(ex.toString());  
		}		  
	}  
  
	//传出Connection物件的方法  
	public Connection getConnection()  
	{   
		//若con为null时, 重新建立资料库连结  
		if(con == null)  
			BulidConnection();  
  
		return this.con;  
	}	  
  
	public void close()  
	{  
		try{  
			con.close(); //关闭Connection物件					  
			con =  null;  
		}  
		catch(SQLException sex)  
		{	  
			System.out.println(sex.toString());  
		}	  
	}  
  
	//当物件加入session时, 将自动执行此函数  
	public void valueBound(HttpSessionBindingEvent event){}  
  
	//当session物件消灭时, 将自动执行此函数  
	public void valueUnbound(HttpSessionBindingEvent event)  
	{  
		if(con != null)  
			close(); //呼叫close方法  
	}  
}