程序代码：

package com.xh.jsp.dbc;
import java.sql.*;
public class DataBaseConnection
{
    private final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
    private final String DBURL="jdbc:sqlserver://localhost:1433;DatabaseName=person";
    private final String DBUSER="sa";
    private final String DBPASSWORD="123";
    Connection conn=null;
    public DataBaseConnection()
    {
        try
        {
            Class.forName(DRIVER);
            conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
        }
        catch (Exception ex)
        {
            System.out.println("数据库连接出错"+ex.toString());
        }
    }
    public Connection getConnection()
    {
        return this.conn;
    }
    public void closeConnection()
    {
        try
        {
            this.conn.close();
        }
        catch (Exception ex)
        {
            System.out.println("关闭数据库出错"+ex.toString());
        }
    }

}