public static Connection getConnection() throws Exception {
        if(connection == null || connection.isClosed()) {
            Class.forName("com.mysql.jdbc.Driver");
            connection = (Connection) DriverManager.getConnection(
                    "jdbc:mysql://" + host + ":" + port + "/" + database, username, password);
        }
        return connection;
    }