searchbookbybookname.java

项目名称eShop

/*
 * 创建日期：2006-8-7 21:56:27
 *
 * 代码作者：万星
 * 
 * 项目名称：eShop
 * 
 * Copyright 2006 北京交通大学信息管理与信息系统系. 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.ArrayList;
import java.util.Collection;

import eshop.common.*;


/**
 * <h5>功能说明:</h5>
 *
 * <h5>对应需求:</h5>
 * 
 *
 * @version 1.0
 * @author Administrator
 */
public class SearchBookByBookName implements ISearchBook
{

    /* （非 Javadoc）
     * @see eshop.bussiness.ISearchBook#getBook(java.lang.String)
     */
    public Collection getBook(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_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;
    }
    
}