[LucianoRey]

Hola, a ver si te sirve esto:

public void initaliseTheProductList(){
    try{
 
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection conn = DriverManager.getConnection("jdbc:odbc:aDatabase");
      stmt = conn.createStatement();
 
      String fullListQuery = "select * from Products";
 
      ResultSet rset = stmt.executeQuery(fullListQuery);
 
      while (rset.next()){
        fullList.add(rset.getString("prod_catNo"));
        fullList.add(rset.getString("prod_name"));
        fullList.add(rset.getString("prod_description"));
        fullList.add(rset.getString("prod_price"));
      }//End while
 
      conn.close();
    }catch (Exception ex){
      System.out.println(ex);
    }
 
  }

Saludos.