• 教师信息管理系统(方式一:数据库为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

    方式二:

        运行截图

          

  • 相关阅读:
    POJ 3744:Scout YYF I 概率DP+特征方程+快速幂
    浏览器实现颜色渐变效果(兼容)
    css透明(支持各浏览器)
    sql server密钥
    DDL(Oracle)
    DML(Oralce)
    SQL(Oracle)
    Reflect
    Exception
    XML语法
  • 原文地址:https://www.cnblogs.com/zyt-bg/p/9873653.html
Copyright © 2020-2023  润新知