sql_instruction.md · SWT/SWT

connect 'jdbc:derby:dedb;user=root;password=123123;create=true';
CREATE TABLE
    users
    (
        nickname VARCHAR(10),
        email VARCHAR(50),
        create_time DATE,
        id INTEGER,
        avatar VARCHAR(50),
        password VARCHAR(20),
        type INTEGER,
        CONSTRAINT id_pk PRIMARY KEY (id)
    );
insert into users(id,nickname,password,create_time)
values(1001,'Tom','123123',date('2023-12-01'));
insert into users(id,nickname,password,create_time)
values(1002,'Tim','123123',date('2023-12-01'));

CREATE TABLE
    student
    (
     id Integer NOT NULL,
     name VARCHAR(20),
     idNumber VARCHAR(20),
     gradeName VARCHAR(20),
     className VARCHAR(20),
     status VARCHAR(20),
     delFlag VARCHAR(20),
     createBy VARCHAR(20),
     createTime DATE,
     updateBy VARCHAR(20),
     updateTime DATE,
     remark VARCHAR(20),
    serialVersionUID Integer,
    CONSTRAINT id_stu_k PRIMARY KEY (id)
    );
insert into student(id,name, gradeName,className)
values(1001,'Tim','一班','计科');
insert into student(id,name, gradeName,className)
values(1002,'Sam','二班','计科');
insert into student(id,name, gradeName,className)
values(1003,'Billion','三班','计科');

SWT/SWT

简介

发行版

贡献者

近期动态

SWT/SWT .gitee-modal { width: 500px !important; }

简介

发行版

贡献者

近期动态

搜索帮助

SWT/SWT