基于SSM整合的在线图书系统

基于SSM（SpringMVC、Spring和Mybatis）的在线图书系统，主要包括猜你喜欢，图书评价，分享朋友圈

，图书维护，首页维护，标记喜欢的图书标签等功能

前台访问地址：http://localhost:8080/bookmanage_ssm/user/indexPage.action

账号：zhangsan 密码：123456

后台访问地址：http://localhost:8080/bookmanage_ssm/admin/exitSys.action

管理员账号：admin 密码：123456 基于SSM整合的在线图书系统

部分数据库：
CREATE TABLE t_book (
bookid int(8) NOT NULL AUTO_INCREMENT COMMENT ‘键主，自增长’,
bookname varchar(100) NOT NULL COMMENT ‘图书名称’,
author varchar(200) NOT NULL COMMENT ‘作者’,
press int(5) NOT NULL COMMENT ‘出版社’,
typeid int(5) NOT NULL COMMENT ‘图书分类’,
price varchar(10) DEFAULT NULL COMMENT ‘价格’,
content varchar(500) DEFAULT NULL COMMENT ‘简介’,
keyword varchar(100) DEFAULT NULL COMMENT ‘键词关’,
evaluateid int(9) DEFAULT NULL COMMENT ‘书图评价编号’,
imageUrl varchar(200) DEFAULT NULL COMMENT ‘图片路径’,
score varchar(10) DEFAULT NULL COMMENT ‘综合评分’,
number int(8) DEFAULT NULL COMMENT ‘点赞人数’,
times int(8) DEFAULT NULL,
time varchar(50) DEFAULT NULL,
PRIMARY KEY (bookid)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8;
CREATE TABLE t_category (
id int(5) NOT NULL AUTO_INCREMENT COMMENT ‘书架分类编号，主键，自增长’,
name varchar(40) NOT NULL COMMENT ‘分类名称’,
status varchar(5) NOT NULL,
remark varchar(200) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

– Records of t_category

INSERT INTO t_category VALUES (‘2’, ‘操作系统’, ‘2’, ‘测试修改’);
INSERT INTO t_category VALUES (‘3’, ‘电子商务’, ‘1’, ‘测试修改’);
INSERT INTO t_category VALUES (‘4’, ‘数据库’, ‘1’, ‘测试信息’);
INSERT INTO t_category VALUES (‘5’, ‘测试新增’, ‘1’, ‘测试新增’);
INSERT INTO t_category VALUES (‘6’, ‘toBookTypePage.actio’, ‘1’, ‘toBookTypePage.action’);
INSERT INTO t_category VALUES (‘7’, ‘/admin/addType.actio’, ‘1’, ‘/admin/addType.action’);
INSERT INTO t_category VALUES (‘8’, ‘’, ‘1’, ‘’);
INSERT INTO t_category VALUES (‘9’, ‘’, ‘1’, ‘’);

– Table structure for t_evaluate

DROP TABLE IF EXISTS t_evaluate;
CREATE TABLE t_evaluate (
id int(6) NOT NULL AUTO_INCREMENT COMMENT ‘主键自增长’,
content varchar(200) NOT NULL COMMENT ‘评价内容’,
bookid int(5) NOT NULL,
score int(1) DEFAULT NULL COMMENT ‘本次评价得分’,
time varchar(50) DEFAULT NULL COMMENT ‘价评时间’,
remark varchar(200) DEFAULT NULL,
userid varchar(40) DEFAULT NULL COMMENT ‘评论者’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

– Records of t_evaluate

INSERT INTO t_evaluate VALUES (‘1’, ‘好看’, ‘72’, ‘3’, ‘2018-04-09 17:19:10’, ‘测试’, ‘zhangsan’);
INSERT INTO t_evaluate VALUES (‘2’, ‘舒服’, ‘72’, ‘4’, ‘2018-04-09 17:19:24’, ‘测试’, ‘zhangsan’);
INSERT INTO t_evaluate VALUES (‘5’, ‘这本书我看过，讲得还不错’, ‘72’, ‘5’, ‘2018-04-11 17:38:16’, null, ‘zhangsan’);
INSERT INTO t_evaluate VALUES (‘6’, ‘这本书我看过，讲得还不错’, ‘72’, ‘3’, ‘2018-04-11 17:40:49’, null, ‘zhangsan’);
INSERT INTO t_evaluate VALUES (‘7’, ‘这本书我看过，讲得还不错’, ‘72’, ‘5’, ‘2018-04-11 17:47:38’, null, ‘zhangsan’);
INSERT INTO t_evaluate VALUES (‘8’, ‘这本书我看过，讲得还不错’, ‘72’, ‘1’, ‘2018-04-11 17:48:17’, null, ‘zhangsan’);
INSERT INTO t_evaluate VALUES (‘9’, ‘这本书我看过，讲得还不错’, ‘72’, ‘5’, ‘2018-04-11 17:53:09’, null, ‘zhangsan’);

– Table structure for t_homepage

DROP TABLE IF EXISTS t_homepage;
CREATE TABLE t_homepage (
id int(5) NOT NULL AUTO_INCREMENT COMMENT ‘主键，自增长’,
name varchar(100) NOT NULL,
pageid int(5) NOT NULL COMMENT ‘记录bookid’,
remark varchar(500) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

基于SSM整合的在线图书系统

相关推荐