MySQL欄位加密與解密
加密：
aes_encrypt('admin','key')
2. 解密：
aes_decrypt(password,'key')
2.雙向加密 透過金鑰去加密，解密的時候的只有知道這個金鑰的人來解密
加密：encode()
解密：decode()
encode('123456' 'adfd ##3.PASSWORD('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=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语句
insert into t_user (userName,password) values('admin',AES_ENCRYPT('123456','key'));
select userName,AES_DECRYPT(password,'key')password from t_user;以上是關於MySQL加密詳解的詳細內容。更多資訊請關注PHP中文網其他相關文章！
