oracle 21c create user

--  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;

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)