MyBatis增删改与MD5加密实现

ctrl+shift+N 查找文件
增删改需要进行事务管理。
增

@Test
public void testAdd(){
    User user=new User("wangwu","123","王五",18,new Date());
    SqlSession sqlSession = MyBatisUtil.getSqlSession();
    try {
        sqlSession.insert("insertUser",user);
        sqlSession.commit();
    } catch (Exception e) {
        e.printStackTrace();
        sqlSession.rollback();
    }
    sqlSession.close();
}

<insert id="insertUser" >
    insert into tb_users values(default,#{username},#{password},#{realname},#{age}
    ,#{birthday},#{regTime})
</insert>

改

sqlSession.update("updateUser",map);

<update id="updateUser">
    update tb_users set password=#{password} where id=#{id}
</update>

删

sqlSession.update("deleteUser",3);

<delete id="deleteUser">
    delete from tb_users where id=#{id}
</delete>

MD5工具类

package util;

import org.junit.Test;

import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;

public class Md5 {
    /**
     * 传入明文，返回经过md5加密的密文
     * @param s
     * @return
     */
    public static String getMd5(String s) throws NoSuchAlgorithmException {
        //获得MD5加密算法
        MessageDigest md5 = MessageDigest.getInstance("MD5");
        //对明文进行加密，得到每1字节
        byte[] digest = md5.digest(s.getBytes());
        //定义StringBuilder对得到的密文每一个字节拼接
        StringBuilder stringBuilder = new StringBuilder();
        for (byte b:
                digest) {
            //1个字节转换为2位16进制，与ff进行与运算会把负数变正数，不然会出现高位ffffffff
            String s1=Integer.toHexString(b&0xff);
            //对于不足2位的1个字节前面进行0填充
            if(s1.length()==1){
                stringBuilder.append("0");
            }
            //拼接
            stringBuilder.append(s1);
        }
        return stringBuilder.toString();
    }
    @Test
    public  void testMD5() throws NoSuchAlgorithmException {
        System.out.println(getMd5("123"));
    }
}