connect and display MS ACCESS

[Curtis Bridges]

I need some help. I'm trying to connect to a database I created in MS ACCESS the file name is db challenge.mdb
would somebody heip me out ? Please.
I'm getting 3 errors on lines 44,47,52 saying cannot find symbol variable rowSet
1 error on line 26 that say's cannot find symbol method JdbcRowSetImpl()
1 error on line 28 that say's cannot find symbol method setUserName(java.lang.String)

 
 
   import java.sql.ResultSetMetaData;
   import java.sql.SQLException;
   import javax.sql.rowset.JdbcRowSet;
   import com.sun.rowset.JdbcRowSetImpl;
   
  
  
  public class JdbcRowSetTest
  {
      //JDBC database URL, username and password
      static final String DRIVER = "com.mysql.jdbc.Driver";
      static final String DATABASE_URL = "jdbc:mysql://localhost/books";
      static final String USERNAME = "jhtp7";
      static final String PASSWORD = "jhtp7";
      
      
      public JdbcRowSetTest()
      {
      
      //connect and query database
      try
      {
      Class.forName(DRIVER);
      
      // specify properties
       JdbcRowSet rowset = JdbcRowSetImpl(); 
       rowset.setUrl (DATABASE_URL);
       rowset.setUserName(USERNAME);
       rowset.setPassword (PASSWORD);
       rowset.setCommand ("SELECT * FROM authors");
       rowset.execute();
       
       // process query results
       ResultSetMetaData metaData = rowset.getMetaData();
       int  numberOfColumns = metaData.getColumnCount();
       System.out.println(" Authors  Table of Books Database");
       
       // display rowset header
       for ( int i = 1; i <= numberOfColumns; i++)
        System.out.printf("hhh",metaData.getColumnName(i));
        System.out.println ();
        
       //display each row
       while( rowSet.next)
       {
       for ( int i = 1; i <= numberOfColumns; i++)
        System.out.printf("hhh",rowSet.getObject(i));
        System.out.println ();
       } //end while
       
       // close
       rowSet.close();
      }//end try
      catch ( SQLException sqlException )
      {
      
        sqlException.printStackTrace();
          System.exit(1);
      }//end catch
      catch(ClassNotFoundException classNotFound)
      {
       classNotFound.printStackTrace();
            System.exit(1);
      }//end catch
        } // end DisplayAuthors constructor
      
      // Launch
         public static void main( String args[] )
         {
         JdbcRowSetTest appication = new JdbcRowSetTest();
         };//end main
         }//end class JdbcRowSetTest