app网站建设 - 百度,全景图网站怎么做,浏览器在线,深圳龙岗网络推广公司1.需求分析
注册功能#xff08;添加用户操纵#xff09;登录功能#xff08;查询操作)我的文章列表页#xff08;查询我的文章|文章修改|文章详情|文章删除#xff09;博客编辑页#xff08;添加文章操作#xff09;所有人博客列表#xff08;带分页功能#xff09;…1.需求分析
注册功能添加用户操纵登录功能查询操作)我的文章列表页查询我的文章|文章修改|文章详情|文章删除博客编辑页添加文章操作所有人博客列表带分页功能文章详情页多个查询功能和一个修改功能
2.设计数据库
用户表id(主键登录名密码头像状态
文章表主键标题正文发表时间更新时间作者id阅读量状态。
3.创建项目所有框架
所用技术Spring Boot Spring MVC MyBatis MySQL
将前端代码添加到项目中前端代码详情请看博客连接。
创建后端并进行项目分层
控制层服务层数据持久层实体类层配置层工具层 4.后端代码
4.1实体类层
用户类
package com.example.demo.model;import lombok.Data;import java.time.LocalDateTime;/*** Describe:* User:lenovo* Date:2023-08-03* Time:18:02*/
Data
public class Userinfo {private int id;private String username;private String password;private String photo;private LocalDateTime createtime;private LocalDateTime updatetime;private int state;
}文章类
package com.example.demo.model;import lombok.Data;import java.time.LocalDateTime;/*** Describe:* User:lenovo* Date:2023-08-03* Time:18:04*/
Data
public class Articleinfo {private int id;private String title;private String content;private LocalDateTime createtime;private LocalDateTime updatetime;private int uid;private int rcount;private int state;
}4.2注册功能
在common层编写ResultAjax类为统一的返回类。
Data
public class ResultAjax {private int code;private String msg;private Object data;//为了方便使用我们构造一个成功方法public static ResultAjax succ(Object data) {ResultAjax resultAjax new ResultAjax();resultAjax.setCode(200);resultAjax.setData(data);return resultAjax;}//为了方便处理构造一个成功的方法public static ResultAjax succ(int code, String msg, Object data) {ResultAjax resultAjax new ResultAjax();resultAjax.setData(code);resultAjax.setMsg(msg);resultAjax.setData(data);return resultAjax;}//为了方便我们构造一个失败的方法public static ResultAjax fail(int code, String msg) {ResultAjax resultAjax new ResultAjax();resultAjax.setCode(code);resultAjax.setMsg(msg);resultAjax.setData(null);return resultAjax;}//为了方便我们构造一个失败的方法public static ResultAjax fail(int code, String msg, Object data) {ResultAjax resultAjax new ResultAjax();resultAjax.setCode(code);resultAjax.setMsg(msg);resultAjax.setData(data);return resultAjax;}
}编写UserMapper类
Mapper
public interface UserMapper {Insert(insert into userinfo(username, password) values(#{username}, #{password}))int reg(String username, String password);
}编写UserService类
Service
public class UserService {AutowiredUserMapper userMapper;public int reg(String username, String password) {return userMapper.reg(username, password);}
}
编写UserController类
RestController
RequestMapping(/user)
public class UserController {Autowiredprivate UserService userService;RequestMapping(/reg)public ResultAjax reg(Userinfo userinfo) {//1.参数校验if(userinfo.getUsername() null || userinfo.getUsername().trim().equals()) {return ResultAjax.fail(-1, 参数错误);}if(userinfo.getPassword() null || userinfo.getPassword().trim().equals()) {return ResultAjax.fail(-1, 参数错误);}//2.处理数据int ret userService.reg(userinfo.getUsername(), userinfo.getPassword());//3.返回结果return ResultAjax.succ(ret);}
}4.3登录功能
VO实体对象类是实体对象类的一个扩展主要包含数据表中不拥有但是前后端可能会使用到的对象。比如登录的时候我们需要验证码这个验证码必须后端接收并且不存在于数据表中我们可以使用扩展对象进行接收。
编写UserVO类在此文章中作用不大但是方便以后的更新
/*** Describe: userinfo的扩展类* User:lenovo* Date:2023-08-04* Time:19:03*/
Data
public class UserinfoVO extends Userinfo {//这里可以放入验证码private String checkCode;
}
编写UserMapper类
Select(select * from userinfo where username#{username})Userinfo getUserByName(Param(username)String username);
编写UserService类
public Userinfo getUserByName(String username) {return userMapper.getUserByName(username);}
编写UserController类
//登录接口根据名字查找用户RequestMapping(/login)public ResultAjax getUserByName(UserinfoVO userinfoVO, HttpServletRequest request) {// 1.校验参数if(userinfoVO null || !StringUtils.hasLength(userinfoVO.getUsername()) ||!StringUtils.hasLength(userinfoVO.getPassword())) { //这里我们使用StringUtils.hasLength判断它是否为null或为空return ResultAjax.fail(-1, 非法参数);}// 2.根据用户名查找对象Userinfo userinfo userService.getUserByName(userinfoVO.getUsername());if(!userinfoVO.getPassword().equals(userinfo.getPassword())) {//密码错误return ResultAjax.fail(-2, 账号或密码错误);}// 3.将对象存储到session中HttpSession session request.getSession();session.setAttribute(AppVariable.SESSION_USERINFO_KEY, userinfo);// 4.将结果返回给前端return ResultAjax.succ(1);}
这里我们使用cookie-session才储存用户信息。
编写公共类通过这个类我们知道session通过什么关键字来获取到用户的关键信息
/*** Describe: 全局变量* User:lenovo* Date:2023-08-04* Time:19:12*/
public class AppVariable {//用户的session keypublic static final String SESSION_USERINFO_KEY SESSION_USERINFO;
}
4.4登录校验/统一异常处理/统一结果返回
登录校验:
/*** Describe:拦截器* User:lenovo* Date:2023-08-09* Time:19:06*/
public class LoginIntercept implements HandlerInterceptor {Overridepublic boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws IOException {HttpSession session request.getSession(false);if(session null || session.getAttribute(AppVariable.SESSION_USERINFO_KEY) null) {response.sendRedirect(/login.html);return false;}return true;}
}
/*** Describe:系统配置文件* User:lenovo* Date:2023-08-09* Time:19:15*/
Configuration
public class MyConfig implements WebMvcConfigurer {Overridepublic void addInterceptors(InterceptorRegistry registry) {registry.addInterceptor(new LoginIntercept()).addPathPatterns(/**).excludePathPatterns(/user/login).excludePathPatterns(/user/reg).excludePathPatterns(/art/getlistbypage).excludePathPatterns(/art/detail).excludePathPatterns(/editor.md/*).excludePathPatterns(/img/*).excludePathPatterns(/js/*).excludePathPatterns(/css/*).excludePathPatterns(/blog_list.html).excludePathPatterns(/blog_content.html).excludePathPatterns(/reg.html).excludePathPatterns(/login.html);}
}统一结果返回
/*** Describe:保底统一的返回值* User:lenovo* Date:2023-08-05* Time:10:00*/
ControllerAdvice
public class ResponseAdvice implements ResponseBodyAdvice {Autowiredprivate ObjectMapper objectMapper;Overridepublic boolean supports(MethodParameter returnType, Class converterType) {return true;}Overridepublic Object beforeBodyWrite(Object body, MethodParameter returnType, MediaType selectedContentType, Class selectedConverterType, ServerHttpRequest request, ServerHttpResponse response) {//判断类是否为标准的返回类型if(body instanceof ResultAjax) {return body;}if(body instanceof String) {ResultAjax resultAjax ResultAjax.succ(body);try {return objectMapper.writeValueAsString(resultAjax);//如果是String类型我们需要手动的转化为json对象} catch (JsonProcessingException e) {e.printStackTrace();}}return ResultAjax.succ(body);}
}统一异常的处理
/*** Describe:统一异常的处理* User:lenovo* Date:2023-08-05* Time:10:33*/
//RestControllerAdvice //为了发现后续编程过程中的问题我们可以先注释掉
public class ExceptionAdvice {ExceptionHandler(Exception.class)public ResultAjax doException(Exception e) {return ResultAjax.fail(-1, e.getMessage());}
}4.5查看我的文章列表页
Mapper:
Mapper
public interface ArticleMapper {Select(select * from articleinfo where uid #{uid} order by id desc)ListArticleinfo getListByUid(Param(uid) int uid);
}
service
Service
public class ArticleService {Autowiredprivate ArticleMapper articleMapper;public ListArticleinfo getListByUid(Param(uid) int uid) {return articleMapper.getListByUid(uid);}
}
controller: //得到当前登录用户的文章列表RequestMapping(/mylist)public ResultAjax myList(HttpServletRequest request) {// 1.等到当前登录的用户Userinfo userinfo SessionUtils.getUser(request);if(userinfo null) {return ResultAjax.fail(-1, 请先登录);}// 2.根据用户的id查询你次用户发表的所有文章ListArticleinfo list articleService.getListByUid(userinfo.getId());//处理list-将文章正文变成简介if(list ! null list.size() 0) {//并发的处理文章的内容,然后处理集合中每一个元素list.stream().parallel().forEach((art) - {if(art.getContent().length() _DESC_LENGTH) {//这是简介内容我们取前120个字符art.setContent(art.getContent().substring(0, _DESC_LENGTH));}});}return ResultAjax.succ(list);}
4.6添加博客
Mapper:
Select(select * from userinfo where username#{username})Userinfo getUserByName(Param(username)String username);
service: public int add(Articleinfo articleinfo) {return articleMapper.add(articleinfo);}
controller:
//添加文章RequestMapping(/add)public ResultAjax add(Articleinfo articleinfo, HttpServletRequest request) {// 1.校验参数if(articleinfo null || !StringUtils.hasLength(articleinfo.getTitle()) ||!StringUtils.hasLength(articleinfo.getContent())) {return ResultAjax.fail(-1, 非法参数);}// 2.组装数据Userinfo userinfo SessionUtils.getUser(request);if(userinfo null) {return ResultAjax.fail(-2, 请先登录);}articleinfo.setUid(userinfo.getId());int ret articleService.add(articleinfo);// 3.将结果返回给前端return ResultAjax.succ(ret);}
4.7删除博客
Mapper:
Delete(delete from articleinfo where id #{aid} and uid uid)int del(Param(aid) Integer aid, int uid);
Service:
public int del(Integer aid, int uid) {return articleMapper.del(aid, uid);}
Controller:
//删除文章RequestMapping(/del)public ResultAjax del(Integer aid, HttpServletRequest request) {// 1.参数校验if(aid null || aid 0) {return ResultAjax.fail(-1, 参数错误);}// 2.获取登录的用户Userinfo userinfo SessionUtils.getUser(request);if(userinfo null) {return ResultAjax.fail(-1, 请先登录);}// 3.执行删除操作// 执行删除操作,我们有很多的方式,这里采用 aid和uid 的方法int ret articleService.del(aid, userinfo.getId());if(ret 0) {return ResultAjax.fail(-1, 你不是文章的归属人);}return ResultAjax.succ(ret);}
4.8查看文章详情
查看文章主要包含三个功能:
查询文章的内容查询相应的作者信息查询文章总数
最后两点我们可以使用多线程的方式来实现,提高查询的效率,同时三个功能使用一个HTTP请求,以减少多次连接和断开的次数,减少资源的消耗.
ArticleMapper: Select(select * from articleinfo where id #{aid})Articleinfo getDetailById(Param(aid) int aid);Select(select count(*) from articleinfo where uid #{uid})int getArtCountByUid(Param(uid) int uid);
UserMapper: Select(select * from userinfo where id #{uid})UserinfoVO getUseById(Param(uid) int uid);ArticleService: public Articleinfo getDetail(int aid) {return articleMapper.getDetailById(aid);}public int getArtCountByUid(int uid) {return articleMapper.getArtCountByUid(uid);}
UserService:
public UserinfoVO getUserById(int uid) {return userMapper.getUseById(uid);}
ArticleController:
//获取文章详情RequestMapping(/detail)public ResultAjax detail(Integer aid) throws ExecutionException, InterruptedException {// 1.参数校验if(aid null || aid 0) {return ResultAjax.fail(-1, 参数错误!);}// 2.查看文章详情Articleinfo articleinfo articleService.getDetail(aid);if(articleinfo null) {return ResultAjax.fail(-2, 查询文章不存在);}// 3.根据uid查询作者的详情信息FutureTaskUserinfoVO userTask new FutureTask(() - {return userService.getUserById(articleinfo.getUid());});// 4.查询uid查询用户发表的文章总数FutureTaskInteger artCountTask new FutureTask(() - {return articleService.getArtCountByUid(articleinfo.getUid());});taskExecutor.submit(artCountTask);taskExecutor.submit(userTask);// 5.组装数据UserinfoVO userinfoVO userTask.get(); //等待任务执行完成int artCount artCountTask.get(); //等待任务执行完成userinfoVO.setArtCount(artCount);HashMapString, Object result new HashMap();result.put(user, userinfoVO);result.put(art, articleinfo);// 6.返回结果给前端return ResultAjax.succ(result);}
增加阅读量:
Mapper: Update(update articleinfo set rcount rcount 1 where id #{aid})int incrementRCount(Param(aid) int aid);
Service:
public int incrementRCount(int aid) {return articleMapper.incrementRCount(aid);}
Controller:
//文章阅读量加1RequestMapping(/increment_rcount)public ResultAjax incrementRCount(Integer aid) {// 1.参数校验if(aid null || aid 0) {return ResultAjax.fail(-1, 参数错误);}// 2.更改数据库int result articleService.incrementRCount(aid);// 3.返回结果return ResultAjax.succ(result);}
4.9修改文章
Mapper: Select(select * from articleinfo where id #{aid} and uid #{uid})Articleinfo getArticleByIdAndUid(int aid, int uid);Update(update articleinfo set title#{title}, content#{content} where id #{id} and uid #{uid})int update(Articleinfo articleinfo);
service: public Articleinfo getArticleByIdAndUid(int aid, int uid) {return articleMapper.getArticleByIdAndUid(aid, uid);}public int update(Articleinfo articleinfo) {return articleMapper.update(articleinfo);}
controller:
//修改文章//更新文章RequestMapping(/update)public ResultAjax update(Articleinfo articleinfo, HttpServletRequest request) {// 1.参数校验if(articleinfo null || articleinfo.getId() 0 ||!StringUtils.hasLength(articleinfo.getTitle()) ||!StringUtils.hasLength(articleinfo.getContent())) {return ResultAjax.fail(-1, 参数错误!);}// 2.获取登录的用户Userinfo userinfo SessionUtils.getUser(request);if(userinfo null) {return ResultAjax.fail(-2, 请登录!);}// 3.操作数据库articleinfo.setUid(userinfo.getId());int ret articleService.update(articleinfo);return ResultAjax.succ(ret);}//修改文章//获取文章RequestMapping(/update_init)public ResultAjax updateInit(Integer aid, HttpServletRequest request) {// 1.参数校验if(aid null || aid 0) {return ResultAjax.fail(-1, 参数错误!);}// 2.操作数据库Userinfo userinfo SessionUtils.getUser(request);if(userinfo null) {return ResultAjax.fail(-2, 请登录);}//我们利用where id #{aid} and uid #{uid}的操作校验文章所有者Articleinfo articleinfo articleService.getArticleByIdAndUid(aid, userinfo.getId());// 3.返回结果return ResultAjax.succ(articleinfo);}
4.10文章列表页
文章列表页,主要包含两部分:
文章的获取分页功能
mapper: Select(select * from articleinfo order by id desc limit #{psize} offset #{offset})ListArticleinfo getListByPage(Param(psize) int psize, Param(offset) int offset);Select(select count(*) from articleinfo)int getCount();
service: public ListArticleinfo getListByPage(int psize, int offset) {return articleMapper.getListByPage(psize, offset);}public int getCount() {return articleMapper.getCount();}
controller:
//查询分页功能RequestMapping(/getlistbypage)public ResultAjax getListByPage(Integer pindex, Integer psize) throws ExecutionException, InterruptedException {// 1.参数校验if(pindex null) {pindex 1;}if(psize null) {psize 2;}// 2.并发执行文章列表和总页数的查询int finalOffset psize * (pindex - 1); // 分页公式int finalPSize psize;FutureTaskListArticleinfo listTask new FutureTask(() - {return articleService.getListByPage(finalPSize, finalOffset);});FutureTaskInteger sizeTask new FutureTaskInteger(() - {int totalCount articleService.getCount();if(totalCount % finalPSize ! 0) {return totalCount / finalPSize 1;}return totalCount/ finalPSize;});taskExecutor.submit(listTask);taskExecutor.submit(sizeTask);// 3.组装数据ListArticleinfo list listTask.get();int size sizeTask.get();HashMapString, Object map new HashMap();map.put(list, list);map.put(size, size);// 4.将结果返回给前端return ResultAjax.succ(map);}
4.11注销功能
Controller:
//注销功能RequestMapping(/logout)public ResultAjax logout(HttpServletRequest request) {HttpSession session request.getSession(false);if(session ! null session.getAttribute(AppVariable.SESSION_USERINFO_KEY) ! null) {session.removeAttribute(AppVariable.SESSION_USERINFO_KEY);}return ResultAjax.succ(1);}
5.加盐算法 /*** Describe: 密码工具类* User:lenovo* Date:2023-08-10* Time:10:45*/
public class PasswordUtils {/*** 加盐加密*/public static String encrypt(String password) {// 1.盐值String salt UUID.randomUUID().toString().replace(-, );// 2.将盐值密码进行md5得到最终密码String finalPassword DigestUtils.md5DigestAsHex((salt password).getBytes(StandardCharsets.UTF_8));// 3.将盐值和最终密码进行返回return salt $ finalPassword;}/*** 加盐验证*/public static boolean decrypt(String password, String dbpassword) {if(!StringUtils.hasLength(password) || !StringUtils.hasLength(dbpassword) ||dbpassword.length() ! 65) {return false;}// 1.得到盐值String[] dbPasswordArray dbpassword.split(\\$);if(dbPasswordArray.length ! 2) {return false;}// 盐值String salt dbPasswordArray[0];// 最终密码String dbFinalPassword dbPasswordArray[1];// 2.加密待验证的密码String finalPassword DigestUtils.md5DigestAsHex((salt password).getBytes(StandardCharsets.UTF_8));// 3.对比return finalPassword.equals(dbFinalPassword);}
}
修改原来的UserController:
//注册功能添加用户RequestMapping(/reg)public ResultAjax reg(Userinfo userinfo) {//1.参数校验if(userinfo.getUsername() null || userinfo.getUsername().trim().equals()) {return ResultAjax.fail(-1, 参数错误);}if(userinfo.getPassword() null || userinfo.getPassword().trim().equals()) {return ResultAjax.fail(-1, 参数错误);}//2.处理数据int ret userService.reg(userinfo.getUsername(), PasswordUtils.encrypt(userinfo.getPassword()));//3.返回结果return ResultAjax.succ(ret);}//登录接口根据名字查找用户RequestMapping(/login)public ResultAjax getUserByName(UserinfoVO userinfoVO, HttpServletRequest request) {// 1.校验参数if(userinfoVO null || !StringUtils.hasLength(userinfoVO.getUsername()) ||!StringUtils.hasLength(userinfoVO.getPassword())) { //这里我们使用StringUtils.hasLength判断它是否为null或为空return ResultAjax.fail(-1, 非法参数);}// 2.根据用户名查找对象Userinfo userinfo userService.getUserByName(userinfoVO.getUsername());if(!PasswordUtils.decrypt(userinfoVO.getPassword(), userinfo.getPassword())) {//密码错误return ResultAjax.fail(-2, 账号或密码错误);}// 3.将对象存储到session中HttpSession session request.getSession();session.setAttribute(AppVariable.SESSION_USERINFO_KEY, userinfo);// 4.将结果返回给前端return ResultAjax.succ(1);}
