[python零碎笔记]python零碎笔记（持续更新&…

import cx_Oracle

con = cx_Oracle.connect("pythondemo/welcome@192.168.188.11:1521/std1")
cur = con.cursor()

rows = [ (1, "First" ), (2, "Second" ),
         (3, "Third" ), (4, "Fourth" ),
         (5, "Fifth" ), (6, "Sixth" ),
         (7, "Seventh" ) ]

cur.execute("truncate table mytab")
cur.executemany("insert into mytab(id, data) values (:1, :2)", rows)
con.commit()

cur.execute('select * from mytab')
res = cur.fetchall()
print(res)

cur.close()
con.close()

BatchInstall.py
import os
libs = {"numpy","matplotlib","pillow","sklearn","requests",\
        "jieba","beautifulsoup4","wheel","networkx","sympy",\
        "pyinstaller","django","flask","werobot","pyqt5",\
        "pandas","pyopengl","pypdf2","docopt","pygame"}
try:
    for lib in libs:
        os.system("pip3 install "+lib)
    print("Successful")        
except:
    print("Failed Somehow")

import pandas as pd
import cx_Oracle

con = cx_Oracle.connect("scott","tiger","192.168.188.11:1521/std1")

d = pd.read_sql('select * from test',con)

import requests

def getHTMLText(url):
    try:
        r = requests.get(url,timeout=30)
        r.raise_for_status()
        r.encoding = r.apparent_encoding
        return r.text
    except:
        return "产生异常"
    
if __name__ == "__main__":
    url = "https://www.cnblogs.com/yongestcat/"
    print(getHTMLText(url))