MD5加盐和UUid，Mybatis XXXmapper.xml事例

来源：互联网发布：子曰由诲女知之乎知之编辑：程序博客网时间：2024/05/18 00:38

MD5加盐和UUid

public class SeckillUtil {private final  String slat = "skdjffji###!!&^&%GTWH@";private final  String slatString = "skdjffji#@!#!!&^&%@#@D5@";public  String getMD5(long seckillId) {String base = slat + seckillId + "/" ;String md5 = DigestUtils.md5DigestAsHex(base.getBytes());return md5;}public  String getPasswodMD5(String password) {String base = slatString + password + "/" ;String md5 = DigestUtils.md5DigestAsHex(base.getBytes());return md5;}public  String createUuid(){UUID uuid = UUID.randomUUID();return uuid.toString();}}

Mybatis XXXmapper.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"    "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><!--  namespace="实现的接口"--><mapper namespace="org.seckill.dao.UserDao"><!--  目的：为Dao接口方法提供sql语句配置--><insert id="insertUser" parameterType="org.seckill.entity.Suser">insert into SUSER(USER_ID,USER_NAME,USER_PASSWORD,USER_EMAIL,USER_PHONE,USER_TOKEN,USER_DESC)values (#{userId},#{userName},#{userPassword},#{userEmail},#{userPhone},#{userToken},#{userDesc})</insert><!-- update id= "方法名",update返回int型，影响的行数--><update id= "updateUser" parameterType="org.seckill.entity.Suser"><!-- 具体sql语句-->update SUSER<set><if test="userPassword != null and !"".equals(userPassword.trim())">    USER_PASSWORD = #{userPassword},</if><if test="userEmail != null and !"".equals(userEmail.trim())">    USER_EMAIL = #{userEmail},</if><if test="userPhone != null and !"".equals(userPhone.trim())">    USER_PHONE = #{userPhone},</if><if test="userToken != null and !"".equals(userToken.trim())">    USER_TOKEN = #{userToken},</if><if test="userDesc != null and !"".equals(userDesc.trim())">    USER_DESC = #{userDesc},</if></set><where>and USER_NAME = #{userName}</where></update><select id="queryByName" resultType="Suser" >select <include refid="columns"/>from SUSER<where>and USER_NAME = #{name}</where></select><select id="queryBydesc" resultType="Suser" >select <include refid="columns"/>from SUSER<where>and USER_DESC like '%' #{desc} '%'</where></select><!-- order by create_time desc:根据创建时间反向排序--><select id="queryAllUser" resultType="Suser" >select <include refid="columns"/>from SUSERorder by CREATE_TIME desclimit #{offset},#{limit}  </select><sql id="columns">USER_ID,USER_NAME,USER_PASSWORD,USER_EMAIL,USER_PHONE,USER_TOKEN,CREATE_TIME,USER_DESC</sql></mapper>

0 0