Spring Boot 整合Spring Data以及rabbitmq，thymeleaf，向qq邮箱发送信息

说明：

p,e为路由key。

用户系统完成登录的时候，将{手机号-时间-IP}保存到队列Phone-queue中，msg-sys系统获得消息打印到控制台（完成用户登录过程短信服务的异步调用,完成用户系统和短信系统的解耦合）

用户系统完成注册的时候，将{email-时间-IP-账户激活url }保存到队列email-sys中，email-sys将消息打印到控制台，使用控制台打印的账户激活的url，在浏览器向user-sys系统发送请求，修改user表中locked字段的值。（完成用户注册过程邮件服务的异步调用,完成用户系统和邮件系统的解耦合），修改完成后给用户提示账户激活成功

Spring Boot 整合Spring Data以及rabbitmq，thymeleaf，向qq邮箱发送信息

用户登录

用户登录的时候提交用户名和密码，然后给用户短信提示，用户在什么时间，用哪个IP，进行登录。需要将电话-时间-IP格式的数据保存到队列中

用户注册

用户注册，用户注册后，给用户注册信息进行邮箱的激活，点击哪个url进行账户激活。修改数据库中locked字段的值。需要将Email-时间-URL格式的数据保存到队列中

当我们点击注册的时候，会向消息队列发送注册信息，以及向qq邮箱发送文件激活的url

然后看pom文件

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>

    <parent>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-parent</artifactId>

        <version>2.2.1.RELEASE</version>

        <relativePath/> <!-- lookup parent from repository -->

    </parent>

    <groupId>com.bjsxt</groupId>

    <artifactId>spring-boot-jpa-dlzc</artifactId>

    <version>0.0.1-SNAPSHOT</version>

    <name>spring-boot-jpa-dlzc</name>

    <description>spring-boot-jpa-dlzc</description>

    <properties>

        <java.version>1.8</java.version>

    </properties>

    <dependencies>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-data-jpa</artifactId>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-thymeleaf</artifactId>

        </dependency>

        <dependency>

            <groupId>mysql</groupId>

            <artifactId>mysql-connector-java</artifactId>

            <version>5.1.47</version>

        </dependency>

        <!--开启QQ邮箱验证-->

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-mail</artifactId>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-web</artifactId>

        </dependency>

        <!-- rabbitmq -->

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-amqp</artifactId>

        </dependency>

        <dependency>

            <groupId>org.projectlombok</groupId>

            <artifactId>lombok</artifactId>

            <optional>true</optional>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-test</artifactId>

            <scope>test</scope>

            <exclusions>

                <exclusion>

                    <groupId>org.junit.vintage</groupId>

                    <artifactId>junit-vintage-engine</artifactId>

                </exclusion>

            </exclusions>

        </dependency>

    </dependencies>

    <build>

        <plugins>

            <plugin>

                <groupId>org.springframework.boot</groupId>

                <artifactId>spring-boot-maven-plugin</artifactId>

            </plugin>

        </plugins>

    </build>

</project>

由于此项目用到了消息队列

因此注意项目奖结构

Spring Boot 整合Spring Data以及rabbitmq，thymeleaf，向qq邮箱发送信息

消息的发送者 spring-boot-jpa-dlzc

application.properties配置文件

#Mysql数据源配置

spring.datasource.driver-class-name=com.mysql.jdbc.Driver

spring.datasource.url=jdbc:mysql://localhost:3306/sys?characterEncoding=UTF8&useSSL=false

spring.datasource.username=root

spring.datasource.password=root

#JPA相关配置

#项目启动生成数据库

spring.jpa.hibernate.ddl-auto=update

spring.jpa.show-sql=true

server.port=8081

spring.rabbitmq.host=192.168.181.134

spring.rabbitmq.port=5672

spring.rabbitmq.username=admin

spring.rabbitmq.password=111111

#设置交换器的名称

mq.config.exchange=log.direct

#设置短信的路由键

mq.config.queue.message.routing.key=log.message.routing.key

#设置邮件的路由键

mq.config.queue.email.routing.key=log.email.routing.key

#qq邮箱的规则

spring.mail.host=smtp.qq.com

spring.mail.username=设置申请邮箱的账号

spring.mail.password=邮箱的验证码

spring.mail.properties.mail.smtp.auth=true

spring.mail.properties.mail.smtp.starttls.enable=true

spring.mail.properties.mail.smtp.starttls.required=true

实体类

locked字段是为了激活账号使用的，给予默认值是0，注册成但是未激活的时候，此时locked值是0，点击激活之后locked值修改成1，在我们登录的时候带着uname和pwd以及locked的值为1三个条件去判断，如果有值说明账户激活成功，查询没有则返回用户，账户未激活信息提示

package com.bjsxt.pojo;

import lombok.Data;

import org.hibernate.annotations.ColumnDefault;

import javax.persistence.*;

import java.io.Serializable;

@Entity

@Table(name = "users")

@Data

public class Users implements Serializable {

    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    @Column(name = "uid")

    private  int uid;

    @Column(name = "uname")

    private String uname;

    @Column(name = "pwd")

    private String pwd;

    @Column(name = "email")

    private String email;

    @Column(name = "phone")

    private String phone;

    @Column(name = "locked")

    @ColumnDefault(value = "0")

    private int locked;

    public Users() {

    }

    public Users(String uname, String pwd, String email, String phone, int locked) {

        this.uname = uname;

        this.pwd = pwd;

        this.email = email;

        this.phone = phone;

        this.locked = locked;

    }

}

消息发送实现类

Spring Boot 整合Spring Data以及rabbitmq，thymeleaf，向qq邮箱发送信息

com.bjsxt.send.LoginSender

package com.bjsxt.send;

import org.springframework.amqp.core.AmqpTemplate;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.beans.factory.annotation.Value;

import org.springframework.stereotype.Component;

/***

 * 消息的发送者

 */

@Component

public class LoginSender {

    @Autowired

    private AmqpTemplate amqpTemplate;

    @Value("${mq.config.exchange}")

    private String exchange;

    @Value("${mq.config.queue.message.routing.key}")

    private String routingkey;

    /**

     * 发送消息的方法

     * @param msg

     */

    public void sendMsg(String msg){

        /*向消息队列发送消息*/

        /*

         * 参数一：队列的名称

         * 参数二：发送的消息

         * */

        amqpTemplate.convertAndSend(exchange,routingkey,msg);

    }

}

com.bjsxt.send.RegSender

package com.bjsxt.send;

import org.springframework.amqp.core.AmqpTemplate;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.beans.factory.annotation.Value;

import org.springframework.stereotype.Component;

/***

 * 消息的发送者

 */

@Component

public class RegSender {

    @Autowired

    private AmqpTemplate amqpTemplate;

    @Value("${mq.config.exchange}")

    private String exchange;

    @Value("${mq.config.queue.email.routing.key}")

    private String routingkey;

    /**

     * 发送消息的方法

     * @param msg

     */

    public void sendMsg(String msg){

        /*向消息队列发送消息*/

        /*

         * 参数一：队列的名称

         * 参数二：发送的消息

         * */

        amqpTemplate.convertAndSend(exchange,routingkey,msg);

    }

}

dao层

com.bjsxt.dao.UserDao

package com.bjsxt.dao;

import com.bjsxt.pojo.Users;

import org.springframework.data.jpa.repository.JpaRepository;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;

import org.springframework.data.jpa.repository.Modifying;

import org.springframework.data.jpa.repository.Query;

import org.springframework.transaction.annotation.Transactional;

public interface UserDao extends JpaRepository<Users,Integer>, JpaSpecificationExecutor<Users> {

    /**

     * 登录操作

     * @param uname

     * @param pwd

     * @return

     */

    @Query(value = "select * from users where uname=? and pwd =? and locked=1",nativeQuery = true)

    Users findUser(String uname,String pwd);

    /**

     * 激活操作

     * @param uid

     */

    @Modifying

    @Transactional

    @Query(value = "update users set locked=1 where uid=?",nativeQuery = true)

    void updateUser(int uid);

    /**

     * 激活操作

     * @param uname

     * @param pwd

     */

    @Modifying

    @Transactional

    @Query(value = "update users set locked=1 where uname=? and pwd =?",nativeQuery = true)

    void updateUserlocked(String uname,String pwd);

}

service层

com.bjsxt.service.UserService（接口）

package com.bjsxt.service;

import com.bjsxt.pojo.Users;

public interface UserService {

    /**

     * 添加用户

     * @param users

     */

    void addUser(Users users);

    /**

     * 处理登录请求

     * @param uname

     * @param pwd

     * @return

     */

    Users findUser(String uname,String pwd);

    /***

     * 处理用户激活

     * @param uid

     * @return

     */

    void updateUserLock(int uid);

    /**

     * 处理用户激活

     * @param uname

     * @param pwd

     */

    void updateLock(String uname,String pwd);

}

com.bjsxt.service.impl.UserServiceImpl接口实现类

package com.bjsxt.service.impl;

import com.bjsxt.dao.UserDao;

import com.bjsxt.pojo.Users;

import com.bjsxt.service.UserService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

@Service

public class UserServiceImpl implements UserService {

    @Autowired

    private UserDao userDao;

    /**

     * 添加用户操作

     * @param users

     */

    @Override

    public void addUser(Users users) {

        userDao.save(users);

    }

    /**

     * 处理登录操作

     * @param uname

     * @param pwd

     * @return

     */

    @Override

    public Users findUser(String uname, String pwd) {

        return userDao.findUser(uname,pwd);

    }

    /**

     * 处理用户激活操作

     * @param uid

     */

    @Override

    public void updateUserLock(int uid) {

        userDao.updateUser(uid);

    }

    /**

     * 处理用户激活

     * @param uname

     * @param pwd

     */

    @Override

    public void updateLock(String uname,String pwd) {

        userDao.updateUserlocked(uname,pwd);

    }

}

控制层

com.bjsxt.controller.PageController（页面跳转）

package com.bjsxt.controller;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.PathVariable;

import org.springframework.web.bind.annotation.RequestMapping;

@Controller

public class PageController {

    /***

     * 展示页面

     * @return

     */

    @RequestMapping("/{page}")

    public String showPage(@PathVariable String page){

        return page;

    }

}

com.bjsxt.controller.UserController用户操作处理

package com.bjsxt.controller;

import com.bjsxt.pojo.Users;

import com.bjsxt.send.LoginSender;

import com.bjsxt.send.RegSender;

import com.bjsxt.service.UserService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.mail.SimpleMailMessage;

import org.springframework.mail.javamail.JavaMailSender;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.PathVariable;

import org.springframework.web.bind.annotation.RequestMapping;

import javax.servlet.http.HttpServletRequest;

import java.text.SimpleDateFormat;

import java.util.Date;

@Controller

public class UserController {

    @Autowired

    private JavaMailSender mailSender;

    @Autowired

    private UserService us;

    @Autowired

    private RegSender regSender;

    @Autowired

    private LoginSender loginSender;

    @RequestMapping("/save")

    public String addUser(Users users){

        us.addUser(users);

        //将Email-时间-URL格式的数据保存到队列中

        String email = users.getEmail();

        Date now =new Date();

        SimpleDateFormat spdf=new SimpleDateFormat("yyyy年MM月dd日 hh:mm:ss");

        String date = spdf.format(now);

        String url="http://192.168.41.24:8081/locked/"+users.getUid();

        regSender.sendMsg("邮箱："+email+"\t时间："+date+"\turl："+url);

        /**

         * 向qq邮箱发送信息

         */

        SimpleMailMessage message = new SimpleMailMessage();

        message.setFrom("1252639547@qq.com");//信息由谁发送

        message.setTo(users.getEmail());//信息发送给谁

        message.setSubject("主人主人！！你有新邮件啦~");//设置邮件的主题

        message.setText(url);//设置邮件的内容

        mailSender.send(message);

        return "login";

    }

    @RequestMapping("/loginuser")

    public String login(String uname, String pwd, HttpServletRequest request){

        Users user = us.findUser(uname, pwd);

        if (user!=null){

            //电话-时间-IP格式的数据保存到队列中

            String phone = user.getPhone();

            Date now =new Date();

            SimpleDateFormat spdf=new SimpleDateFormat("yyyy年MM月dd日 hh:mm:ss");

            String date = spdf.format(now);

            String ip = request.getRemoteHost();

            loginSender.sendMsg("电话："+phone+"\t时间："+date+"\tIP："+ip);

            return "success";

        }else {

            request.setAttribute("uname",uname);

            request.setAttribute("pwd",pwd);

            return "cuowu";

        }

    }

    /**

     * 处理用户激活

     * @param uid

     * @return

     */

    @RequestMapping("/locked/{uid}")

    public String bindLock(@PathVariable int uid){

        us.updateUserLock(uid);

        return "success1";

    }

    /**

     * 处理用户激活

     * @param uname

     * @param pwd

     * @return

     */

    @RequestMapping("/lock/{uname}/{pwd}")

    public String Locked(@PathVariable String uname,@PathVariable String pwd){

        us.updateLock(uname,pwd);

        return "success1";

    }

}

前端的页面分步

Spring Boot 整合Spring Data以及rabbitmq，thymeleaf，向qq邮箱发送信息

注册界面

templates/reg.html

<!DOCTYPE html>

<html lang="en" xmlns:th="http://www.w3.org/1999/xhtml">

<head>

    <meta charset="UTF-8"/>

    <title>注册</title>

</head>

<body>

<h1 style="align-content: center">用户注册</h1>

<form th:action="@{/save}" method="post" style="align-content: center">

    <p>

        用户名:<input type="text" name="uname">

    </p>

    <p>

        密码:<input type="password" name="pwd">

    </p>

    <p>

        确认密码:<input type="password">

    </p>

    <p>

        邮箱:<input type="email" name="email">

    </p>

    <p>

        电话号码:<input type="number" name="phone">

    </p>

    <p>

        <input type="submit" value="注册">

    </p>

</form>

</body>

</html>

登录界面

templates/login.html

<!DOCTYPE html>

<html lang="en" xmlns:th="http://www.w3.org/1999/xhtml">

<head>

    <meta charset="UTF-8"/>

    <title>Title</title>

</head>

<body>

<form method="post" th:action="@{/loginuser}">

    <p>

        用户名：<input type="text" name="uname">

    </p>

    <p>

        密码:<input type="password" name="pwd">

    </p>

    <p>

        <input type="submit" value="登录">&nbsp;&nbsp;<a href="reg.html">戳我去注册</a>

    </p>

</form>

</body>

</html>

当你注册成功后，但是没有激活直接登录，失败界面

templates/cuowu.html

<!DOCTYPE html>

<html lang="en" xmlns:th="http://www.w3.org/1999/xhtml">

<head>

    <meta charset="UTF-8">

    <title>主页面</title>

</head>

<body>

<h1>亲，你还未激活，请点击激活后登录</h1>

    <table border="1">

        <tr>

            <th>用户名</th>

            <th>密码</th>

            <th>操作</th>

        </tr>

        <tr>

            <th th:text="${uname}"></th>

            <th th:text="${pwd}"></th>

            <th><a th:href="@{/lock/}+${uname}+@{/}+${pwd}">激活</a></th>

        </tr>

    </table>

</body>

</html>

用户激活成功页面

templates/success1.html

<!DOCTYPE html>

<html lang="en" xmlns:th="http://www.w3.org/1999/xhtml">

<head>

    <meta charset="UTF-8">

    <title>激活页面</title>

</head>

<body>

<h1><a th:href="@{/login.html}">用户激活成功,戳我去登录</a></h1>

</body>

</html>

登录成功页面

templates/success.html

<!DOCTYPE html>

<html lang="en" xmlns:th="http://www.w3.org/1999/xhtml">

<head>

    <meta charset="UTF-8">

    <title>主页面</title>

</head>

<body>

<h1>登录成功</h1>

</body>

</html>

消息接受者 spring-boot-jpa-zcdl-consumer

pom文件

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>

    <parent>

        <groupId>org.springframework.boot</groupId>

        <artifactId>spring-boot-starter-parent</artifactId>

        <version>2.2.1.RELEASE</version>

        <relativePath/> <!-- lookup parent from repository -->

    </parent>

    <groupId>com.bjsxt</groupId>

    <artifactId>spring-boot-jpa-zcdl-consumer</artifactId>

    <version>0.0.1-SNAPSHOT</version>

    <name>spring-boot-jpa-zcdl-consumer</name>

    <description>spring-boot-jpa-zcdl-consumer</description>

    <properties>

        <java.version>1.8</java.version>

    </properties>

    <dependencies>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-amqp</artifactId>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-web</artifactId>

        </dependency>

        <dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-test</artifactId>

            <scope>test</scope>

            <exclusions>

                <exclusion>

                    <groupId>org.junit.vintage</groupId>

                    <artifactId>junit-vintage-engine</artifactId>

                </exclusion>

            </exclusions>

        </dependency>

        <dependency>

            <groupId>org.springframework.amqp</groupId>

            <artifactId>spring-rabbit-test</artifactId>

            <scope>test</scope>

        </dependency>

    </dependencies>

    <build>

        <plugins>

            <plugin>

                <groupId>org.springframework.boot</groupId>

                <artifactId>spring-boot-maven-plugin</artifactId>

            </plugin>

        </plugins>

    </build>

</project>

application.properties配置文件

server.port=8082

spring.rabbitmq.host=192.168.181.134

spring.rabbitmq.port=5672

spring.rabbitmq.username=admin

spring.rabbitmq.password=111111

#设置交换器的名称

mq.config.exchange=log.direct

#设置短信队列名称

mq.config.queue.message=log.message

#设置短信的路由键

mq.config.queue.message.routing.key=log.message.routing.key

#设置邮件队列名称

mq.config.queue.email=log.email

#设置邮件的路由键

mq.config.queue.email.routing.key=log.email.routing.key

接收消息

Spring Boot 整合Spring Data以及rabbitmq，thymeleaf，向qq邮箱发送信息

com.bjsxt.receiver.EmailReceiver

package com.bjsxt.receiver;

import org.springframework.amqp.core.ExchangeTypes;

import org.springframework.amqp.rabbit.annotation.*;

import org.springframework.stereotype.Component;

@Component

@RabbitListener(

        bindings = @QueueBinding(

                value =@Queue(value = "${mq.config.queue.email}",autoDelete = "true"),

                exchange = @Exchange(value = "${mq.config.exchange}",type = ExchangeTypes.DIRECT),

                key = "${mq.config.queue.email.routing.key}"

        )

)

public class EmailReceiver {

    /**

     * 接收消息的方法

     * 采用消息队列监听机制

     * @param msg

     */

    @RabbitHandler

    public void process(String msg){

        System.out.println("邮件消息："+msg);

    }

}

com.bjsxt.receiver.MessageReceiver

package com.bjsxt.receiver;

import org.springframework.amqp.core.ExchangeTypes;

import org.springframework.amqp.rabbit.annotation.*;

import org.springframework.stereotype.Component;

@Component

@RabbitListener(

        bindings = @QueueBinding(

                value =@Queue(value = "${mq.config.queue.message}",autoDelete = "true"),

                exchange = @Exchange(value = "${mq.config.exchange}",type = ExchangeTypes.DIRECT),

                key = "${mq.config.queue.message.routing.key}"

        )

)

public class MessageReceiver {

    /**

     * 接收消息的方法

     * 采用消息队列监听机制

     * @param msg

     */

    @RabbitHandler

    public void process(String msg){

        System.out.println("短信消息："+msg);

    }

}