Student management system using STRUTS2 framework as a background development framework, JSP implementation of page data display, the database using MySQL.
Feature Description:
Including student information management, class information management, grade information management, System Information management and other functions.
The database model is set up as follows:
CREATE TABLE T_class (
ClassId Int (one) not NULL auto_increment,
ClassName varchar (default) NULL,
Gradeid Int (one) default NULL,
Classdesc text,
PRIMARY KEY (classId)
) Engine=innodb DEFAULT Charset=utf8;
CREATE TABLE T_datadic (
Ddid Int (one) not NULL auto_increment,
Ddtypeid Int (one) default NULL,
Ddvalue varchar (default) NULL,
Dddesc text,
PRIMARY KEY (Ddid)
) Engine=innodb DEFAULT Charset=utf8;
CREATE TABLE T_datadictype (
Ddtypeid Int (one) not NULL auto_increment,
Ddtypename varchar (default) NULL,
Ddtypedesc text,
PRIMARY KEY (Ddtypeid)
) Engine=innodb DEFAULT Charset=utf8;
CREATE TABLE T_grade (
Gradeid Int (one) not NULL auto_increment,
Gradename varchar (default) NULL,
Gradedesc text,
PRIMARY KEY (Gradeid)
) Engine=innodb DEFAULT Charset=utf8;
CREATE TABLE T_student (
StudentID varchar (+) not NULL,
Stuno varchar (default) NULL,
Stuname varchar (default) NULL,
Stusex varchar () default NULL,
Stubirthday Date Default NULL,
STURXSJ Date Default NULL,
Stunation varchar (default) NULL,
STUZZMM varchar (default) NULL,
ClassId Int (one) default NULL,
Studesc text,
Stupic varchar (default) NULL,
PRIMARY KEY (StudentID)
) Engine=innodb DEFAULT Charset=utf8;
CREATE TABLE T_user (
UserId Int (one) is not NULL auto_increment,
UserName varchar (default) NULL,
Password varchar (default) NULL,
PRIMARY KEY (userId)
) Engine=innodb DEFAULT Charset=utf8;
The functions are as follows:
Student management system based on STRUTS2 framework Development