用户注册 v1 -根据邮箱注册用户

注册流程图

 

1. 验证邮箱有效性（代码亲测有效）

public static boolean verifyEmail(String email) {
    Pattern regex = Pattern.compile("^([a-z0-9A-Z]+[-|_|\\.]?)+[a-z0-9A-Z]@([a-z0-9A-Z]+(-[a-z0-9A-Z]+)?\\.)+[a-zA-Z]{2,}$");
    return regex.matcher(email).matches();
}

邮箱正则表达式解析

https://blog.csdn.net/cheng8512/article/details/2076145?ops_request_misc=%25257B%252522request%25255Fid%252522%25253A%252522161147817816780269813346%252522%25252C%252522scm%252522%25253A%25252220140713.130102334.pc%25255Fall.%252522%25257D&request_id=161147817816780269813346&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_v2~rank_v29-1-2076145.pc_search_result_cache&utm_term=java%20%E6%A3%80%E6%B5%8B%E9%82%AE%E4%BB%B6%E5%90%88%E6%B3%95

2. 验证邮箱是否存在

<select id="selectUserByEmail" resultType="java.lang.Integer">
    SELECT count(*) FROM user WHERE email = #{email};
</select>

3. 插入数据

<insert id="insertUserByEmail" parameterType="User">
    INSERT INTO user
    (email)
    VALUES
    (#{email});
</insert>