stockbean.java

精美的画面。完善的功能

package Flower.model;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Collection;
import java.util.Vector;
public class stockBean 
{
  Connection con=null;
  PreparedStatement pstmt=null;
  ResultSet rs=null;
    PreparedStatement pstmt1=null;
  ResultSet rs1=null;
  public boolean addStock(Stock st) throws Exception
  {
    boolean res=false;
    try 
    {
      con=DBConnect.getConnection();
      pstmt=con.prepareStatement("insert into Stock values(?,?,?)");
      pstmt.setString(1,st.getStockid());
      pstmt.setString(2,st.getGoodsid());
      pstmt.setLong(3,st.getStocknum());
      pstmt.executeUpdate();
      pstmt.close();
      con.close();
      res=true;
      
    } 
    catch (Exception ex) 
    {
      ex.printStackTrace();
    }
    return res;
    
  }

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

  public boolean updateStock(Stock st) throws Exception
  {
    boolean res=false;
    try 
    {
      con=DBConnect.getConnection();
      pstmt=con.prepareStatement("update Stock set Goodsid=?,Stocknum=? where Stockid=?");
      
      pstmt.setString(1,st.getGoodsid());
      pstmt.setLong(2,st.getStocknum());
      pstmt.setString(3,st.getStockid());
      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 Stock where Stockid=?");
      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 findStock(Stock st)
  {
  Vector v=new Vector();
    try 
    {
      con=DBConnect.getConnection();
      if(st.getStockid().equals("")&&st.getGoodsid().equals(""))
      {
        pstmt1=con.prepareStatement("select * from stock");
        rs1=pstmt1.executeQuery();
        while(rs1.next())
        {
          Stock s1=new Stock();
          s1.setStockid(rs1.getString(1));
          s1.setGoodsid(rs1.getString(2));
          s1.setStocknum(rs1.getLong(3));
          v.add(s1);
        }
      }
      else
      {
        String s=" where ";
        if(!st.getStockid().equals(""))
          s=s+"stockid like '%"+st.getStockid()+"%' and";
        if(!st.getGoodsid().equals(""))
          s=s+" goodsid like '%"+st.getGoodsid()+"%' and";
        if(s.equals(" where "))
          s="";
        else
          s=s.substring(0,s.lastIndexOf(" "));
          pstmt=con.prepareStatement("select * from stock"+s+"");
          rs=pstmt.executeQuery();
        while(rs.next())
        {
          Stock s1=new Stock();
          s1.setStockid(rs.getString(1));
          s1.setGoodsid(rs.getString(2));
          s1.setStocknum(rs.getLong(3));
          v.add(s1);
        }
          rs.close();
          pstmt.close();
          pstmt1.close();
          con.close();
      }
    } 
    catch (Exception ex) 
    {
      ex.printStackTrace();
    }
    
    return v;
  }
 
}