Advertisement
ramarivera

Java1

Mar 6th, 2015
202
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.77 KB | None | 0 0
  1. public class Prueba {
  2.  
  3.     public static void main(String[] args) {
  4.        
  5.             Class.forName("com.mysql.jdbc.Driver");
  6.             Connection conexion = DriverManager.getConnection("jdbc:mysql://localhost/tgi_cdu", "root", "123");
  7.             Statement st = conexion.createStatement();
  8.             Statement stUpdate = conexion.createStatement();
  9.             String query = "SELECT causer_k USUARIO, caclav_k CLAVE FROM claves WHERE caclav_k IS NOT NULL";
  10.  
  11.             ResultSet rs = st.executeQuery(query);
  12.  
  13.             while (rs.next()) {
  14.                 String user = rs.getString("USUARIO");
  15.                 String nuevaClave = SessionHandler.getHash("123", user);
  16.  
  17.                 String updateQuery = "UPDATE claves SET caclav_k = '" + nuevaClave + "' WHERE causer_k = '" + user + "'";
  18.  
  19.                 int rows = stUpdate.executeUpdate(updateQuery);
  20.  
  21.                 if (rows == 0) {
  22.                     System.out.println("User " + user + " no pudo ser actualizado.");
  23.                 } else {
  24.                     System.out.println("User " + user + " actualizado correctamente.");
  25.                 }
  26.             }
  27.            
  28.             rs.close();
  29.  
  30.             Statement stUpdateClave = conexion.createStatement();
  31.             String queryUpdateClave = "UPDATE tgi_cdu.director SET valor = '123' WHERE codigo = 'CLAVEWS'";
  32.             Statement stUpdateServer = conexion.createStatement();
  33.             String queryUpdateServer = "UPDATE tgi_cdu.director SET valor = 'http://localhost:8080/GAT_CDU WHERE codigo = 'URLWS'";
  34.  
  35.             System.out.println("Clave WS Actualizado: " + stUpdateClave.executeUpdate(queryUpdateClave));
  36.             System.out.println("Server WS Actualizado: " + stUpdateServer.executeUpdate(queryUpdateServer));
  37.         }
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement