SpringBoot秒杀系统：4.登陆功能设计

系统管理员 2023-02-18 09:53 11阅读 0赞

1.  用户表

DROP TABLE IF EXISTS `seckill_user`;
    CREATE TABLE `seckill_user` (
      `id` bigint(20) unsigned NOT NULL COMMENT '用户ID',
      `nickname` varchar(255) NOT NULL,
      `password` varchar(32) DEFAULT NULL COMMENT 'MD5(MD5(pass明文+salt)+salt)',
      `salt` varchar(10) DEFAULT NULL,
      `head` varchar(128) DEFAULT NULL,
      `register_date` datetime DEFAULT NULL COMMENT '注册时间',
      `last_login_date` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '上次登录时间',
      `login_count` int(11) DEFAULT '0' COMMENT '登录次数',
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

1.  计算MD5密码  
    利用二次MD5的方式  
    MD5(MD5(pass明文+salt)+salt)

<dependency>
                <groupId>commons-codec</groupId>
                <artifactId>commons-codec</artifactId>
            </dependency>
            <dependency>
                <groupId>org.apache.commons</groupId>
                <artifactId>commons-lang3</artifactId>
                <version>3.6</version>
            </dependency>

package com.liuyang.seckill.util;
    
    
    import org.apache.commons.codec.digest.DigestUtils;
    
    public class MD5Util {
        
    
        public static String md5(String src) {
        
            return DigestUtils.md5Hex(src);
        }
    
        private static final String salt = "1a2b3c4d";
    
        public static String inputPassToFormPass(String inputPass) {
        
            String str = ""+salt.charAt(0)+salt.charAt(2) + inputPass +salt.charAt(5) + salt.charAt(4);
            System.out.println(str);
            return md5(str);
        }
    
    
        public static String formPassToDBPass(String formPass, String salt) {
        
            String str = ""+salt.charAt(0)+salt.charAt(2) + formPass +salt.charAt(5) + salt.charAt(4);
            return md5(str);
        }
    
        public static String inputPassToDbPass(String inputPass, String saltDB) {
        
            String formPass = inputPassToFormPass(inputPass);
            String dbPass = formPassToDBPass(formPass, saltDB);
            return dbPass;
        }
    
    
        public static void main(String[] args) {
        
            System.out.println(inputPassToDbPass("123456","1a2b3c4d"));
        }
    }

1.  手动注册用户  
    本项目主要目的是实现秒杀，所以省去用户注册部分  
    利用前面计算的MD5加密后密码手动插入一个用户

INSERT INTO `seckill_user` VALUES (18844118879, '123456', 'b7797cce01b4b131b433b6acf4add449', '1a2b3c4d', NULL, '2020-6-16 18:38:28', '2020-6-17 11:45:15', 0);

1.  登录数据传输

首先显示登陆页面

@RequestMapping("/to_login")
        public String toLogin() {
        
            return "login";
        }

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x0aGlyZG9uZWw_size_16_color_FFFFFF_t_70]  
登录页面中提交

后台接收  
建立一个接收数据的实体类

package com.liuyang.seckill.vo;
    
    public class LoginVo {
        
        private String mobile;
        private String password;
    
        @Override
        public String toString() {
        
            return "LoginVo{" +
                    "mobile='" + mobile + '\'' +
                    ", password='" + password + '\'' +
                    '}';
        }
    
        public String getMobile() {
        
            return mobile;
        }
    
        public void setMobile(String mobile) {
        
            this.mobile = mobile;
        }
    
        public String getPassword() {
        
            return password;
        }
    
        public void setPassword(String password) {
        
            this.password = password;
        }
    }

将前台接收的结果打印到日志中  
注意：这里后端接收表单数据，直接将根据表单定义的数据类放入函数参数中就可以！！！  
PHP开发时会自动生成这些实体类，无需开发者定义，这也就减少了实体类定义出错导致的开发错误，但这样无法让开发者了解传输生成数据的类型，也让开发者不能直接自定义实体类中的各种方法。

private static Logger log = LoggerFactory.getLogger(LoginController.class);
    	
        @RequestMapping("/do_login")
        public String doLogin(LoginVo loginVo) {
        
            log.info(loginVo.toString());
            return "login";
        }

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x0aGlyZG9uZWw_size_16_color_FFFFFF_t_70 1]  
错误点1：如果实体类不加get set方法，无法接收数据

![在这里插入图片描述][20200617121949475.png]

错误点2 ：名称不一致同样接收不到

package com.liuyang.seckill.vo;
    
    public class LoginVo {
        
        private String mobile1;
        private String password;
    
    
        @Override
        public String toString() {
        
            return "LoginVo{" +
                    "mobile='" + mobile1 + '\'' +
                    ", password='" + password + '\'' +
                    '}';
        }
    
        public String getMobile1() {
        
            return mobile1;
        }
    
        public void setMobile1(String mobile) {
        
            this.mobile1 = mobile;
        }
    
        public String getPassword() {
        
            return password;
        }
    
        public void setPassword(String password) {
        
            this.password = password;
        }
    }

![在这里插入图片描述][20200617122212671.png]  
5. 后台登录数据处理  
首先根据用户表建立好用户实体类

package com.liuyang.seckill.domain;
    
    import java.util.Date;
    
    public class SeckillUser {
        
    	private Long id;
    	private String nickname;
    	private String password;
    	private String salt;
    //	private String head;
    	private Date registerDate;
    	private Date lastLoginDate;
    	private Integer loginCount;
    	public Long getId() {
        
    		return id;
    	}
    	public void setId(Long id) {
        
    		this.id = id;
    	}
    	public String getNickname() {
        
    		return nickname;
    	}
    	public void setNickname(String nickname) {
        
    		this.nickname = nickname;
    	}
    	public String getPassword() {
        
    		return password;
    	}
    	public void setPassword(String password) {
        
    		this.password = password;
    	}
    	public String getSalt() {
        
    		return salt;
    	}
    	public void setSalt(String salt) {
        
    		this.salt = salt;
    	}
    //	public String getHead() {
        
    //		return head;
    //	}
    //	public void setHead(String head) {
        
    //		this.head = head;
    //	}
    	public Date getRegisterDate() {
        
    		return registerDate;
    	}
    	public void setRegisterDate(Date registerDate) {
        
    		this.registerDate = registerDate;
    	}
    	public Date getLastLoginDate() {
        
    		return lastLoginDate;
    	}
    	public void setLastLoginDate(Date lastLoginDate) {
        
    		this.lastLoginDate = lastLoginDate;
    	}
    	public Integer getLoginCount() {
        
    		return loginCount;
    	}
    	public void setLoginCount(Integer loginCount) {
        
    		this.loginCount = loginCount;
    	}
    }

建立SQL查询类

package com.liuyang.seckill.dao;
    
    import com.liuyang.seckill.domain.SeckillUser;
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Param;
    import org.apache.ibatis.annotations.Select;
    
    @Mapper
    public interface SeckillUserDao {
        
    
    	@Select("select * from seckill_user where id = #{id}")
    	public SeckillUser getById(@Param("id") long id);
    }

在Service类中编写登录逻辑  
知识点：Long.parseLong(mobile)将前台传输的String类型转换为long类型

package com.liuyang.seckill.service;
    import com.liuyang.seckill.dao.SeckillUserDao;
    import com.liuyang.seckill.domain.SeckillUser;
    import com.liuyang.seckill.redis.RedisService;
    import com.liuyang.seckill.result.CodeMsg;
    import com.liuyang.seckill.util.MD5Util;
    import com.liuyang.seckill.vo.LoginVo;
    import org.slf4j.Logger;
    import org.slf4j.LoggerFactory;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import javax.servlet.http.HttpServletResponse;
    
    @Service
    public class SeckillUserService {
        
    	Logger log = LoggerFactory.getLogger(SeckillUserService.class);
    	
    	@Autowired
    	SeckillUserDao seckillUserDao;
    	
    	@Autowired
    	RedisService redisService;
    	
    	public SeckillUser getById(long id) {
        
    		return seckillUserDao.getById(id);
    	}
    	public CodeMsg login(LoginVo loginVo) {
        
    		if(loginVo == null) {
        
    			return CodeMsg.SERVER_ERROR;
    		}
    		String mobile = loginVo.getMobile();
    		String formPass = loginVo.getPassword();
    		//判断手机号是否存在
    		SeckillUser user = getById(Long.parseLong(mobile));
    		if(user == null) {
        
    			return CodeMsg.MOBILE_NOT_EXIST;
    		}
    		//验证密码
    		String dbPass = user.getPassword();
    		String saltDB = user.getSalt();
    		String calcPass = MD5Util.formPassToDBPass(formPass, saltDB);
    		log.info(dbPass+"           "+calcPass+"           "+formPass);
    		log.info(String.valueOf(calcPass.equals(dbPass)));
    
    		if(!calcPass.equals(dbPass)) {
        
    			return CodeMsg.PASSWORD_ERROR;
    		}
    		return CodeMsg.SUCCESS;
    	}
    
    }

Controller中实现登录接口以及跳转接口

@ResponseBody
        @RequestMapping("/do_login")
        public Result<CodeMsg> doLogin(LoginVo loginVo) {
        
            log.info(loginVo.toString());
            if(loginVo.getMobile()==null){
        
                return Result.error(CodeMsg.SERVER_ERROR);
            }
            CodeMsg cm = seckillUserService.login(loginVo);
            if(cm.getCode()!=0){
        
                return Result.error(CodeMsg.SERVER_ERROR);
            }else {
        
                return Result.success(cm);
            }
        }

package com.liuyang.seckill.controller;
    
    
    import com.liuyang.seckill.domain.SeckillUser;
    import com.liuyang.seckill.redis.RedisService;
    import com.liuyang.seckill.service.SeckillUserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    @Controller
    @RequestMapping("/goods")
    public class GoodsController {
        
    
    	@Autowired
    	SeckillUserService seckillUserService;
    	
    	@Autowired
    	RedisService redisService;
    	
        @RequestMapping("/to_list")
        public String list(Model model, SeckillUser user) {
        
        	model.addAttribute("user", user);
            return "goods_list";
        }
        
    }

1.  登录测试  
    可以登录成功，但是无法获取用户登录后的名称等信息！  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x0aGlyZG9uZWw_size_16_color_FFFFFF_t_70 2]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x0aGlyZG9uZWw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200617121009646.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x0aGlyZG9uZWw=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x0aGlyZG9uZWw_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200617121716940.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x0aGlyZG9uZWw=,size_16,color_FFFFFF,t_70
[20200617121949475.png]: https://img-blog.csdnimg.cn/20200617121949475.png
[20200617122212671.png]: https://img-blog.csdnimg.cn/20200617122212671.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x0aGlyZG9uZWw_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200617143238954.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x0aGlyZG9uZWw=,size_16,color_FFFFFF,t_70