基于SSM java框架的个人博客系统项目毕业设计

介绍： spring，springmvc，mybatis，mysql，eclipse

数据库表： CREATE TABLE IF NOT EXISTS admin ( id mediumint(9) NOT NULL AUTO_INCREMENT, username varchar(30) NOT NULL, password char(32) NOT NULL, PRIMARY KEY (id), UNIQUE KEY username (username) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1206227 ;

– – 转存表中的数据 admin

INSERT INTO admin (id, username, password) VALUES (10080, ‘雨云天下’, ‘111111’);

– – 表的结构 admin_login_log

CREATE TABLE IF NOT EXISTS admin_login_log ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘日志ID’, admin_id int(11) NOT NULL COMMENT ‘管理员ID’, date timestamp NULL DEFAULT NULL COMMENT ‘登陆日期’, ip varchar(30) DEFAULT NULL COMMENT ‘登陆IP’, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;

– – 转存表中的数据 admin_login_log

INSERT INTO admin_login_log (id, admin_id, date, ip) VALUES (25, 10080, ‘2018-02-27 03:39:48’, ‘0:0:0:0:0:0:0:1’), (26, 10080, ‘2018-02-27 05:34:29’, ‘0:0:0:0:0:0:0:1’), (27, 10080, ‘2018-02-27 06:41:30’, ‘0:0:0:0:0:0:0:1’), (28, 10080, ‘2018-02-27 07:18:22’, ‘0:0:0:0:0:0:0:1’), (29, 10080, ‘2018-02-27 07:18:46’, ‘0:0:0:0:0:0:0:1’), (30, 10080, ‘2018-02-27 07:28:14’, ‘0:0:0:0:0:0:0:1’), (31, 10080, ‘2018-02-27 07:32:13’, ‘0:0:0:0:0:0:0:1’), (32, 10080, ‘2018-02-27 07:51:58’, ‘0:0:0:0:0:0:0:1’), (33, 10080, ‘2018-02-27 08:11:26’, ‘0:0:0:0:0:0:0:1’), (34, 10080, ‘2018-02-27 08:21:32’, ‘0:0:0:0:0:0:0:1’), (35, 10080, ‘2018-02-27 08:28:39’, ‘0:0:0:0:0:0:0:1’), (36, 10080, ‘2018-02-27 08:43:33’, ‘0:0:0:0:0:0:0:1’), (37, 10080, ‘2018-02-27 09:14:37’, ‘0:0:0:0:0:0:0:1’), (38, 10080, ‘2018-02-27 09:40:24’, ‘0:0:0:0:0:0:0:1’), (39, 10080, ‘2018-02-27 09:56:18’, ‘0:0:0:0:0:0:0:1’), (40, 10080, ‘2018-03-13 09:37:35’, ‘0:0:0:0:0:0:0:1’);

– – 表的结构 article

CREATE TABLE IF NOT EXISTS article ( id mediumint(9) NOT NULL AUTO_INCREMENT, title varchar(50) NOT NULL COMMENT ‘标题’, keywords varchar(150) NOT NULL COMMENT ‘关键字’, desci varchar(500) NOT NULL COMMENT ‘描述’, pic varchar(500) DEFAULT NULL COMMENT ‘图片地址’, content text NOT NULL COMMENT ‘内容’, click mediumint(9) NOT NULL DEFAULT ‘0’ COMMENT ‘点击量’, time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘发表日期’, catalog_id mediumint(9) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=105 ;