python连接mysql数据库

import pymysql
try:
    conn=pymysql.connect(host='127.0.0.1',port=3306,user='root',password='196819',db='test',charset='utf8')
    print("success")
    cur=conn.cursor()
    # sql1=cur.execute("insert into student values(1,'hujinlong','18710360575');")
    id_number=10
    name="zhangsanfeng"
    phonenumber='19221911'
    sql2="insert into student values(%s,%s,%s)"
    ret=cur.execute(sql2,(id_number,name,phonenumber))
    # sql2=cur.execute()
    print(ret)
    conn.commit()
    conn.close()




    # for i in (8,9,10):
    #     cur.execute(sql1,(i,name+str(i),tel))
    # ret =cur.executemany(sql1,[(5,'jilly5','125212563'),(6,'jilly6','125212566'),(7,'jilly7','125212563')])
    # print(ret)
    # cur.callproc('protestinsert2')
    # conn.commit()
    # conn.close()
except:
    print("failed")