但它不起作用,有人可以纠正它并发布它吗? 谢谢。
你的意思是,
UPDATE user
SET password = AES_ENCRYPT('" + newpw1 + "','key')
WHERE uid = '" + pubvar.uid + "')
更好地利用PreparedStatement
从SQL 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();