python: Connecting to Oracle 11g Database in Python

 

# encoding: utf-8
# 版权所有 2024 涂聚文有限公司
# 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎
# 描述：python -m pip install oracledb
# python -m pip install cx_Oracle --upgrade
# pip install cx_Oracle
# Author    : geovindu,Geovin Du 涂聚文.
# IDE       : PyCharm 2024.3 python 3.11
# os        : windows 10
# database  : mysql 9.0 sql server 2019, poostgreSQL 17.0
# Datetime  : 2024/12/21 22:14
# User      : geovindu
# Product   : PyCharm
# Project   : Pysimple
# File      : oracledemo.py
# explain   : 学习
import getpass
import oracledb
import cx_Oracle

# 连接到Oracle数据库
connection = cx_Oracle.connect(user="SCOTT", password="88888", dsn="localhost/ORCL")

# 创建游标
cursor = connection.cursor()

# 执行查询
cursor.execute("SELECT * FROM DEPT")

# 获取查询结果
result = cursor.fetchall()

# 打印查询结果
for row in result:
    print(row)

　　

 

 

 

 

Oracle SQL Developer Downloads | Oracle 中国

https://www.oracle.com/cn/database/sqldeveloper/technologies/download/

https://www.oracle.com/database/technologies/oracle-database-software-downloads.html

 

# encoding: utf-8
# 版权所有 2024 ©涂聚文有限公司
# 许可信息查看：言語成了邀功盡責的功臣，還需要行爲每日來值班嗎
# 描述：python -m pip install oracledb
# python -m pip install cx_Oracle --upgrade
# Author    : geovindu,Geovin Du 涂聚文.
# IDE       : PyCharm Community Edition 2024.3 python 3.11
# OS        : windows 10
# Datetime  : 2024/12/22 22:33
# User      : geovindu
# Product   : PyCharm  Community
# Project   : ictsimple
# File      : oracledemo.py
# explain   : 学习

import cx_Oracle


class dept(object):
    """

    """
    def __init__(self):
        """

        """
        self.__idno=None
        self.__deptname=None
        self.__localcity=None

    @property
    def idno(self):
        """

        :return:
        """
        return self.__idno

    @idno.setter
    def idno(self,no:str):
        """

        :param no:
        :return:
        """
        self.__idno=no

    @property
    def deptname(self):
        """

        :return:
        """
        return self.__deptname

    @deptname.setter
    def deptname(self,name:str):
        """

        :param name:
        :return:
        """
        self.__deptname=name

    @property
    def localcity(self):
        """

        :return:
        """
        return self.__localcity

    @localcity.setter
    def localcity(self,city:str):
        """

        :param city:
        :return:
        """
        self.__localcity=city



# 连接到Oracle数据库
connection = cx_Oracle.connect(user="SCOTT", password="88888", dsn="localhost/orcl.docker.internal")
# 创建游标
cursor = connection.cursor()
# 执行查询
cursor.execute("SELECT * FROM DEPT")
# 获取查询结果
result = cursor.fetchall()
dt=[]
# 打印查询结果
for idno,name,city in result:
    print(idno,name,city)
    info=dept()
    info.idno=idno
    info.deptname=name
    info.localcity=city
    dt.append(info)
print("****************")
for dd in dt:
    print(dd.idno,dd.deptname,dd.localcity)

　　

全局数据库名的名称要记着，程序代码连接数据库有关联。