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;
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;
客户端访问程序:
Oracle Instant Client Downloads
数据库建模:
https://www.oracle.com/database/sqldeveloper/technologies/sql-data-modeler/download/
环境变量:(第一次写的好环境变量名称,重启电脑,名称写错了,不能重改,否则无法登录数据库,错了名称可以一样用) 这一步不需配置
ORACLE_HOME = D:\database\oracle\instantclient_21_15
TNS_ADMIN = D:\database\oracle\instantclient_21_15
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
修改Path变量,在后面添加 D:\database\oracle\instantclient_21_15
不需要写配置文件
这个.net 配置也换了内容:
不配置是:
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;
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 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)
哲学管理(学)人生, 文学艺术生活, 自动(计算机学)物理(学)工作, 生物(学)化学逆境, 历史(学)测绘(学)时间, 经济(学)数学金钱(理财), 心理(学)医学情绪, 诗词美容情感, 美学建筑(学)家园, 解构建构(分析)整合学习, 智商情商(IQ、EQ)运筹(学)生存.---Geovin Du(涂聚文)