searchbookbyall.java

项目名称eShop

/*
 * 创建日期：2006-8-7 22:27:14
 *
 * 代码作者：Administrator
 * 
 * 项目名称：eShop
 * 
 * Copyright 2005 Metarnet, Inc. All right reserved.
 */
package eshop.business;

import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Collection;
import java.util.ArrayList;

import eshop.common.DBConnection;
/**
 * <h5>功能说明:</h5>
 *
 * <h5>对应需求:</h5>
 * 
 *
 * @version 1.0
 * @author Administrator
 */
public class SearchBookByAll implements ISearchBook
{

    /* （非 Javadoc）
     * @see eshop.bussiness.ISearchBook#getBook(java.lang.String)
     */
    public Collection getBook(String strKeyWords) throws SQLException
    {
        Collection clnBooks=new ArrayList(); 
        
        clnBooks=this.getAllBook(strKeyWords);

        
        return clnBooks;  
    }
    
    private Collection getAllBook(String strKeyWords) throws SQLException
    {
        Collection clnBooks=new ArrayList(); 
        
        Connection conn=DBConnection.getConnection();        
        Statement stmt=conn.createStatement();
        ResultSet rs=null;
        try
        {   
            String strSQL="";
            if(strKeyWords.equals(""))
            {
                 strSQL="select * from T_BOOK order by F_BOOKID desc";
            }
            else
            {
                 strSQL="select * from T_BOOK where F_AUTHOR='" +strKeyWords+
                "' or F_BOOKNAME='"+strKeyWords+"' order by F_BOOKID desc";
            }
           
            
            rs=stmt.executeQuery(strSQL);            
            
            while(rs.next())
            {                    
                
                int    intBookID=rs.getInt("F_BOOKID");
                String strBookName=rs.getString("F_BOOKNAME");                      
                float flPrice=rs.getFloat("F_PRICE");
                float flDisCount=rs.getFloat("F_DISCOUNT");  
                String  strPicture=rs.getString("F_PICTURE");
                BigDecimal bdEshopPrice=calculateEshopPrice(BigDecimal.valueOf(flPrice),BigDecimal.valueOf(flDisCount));
                
                BookVO book=new BookVO(); 
                
                book.setBookID(intBookID);
                book.setBookName(strBookName);
                book.setBookPrice(BigDecimal.valueOf(flPrice));
                book.setBookEshopPrice(bdEshopPrice);
                book.setBookPicture(strPicture);
                
                clnBooks.add(book);                        
            }
            
            
        }
        catch(SQLException e)
        {
            e.printStackTrace();
            throw e;
            
        }
        finally
        {
            conn.close();             
        }
        
        return clnBooks;  
    }
    
    
    private BigDecimal calculateEshopPrice(BigDecimal bdPrice,BigDecimal bdDiscount)
    {
        BigDecimal bdEshopPrice=null;
        
        bdEshopPrice=bdPrice.multiply(bdDiscount);
        
        return bdEshopPrice;
    }
}