-- oracle 21c
create user c##geovindu identified by 88888;
grant create session,create table,unlimited tablespace to c##geovindu;
create user c##geovin identified by 88888;
grant create session,create table,unlimited tablespace to c##geovin;
grant connect,resource,dba to c##geovindu;
grant connect,resource,dba to c##geovin;create table:
drop table IF EXISTS School;
create table School --創建表
(
SchoolId char(5) NOT NULL, --
SchoolName nvarchar2(500) NOT NULL,
SchoolTelNo varchar(8) NULL,
PRIMARY KEY (SchoolId) --#主鍵
);
--对表的说明
comment on table School is '学校表';
--对表中列的说明
comment on column School.SchoolId is 'ID';
comment on column School.SchoolName is '学校名称';
comment on column School.SchoolTelNo is '电话号码';
select * from School order by SchoolId;
# 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 oracle 21c
# Datetime : 2024/12/28 12:15
# User : geovindu
# Product : PyCharm
# Project : Pysimple
# File : oracledemo.py
# explain : 学习
import getpass
import oracledb
import cx_Oracle
class SchoolInfo(object):
"""
"""
def __init__(self):
"""
"""
self.__idno = None
self.__schoolname = None
self.__schooltel = None
@property
def idno(self):
"""
:return:
"""
return self.__idno
@idno.setter
def idno(self, no: str):
"""
:param no:
:return:
"""
self.__idno = no
@property
def schoolname(self):
"""
:return:
"""
return self.__schoolname
@schoolname.setter
def schoolname(self, name: str):
"""
:param name:
:return:
"""
self.__schoolname = name
@property
def schooltel(self):
"""
:return:
"""
return self.__schooltel
@schooltel.setter
def schooltel(self, tel: str):
"""
:param city:
:return:
"""
self.__schooltel = tel
# 连接到Oracle数据库
connection = cx_Oracle.connect(user="c##geovindu", password="888888", dsn="localhost/TechnologyGame")
# 创建游标
cursor = connection.cursor()
# 执行查询
cursor.execute("SELECT * FROM School order by SchoolId")
# 获取查询结果
result = cursor.fetchall()
# 打印查询结果
dt = []
# 打印查询结果
for idno, name, tel in result:
# print(idno,name,tel)
info = SchoolInfo()
info.idno = idno
info.schoolname = name
info.schooltel = tel
dt.append(info)
print("****************")
for dd in dt:
print(dd.idno, dd.schoolname, dd.schooltel)
