dbconnection.java~3~

JSP版的在线相册系统

package photo;
import java.io.*;
import javax.servlet.http.*;
import java.sql.*;

public class DBConnection implements HttpSessionBindingListener{

     //当变量加入Session时自动执行此函数
    public void valueBound(HttpSessionBindingEvent event){}
    //Session变量关闭时执行此函数
    public void valueUnbound(HttpSessionBindingEvent event) {}
    private Connection conn = null;
    public DBConnection()
    {
        //建立数据库链接
        BulidConnection();
    }
    //建立数据库链接的方法
    private void BulidConnection()
    {
        try
        {

         Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
         //加载数据库驱动程序
         String  url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=photo";
        //数据库连接串，photo为数据库的名称
       String  user="sa";
       String  password="mc";
       conn=DriverManager.getConnection(url,user,password);
        } catch(Exception ex)
        {
            System.out.println(ex.toString());
        }
    }
    public Connection getConnection()
    {
        //如果conn为null，则重新建立连接
        if(conn == null)
          BulidConnection();
        return conn;
    }
    public void close()
    {
        try
        {
            //关闭con
            conn.close();
            conn = null;
        } catch(SQLException ex){}
    }
}