ordermainbean.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 OrdermainBean 
{
  Connection con=null;
  PreparedStatement pstmt=null;
  ResultSet rs=null;
  PreparedStatement pstmt1=null;
  ResultSet rs1=null;
  public boolean addOrder(Ordermain om) throws Exception
  {
    boolean res=false;
    try
    {
      con=DBConnect.getConnection();
      pstmt=con.prepareStatement("insert into Ordermain values(?,?,?,?,?,?,?)");
      pstmt.setString(1,om.getOrderid());
      pstmt.setString(2,om.getCustomerid());
      pstmt.setString(3,om.getOrderdate().toString());
      pstmt.setDouble(4,om.getTotalmoney());
      pstmt.setString(5,om.getPaytype());
      pstmt.setString(6,om.getPayflag());
      pstmt.setString(7,om.getFlag());
      pstmt.executeUpdate();
      pstmt.close();
      con.close();
      res=true;
    }
    catch(Exception ex)
    {
      ex.printStackTrace();
    }
    return res;
  }

  public boolean delOrder(String id)
  {
    boolean res=false;
    try 
    {
      con=DBConnect.getConnection();
      pstmt=con.prepareStatement("delete from Ordermain where Orderid=?");
      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 Ordermain where Orderid=?");
      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 FindOrder(Ordermain om)
  {
    Vector v=new Vector();
    try 
    {
      con=DBConnect.getConnection();
      if(om.getOrderid().equals("")&&om.getCustomerid().equals("")&&om.getPaytype().equals("")&&om.getPayflag().equals("")&&om.getFlag().equals(""))
      {
        pstmt1=con.prepareStatement("select * from ordermain");
        rs1=pstmt1.executeQuery();
        while(rs1.next())
        {
          Ordermain o=new Ordermain();
          o.setOrderid(rs1.getString(1));
          o.setCustomerid(rs1.getString(2));
          o.setPaytype(rs1.getString(5));
          o.setPayflag(rs1.getString(6));
          o.setFlag(rs1.getString(7));
          v.add(o);
        }
      }
      else
      {
        String s=" where ";
        if(!om.getOrderid().equals(""))
          s=s+"orderid like '%"+om.getOrderid()+"%' and";
        if(!om.getCustomerid().equals(""))
          s=s+" customerid like '%"+om.getCustomerid()+"%' and";
        if(!om.getPaytype().equals(""))
          s=s+" paytype like '%"+om.getPaytype()+"%' and";
        if(!om.getPayflag().equals(""))
          s=s+" payflag like '%"+om.getPayflag()+"%' and";
        if(!om.getFlag().equals(""))
          s=s+" flag like '%"+om.getFlag()+"%' and";
        if(s.equals(" where "))
          s="";
        else
          s=s.substring(0,s.lastIndexOf(" "));
        pstmt=con.prepareStatement("select * from ordermain"+s+"");
        rs=pstmt.executeQuery();
        while(rs.next())
        {
          Ordermain o=new Ordermain();
          o.setOrderid(rs.getString(1));
          o.setCustomerid(rs.getString(2));
          o.setPaytype(rs.getString(5));
          o.setPayflag(rs.getString(6));
          o.setFlag(rs.getString(7));
          v.add(o);
        }
      }
    } 
    catch (Exception ex) 
    {
      ex.printStackTrace();
    }
    
    return v;
  }
    
}