Com.sun.rowset.CachedRowSetImpl is sun proprietary API and may be removed in a future release

import java.sql.SQLException;
import javax.sql.rowset.CachedRowSet;
import java.util.ArrayList;
import com.sun.rowset.CachedRowSetImpl; // CachedRowSet implementation

public class GuestDataBean 
{
   private CachedRowSet rowSet;

   // construct TitlesBean object 
   public GuestDataBean() throws Exception
   {
      // load the MySQL driver
      Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
      
      // specify properties of CachedRowSet
      rowSet = new CachedRowSetImpl();  
      rowSet.setUrl( "jdbc:odbc:Conexão" ); 
      rowSet.setUsername( "" );
      rowSet.setPassword( "" );

	  // obtain list of titles
      rowSet.setCommand( 
         "SELECT Nome, Sobrenome, email FROM Jogador" );
      rowSet.execute();
   } // end GuestDataBean constructor

   // return an ArrayList of GuestBeans
   public ArrayList< GuestBean > getGuestList() throws SQLException
   {
      ArrayList< GuestBean > guestList = new ArrayList< GuestBean >();

      rowSet.beforeFirst(); // move cursor before the first row

      // get row data
      while ( rowSet.next() ) 
      {
         GuestBean guest = new GuestBean();

         guest.setNome( rowSet.getString( 1 ) );
         guest.setSobrenome( rowSet.getString( 2 ) );
         guest.setemail( rowSet.getString( 3 ) );

         guestList.add( guest ); 
      } // end while

      return guestList;
   } // end method getGuestList
   
   // insert a guest in guestbook database
   public void addGuest( GuestBean guest ) throws SQLException
   {
      rowSet.moveToInsertRow(); // move cursor to the insert row

      // update the three columns of the insert row 
      rowSet.updateString( 1, guest.getNome() ); 
      rowSet.updateString( 2, guest.getSobrenome() ); 
      rowSet.updateString( 3, guest.getemail() ); 
      rowSet.insertRow(); // insert row to rowSet
      rowSet.moveToCurrentRow(); // move cursor to the current row
      rowSet.acceptChanges(); // propagate changes to database
   } // end method addGuest
} // end class GuestDataBean