# mybatis

**Repository Path**: Qwuyl/mybatis

## Basic Information

- **Project Name**: mybatis
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2021-03-30
- **Last Updated**: 2021-06-10

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

修改sql：在src/main/resources/dbconfig.properties里面进行修改
SQL语句：建立数据库
create table course
(
    c_no         int auto_increment
        primary key,
    c_name       varchar(255) null,
    c_redit      tinyint      null,
    c_teacher    varchar(255) null,
    c_number_now int          null,
    c_number_all int          null,
    c_time       int          null,
    c_power      int          null,
    normal       double       null,
    exam         double       null
);

create table teacher
(
    teacher_id       varchar(255) not null
        primary key,
    teacher_name     varchar(255) not null,
    teacher_class    varchar(255) null,
    teacher_dety     varchar(255) null,
    teacher_password varchar(255) null,
    power            varchar(255) not null,
    sex              varchar(10)  null
);

create table class_dept
(
    id      varchar(255) not null
        primary key,
    p_id    varchar(255) null,
    name    varchar(255) null,
    teacher varchar(255) null,
    constraint class_dept_name_uindex
        unique (name),
    constraint class_dept_teacher_teacher_id_fk
        foreign key (teacher) references teacher (teacher_id)
);

create table student
(
    student_id       varchar(255) not null
        primary key,
    student_name     varchar(255) not null,
    student_birth    date         not null,
    student_class    varchar(255) not null,
    student_dept     varchar(255) not null,
    student_password varchar(255) null,
    sex              varchar(10)  null,
    constraint student_ibfk_1
        foreign key (student_class) references class_dept (id),
    constraint student_ibfk_2
        foreign key (student_dept) references class_dept (id)
);

create table change_major
(
    id            int auto_increment
        primary key,
    student_id    varchar(255) null,
    student_class varchar(255) not null,
    student_dept  varchar(255) not null,
    result1       tinyint(1)   null,
    result2       tinyint(1)   null,
    constraint change_major_class_dept_id_fk
        foreign key (student_class) references class_dept (id),
    constraint change_major_class_dept_id_fk_2
        foreign key (student_dept) references class_dept (id),
    constraint change_major_student_student_id_fk
        foreign key (student_id) references student (student_id)
);

create table `leave`
(
    id         int auto_increment
        primary key,
    student_id varchar(255)  null,
    time       date          null,
    reason     varchar(1023) null,
    end_time   date          null,
    result     tinyint(1)    null,
    constraint leave_student_student_id_fk
        foreign key (student_id) references student (student_id)
);

create table sc
(
    student_id varchar(255) null,
    course_id  int          null,
    grade      int          null,
    exam       int          null,
    normal     int          null,
    constraint SC_student_student_id_fk
        foreign key (student_id) references student (student_id),
    constraint sc_course_c_no_fk
        foreign key (course_id) references course (c_no)
);

create index student_class
    on student (student_class);

create index student_dept
    on student (student_dept);

项目地址
http://123.57.48.194:8080/springmvc/index.jsp
管理员账号：20000923
密码：admin
普通用户：541907230321
密码：000000