favorite.java

图书馆检索系统

package library;

import java.sql.*;

/**
* A class representing a favorite.
*
* @author dms
* @version 1.0
*
*/
public class Favorite extends LibraryObject {
   
   	private String callNumber;
   	private Member member;
 
	/**
	* public class Hold constructor
	*
	*/
	public Favorite(){} 

	/**
	* class Hold constructor that runs query 
	* to load a set of holds. Use inherited
	* method <code>getNext()</code> to iterate
	* through the returned Hold objects. This
	* constructor has default access, so only
	* classes in this package can use this 
	* constructor.  This effectively restricts the
	* use of this constructor to the Model.
	* @param sSQL String containing SQL statement
	* @throws SQLException
	*/
	Favorite(String sSQL) throws SQLException {
	
		ensureconnection();	
	  	mr = db.runQuery(sSQL);
		
	}
  
	protected void setVariables(ResultSet r) throws SQLException {
   
    	callNumber = r.getString("TitleID");
    	
    	member = new Member();
    	member.setConnection(db);
    	member.getMember(r.getInt("CustomerID"));	
      	
  	}

	/**
	* Accessor for Call Number
	* @return String
	*/
    public String getCallNumber() {return callNumber;}

	/**
	* Accessor for holder member
	* @return Member
	*/
    public Member getMember() {
    	return member;
    }
		
}