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(); } }