JDBC SqlServer 连接

public class DBUtils {

    public Connection getConnection() throws ClassNotFoundException, SQLException {
        String url = "jdbc:sqlserver://localhost:1433;database=sale;trustServerCertificate=true"; // SQL Server地址及数据库名称
        String username = "root"; // SQL Server登录账号
        String password = "123456"; // SQL Server登录密码
        Connection conn = null;
        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); // 加载驱动程序
            conn = DriverManager.getConnection(url, username, password); // 获取数据库连接
        } catch (Exception e) {
            System.out.println("Error connecting to database.");
            e.printStackTrace();
        } finally {
            if (conn != null) {
                try {
                    conn.close(); // 关闭数据库连接
                } catch (SQLException ex) {
                    ex.printStackTrace();
                }
            }
        }
        return conn;
    }

    public void closeConnection(Connection connection) throws SQLException {
        if (connection != null)
            connection.close();
    }

    public static void main(String[] args) throws Exception {
        DBUtils dbUtils = new DBUtils();
        dbUtils.getConnection();
    }
}