基于SSM框架的资源管理系统(类似博客系统)
实现功能:1.管理员登录
2.用户登录
3.用户发表文章
4.用户浏览文章及评论
5.用户修改、删除文章
6.管理员审核、删除文章
7.资源上传
8.资源下载
实现步骤:
1.创建一个数据库
resource_management
语句:create database resource_management
2.创建7个表
①用户表
id,账号,姓名,身份,职位,邮箱,手机号,个人头像id,出生日期,密码
sql语句:
create table `user`(
`user_id` int unsigned auto_increment,
`user_account` varchar(30) not null,
`user_name` varchar(40) not null,
`user_identity` tinyint default 0 not null,
`position` varchar(40) not null,
`email` varchar(60),
`telephone` varchar(11),
`personal_image_id` int unsigned default 0,
`birthday` varchar(30),
primary key(`user_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
②个人头像表
id,图片名称,图片保存路径
sql语句:
create table `personal_image`(
`image_id` int unsigned auto_increment,
`image_name` varchar(50) not null,
`image_url` varchar(150) not null,
primary key(`image_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
③文章表
id,发表类型,文章名称,文章类型,文章内容,作者id,访问次数,评论个数,时间,描述
sql语句:
create table `article`(
`article_id` int unsigned auto_increment,
`publish_type` varchar(10) not null,
`article_name` varchar(40) not null,
`article_type` varchar(30) not null,
`article_content` mediumtext not null,
`author_id` int unsigned,
`praise` int default 0,
`tread` int default 0,
`finish_time` datetime not null,
primary key(`article_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
④评论表
id,评论者账号,文章id,评论内容,时间 ,被评论者账号,文章名
sql语句:
create table `comment`(
`comment_id` int unsigned auto_increment,
`observer_account` varchar(30) not null,
`article_id` int unsigned,
`comment_content` text not null,
`comment_time` datetime not null,
primary key(`comment_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
⑤审核表
id,文章id,时间,审核状态
sql语句:
create table `review`(
`review_id` int unsigned auto_increment,
`articles_id` int unsigned,
`review_time` datetime not null,
`review_status` tinyint,
primary key(`review_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
⑥资源上传表
id,资源名称,资源保存的路径,资源上传者账号,时间
sql语句:
create table `resource_upload`(
`resource_id` int unsigned auto_increment,
`resource_name` varchar(100) not null,
`resource_url` varchar(150) not null,
`uploader_account` varchar(30) not null,
`upload_time` datetime not null,
primary key(`resource_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
⑦资源下载表
id,资源名称,下载者账号,时间
sql语句:
create table `resource_download`(
`resource_id` int unsigned auto_increment,
`resource_name` varchar(100) not null,
`downloader_account` varchar(30) not null,
`download_time` datetime not null,
primary key(`resource_id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
项目源码地址:https://github.com/PettyKoKo/ssm-resource-management