方式一：

運(yùn)行截圖

數(shù)據(jù)庫的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', '計算機(jī)', '2012-04-25', '123', '12323', '123213', '123213', '123787878@qq.com', '123', '2014001', '2018');

INSERT INTO "C##ZYT"."TEACHER" VALUES ('83', '張三豐', 'ededed', '15833814309', '計算機(jī)', '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', '張運(yùn)濤', '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

方式二：

運(yùn)行截圖

總結(jié)

以上是生活随笔為你收集整理的教室信息管理系统mysql_教师信息管理系统（方式一：数据库为oracle数据库；方式二：存储在文件中）...的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。