python + informix+基本语句

发布时间 2023-04-23 15:38:59作者: 徐俊112
import jaydebeapi
import os
import logging
import time
class Postgre_Person:
  
    def __init__(self):
        # 打开数据库连接
         for i in range(10):
            try:
                url =  ###
                user = ###
                password = ####
                dirver = 'com.informix.jdbc.IfxDriver'
                jarFile = "D:\\informix\ifxjdbc.jar"
                conn = jaydebeapi.connect(dirver, url, [user, password], jarFile)
                # 创建游标对象
                self.curs = conn.cursor()
                logging.info('informix数据库连接成功')
                break
                
            except Exception as e:
                print("连接informixCB数据库异常!!!", "错误信息:", e)
                logging.info("连接informixCB数据库异常!!!", "错误信息:", e)
                return 0

       
    # 查询数据()
    def Post_select(self):
              try:
            sql = '''
            self.curs.execute(sql)
            list_count = self.curs.fetchall()return list_count
            
        except Exception as e:
           return 0