cn.structure.starter.oauth.mapper

接口 VerificationCodeMapper

@Mapper
public interface VerificationCodeMapper

验证码Mapper

从以下版本开始:

2021/6/21 16:35

版本:

1.0.1

作者:

chuck

方法概要

限定符和类型	方法和说明
VerificationCodeInfo	findCodeById(Integer id)
List<VerificationCodeInfo>	findOneDayCodeListByAddress(String ipAddress)
int	findVerificationCodeBlacklistByAddress(String address)
int	save(VerificationCodeInfo verificationCodeInfo)
int	updateCheckById(Integer id)

方法详细资料

save

@Insert(value="INSERT INTO verification_code_info (code,address,create_time)VALUES(#{code},#{address},#{createTime})")
 @Options(useGeneratedKeys=true,
         keyProperty="id")
int save(VerificationCodeInfo verificationCodeInfo)

findVerificationCodeBlacklistByAddress

@ResultType(value=java.lang.Integer.class)
 @Select(value="SELECT COUNT(1) FROM verification_code_blacklist WHERE address = #{address}")
int findVerificationCodeBlacklistByAddress(@Param(value="address")
                                                                                                                                                                                      String address)

findOneDayCodeListByAddress

@Results(id="baseResult",value={@Result(column="is_check",property="check",jdbcType=TINYINT),@Result(column="create_time",property="createTime",jdbcType=DATETIMEOFFSET)})
 @Select(value="SELECT id,code,address,is_check,create_time FROM verification_code_info WHERE address = #{address} AND  TO_DAYS(create_time) = TO_DAYS(NOW())")
List<VerificationCodeInfo> findOneDayCodeListByAddress(@Param(value="address")
                                                                                                                                                                                                                                                                                                                                                                                                    String ipAddress)

findCodeById

@ResultMap(value="baseResult")
 @Select(value="SELECT id,code,address,is_check,create_time FROM verification_code_info WHERE id = #{id}")
VerificationCodeInfo findCodeById(@Param(value="id")
                                                                                                                                                                              Integer id)

updateCheckById

@Update(value="UPDATE verification_code_info SET is_check = 1 WHERE id = #{id} ")
int updateCheckById(@Param(value="id")
                                                                                                       Integer id)