第二次数据库作业--Dbutil

package utils;

import java.sql.*;

/**
 * Created by yinus on 2016/4/4.
 */

public class Dbtuil {
    private static final String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
    private static final String dbURL="jdbc:sqlserver://localhost:port;DatabaseName=tableName";
    private static final String userName="usrName";
    private static final String userPwd="password";
    private static Connection connection = null;
    static{
        try {
            Class.forName(driverName);
            connection=DriverManager.getConnection(dbURL,userName,userPwd);
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    public static Connection getConnection(){
        return connection;
    }

    public static void close() throws SQLException {
        connection.close();
    }
}