‘’’
让python通过jdbc连接数据库
1、安装visualcppbuildtools_full.exe
链接：https://pan.baidu.com/s/1MLxNJfWNGuKIxgNYkJgUnw 密码：3etc
2、pip install JayDeBeApi
https://pypi.org/project/JayDeBeApi/
3、测试代码
‘’’
import jaydebeapi
url = ‘jdbc:oracle:thin:@127.0.0.1:1521/orcl’
user = ‘hwf_model’
password = ‘hwf_model’
dirver = ‘oracle.jdbc.driver.OracleDriver’
jarFile = ‘E:\pycharm\lib\ojdbc14.jar’
#conn=jaydebeapi.connect(‘oracle.jdbc.driver.OracleDriver’,‘jdbc:oracle:thin:@127.0.0.1:1521/orcl’,[‘hwf_model’,‘hwf_model’],‘E:/pycharm/lib/ojdbc14.jar’)
conn = jaydebeapi.connect(dirver, url, [user, password], jarFile)
curs = conn.cursor()
sqlStr = ‘select * from dual’
curs.execute(sqlStr)
result = curs.fetchall()
print(result)
curs.close()
conn.close()