URL样例:
# url 示例1 jdbc:oracle:thin:@172.16.2.32/orclis
# url 示例2 jdbc:oracle:thin:@172.16.2.31:1521:orcl
思路:
(1) 分开来看,分别设定函数获得数据库的名称和IP
(2) 借助python中的find函数实现切片
# 获得数据库的名称
def get_database(url):
# url 示例1 jdbc:oracle:thin:@172.16.2.32/orclis
# url 示例2 jdbc:oracle:thin:@172.16.2.31:1521:orcl
url_len = len(url)
database_index = url.rfind('/')
if database_index > 0:
return url[database_index - url_len + 1:]
else:
return url[url.rfind(':') - url_len + 1:]
# 获得数据库的IP
def get_host(url):
split_url = url[url.find("@") + 1:]
colon_index = split_url.find(":")
if colon_index > 0:
return split_url[0:colon_index]
else:
return split_url[0:split_url.find("/")]