添加用户接口更新

whyczh

2022-05-13 c4b24f0763164fb75932dfe2ede69fe8c6110b93

添加用户接口更新

 src/main/java/com/whyc/mapper/UserMapper.java

@@ -1,12 +1,15 @@
package com.whyc.mapper;

import com.whyc.pojo.UserInf;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface UserMapper extends CustomMapper<UserInf> {

    UserInf getUserInfoByPhoneNumber(String phoneNumber);
    UserInf getUserInfoByPhoneNumber(@Param("phoneNumber") String phoneNumber);

    int addJudge(@Param("uName") String uName,@Param("uPhoneNumber") String uPhoneNumber);

    List<UserInf> searchCS_All2();


 src/main/java/com/whyc/service/UserService.java

@@ -50,6 +50,9 @@
            if (userFound.getUId() != 0) {
                return new Response<>().set(1, false, "用户已存在");
            }
            if (userMapper.addJudge(user.getUName(),user.getUMobilephone())>0){
                return new Response<>().set(1, false, "用户已存在");
            }
            //user.setCreateTime(new Date());
            String[] dataArr = RSAUtil.decryptFrontP(user.getUpassword(), RSAUtil.fontSeparator);
            String password = dataArr[0];

 src/main/resources/mapper/UserMapper.xml

@@ -2,9 +2,14 @@
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.whyc.mapper.UserMapper" >

    <select id="addJudge" resultType="int">
        select count(uid) as nums from db_user.tb_user_inf where uname=#{uName} or uMobilephone=#{uPhoneNumber} limit 1
    </select>



    <select id="getUserInfoByPhoneNumber" resultType="com.whyc.pojo.UserInf">
        select * from db_user.tb_user_inf where uMobilephone =? limit 1
        select * from db_user.tb_user_inf where uMobilephone =#{phoneNumber} limit 1
    </select>
    <select id="searchCS_All2" resultType="com.whyc.pojo.UserInf">
        SELECT uId,uName FROM db_user.tb_user_inf  where uId not in (select distinct uId from db_user.tb_user_permitgroup_data) and uId!=0