文末获取源码
开发语言:Java
使用框架:spring boot
前端技术:JavaScript、Vue.js 、css3
开发工具:IDEA/MyEclipse/Eclipse、Visual Studio Code
数据库:MySQL 5.7/8.0
数据库管理工具:phpstudy/Navicat
JDK版本:Java jdk8
Maven:apache-maven 3.8.1-bin
目录
一、前言介绍
二、系统架构设计
三、管理员功能模块
3.1登录页面编辑
3.2注册页面
3.3管理管理页面
3.4投搞中心管理页面
3.5稿件管理页面
3.6稿件分类管理页面
四、用户功能模块
五、专家功能模块
六、部分核心代码
6.1专家管理关键代码
6.2稿件管理关键代码
6.3稿件分类管理关键代码
6.4登录系统主要代码
6.5注册逻辑关键代码
建立基于SpringBoot的投稿和稿件处理系统后,其前台的用户可以在线写稿、预览、投递,并能在第一时间内收到用稿通知;后台管理员则可在线审批来稿,从而实现投稿-采编发布一体化。提高工作效率、加强信息资源共享。
投稿和稿件处理系统的主要使用者分为管理员、用户与专家,实现功能包括:首页、用户管理、投稿中心、稿件管理、稿件分类等功能。由于本网站的功能模块设计比较全面,所以使得整个投稿和稿件处理系统的过程得以实现。本系统的使用可以实现本springboot投稿和稿件处理系统的信息化,可以方便管理员进行更加方便快捷的管理,可以提高投稿和稿件处理系统的管理效率。
投稿和稿件处理系统的系统项目的概述设计分析,主要内容投稿和稿件处理系统信息的具体分析,进行数据库的是设计,数据采用mysql数据库,并且对于系统的设计采用比较人性化的操作设计,对于系统出现的错误信息可以及时做出处理及反馈。
基于投稿和稿件处理系统的设计基于现有的互联网,可以实现管理员:首页、用户管理、在线投稿、稿件分类、稿件管理、专家管理功能模块等。根据系统功能需求建立的模块关系图如下图:
@RequestMapping(value = {"/count_group", "/count"})public Map count(HttpServletRequest request) {Query count = service.count(service.readQuery(request), service.readConfig(request));return success(count.getResultList());}
@PostMapping("/add")@Transactionalpublic Map add(HttpServletRequest request) throws IOException {service.insert(service.readBody(request.getReader()));return success(1);}@Transactionalpublic Map addMap(Map map){service.insert(map);return success(1);}public Map readBody(BufferedReader reader){BufferedReader br = null;StringBuilder sb = new StringBuilder("");try{br = reader;String str;while ((str = br.readLine()) != null){sb.append(str);}br.close();String json = sb.toString();return JSONObject.parseObject(json, Map.class);}catch (IOException e){e.printStackTrace();}finally{if (null != br){try{br.close();}catch (IOException e){e.printStackTrace();}}}return null;}public void insert(Map body){StringBuffer sql = new StringBuffer("INSERT INTO ");sql.append("`").append(table).append("`").append(" (");for (Map.Entry entry:body.entrySet()){sql.append("`"+humpToLine(entry.getKey())+"`").append(",");}sql.deleteCharAt(sql.length()-1);sql.append(") VALUES (");for (Map.Entry entry:body.entrySet()){Object value = entry.getValue();if (value instanceof String){sql.append("'").append(entry.getValue()).append("'").append(",");}else {sql.append(entry.getValue()).append(",");}}sql.deleteCharAt(sql.length() - 1);sql.append(")");log.info("[{}] - 插入操作:{}",table,sql);Query query = runCountSql(sql.toString());query.executeUpdate();}
@PostMapping("/set")@Transactionalpublic Map set(HttpServletRequest request) throws IOException {service.update(service.readQuery(request), service.readConfig(request), service.readBody(request.getReader()));return success(1);}public Map readConfig(HttpServletRequest request){Map map = new HashMap<>();map.put(FindConfig.PAGE,request.getParameter(FindConfig.PAGE));map.put(FindConfig.SIZE,request.getParameter(FindConfig.SIZE));map.put(FindConfig.LIKE,request.getParameter(FindConfig.LIKE));map.put(FindConfig.ORDER_BY,request.getParameter(FindConfig.ORDER_BY));map.put(FindConfig.FIELD,request.getParameter(FindConfig.FIELD));map.put(FindConfig.GROUP_BY,request.getParameter(FindConfig.GROUP_BY));map.put(FindConfig.MAX_,request.getParameter(FindConfig.MAX_));map.put(FindConfig.MIN_,request.getParameter(FindConfig.MIN_));return map;}public Map readQuery(HttpServletRequest request){String queryString = request.getQueryString();if (queryString != null && !"".equals(queryString)) {String[] querys = queryString.split("&");Map map = new HashMap<>();for (String query : querys) {String[] q = query.split("=");map.put(q[0], q[1]);}map.remove(FindConfig.PAGE);map.remove(FindConfig.SIZE);map.remove(FindConfig.LIKE);map.remove(FindConfig.ORDER_BY);map.remove(FindConfig.FIELD);map.remove(FindConfig.GROUP_BY);map.remove(FindConfig.MAX_);map.remove(FindConfig.MIN_);return map;}else {return new HashMap<>();}}@Transactionalpublic void update(Map query,Map config,Map body){StringBuffer sql = new StringBuffer("UPDATE ").append("`").append(table).append("`").append(" SET ");for (Map.Entry entry:body.entrySet()){Object value = entry.getValue();if (value instanceof String){sql.append("`"+humpToLine(entry.getKey())+"`").append("=").append("'").append(value).append("'").append(",");}else {sql.append("`"+humpToLine(entry.getKey())+"`").append("=").append(value).append(",");}}sql.deleteCharAt(sql.length()-1);sql.append(toWhereSql(query,"0".equals(config.get(FindConfig.LIKE))));log.info("[{}] - 更新操作:{}",table,sql);Query query1 = runCountSql(sql.toString());query1.executeUpdate();}public String toWhereSql(Map query, Boolean like) {if (query.size() > 0) {try {StringBuilder sql = new StringBuilder(" WHERE ");for (Map.Entry entry : query.entrySet()) {if (entry.getKey().contains(FindConfig.MIN_)) {String min = humpToLine(entry.getKey()).replace("_min", "");sql.append("`"+min+"`").append(" >= '").append(URLDecoder.decode(entry.getValue(), "UTF-8")).append("' and ");continue;}if (entry.getKey().contains(FindConfig.MAX_)) {String max = humpToLine(entry.getKey()).replace("_max", "");sql.append("`"+max+"`").append(" <= '").append(URLDecoder.decode(entry.getValue(), "UTF-8")).append("' and ");continue;}if (like == true) {sql.append("`"+humpToLine(entry.getKey())+"`").append(" LIKE '%").append(URLDecoder.decode(entry.getValue(), "UTF-8")).append("%'").append(" and ");} else {sql.append("`"+humpToLine(entry.getKey())+"`").append(" = '").append(URLDecoder.decode(entry.getValue(), "UTF-8")).append("'").append(" and ");}}sql.delete(sql.length() - 4, sql.length());sql.append(" ");return sql.toString();} catch (UnsupportedEncodingException e) {log.info("拼接sql 失败:{}", e.getMessage());}}return "";}
/*** 登录* @param data* @param httpServletRequest* @return*/@PostMapping("login")public Map login(@RequestBody Map data, HttpServletRequest httpServletRequest) {log.info("[执行登录接口]");String username = data.get("username");String email = data.get("email");String phone = data.get("phone");String password = data.get("password");List resultList = null;Map map = new HashMap<>();if(username != null && "".equals(username) == false){map.put("username", username);resultList = service.select(map, new HashMap<>()).getResultList();}else if(email != null && "".equals(email) == false){map.put("email", email);resultList = service.select(map, new HashMap<>()).getResultList();}else if(phone != null && "".equals(phone) == false){map.put("phone", phone);resultList = service.select(map, new HashMap<>()).getResultList();}else{return error(30000, "账号或密码不能为空");}if (resultList == null || password == null) {return error(30000, "账号或密码不能为空");}//判断是否有这个用户if (resultList.size()<=0){return error(30000,"用户不存在");}User byUsername = (User) resultList.get(0);Map groupMap = new HashMap<>();groupMap.put("name",byUsername.getUserGroup());List groupList = userGroupService.select(groupMap, new HashMap<>()).getResultList();if (groupList.size()<1){return error(30000,"用户组不存在");}UserGroup userGroup = (UserGroup) groupList.get(0);//查询用户审核状态if (!StringUtils.isEmpty(userGroup.getSourceTable())){String sql = "select examine_state from "+ userGroup.getSourceTable() +" WHERE user_id = " + byUsername.getUserId();String res = String.valueOf(service.runCountSql(sql).getSingleResult());if (res==null){return error(30000,"用户不存在");}if (!res.equals("已通过")){return error(30000,"该用户审核未通过");}}//查询用户状态if (byUsername.getState()!=1){return error(30000,"用户非可用状态,不能登录");}String md5password = service.encryption(password);if (byUsername.getPassword().equals(md5password)) {// 存储Token到数据库AccessToken accessToken = new AccessToken();accessToken.setToken(UUID.randomUUID().toString().replaceAll("-", ""));accessToken.setUser_id(byUsername.getUserId());tokenService.save(accessToken);// 返回用户信息JSONObject user = JSONObject.parseObject(JSONObject.toJSONString(byUsername));user.put("token", accessToken.getToken());JSONObject ret = new JSONObject();ret.put("obj",user);return success(ret);} else {return error(30000, "账号或密码不正确");}}
/*** 注册* @param user* @return*/@PostMapping("register")public Map signUp(@RequestBody User user) {// 查询用户Map query = new HashMap<>();query.put("username",user.getUsername());List list = service.select(query, new HashMap<>()).getResultList();if (list.size()>0){return error(30000, "用户已存在");}user.setUserId(null);user.setPassword(service.encryption(user.getPassword()));service.save(user);return success(1);}/*** 用户ID:[0,8388607]用户获取其他与用户相关的数据*/@Id@GeneratedValue(strategy = GenerationType.IDENTITY)@Column(name = "user_id")private Integer userId;/*** 账户状态:[0,10](1可用|2异常|3已冻结|4已注销)*/@Basic@Column(name = "state")private Integer state;/*** 所在用户组:[0,32767]决定用户身份和权限*/@Basic@Column(name = "user_group")private String userGroup;/*** 上次登录时间:*/@Basic@Column(name = "login_time")private Timestamp loginTime;/*** 手机号码:[0,11]用户的手机号码,用于找回密码时或登录时*/@Basic@Column(name = "phone")private String phone;/*** 手机认证:[0,1](0未认证|1审核中|2已认证)*/@Basic@Column(name = "phone_state")private Integer phoneState;/*** 用户名:[0,16]用户登录时所用的账户名称*/@Basic@Column(name = "username")private String username;/*** 昵称:[0,16]*/@Basic@Column(name = "nickname")private String nickname;/*** 密码:[0,32]用户登录所需的密码,由6-16位数字或英文组成*/@Basic@Column(name = "password")private String password;/*** 邮箱:[0,64]用户的邮箱,用于找回密码时或登录时*/@Basic@Column(name = "email")private String email;/*** 邮箱认证:[0,1](0未认证|1审核中|2已认证)*/@Basic@Column(name = "email_state")private Integer emailState;/*** 头像地址:[0,255]*/@Basic@Column(name = "avatar")private String avatar;/*** 创建时间:*/@Basic@Column(name = "create_time")@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")private Timestamp createTime;@Basic@Transientprivate String code;}
上一篇:挡住的造句是什么
下一篇:一个成语“南山什么“.