Java examples for enum - yoss123/test-automation-repo GitHub Wiki

Example #1

import java.sql.DriverManager; // Maven dependency added for 'MariaDB Java Client'

public class SqlUtils {

    private static Connection dbConnection = null;

    public enum DatabaseConnData {
        QA_USERS("jdbc:mariadb://[server_host]/[database_name]", "userName", "pass"),
        QA_DATA("jdbc:mariadb://[server_host]/[database_name]", "userName", "pass"),
        DEV_USERS("jdbc:mariadb://[server_host]/[database_name]", "userName", "pass"),
        DEV_DATA("jdbc:mariadb://[server_host]/[database_name]", "userName", "pass");

        private String url;
        private String userName;
        private String pass;
        DatabaseConnData(String dbUrl, String userName, String pass) {
            this.url = dbUrl;
            this.userName = userName;
            this.pass = pass;
        }
        private String getUrl() { return url; }
        private String getUserName() { return userName; }
        private String getPass() { return pass; }
    }

    public static Connection getDbConnection(DatabaseConnData databaseConnData) {
        if(Objects.isNull(dbConnection)) {
            try {
                dbConnection = DriverManager.getConnection(databaseConnData.getUrl(), databaseConnData.getUserName(), databaseConnData.getPass());
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return dbConnection;
    }
}