SpringBoot+rediis实现秒杀系统

创建t_user表

create TABLE t_user(
`id` BIGINT(20) NOT NULL,
`nikcname` VARCHAR(255) NOT NULL,
`password` VARCHAR(32) DEFAULT Null COMMENT 'MD5(MD5(pass明文+固定slat)+slat)',
`slat` VARCHAR(10) DEFAULT NULL,
`head` VARCHAR(128) DEFAULT NULL,
`register_date` datetime DEFAULT NULL,
`last_login_date` datetime DEFAULT null,
`login_count` int(11) DEFAULT '0'
)

登录使用MD5加密

导入依赖包

<!--md5依赖-->
        <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>

 创建工具类MD5Util

package com.xxxx.seckill.utils;

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 inputPAssToFromPass(String inputPass){
        String str =salt.charAt(0)+salt.charAt(2)+inputPass+salt.charAt(5)+salt.charAt(4);
        return md5(str);
    }
    //第二次加密
    public static String fromPassToDBPass(String inputPass,String salt){
        String src =salt.charAt(0)+salt.charAt(2)+inputPass+salt.charAt(5)+salt.charAt(4);
        return md5(src);
    }
    public static String inputPassToDBPass(String inputPass,String salt){
        String fromPass = inputPAssToFromPass(inputPass);
        String dbPass = fromPassToDBPass(fromPass, salt);
        return dbPass;
    }

    public static void main(String[] args) {
        System.out.println(inputPAssToFromPass("123456"));//ce21b747de5af71ab5c2e20ff0a60eea
        System.out.println(fromPassToDBPass("ce21b747de5af71ab5c2e20ff0a60eea","1a2b3c4d"));
        System.out.println(inputPassToDBPass("123456","1a2b3c4d"));
    }
}

 新建逆向工程项目（springboot工程只需spring web）

添加mybatis依赖

 <dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-boot-starter</artifactId>
        <version>最新版本</version>
    </dependency>

添加generator依赖

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-generator</artifactId>
    <version>3.5.0</version>
</dependency>

添加Freemarker依赖

        <dependency>
            <groupId>org.freemarker</groupId>
            <artifactId>freemarker</artifactId>
            <version>2.3.30</version>
        </dependency>

添加书库依赖

<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.32</version>
            <scope>runtime</scope>
</dependency>