@@ -0,0 +1,2104 @@
+/*%0A * This file is part of Avocado, licensed under the MIT License (MIT).%0A *%0A * Copyright (c) 2016, Lexteam %3Chttp://www.lexteam.xyz/%3E%0A *%0A * Permission is hereby granted, free of charge, to any person obtaining a copy%0A * of this software and associated documentation files (the %22Software%22), to deal%0A * in the Software without restriction, including without limitation the rights%0A * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell%0A * copies of the Software, and to permit persons to whom the Software is%0A * furnished to do so, subject to the following conditions:%0A *%0A * The above copyright notice and this permission notice shall be included in%0A * all copies or substantial portions of the Software.%0A *%0A * THE SOFTWARE IS PROVIDED %22AS IS%22, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR%0A * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,%0A * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE%0A * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER%0A * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,%0A * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN%0A * THE SOFTWARE.%0A */%0Apackage xyz.lexteam.avocado.sql;%0A%0Aimport java.sql.Connection;%0Aimport java.sql.DriverManager;%0Aimport java.sql.SQLException;%0Aimport java.util.Optional;%0Aimport java.util.Properties;%0A%0A/**%0A * Utility class to create %7B@link Connection%7Ds.%0A */%0Apublic final class Connections %7B%0A%0A    public static Optional%3CConnection%3E newConnection(String host, int port, String database, String username,%0A            String password) %7B%0A        Properties connectionProps = new Properties();%0A        connectionProps.put(%22user%22, username);%0A        connectionProps.put(%22password%22, password);%0A%0A        try %7B%0A            return Optional.of(%0A                    DriverManager.getConnection(String.format(%22jdbc:mysql://%25s:%25s/%25s%22, host, port, database),%0A                            connectionProps));%0A        %7D catch (SQLException e) %7B%0A            e.printStackTrace();%0A            return Optional.empty();%0A        %7D%0A    %7D%0A%7D%0A

Add Connections utility