Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Class gestor
- {
- private final String cadena = "jdbc:sqlserver://localhost:1433;databaseName=Persona";
- public final String usuario = "mi_usuario";
- public final String contrasenia = "mi_contraseña";
- ArrayList<Persona> cargarPersonas()
- {
- ArrayList<Persona> personas = new ArrayList<>();
- try
- {
- Connection cn = DriverManager.getConnection(cadena, usuario, contrasenia);
- Statement st = cn.createStatement();
- ResultSet rs = st.executeQuery("SELECT * FROM Personas");
- while (rs.next())
- {
- String nombre = rs.getString("nombre");
- String apellido = rs.getString("apellido");
- int edad = rs.getInt("edad");
- Persona p = new Persona(nombre,apellido,edad);
- personas.add(p);
- }
- rs.close();
- st.close();
- cn.close();
- }catch (SQLException e)
- {
- System.out.println("ERROR : " + e);
- }
- return personas;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement