Thread: get element of ArrayList.

I have an arraylist as follows and I am trying to get an element so that it can be used in an if statement for evaluation. Is there a way to do this.

ArrayList<MusicRecording> info = myDataAccessor.getRecordings(category);
 
//This is what I want to do
if(info.get(3) == 1){
   //Do Something
}

MusicRecording is a class. I want to look at the value returned by getOwned();

public class MusicRecording extends Recording {
 
	/**
	 *  Data members
	 */
	private String artist;
	private int year;
	private String gameDescr;
	private String owned;
	private String link;
 
 
 
		public MusicRecording(String theArtist, String theGameDescr,
						  String theTitle, 
						  String theCategory, String theImageName, int theYear,String theOwned, String theLink) {
 
		super(theTitle, theCategory, theImageName);
 
		artist = theArtist;
		year = theYear;
		gameDescr = theGameDescr;
		owned = theOwned;
		link = theLink;
 
	}
 
 
	public String getArtist() {
		return artist;
	}
 
	public String getDescr(){
		return gameDescr;
	}
 
	public int getYear(){
		return year;
	}
 
	public String getOwned(){
		return owned;
	}
 
	public String getLink(){
		return link;
 
	}
 
 
		public String toString() {
 
		//display the Name of the Game and other info
		return getTitle() + "," + "   " + getArtist() + "," + "   " + getYear() + getOwned();
	}
 
 
 
		public int compareTo(Object object) {
 
		MusicRecording recording = (MusicRecording) object;
		String targetArtist = recording.getArtist();
 
		return artist.compareTo(targetArtist);
	}
 
}

Sure. Simply "Yes" or "No". Those are the only two values the "owned" variable can contain. it gets trickey though. See where say myDataAccessor.getRecordings(category);

That comes from this class.

 
import java.util.*;
import java.util.logging.Logger;
import java.sql.*;
 
 
public class MusicDataAccessor {
 
	/**
	 * Logger for the messages
	 */
	private static Logger logger = Logger.getLogger("crs471");
 
	private Connection myConn;
 
	private String system;
 
 
 
 
 
	protected static String owned;
 
	/**
	 * Constructs the data accessors.
	 */
	public MusicDataAccessor() {
 
		//  TO DO:  Complete the steps below.
		//
		//			For help, see the hints online
 
		try {
			// 1. Load database driver
			//         - driver name = com.mysql.jdbc.Driver		
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 
            String database =  "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/users/mfierro/desktop/Project/RainForest.mdb;";
			// 2. Connect to database
			//         - DB URL 	= jdbc:mysql://localhost:3306/rainforestdb
			//		   - user name 	= student
			//		   - password 	= student
			myConn = DriverManager.getConnection(
					database, "", "");
 
			logger.info("Connection successful");
		} catch (Exception exc) {
			logger.severe(exc.toString());
		}
	}
 
	/**
	 * Returns a sorted list of the categories for the recordings.
	 */
	public ArrayList<String> getCategories() {
 
		//  TO DO:  Complete the steps below.
		//
		//			For help, see the hints online
 
		// 3. Create an empty ArrayList of <String> for the categories
		ArrayList<String> categories = new ArrayList<String>();
 
		Statement myStmt = null;
		ResultSet myRs = null;
 
		try {
 
			// 4. Execute query with the given sql
			String sql = "SELECT name FROM Music_Categories order by id asc";
 
			myStmt = myConn.createStatement();
			myRs = myStmt.executeQuery(sql);
 
			// 5. Process result and place data in the categories ArrayList
			while (myRs.next()) {
				final String category = myRs.getString("name");
				categories.add(category);
			}
 
		}
		catch (SQLException exc) {
			logger.severe(exc.toString());
		}
		finally {
			// 6. Close the result set and the statement
			//    - NOTE: DO NOT CLOSE THE CONNECTION, "myConn"
 
			try {
				if (myRs != null) {
					myRs.close();
				}
 
				if (myStmt != null) {
					myStmt.close();
				}
			}
			catch (Exception exc) {
				logger.severe(exc.toString());
			}
		}
 
		// 7. Return the categories ArrayList
		return categories;
	}
 
 
 
 
	/**
	 * Returns a sorted list of recordings that match a given category
	 *
	 * @param category
	 *            the category for requested recordings.
	 * @return collection of <code>MusicRecording</code> objects
	 */
 
	public ArrayList<MusicRecording> getRecordings(String category) {
 
		ArrayList<MusicRecording> recordingList = new ArrayList<MusicRecording>();
 
		logger.info("Getting a list of recordings for: " + category);
 
 
		//select the system for the query based on the tab that is currently selected
 
	    if (MainFrame.sel == 0){
	    	 system="snes";
	    }
 
	    if (MainFrame.sel == 1){
	    	 system="sega";
	    }
 
	    if (MainFrame.sel == 2){
	    	 system="sega32X";
	    }
 
	    if (MainFrame.sel == 3){
	    	 system="sms";
	    }
 
		String sql = "SELECT * FROM Music_Recordings where category='" + category + "' and system='" + system + "'";
 
		Statement myStmt = null;
		try {
			myStmt = myConn.createStatement();
			ResultSet myRs = myStmt.executeQuery(sql);
 
			while (myRs.next()) {
			//	int recordingId = myRs.getInt("recording_id");
				String artist = myRs.getString("publisher");
				String title = myRs.getString("title");
				String imageName = myRs.getString("image_name");
				String gameDescr = myRs.getString("descr_name");
				int year = myRs.getInt("release_yr");
				String owned1 = myRs.getString("num_tracks");
				String link = myRs.getString("link");
				//String publisher = myRs.getString("publisher");
 
 
 
 
 
				MusicRecording tempRecording = new MusicRecording(artist, gameDescr, title, category, imageName,year,owned1,link);
 
 
				recordingList.add(tempRecording);
 
 
 
				}
 
		}
		catch (SQLException exc) {
			logger.severe(exc.toString());
		}
		finally {
			close(myStmt);
		}
 
		logger.info("getRecordings() complete!\n");
 
		return recordingList;
	}
 
 
	protected void close(Statement theStatement) {
		try {
			if (theStatement != null) {
				theStatement.close();
			}
		} catch (SQLException exc) {
			logger.severe(exc.toString());
		}
	}
}