摘要:项目结构 sql: CREATE TABLE IF NOT EXISTS School ( SchoolId TEXT not null, SchoolName TEXT NOT NULL, SchoolTelNo TEXT NOT NULL ) 整体思路Model:负责与 SQLite 数据库进行
阅读全文
posted @ 2025-02-11 20:31
®Geovin Du Dream Park™
阅读(75)评论(0)推荐(0)
摘要:sql: drop table IF EXISTS School; create table School --創建表 ( SchoolId char(5) NOT NULL, -- SchoolName nvarchar2(500) NOT NULL, SchoolTelNo varchar(8)
阅读全文
posted @ 2025-01-02 20:37
®Geovin Du Dream Park™
阅读(25)评论(0)推荐(0)
摘要:oracel sql script CREATE OR REPLACE PROCEDURE SelectSchool( paramSchoolId IN char, p_cursor OUT SYS_REFCURSOR ) AS BEGIN OPEN p_cursor FOR SELECT * FR
阅读全文
posted @ 2024-12-27 06:21
®Geovin Du Dream Park™
阅读(12)评论(0)推荐(0)
摘要:用database configuration Assistant 引导创建数据库。 创建操作用户: -- 别加双引号,否则,无法用 create user geovindu identified by 888888; create user geovin identified by 888888;
阅读全文
posted @ 2024-12-23 20:50
®Geovin Du Dream Park™
阅读(23)评论(0)推荐(0)