基于ssm社团管理系统

介绍：
eclipse+mysql+spring+springmvc+mybatis
本社团管理系统主要包括系统用户管理模块、社团用户管理模块、学校用户管理、活动公告管理、登录模块、和退出模块等多个模块。它帮助社团管理实现了信息化、网络化，通过测试，实现了系统设计目标，相比传统的管理模式，本系统合理的利用了社团管理数据资源，有效的减少了社团管理的经济投入，大大提高了社团管理的效率。

项目截图：







数据库表：
CREATE TABLE 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=8 DEFAULT CHARSET=gb2312;

– Records of allusers

INSERT INTO allusers VALUES (‘2’, ‘hsg’, ‘hsg’, ‘超级管理员’, ‘2019-03-01 13:03:47’);
INSERT INTO allusers VALUES (‘6’, ‘admin8’, ‘admin’, ‘超级管理员’, ‘2019-03-03 17:32:28’);
INSERT INTO allusers VALUES (‘7’, ‘admin6’, ‘admin6’, ‘超级管理员’, ‘2019-04-07 23:21:20’);

– Table structure for baomingxinxi

DROP TABLE IF EXISTS baomingxinxi;
CREATE TABLE baomingxinxi (
id int(11) NOT NULL AUTO_INCREMENT,
shetuanmingcheng varchar(50) DEFAULT NULL,
biaoti varchar(50) DEFAULT NULL,
huodongshijian varchar(50) DEFAULT NULL,
huodongdidian varchar(50) DEFAULT NULL,
faburen varchar(50) DEFAULT NULL,
shenqingren varchar(50) DEFAULT NULL,
xingming varchar(50) DEFAULT NULL,
lianxidianhua varchar(50) DEFAULT NULL,
issh varchar(10) DEFAULT ‘否’,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

– Records of baomingxinxi

INSERT INTO baomingxinxi VALUES (‘2’, ‘音乐社团’, ‘A社团A社团公告’, ‘2019-04-21’, ‘’, ‘001’, ‘555555’, ‘张三’, ‘13888888888’, ‘否’, ‘2019-04-21 02:41:00’);

– Table structure for changdixinxi

DROP TABLE IF EXISTS changdixinxi;
CREATE TABLE changdixinxi (
id int(11) NOT NULL AUTO_INCREMENT,
changdimingcheng varchar(50) DEFAULT NULL,
didian varchar(50) DEFAULT NULL,
zhaopian varchar(50) DEFAULT NULL,
shiyongzhuangtai varchar(50) DEFAULT NULL,
jianjie varchar(50) DEFAULT NULL,
tianjiaren varchar(50) DEFAULT NULL,
dianzan_d int(11) DEFAULT ‘0’,
dianzan_c int(11) DEFAULT ‘0’,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;

– Records of changdixinxi

INSERT INTO changdixinxi VALUES (‘2’, ‘H场地’, ‘泰兴路22号’, ‘upload/nopic.jpg’, ‘占用’, ‘没问题’, ‘034’, ‘0’, ‘0’, ‘2019-04-21 00:35:16’);
INSERT INTO changdixinxi VALUES (‘3’, ‘B场地’, ‘鑫和锦园2栋’, ‘upload/nopic.jpg’, ‘占用’, ‘无’, ‘009’, ‘0’, ‘0’, ‘2019-04-21 00:35:16’);
INSERT INTO changdixinxi VALUES (‘4’, ‘D场地’, ‘复兴街27号’, ‘upload/nopic.jpg’, ‘占用’, ‘无’, ‘019’, ‘0’, ‘0’, ‘2019-04-21 00:35:16’);
INSERT INTO changdixinxi VALUES (‘5’, ‘Y场地’, ‘人民路57号’, ‘upload/nopic.jpg’, ‘可用’, ‘没问题’, ‘015’, ‘0’, ‘0’, ‘2019-04-21 00:35:16’);
INSERT INTO changdixinxi VALUES (‘6’, ‘L场地’, ‘开明路22号’, ‘upload/1555782348312.jpg’, ‘可用’, ‘暂无’, ‘001’, ‘0’, ‘0’, ‘2019-04-21 00:35:16’);
INSERT INTO changdixinxi VALUES (‘7’, ‘111’, ‘教室8’, ‘upload/1555782302710.jpg’, ‘可用’, ‘中国大学’, ‘001’, ‘0’, ‘0’, ‘2019-04-21 01:45:07’);
INSERT INTO changdixinxi VALUES (‘8’, ‘3425’, ‘中国浙江’, ‘upload/1555782318193.jpg’, ‘可用’, ‘中国大学’, ‘001’, ‘0’, ‘0’, ‘2019-04-21 01:45:22’);
INSERT INTO changdixinxi VALUES (‘9’, ‘454’, ‘北京大会堂’, ‘upload/1555782333269.jpg’, ‘占用’, ‘xxx事件’, ‘001’, ‘0’, ‘0’, ‘2019-04-21 01:45:37’);

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！