rightbean.java

教师办公管理系统

package to.model.Right;

import java.sql.PreparedStatement;
import java.util.Collection;
import java.util.Vector;
import to.model.*;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.CallableStatement;

public class RightBean 
{
  
  Connection con=null;
  ResultSet rs=null;
  CallableStatement cs=null;
  PreparedStatement ps=null;
  DBConnection db=new DBConnection("CollegePool",500);
  
  
  //kjc_Right add
  public String insertRight(RightItem ri)
  {
    try
    {
       con=db.getConnection();
       cs=con.prepareCall("{call kjcRight(?,?,?,?)}");
       cs.setInt(1,ri.getRightID());
       cs.setString(2,ri.getRightName());
       cs.setString(3,ri.getRightExplain());
       cs.setString(4,"add");
       cs.executeUpdate();
       return "添加成功";
    }//end block try
    catch(Exception e)
    {
      e.printStackTrace();
      return "添加失败";
    }//end block catch
  }//end method inserRight()
  
  
  
  //kjc_Right update
  public String updateRight(RightItem ri)
  {
    try
    {
      con=db.getConnection();
      cs=con.prepareCall("{call kjcRight(?,?,?,?)}");
      cs.setInt(1,ri.getRightID());
      cs.setString(2,ri.getRightName());
      cs.setString(3,ri.getRightExplain());
      cs.setString(4,"edit");
      cs.executeUpdate();
      return "修改成功";
    }//end block try
    catch(Exception e)
    {
      e.printStackTrace();
      return "修改失败";
    }//end block catch
  }//end method updateRight()
  
  
  
  //kjc_Right delete
  public String deleteRight(RightItem ri)
  {
    try
    {
      con=db.getConnection();
      cs=con.prepareCall("{call kjcRight(?,?,?,?)}");
      cs.setInt(1,ri.getRightID());
      cs.setString(2,ri.getRightName());
      cs.setString(3,ri.getRightExplain());
      cs.setString(4,"del");
      cs.executeUpdate();
      return "删除成功";
    }//end block try
    catch(Exception e)
    {
      e.printStackTrace();
      return "删除失败";
    }//end block catch
  }//end method deleteRight()
  
  
  
  //kjc_Right find
  public Collection selectRight()
  {
    Vector v=new Vector();    
    try
    {
      con=db.getConnection();
      ps=con.prepareStatement("select * from kjc_Right");
      rs=ps.executeQuery();
      while(rs.next())
      {
        RightItem ri=new RightItem();
        ri.setRightID(rs.getInt("RightID"));
        ri.setRightName(rs.getString("RightName"));
        ri.setRightExplain(rs.getString("RightExplain"));
        v.add(ri);
      }
      return v;
    }//end block try
    catch(Exception e)
    {
      e.printStackTrace();
      return null;
    }//end block catch
  }//end method selectRight()
  
  
  public RightItem getRightbyID(int id)
  {
    try
    {
      con=db.getConnection();
      ps=con.prepareStatement("select * from kjc_Right where RightID='"+id+"'");
      rs=ps.executeQuery();
       RightItem ri=new RightItem();
      while(rs.next())
      {
        ri.setRightID(rs.getInt("RightID"));
        ri.setRightName(rs.getString("RightName"));
        ri.setRightExplain(rs.getString("RightExplain"));
      }
      return ri;
    }//end block try
    catch(Exception e)
    {
      e.printStackTrace();
      return null;
    }//end block catch
  
  }//end method getRightbyID()
  
  

}//end class RightBean