Scribd Logo
Upload

Welcome to Scribd!

  • 12 views

    Usuario User New Usuario

    Uploaded by

    Daniel Alejandro Rodriguez
    This document defines a class called ConsultaBD that connects to a MySQL database called "usuarios" using JDBC and retrieves all records from the "usuario" table. The getUsuarios method establishes a connection using the MySQL driver, executes a SELECT query to retrieve all columns and rows from the usuario table, iterates through the result set and adds each record to an ArrayList of Usuario objects which is then returned.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd

    Usuario User New Usuario

    Uploaded by

    Daniel Alejandro Rodriguez
    12 views2 pages
    This document defines a class called ConsultaBD that connects to a MySQL database called "usuarios" using JDBC and retrieves all records from the "usuario" table. The getUsuarios method establishes a connection using the MySQL driver, executes a SELECT query to retrieve all columns and rows from the usuario table, iterates through the result set and adds each record to an ArrayList of Usuario objects which is then returned.

    Original Title

    Struts Consulta II

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document defines a class called ConsultaBD that connects to a MySQL database called "usuarios" using JDBC and retrieves all records from the "usuario" table. The getUsuarios method establishes a connection using the MySQL driver, executes a SELECT query to retrieve all columns and rows from the usuario table, iterates through the result set and adds each record to an ArrayList of Usuario objects which is then returned.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    12 views2 pages

    Usuario User New Usuario

    Uploaded by

    Daniel Alejandro Rodriguez
    This document defines a class called ConsultaBD that connects to a MySQL database called "usuarios" using JDBC and retrieves all records from the "usuario" table. The getUsuarios method establishes a connection using the MySQL driver, executes a SELECT query to retrieve all columns and rows from the usuario table, iterates through the result set and adds each record to an ArrayList of Usuario objects which is then returned.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    package consulta.jdbc; /** * * @author Administrador */ import java.sql.*; import java.util.ArrayList; import java.util.List; import javax.sql.

    *; public class ConsultaBD { public static void main(String[] args) { } Connection c = null; Statement Stmt = null; ResultSet RS = null; public ArrayList getUsuarios() throws ClassNotFoundException, SQLException { ArrayList array = new ArrayList(); Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost/usuarios","root","root"); System.out.println("Conectando a la base de datos ..."); Stmt = con.createStatement(); RS = Stmt.executeQuery("SELECT * FROM usuario"); while (RS.next()) { Usuario user = new Usuario(); user.setNombre(RS.getString("Nombre")); user.setNombre(RS.getString("Apellido")); array.add(user); } return array; } }

    You might also like