[数据库]MySQL加密
0
2016-12-28 13:00:07
MySQL字段加密和解密1.加密：aes_encrypt('admin','key') 解密：aes_decrypt(password,'key') 2.双向加密 通过密钥去加密，解密的时候的只有知道这个密钥的人来解密 加密：encode() 解密：decode() eg:encode('123456' 'adfdgfdhggfh'); decode(password,'adfdgfdhggfh');('123456') password加密是不可逆转的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=(sql); (1, ()); (2, ()); ResultSet rs=(); if(()){ resultUser=new User(); ((1)); ((2)); (()+"^^^^^"); } return resultUser; }} //sql语句 insert into t_user (userName,password) values('admin',AES_ENCRYPT('123456','key')); select userName,AES_DECRYPT(password,'key')password from t_user;
本文网址：/a/
*特别声明：以上内容来自于网络收集，著作权属原作者所有，如有侵权，请联系我们：admin@。
MYSQL
0