storepublisher.java

来自「这是一个小程序 网上书店用的 我们学生做的一个小实验」· Java 代码 · 共 38 行

package bean;
import java.util.*;
import java.sql.*;

/** 
 * This bean represents a heavyweight publisher.
 * @author  CTE
 * @version 1.0
 */
public class StorePublisher{
    
    /**
     * class LibraruLibrarian constructor
     */
    public StorePublisher() 
    {}
    
    /**
     * getPublisher returns a new publisher with the specified ssn
     * @param ssn int ssn of librarian to create
     * @retrun Librarian
     */
    public static Publisher getPublisher( int ssn )
	throws Exception {
	
	DBWrapper myConnection = DBWrapper.Instance();
	String sqlQuery = "select * from publisher where num='" + ssn + "'";
	ResultSet r = null;
	Publisher publisher = null;
	
	r = myConnection.runQuery( sqlQuery );
	if (r.next()) {
	    publisher = new Publisher( r.getString("num"), r.getString( "name" ), r.getString( "address") );
	}
	return publisher;
    }
}