.jpg)
MySQL字段加密和解密
-
? 加密：
????aes_encrypt('admin','key')
????2. ?解密：
??aes_decrypt(password,'key')
2.雙向加密 ? ? ?通過(guò)密鑰去加密，解密的時(shí)候的只有知道這個(gè)密鑰的人來(lái)解密
? ? ? 加密：encode()
? ? ? 解密：decode()
? ? ? ?????encode(‘123456’ ‘adfdgfdhggfh’);
? ? ? ? ? ?decode(password,’adfdgfdhggfh’);
3.PASSWORD(‘123456’)
? ? password加密是不可逆轉(zhuǎn)的
4.MD5(‘123456’)
//UserDao? public?User?login(Connection?con,User?user)?throws?Exception{ ????????User?resultUser=null; ????????String?sql="select?userName,AES_DECRYPT(password,'key')?password?from?t_user?where?userName=??and?AES_DECRYPT(PASSWORD,'key')=?"; ????????PreparedStatement?pstmt=con.prepareStatement(sql); ????????pstmt.setString(1,?user.getUserName()); ????????pstmt.setString(2,?user.getPassword()); ????????ResultSet?rs=pstmt.executeQuery(); ????????if(rs.next()){ ????????????resultUser=new?User(); ????????????resultUser.setUserName(rs.getString(1)); ????????????resultUser.setPassword(rs.getString(2)); ????????????System.out.println(resultUser.getPassword()+"^^^^^"); ????????} ????????return?resultUser; ????} } ??? ?//sql語(yǔ)句? ?insert?into?t_user?(userName,password)?values('admin',AES_ENCRYPT('123456','key'));?? ?select?userName,AES_DECRYPT(password,'key')password?from?t_user;
? 版權(quán)聲明
文章版權(quán)歸作者所有，未經(jīng)允許請(qǐng)勿轉(zhuǎn)載。
THE END
.png)
