mysql ,MD5盐值加密

来源：互联网发布：网购选哪软件好编辑：程序博客网时间：2024/05/17 08:19

insert into kq_user(user_id,user_name,password,salt_value)
values('admin','admin','70c3fb494f99ed2a1335d581f5c6aee0','120');

=========================================

select md5(CONCAT('admin','120'))

70c3fb494f99ed2a1335d581f5c6aee0

insert into kq_user(user_id,user_name,password,salt_value)
values('admin','admin','70c3fb494f99ed2a1335d581f5c6aee0','120');

select * from kq_user;

========================================

select md5(CONCAT('120','120'))

70c3fb494f99ed2a1335d581f5c6aee0

insert into kq_user(user_id,user_name,password,salt_value)
values('120','120','70c3fb494f99ed2a1335d581f5c6aee0','120');

select * from kq_user;

========================================

<select id="validUser" parameterType="com.paic.xface.common.entity.User"
resultType="com.paic.xface.common.entity.User">
select t.user_id userId, t.user_name userName,t.`password` password, t.user_display_name userDisplayName,t.salt_value salt from kq_user as t where
t.`password`=md5(CONCAT(#{password},t.salt_value)) and
t.user_name=#{userName} limit 0,1
</select>

<update id="updatePwd" parameterType="com.paic.xface.common.entity.User">
UPDATE `kq_user` t
SET t.`password` = md5(#{password}),
t.salt_value = #{userDisplayName}
WHERE
t.user_id = #{userId}
</update>

阅读全文

0 0