擅长:python、mysql、java
<p><strong>代码</strong></p>
<pre class="lang-py prettyprint-override"><code>from urllib import parse
from urllib.parse import urlsplit
url = 'http://localhost:5432/postgres?user=postgres&password=somePassword'
split_url = urlsplit(url)
hostname = split_url.netloc
path = split_url.path
params = dict(parse.parse_qsl(split_url.query))
username = params['user']
password = params['password']
db_url = "jdbc:postgresql://" + hostname + path
print(db_uri)
</code></pre>
<hr/>
<p><strong>输出</strong></p>
<pre><code>jdbc:postgresql://localhost:5432/postgres
</code></pre>