Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class Prueba {
- public static void main(String[] args) {
- Class.forName("com.mysql.jdbc.Driver");
- Connection conexion = DriverManager.getConnection("jdbc:mysql://localhost/tgi_cdu", "root", "123");
- Statement st = conexion.createStatement();
- Statement stUpdate = conexion.createStatement();
- String query = "SELECT causer_k USUARIO, caclav_k CLAVE FROM claves WHERE caclav_k IS NOT NULL";
- ResultSet rs = st.executeQuery(query);
- while (rs.next()) {
- String user = rs.getString("USUARIO");
- String nuevaClave = SessionHandler.getHash("123", user);
- String updateQuery = "UPDATE claves SET caclav_k = '" + nuevaClave + "' WHERE causer_k = '" + user + "'";
- int rows = stUpdate.executeUpdate(updateQuery);
- if (rows == 0) {
- System.out.println("User " + user + " no pudo ser actualizado.");
- } else {
- System.out.println("User " + user + " actualizado correctamente.");
- }
- }
- rs.close();
- Statement stUpdateClave = conexion.createStatement();
- String queryUpdateClave = "UPDATE tgi_cdu.director SET valor = '123' WHERE codigo = 'CLAVEWS'";
- Statement stUpdateServer = conexion.createStatement();
- String queryUpdateServer = "UPDATE tgi_cdu.director SET valor = 'http://localhost:8080/GAT_CDU WHERE codigo = 'URLWS'";
- System.out.println("Clave WS Actualizado: " + stUpdateClave.executeUpdate(queryUpdateClave));
- System.out.println("Server WS Actualizado: " + stUpdateServer.executeUpdate(queryUpdateServer));
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement