mysql字段加密和解密
加密：
aes_encrypt('admin','key')
2. 解密：
aes_decrypt(password,'key')
2.双向加密 通过密钥去加密，解密的时候的只有知道这个密钥的人来解密
加密：encode()
解密：decode()
encode('123456' 'adfdgfdhggfh');
decode(password,'adfdgfdhggfh');
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加密详解的详细内容。