providerbean.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 ProviderBean 
{
  Connection con=null;
  PreparedStatement pstmt=null;
  ResultSet rs=null;
  public boolean addProvider(Providerinfo11 proinfo) throws Exception
  {
    boolean res=false;
    try
    {
      con=DBConnect.getConnection();
      pstmt=con.prepareStatement("insert into ProviderInfo11 values(?,?,?,?,?,?)");
      pstmt.setString(1,proinfo.getSupid());
      pstmt.setString(2,proinfo.getSupname());
      pstmt.setString(3,proinfo.getAddress());
      pstmt.setString(4,proinfo.getZipcode());
      pstmt.setString(5,proinfo.getEmail());
      pstmt.setString(6,proinfo.getTel());
      pstmt.executeUpdate();
      pstmt.close();
      con.close();
      res=true;
    }
    catch(Exception ex)
    {
      ex.printStackTrace();
    }
    return res;
  }

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

  public boolean updateProvider(Providerinfo11 proinfo) throws Exception
  {
    boolean res=false;
    try 
    {
      con=DBConnect.getConnection();
      pstmt=con.prepareStatement("update ProviderInfo11 set SupName=?,Address=?,zipCode=?,Email=?,Tel=? where SupID=?");
      
      pstmt.setString(1,proinfo.getSupname());
      pstmt.setString(2,proinfo.getAddress());
      pstmt.setString(3,proinfo.getZipcode());
      pstmt.setString(4,proinfo.getEmail());
      pstmt.setString(5,proinfo.getTel());
      pstmt.setString(6,proinfo.getSupid());
      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 ProviderInfo11 where SupID=?");
      pstmt.setString(1,id);
      rs=pstmt.executeQuery();
      if(rs.next())
      {
        res=true;
      }
      else
      {
        res=false;
      }
    } 
    catch (Exception ex) 
    {
      ex.printStackTrace();
    }
    
    return res;
  }

  public Collection FindProvider(Providerinfo11 proinfo)
  {
    Vector v=new Vector();
    try
    {
      con=DBConnect.getConnection();
      String s=" where ";
      if(!proinfo.getSupid().equals(""))
        s=s+"SupID like '%"+proinfo.getSupid()+"%' and";
      if(!proinfo.getSupname().equals(""))
        s=s+"SupName like '%"+proinfo.getSupname()+"%' and";
      if(s.equals(" where "))
        s="";
      else
        s=s.substring(0,s.lastIndexOf(" "));
      pstmt=con.prepareStatement("select * from ProviderInfo11"+s+"");
      rs=pstmt.executeQuery();
      while(rs.next())
      {
        Providerinfo11 pro=new Providerinfo11();
        pro.setSupid(rs.getString(1));
        pro.setSupname(rs.getString(2));
        pro.setAddress(rs.getString(3));
        pro.setZipcode(rs.getString(4));
        pro.setEmail(rs.getString(5));
        pro.setTel(rs.getString(6));
        v.add(pro);
      }
      pstmt.close();
      con.close();
    }
    catch(Exception ex)
    {
      ex.printStackTrace();
    }
    return v;
  }
}