pip install cx_Oracle

import cx_Oracle
import queue

class OracleDatabase:
    # 構(gòu)造函數(shù)，傳入數(shù)據(jù)庫(kù)連接參數(shù)
    def __init__(self, user, pwd, dsn, size):
        self.user = user
        self.pwd = pwd
        self.dsn = dsn
        ## 定義連接池
        self.size = size
        self.conn_queue = queue.Queue(maxsize=self.size)
        for i in range(self.size):
            self.conn_queue.put(self._create_connection())

    # 創(chuàng)建數(shù)據(jù)庫(kù)連接
    def _create_connection(self):
        return cx_Oracle.connect(self.user, self.pwd, self.dsn)
  
    # 從連接池里面獲取連接
    def _get_conn(self):
        conn = self.conn_queue.get()
        if conn is None:
            self._create_connection()
        return conn

    # 將連接put到連接池中
    def _put_conn(self, conn):
        self.conn_queue.put(conn)

    # 關(guān)閉所有連接
    def _close_conn(self):
        try:
            while True:
                conn = self.conn_queue.get_nowait()
                if conn:
                    conn.close()
        except queue.Empty:
            print(">>>>數(shù)據(jù)庫(kù)連接全部關(guān)閉<<<<")
            pass 

    # 執(zhí)行查詢語(yǔ)句
    def query(self, sql, params=None):
        res = []
        conn = self._get_conn()
        cursor = conn.cursor()
        try:
            if params:
                cursor.execute(sql, params)
            else:
                cursor.execute(sql)
            rows = cursor.fetchall()
            for row in rows:
                res.append(row)
        except Exception as e:
            print(str(e))
        finally:
            cursor.close()
            self._put_conn(conn)
        return res

if __name__ == '__main__':
    user = "user_dba"
    pwd = "user_password"
    dsn = cx_Oracle.makedsn('0.0.0.0', '1521', service_name='s_demo_db')
    db = OracleDatabase(user, pwd, dsn, 2)
    cl_code = input("輸入訂單號(hào): ").strip()
    
    print("數(shù)據(jù)信息展示:")
    sql_1 = """select *
		  from table_demo c
		  where c.cl_code = :cl_code"""

    results_1 = db.query(sql_1, [cl_code])
	print(results_1)
	# ......

pip install PrettyTable

from prettytable import PrettyTable

## 接著第三部分的代碼
tb_1 = PrettyTable(['**號(hào)', '**時(shí)間', '當(dāng)前狀態(tài)', '單號(hào)', '機(jī)構(gòu)'])
for rs_1 in results_1:
	tb_1.add_row([rs_1[0], rs_1[1], rs_1[2], rs_1[3], rs_1[4]])
print(tb_1)