package com.am;
import java.sql.*;

public class OpenDB
{

    String userName="sa";
    String userPassword="111";
    private String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
    private String url = "jdbc:microsoft:sqlserver://localhost:1433;dataBaseName=test";

    Connection dbConn;
    public OpenDB()
    {

    }
    public Connection getConnection()
    {
        try
        {
            Class.forName(driverName).newInstance();
            dbConn=DriverManager.getConnection(url,userName,userPassword);
        }
        catch(Exception ex)
        {
            System.out.println(ex.toString());
            dbConn = null;
        }

        return dbConn;
    }

}