mysql批量加密_JDBC批量加密数据库密码

packagecom.lxc.wmb;importjava.io.UnsupportedEncodingException;importjava.security.NoSuchAlgorithmException;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.ArrayList;importjava.util.HashMap;importjava.util.List;importjava.util.Map;public classUpdatePwd {public static voidmain(String[] args) {

String url= "jdbc:mysql://test1256.db.58dns.org:23384/db58_fbu_payment?useUnicode=true&characterEncoding=UTF-8&connectTimeout=60000&socketTimeout=60000";

String userName= "fbupay_admin";

String password= "7046e5127a93295c";

updatePwd(url, userName, password);

}private static voidupdatePwd(String url, String userName, String password) {

Connection conn= null;

PreparedStatement ps= null;

ResultSet rs= null;try{

Class.forName("com.mysql.cj.jdbc.Driver");

conn=DriverManager.getConnection(url, userName, password);

String sql= "SELECT ID,PASSWORD FROM FP_USER_BASE WHERE PASSWORD IS NOT NULL";

ps=conn.prepareStatement(sql);

ps.executeQuery();

rs=ps.executeQuery();

List> list = new ArrayList>();while(rs.next()){long id = rs.getLong("id");

String pwd= rs.getString("password");

Map map = new HashMap();

map.put("id", id);

map.put("pwd", pwd);

list.add(map);

}for (Mapmap : list) {long id = (Long) map.get("id");

String pwd= (String) map.get("pwd");

String newPwd=MD5.EncoderByMd5(pwd);

String updateSql= "UPDATE FP_USER_BASE SET PASSWORD = '"+newPwd+"' WHERE ID = "+id;

ps.executeUpdate(updateSql);

}

}catch(ClassNotFoundException e) {

e.printStackTrace();

}catch(SQLException e) {

e.printStackTrace();

}catch(NoSuchAlgorithmException e) {

e.printStackTrace();

}catch(UnsupportedEncodingException e) {

e.printStackTrace();

}finally{try{

rs.close();

ps.close();

conn.close();

}catch(SQLException e) {

e.printStackTrace();

}

}

}

}