Python使用JDBC驱动连接8a

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

import sys

import jaydebeapi

print("\nPython JayDeBeApi JDBC 测试程序开始运行.\n")

conn = jaydebeapi.connect("com.gbasedbt.jdbc.Driver",

                           "jdbc:gbasedbt-sqli://172.16.97.98:8900/testdb:GBASEDBTSERVER=ol_gbasedbt12;DB_LOCALE=en_us.8859-1;CLIENT_LOCALE=en_us.8859-1;IFX_LOCK_MODE_WAIT=60",

                           ["gbasedbt", "123456"],

                           "/home/gbasedbt/gbasedbtjdbc_3.3.0_2.jar")

mycursor = conn.cursor()

mycursor.execute("select * from YK_YX_RELY_AVC limit 3")

rows = mycursor.fetchall()

print(rows)

mycursor.close()

conn.close()