教师信息管理系统(方式一:数据库为oracle数据库;方式二:存储在文件中)

方式一:

  运行截图

    

    

    

    

数据库的sql语句:

/*
Navicat Oracle Data Transfer
Oracle Client Version : 12.1.0.2.0

Source Server : ORCZYT
Source Server Version : 120100
Source Host : localhost:1521
Source Schema : C##ZYT

Target Server Type : ORACLE
Target Server Version : 120100
File Encoding : 65001

Date: 2018-10-29 21:50:10
*/


-- ----------------------------
-- Table structure for TEACHER
-- ----------------------------
DROP TABLE "C##ZYT"."TEACHER";
CREATE TABLE "C##ZYT"."TEACHER" (
"TID" NUMBER(19) NOT NULL ,
"TNAME" VARCHAR2(255 CHAR) NULL ,
"SHENFEN" VARCHAR2(255 CHAR) NULL ,
"PHONE" VARCHAR2(255 CHAR) NULL ,
"BUMEN" VARCHAR2(255 CHAR) NULL ,
"TIME" VARCHAR2(255 CHAR) NULL ,
"ZHUANYE" VARCHAR2(255 CHAR) NULL ,
"ZHIWU" VARCHAR2(255 CHAR) NULL ,
"MONEY" VARCHAR2(255 CHAR) NULL ,
"ADDRESS" VARCHAR2(255 CHAR) NULL ,
"EMAIL" VARCHAR2(255 CHAR) NULL ,
"BEIZHU" VARCHAR2(255 CHAR) NULL ,
"TEACHERID" VARCHAR2(255 CHAR) NULL ,
"BIRTH" VARCHAR2(255 CHAR) NULL
)
LOGGING
NOCOMPRESS
NOCACHE

;

-- ----------------------------
-- Records of TEACHER
-- ----------------------------
INSERT INTO "C##ZYT"."TEACHER" VALUES ('74', '李请问', '12132', '15833814301', '计算机', '2012-04-25', '123', '12323', '123213', '123213', '123787878@qq.com', '123', '2014001', '2018');
INSERT INTO "C##ZYT"."TEACHER" VALUES ('83', '张三丰', 'ededed', '15833814309', '计算机', '2017-12-28', 'ewfef', 'efereer', '85454', '石家庄', '12378755545@qq.com', '785454', '2000000', '2000');
INSERT INTO "C##ZYT"."TEACHER" VALUES ('1', '张上', '147159199870145', '15833814341', '软件工程', '2017-12-28', 'ewfef', 'efereer', '85454', '石家庄', '12378755545@qq.com', '12', '2000078', '2000');
INSERT INTO "C##ZYT"."TEACHER" VALUES ('76', '张运涛', '1213212', '15833814345', '软件工程', '2012-06-14', '123', '12323', '123213', '123213', '12354554@qq.com', '123', '2014555', '2011');
INSERT INTO "C##ZYT"."TEACHER" VALUES ('161', '李四', '141123456785577', '14754444555', ' ', '2014-01-12', null, null, null, null, null, null, null, '1997');

-- ----------------------------
-- Indexes structure for table TEACHER
-- ----------------------------

-- ----------------------------
-- Checks structure for table TEACHER
-- ----------------------------
ALTER TABLE "C##ZYT"."TEACHER" ADD CHECK ("TID" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table TEACHER
-- ----------------------------
ALTER TABLE "C##ZYT"."TEACHER" ADD PRIMARY KEY ("TID");

源代码:

 https://pan.baidu.com/s/1R3LqUoaJAvMDc4QU5OA0tg

方式二:

    运行截图

      

原文地址:https://www.cnblogs.com/zyt-bg/p/9873653.html