c05f87170e0a001c1ae389e389b64382

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

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

/** 
 * class StoreBook is a heavy weight representation
 * of a book at a library
 */
public class StoreBookTitle
{
    /**
     * class StoreBook constructor
     */
    public StoreBookTitle()
    {}
    
    /**
     * getBook returns a book object with the specified id
     * @param inBookId int id of book
     * @return Book
     */
    public static BookTitle getBookTitle( String inBookId ) 
	throws Exception {
	
	BookTitle myBook = null;
	String sqlQuery = "select * from booktitle, isbn='" + inBookId + "'";
	// Get a the singleton db wrapper
	DBWrapper myConnection = DBWrapper.Instance();
        ResultSet r = null;
	
	r = myConnection.runQuery( sqlQuery );
	if (r.next()) {
	    // create the book object
	    myBook=new BookTitle(r.getString("title"),r.getString("author"),r.getString("isbn"),r.getString("edition")
	    		,r.getString("publisher"),r.getString("published_date"),r.getDouble("price"),r.getDouble("discount")
	    		,r.getString("description"),r.getInt("qtyinstock"),r.getString("catalognum"));
	}
	// close the result set
	r.close();
	return myBook;
    }
}