operatorbean.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 OperatorBean 
{
    Connection con=null;
    PreparedStatement pstmt=null;
    ResultSet rs=null;
  public boolean addOperator(Operator op) throws Exception
  {
    
    boolean res=false;
    try 
    {
      con=DBConnect.getConnection();
      pstmt=con.prepareStatement("insert into Operator values(?,?,?,?)");
      pstmt.setString(1,op.getOperatorid());
      pstmt.setString(2,op.getOperatorname());
      pstmt.setString(3,op.getOperatorpassword());
      pstmt.setString(4,op.getOperatortype());
      pstmt.executeUpdate();
      pstmt.close();
      con.close();
      res=true;
    } 
    catch (Exception ex) 
    {
      ex.printStackTrace();
    }
    return res;
    
  }

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

  public boolean updateOperator(Operator op) throws Exception
  {
   boolean res=false;
    try 
    {
      con=DBConnect.getConnection();
      pstmt=con.prepareStatement("update Operator set Operatorname=?,Operatorpassword=?,Operatortype=? where Operatorid=?");
      
      pstmt.setString(1,op.getOperatorname());
      pstmt.setString(2,op.getOperatorpassword());
      pstmt.setString(3,op.getOperatortype());
      pstmt.setString(4,op.getOperatorid());
      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 Operator where Operatorid=?");
      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 findOperator(Operator op)
  {
    Vector v=new Vector();
    try 
    {
       con=DBConnect.getConnection();
      String s=" where ";
      if(!op.getOperatorid().equals(""))
        s=s+"operatorid like '%"+op.getOperatorid()+"%' and";
      if(!op.getOperatorname().equals(""))
        s=s+"operatorname like '%"+op.getOperatorname()+"%' and";
      if(!op.getOperatortype().equals(""))
        s=s+"operatortype like '%"+op.getOperatortype()+"%' and";
      if(s.equals(" where "))
        s="";
      else
        s=s.substring(0,s.lastIndexOf(" "));
      pstmt=con.prepareStatement("select * from operator"+s+"");
      rs=pstmt.executeQuery();
      while(rs.next())
      {
        Operator o=new Operator();
        o.setOperatorid(rs.getString(1));
        o.setOperatorname(rs.getString(2));
        o.setOperatortype(rs.getString(4));
        v.add(o);
      }
      pstmt.close();
      con.close();
    } 
    catch (Exception ex) 
    {
      ex.printStackTrace();
    } 
    
    return v;
  }
  
}