游客:/
| 接口地址 | 参数 | SQL | 参数默认值描述 |
| ------------------- | ------------------------------------------------------------ | ------------------------------------------------------------ | ------------------------------------------------------------ |
| login | String username、String password | select * from userVo where username = username and password = password | 登录 |
| register | String username、String password | insert into userVo value (username, password, 'xx', 'xx'); | 注册 |
| getBlogByKeywords | String keywords = null, Integer orderby = star, Integer startIndex = 0、Integer pageSize = 10 | select id, title, star, views, author_username, time from blog where status = 1 and logic_delete = 0 and (title like %keywords% or content like %keywords%) order by 0 limit startIndex, pageSize; | 从下标0开始获取10篇最新blog封面并根据orderby? views:time排序 |
| **getUserBlogList** | **String username = null、Integer status = 1、Integer startIndex = 0、Integer pageSize = 10** | **select id, title, star, views, author_username, time from blog where status= status and logic_delete = 0 and username = username limit startIndex, pageSize;** | **从下标0开始获取全部用户的10篇通过审核的blog封面** |
| getBlogDetails | int id | select id, title, content, star, views, author_username, time comments_id from blog where status= 1 and logic_delete = 0 and id = id;<br /><br />update blog set views = views + 1 where logic_delete = 0 and status = 1 and id = id; | 获取指定blog详情,博客浏览量加一 |
| getCommentsList | int id, int startIndex, int pageSize | select id, parent_comments, sender_username, acceptor_username, content, time from comments where logic_delete = 0 and id = id limit startIndex, pageSize; | 获取指定blog下的评论列表 |
普通用户:/userVo/
| 接口地址 | 参数 | SQL | 参数默认值描述 |
| ---------------- | ----------------------------- | ------------------------------------------------------------ | --------------------- |
| logout | | | 登出 |
| postBlog | Blog blog | insert into blog(title, content, author_username) value (blog.title, blog.content, session.username); | 发布blog |
| deleteMyBlog | int id | update blog set logic_delete = 1 where author_username = session.username and logic_delete = 0 and id = id; | 删除我的blog |
| updateMyBlog | Blog blog | update blog set title = blog.title, content = blog.content, star = blog.star, views = blog.views, status = 0 where author_username = session.username and logic_delete = 0 and id = blog.id; | 更新我的blog |
| starBlog | int id, boolean option | update blog set star = star + 1 where blog_id = id;<br />insert into star value(session.username, blog_id, logic_delete=option); | 收藏/取消收藏指定blog |
| getMyStarList | int startIndex、 int pageSize | select id, title, star, views, author_username, time from blog where id in (select blog_id from star where logic_delete = 0 and username = session.username) limit startIndex, pageSize; | 获取收藏的blog列表 |
| postComments | Comments comments | insert into comments(parent_comments, sender_username, content ) value(comments.parent_comments, session.username, comments.acceptor_username, comments.content); | 在指定blog下评论 |
| deleteMyComments | int id | update comments set logic_delete = 1 where sender_username = session.username and id = id and logic_delete = 0; | 删除我的评论 |
管理员:/admin/
| 接口地址 | 参数 | SQL | 参数默认值描述 |
| ---------- | -------------------- | ------------------------------------------------------------ | ------------------------- |
| auditBlog | int id、int status=1 | update blog set status = status where status = null and logic_delete = 0 and id = id; | 使指定blog通过/不通过审核 |
| deleteBlog | int id | update blog set logic_delete = 1 where logic_delete = 0 and id = id; | 删除指定的blog |
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
博客管理系统-毕业设计.zip (160个子文件)
UserService.class 14KB
BlogVO.class 10KB
BlogService.class 10KB
BlogViewVO.class 10KB
BlogDTO.class 9KB
HttpUtils.class 9KB
UserDTO.class 8KB
VisitorController.class 7KB
User.class 7KB
SecurityConfig.class 6KB
CommentDTO.class 6KB
DictService.class 6KB
CommentService.class 6KB
JwtAuthenticationTokenFilter.class 6KB
JwtTokenUtil.class 6KB
UserDetailsServiceImpl.class 6KB
UserVO.class 6KB
BaseDTO.class 5KB
UserController.class 5KB
Blog.class 5KB
BaseVO.class 4KB
UserDetailsImpl.class 4KB
BaseEntity.class 4KB
CommentVO.class 4KB
IpUtils.class 4KB
DictDTO.class 4KB
LimitRequestAspect.class 4KB
RedisConfig.class 4KB
AdminController.class 4KB
Comment.class 4KB
MyResponse.class 4KB
DictController.class 3KB
SaveFile.class 3KB
Code.class 3KB
MyAuthenticationEntryPoint.class 3KB
Disable.class 3KB
Record.class 2KB
DictData.class 2KB
AddressUtils.class 2KB
JacksonConf.class 2KB
CategoryVO.class 2KB
FilterConfigurer.class 2KB
MyAccessDeniedHandler.class 2KB
MyStackApplication$1.class 2KB
DictType.class 2KB
KaptchaConfig.class 2KB
DictTypeVO.class 2KB
CorsConfig.class 1KB
Category.class 1KB
SystemConfig.class 1KB
ExceptionControllerAdvice.class 1KB
MyStackApplication.class 1KB
MyMetaObjectHandler.class 1KB
HttpUtils$TrustAnyTrustManager.class 1KB
UserInfoUtils.class 1KB
BaseController.class 1KB
VerCodeGenerate.class 913B
HttpUtils$TrustAnyHostnameVerifier.class 868B
BlogMapper.class 767B
CommentMapper.class 622B
LimitRequest.class 530B
UserMapper.class 509B
StatusCode.class 459B
BlogCategory.class 392B
DictTypeMapper.class 385B
DictDataMapper.class 385B
DisableMapper.class 382B
RecordMapper.class 379B
HttpUtils$1.class 199B
mvnw.cmd 7KB
.gitignore 397B
my-stack-back-end-0.0.1-SNAPSHOT.jar 51.12MB
maven-wrapper.jar 57KB
HttpUtils.java 8KB
UserService.java 8KB
IpUtils.java 7KB
BlogService.java 6KB
VisitorController.java 5KB
JwtTokenUtil.java 5KB
JwtAuthenticationTokenFilter.java 4KB
SecurityConfig.java 3KB
UserController.java 3KB
CommentService.java 3KB
DictService.java 3KB
UserDetailsServiceImpl.java 3KB
LimitRequestAspect.java 2KB
DictController.java 2KB
AdminController.java 2KB
MyAuthenticationEntryPoint.java 2KB
SaveFile.java 2KB
RedisConfig.java 2KB
MyResponse.java 2KB
MyStackApplication.java 1KB
KaptchaConfig.java 1KB
UserDetailsImpl.java 1KB
AddressUtils.java 1KB
MyAccessDeniedHandler.java 1KB
BaseDTO.java 1KB
UserDTO.java 933B
JacksonConf.java 914B
共 160 条
- 1
- 2
资源评论
马coder
- 粉丝: 1203
- 资源: 6602
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功