flowerinfobean.java

精美的画面。完善的功能

package Flower.model;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.util.Collection;
import java.util.Vector;
import java.util.*;
public class FlowerInfoBean 
{
  Connection con=null;
  PreparedStatement pstmt=null;
  PreparedStatement pstmt1=null;
  ResultSet rs=null;
//  ResultSet rs3=null;
  ResultSet rs1=null;
  public boolean addFlowerInfo(Flowerinfo Fif) throws Exception
  {
    boolean res=false;
    try 
    {
      con=DBConnect.getConnection();
      pstmt=con.prepareStatement("insert into FlowerInfo values(?,?,?,?,?,?)");
      pstmt.setString(1,Fif.getFlowerid());
      pstmt.setString(2,Fif.getFlowername());
      pstmt.setString(3,Fif.getFlowertypeid());
      pstmt.setString(4,Fif.getFlowercolor());
      pstmt.setString(5,Fif.getFlowerphoto());
      pstmt.setString(6,Fif.getFlowerdescription());
      pstmt.executeUpdate();
      pstmt.close();
      con.close();
      res=true;
    } 
    catch (Exception ex) 
    {
      ex.printStackTrace();
    }
    
    return res;
  }

  public boolean updateFlowerinfo(Flowerinfo Fif) throws Exception
  {
    boolean res=false;
    try 
    {
      con=DBConnect.getConnection();
      pstmt=con.prepareStatement("update FlowerInfo set FlowerName=?,FLowerTypeID=?,FLowerColor=?,FLowerPhoto=?,FlowerDescription=? where FlowerID=?");
       
      pstmt.setString(1,Fif.getFlowername());
      pstmt.setString(2,Fif.getFlowertypeid());
      pstmt.setString(3,Fif.getFlowercolor());
      pstmt.setString(4,Fif.getFlowerphoto());
      pstmt.setString(5,Fif.getFlowerdescription());
      pstmt.setString(6,Fif.getFlowerid());
      pstmt.executeUpdate();
      pstmt.close();
      con.close();
      res=true;
    } 
    catch (Exception ex) 
    {
      ex.printStackTrace();
    }
    
    return res;
  }

  public boolean delFlowerinfo(String id)
  {
    
      boolean res=false;
    try 
    {
      con=DBConnect.getConnection();
      pstmt=con.prepareStatement("delete from FlowerInfo where FlowerID=?");
      pstmt.setString(1,id);
     
      pstmt.executeUpdate();
      pstmt.close();
      con.close();
      res=true;
    } 
    catch (Exception ex) 
    {
      ex.printStackTrace();
    }
    
    return res;
  }

  public boolean getID(String id)
  {
    boolean res=false;
    try 
    {
      con=DBConnect.getConnection();
      pstmt=con.prepareStatement("select * from FlowerInfo where FlowerID=?");
      pstmt.setString(1,id);
      rs=pstmt.executeQuery();
      if(rs.next())
      {
        res=true;
      }
      else
      {
        res=false;
      }
      rs.close();
      pstmt.close();
      con.close();
    } 
    catch (Exception ex) 
    {
      ex.printStackTrace();
    }
    
    return res;
  }

  public Collection FindFlowerInfo(Flowerinfo Fif) throws Exception
  {
    Vector v=new Vector();
    try 
    {
      con=DBConnect.getConnection();
      if(Fif.getFlowerid().equals("")&&Fif.getFlowername().equals("")&&Fif.getFlowertypeid().equals(""))
      {
        pstmt1=con.prepareStatement("select * from flowerinfo");
        rs1=pstmt1.executeQuery();
          while(rs1.next())
          {
            Flowerinfo fi=new Flowerinfo();
            fi.setFlowerid(rs1.getString(1));
            fi.setFlowername(rs1.getString(2));
            fi.setFlowertypeid(rs1.getString(3));
            fi.setFlowercolor(rs1.getString(4));
            fi.setFlowerphoto(rs1.getString(5));
            fi.setFlowerdescription(rs1.getString(6));
            v.add(fi);
          }
      }
      else
      {
        String s=" where ";
        if(!Fif.getFlowerid().equals(""))
          s=s+"flowerid like '%"+Fif.getFlowerid()+"%' and";
        if(!Fif.getFlowername().equals(""))
          s=s+" flowername like '%"+Fif.getFlowername()+"%' and";
        if(!(Fif.getFlowertypeid().equals("")))
          s=s+" flowertypeid like '%"+Fif.getFlowertypeid()+"%' and";
        if(s.equals(" where "))
          s="";
        else
          s=s.substring(0,s.lastIndexOf(" "));
          pstmt=con.prepareStatement("select * from flowerinfo"+s+"");
          rs=pstmt.executeQuery();
          while(rs.next())
          {
            Flowerinfo fi=new Flowerinfo();
            fi.setFlowerid(rs.getString(1));
            fi.setFlowername(rs.getString(2));
            fi.setFlowertypeid(rs.getString(3));
            fi.setFlowercolor(rs.getString(4));
            fi.setFlowerphoto(rs.getString(5));
            fi.setFlowerdescription(rs.getString(6));
            v.add(fi);
          }
          rs.close();
          pstmt.close();
          pstmt1.close();
          con.close();
      }
    } 
    catch (Exception ex) 
    {
      ex.printStackTrace();
    }
    
    return v;
  }
  
  public Collection getFlower(String name)
  {
                              
     Vector v=new Vector();
     try 
     {
        con=DBConnect.getConnection();
        pstmt=con.prepareStatement("select GoodsInfo.Goodsid,FlowerInfo.FlowerName,Flowerinfo.flowerTypeID,FlowerInfo.flowerPhoto,Goodsinfo.RetailPrice from FlowerInfo,GoodsInfo where goodsinfo.flowerid=flowerinfo.flowerid and Flowerinfo.FlowerName = ? ");
        pstmt.setString(1,name);
        rs=pstmt.executeQuery();
        while(rs.next())
        {
            FlowerItem fi=new FlowerItem();
            String goodname=rs.getString(1);
            String aa=rs.getString(2); 
            String bb=rs.getString(3);
            String cc=rs.getString(4);
            double dd=rs.getDouble(5);
            fi.setGoodsid(goodname);
            fi.setFlowerName(aa);
            fi.setFlowerTypeID(bb);
            fi.setFlowerPhoto(cc);
            fi.setRetailPrice(dd);
            v.add(fi);
        }
        return v;
     }
     catch(Exception e)
     {
        return null;
     }
  }
  
  
  
  public Collection getFlowerTypeID(String Type,String name)
  {
    Vector v=new Vector();
     try 
     {
        con=DBConnect.getConnection();
        String Name=name;
        if(Name.equals(""))
        {
          PreparedStatement ps=null;
          ps=con.prepareStatement("select GoodsInfo.Goodsid,FlowerInfo.FlowerName,Flowerinfo.flowerTypeID,FlowerInfo.flowerPhoto,Goodsinfo.RetailPrice from FlowerInfo,GoodsInfo where goodsinfo.flowerid=flowerinfo.flowerid and Flowerinfo.FlowerTypeID = ?");
          ps.setString(1,Type);
          ResultSet rs2=ps.executeQuery();
          while(rs2.next())
          {
              FlowerItem fi=new FlowerItem();
              String goodname=rs2.getString(1);
              String aa=rs2.getString(2); 
              String bb=rs2.getString(3);
              String cc=rs2.getString(4);
              double dd=rs2.getDouble(5);
              fi.setGoodsid(goodname);
              fi.setFlowerName(aa);
              fi.setFlowerTypeID(bb);
              fi.setFlowerPhoto(cc);
              fi.setRetailPrice(dd);
              v.add(fi);
          }
        }
        else if(Type.equals(""))
        {
          PreparedStatement pstm3=null;
          pstm3=con.prepareStatement("select GoodsInfo.Goodsid,FlowerInfo.FlowerName,Flowerinfo.flowerTypeID,FlowerInfo.flowerPhoto,Goodsinfo.RetailPrice from FlowerInfo,GoodsInfo where goodsinfo.flowerid=flowerinfo.flowerid and Flowerinfo.flowername = ?");
          pstm3.setString(1,name);
          ResultSet rs3=pstm3.executeQuery();
          while(rs3.next())
          {
              FlowerItem fi=new FlowerItem();
              String goodname=rs3.getString(1);
              String aa=rs3.getString(2); 
              String bb=rs3.getString(3);
              String cc=rs3.getString(4);
              double dd=rs3.getDouble(5);
              fi.setGoodsid(goodname);
              fi.setFlowerName(aa);
              fi.setFlowerTypeID(bb);
              fi.setFlowerPhoto(cc);
              fi.setRetailPrice(dd);
              v.add(fi);
          }
        }
        else
        {
          pstmt=con.prepareStatement("select GoodsInfo.Goodsid,FlowerInfo.FlowerName,Flowerinfo.flowerTypeID,FlowerInfo.flowerPhoto,Goodsinfo.RetailPrice from FlowerInfo,GoodsInfo where goodsinfo.flowerid=flowerinfo.flowerid and Flowerinfo.FlowerTypeID = ? and Flowerinfo.FlowerName=? ");
          pstmt.setString(1,Type);
          pstmt.setString(2,name);
          rs=pstmt.executeQuery();
          while(rs.next())
          {
              FlowerItem fi=new FlowerItem();
              String goodname=rs.getString(1);
              String aa=rs.getString(2); 
              String bb=rs.getString(3);
              String cc=rs.getString(4);
              double dd=rs.getDouble(5);
              fi.setGoodsid(goodname);
              fi.setFlowerName(aa);
              fi.setFlowerTypeID(bb);
              fi.setFlowerPhoto(cc);
              fi.setRetailPrice(dd);
              v.add(fi);
          }
        }
        return v;
     }
     catch(Exception e)
     {
        return null;
     }
  }
}