对于在校生和关心信息技术与工程实验教学中心发展的人而言，通过信息技术与工程实验教学中心网站可以及时了解中心的发展和动态，如中心所属实验室、中心师资、实验室软硬件环境、开设的实验项目等信息。同时，学生也可以通过中心网站完成实验预约。因此，做好信息技术与工程实验教学中心网站对于促进学院自身发展及满足社会需求等方面均具有重要的作用。
系统采用了jsp的mvc框架,SSM(springMvc+spring+Mybatis)框架进行开发,本系统是独立的运行，不依附于其他系统，可移植，可扩展。
CREATE TABLE IF NOT EXISTS allusers (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(50) DEFAULT NULL,
pwd varchar(50) DEFAULT NULL,
cx varchar(50) DEFAULT ‘普通管理员’,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;
CREATE TABLE IF NOT EXISTS banjixinxi (
id int(11) NOT NULL AUTO_INCREMENT,
banji varchar(50) DEFAULT NULL,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;
CREATE TABLE IF NOT EXISTS gongyubaoxiu (
id int(11) NOT NULL AUTO_INCREMENT,
gonghao varchar(50) DEFAULT NULL,
xingming varchar(50) DEFAULT NULL,
gongyuhao varchar(50) DEFAULT NULL,
riqi date DEFAULT NULL,
fujian varchar(50) DEFAULT NULL,
guzhangmiaoshu varchar(500) DEFAULT NULL,
issh varchar(10) DEFAULT ‘否’,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=gb2312;
CREATE TABLE IF NOT EXISTS gongyudiaohuan (
id int(11) NOT NULL AUTO_INCREMENT,
gonghao varchar(50) DEFAULT NULL,
xingming varchar(50) DEFAULT NULL,
xueyuan varchar(50) DEFAULT NULL,
gongyuhao varchar(50) DEFAULT NULL,
yudiaowang varchar(50) DEFAULT NULL,
diaohuanliyou varchar(500) DEFAULT NULL,
issh varchar(10) DEFAULT ‘否’,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=gb2312;
CREATE TABLE IF NOT EXISTS gongyuxinxi (
id int(11) NOT NULL AUTO_INCREMENT,
gongyuhao varchar(50) DEFAULT NULL,
louhao varchar(50) DEFAULT NULL,
beizhu varchar(500) DEFAULT NULL,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312;
CREATE TABLE IF NOT EXISTS gongzixinxi (
id int(11) NOT NULL AUTO_INCREMENT,
gonghao varchar(50) DEFAULT NULL,
xingming varchar(50) DEFAULT NULL,
xueyuan varchar(50) DEFAULT NULL,
zhiwu varchar(50) DEFAULT NULL,
nianfen varchar(50) DEFAULT NULL,
yuefen varchar(50) DEFAULT NULL,
benyuegongzi varchar(50) DEFAULT NULL,
beizhu varchar(500) DEFAULT NULL,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312;
CREATE TABLE IF NOT EXISTS jiaozhigongxinxi (
id int(11) NOT NULL AUTO_INCREMENT,
gonghao varchar(50) DEFAULT NULL,
mima varchar(50) DEFAULT NULL,
xingming varchar(50) DEFAULT NULL,
xingbie varchar(50) DEFAULT NULL,
zhiwu varchar(50) DEFAULT NULL,
xueyuan varchar(50) DEFAULT NULL,
gongyuhao varchar(50) DEFAULT NULL,
shouji varchar(50) DEFAULT NULL,
beizhu varchar(500) DEFAULT NULL,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;
CREATE TABLE IF NOT EXISTS sushebaoxiu (
id int(11) NOT NULL AUTO_INCREMENT,
xuehao varchar(50) DEFAULT NULL,
xingming varchar(50) DEFAULT NULL,
sushehao varchar(50) DEFAULT NULL,
riqi date DEFAULT NULL,
fujian varchar(50) DEFAULT NULL,
guzhangmiaoshu varchar(500) DEFAULT NULL,
issh varchar(10) DEFAULT ‘否’,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=gb2312;
CREATE TABLE IF NOT EXISTS sushediaohuan (
id int(11) NOT NULL AUTO_INCREMENT,
xuehao varchar(50) DEFAULT NULL,
xingming varchar(50) DEFAULT NULL,
xueyuan varchar(50) DEFAULT NULL,
sushehao varchar(50) DEFAULT NULL,
yudiaowang varchar(50) DEFAULT NULL,
diaohuanliyou varchar(500) DEFAULT NULL,
issh varchar(10) DEFAULT ‘否’,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=gb2312;
CREATE TABLE IF NOT EXISTS sushexinxi (
id int(11) NOT NULL AUTO_INCREMENT,
sushehao varchar(50) DEFAULT NULL,
louhao varchar(50) DEFAULT NULL,
beizhu varchar(500) DEFAULT NULL,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312;
CREATE TABLE IF NOT EXISTS xueshengxinxi (
id int(11) NOT NULL AUTO_INCREMENT,
xuehao varchar(50) DEFAULT NULL,
mima varchar(50) DEFAULT NULL,
xingming varchar(50) DEFAULT NULL,
xingbie varchar(50) DEFAULT NULL,
xueyuan varchar(50) DEFAULT NULL,
sushehao varchar(50) DEFAULT NULL,
shouji varchar(50) DEFAULT NULL,
beizhu varchar(500) DEFAULT NULL,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;
