dbmanager.java

通过jsp,servlet,javaBean,三成架构实现的好友通讯录系统

package com.db;

import java.sql.*;

public class DBManager {
    private static Connection conn=null;
    private static String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
    private static String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=addressBook";
    public static Connection getConnetion()
    {
        try
        {
            Class.forName(driver);
            conn=java.sql.DriverManager.getConnection(url,"sa","sa");

        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return conn;
    }
}