"""
Python 输入股票代码，显示公司官网
"""
# -*- coding:utf-8 -*-
"""先要建立mysql,postgresql等数据库链接"""
engine_mysql = create_engine('mysql+pymysql://用户名:密码@端口:/数据库名?charset=utf8')
engine_pg = create_engine("postgresql+psycopg2://用户名:,密码@端口:/数据库名", client_encoding='utf8')
import pandas as pd
def company_web_open(engine_con,ts_code):
"""
最初安装时要考虑路径、安装浏览器程序，放入PYTHON目录中，版本要和实际浏览器相对
"""
from selenium import webdriver
db_nm = 'stock_company' #上市公司基本信息 可通过tushare*载下**数据，存入数据库
query = "select website from {} where ts_code = '{}';".format(db_nm, ts_code)
print(query)
df = pd.read_sql(query, con=engine_con)
c_web = df.website[0]
print(c_web)
url_wm = 'http://{}'.format(c_web)
print(url_wm)
#browser = webdriver.Chrome()
browser = webdriver.Firefox()
browser.get(url_wm)
if __name__ == '__main__':
company_web_open(engine_pg, '000001.SZ')
"""
运行结果：
2022-10-09 13:00:00 17.803578
select website from stock_company where ts_code = '000001.SZ';
bank.pingan.com
http://bank.pingan.com
Process finished with exit code 0
"""
"""
Pgabc 2022000010
author : Pgabc
www.wmdbsoft.com
"""