python3+jaydebeapi3访问MySQL7

import jaydebeapi

driver='com.mysql.jdbc.Driver'
jarFile=r'C:Usersccxpt.PyCharm2019.2configjdbc-driversMySQL ConnectorJ 88.0.15mysql-connector-java-8.0.15.jar'
url='jdbc:mysql://192.168.23.1:3307/oadb'
DBUser='root'
DBPwd='123456'
conn=jaydebeapi.connect(driver,[url,DBUser,DBPwd],jarFile)

curs = conn.cursor()
curs.execute('select * from glfmdrsj')
rows = curs.fetchall()
print(rows[1])
curs.close()
conn.close()
原文地址:https://www.cnblogs.com/zsfishman/p/12404583.html