title: Storing resultset in an arraylist Java
body: <p>My program queries a MySQL database on the band and CD band, and return the query as a resultset. I am trying to store the resultset of the CD table query into an arraylist so the Title and Year of each CD is stored and then added to the current Band through addCD(CD cd). My Band class has an arraylist of CD objects, and my CD objects has a String for the title, and int for the year. </p>