但它不起作用,有人可以纠正它并发布它吗? 谢谢。

你的意思是,

UPDATE user 
SET password = AES_ENCRYPT('" + newpw1 + "','key') 
WHERE uid = '" + pubvar.uid + "') 

更好地利用PreparedStatementSQL Injection预防。

String _upd = "UPDATE user SET password = AES_ENCRYPT(?,'key') WHERE uid = ?)"; 
PreparedStatement pstmt = con.prepareStatement(_upd); 
pstmt.setString(1, newpw1); 
pstmt.setString(2, pubvar.uid); 
pstmt.executeUpdate(); 

相关推荐