informbean.java

教师办公管理系统

package to.model.Inform;


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


public class InformBean 
{
    Connection con=null;
    PreparedStatement ps=null;
    ResultSet rs=null;
    CallableStatement cs=null;
    DBConnection db=new DBConnection("CollegePool",500);
    
    
    public String insertInform(InformItem ii)
    {
      try
      {
        con=db.getConnection();
        ps=con.prepareStatement("insert into kjc_Inform(InformT,InformC,AddT,EndT,Promulgator,Embracer,Ifreand) values(?,?,?,?,?,?,?)");
        ps.setString(1,ii.getInformT());
        ps.setString(2,ii.getInformC());
        ps.setString(3,ii.getAddT());
        ps.setString(4,ii.getEndT());
        ps.setString(5,ii.getPromulgator());
        ps.setInt(6,ii.getEmbracer());
        ps.setString(7,"未读");
        ps.executeUpdate();
        return "添加成功";
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return "添加失败";
      }//end block catch
    }//end method insertInform()
    
    
    public void insertTempInform(InformItem ii)
    {
      try
      {
        con=db.getConnection();
        ps=con.prepareStatement("insert into kjc_TempInform(InformT,InformC,AddT,EndT,Promulgator,Embracer,Ifreand) values(?,?,?,?,?,?,?)");
        ps.setString(1,ii.getInformT());
        ps.setString(2,ii.getInformC());
        ps.setString(3,ii.getAddT());
        ps.setString(4,ii.getEndT());
        ps.setString(5,ii.getPromulgator());
        ps.setInt(6,ii.getEmbracer());
        ps.setString(7,"未读");
        ps.executeUpdate();   
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
      }//end block catch
    }//end method insertInform()
    
    
    
    
    
    
    public Collection getInform(int id)
    {
      try
      {
        Vector v=new Vector();
        con=db.getConnection();
        ps=con.prepareStatement("select InformID,InformT,Promulgator,AddT,EndT,Ifreand from kjc_Inform where Embracer=? or Embracer='0'");
        ps.setInt(1,id);
        rs=ps.executeQuery();
        int i=1;
        while(rs.next())
        {
          InformItem ii=new InformItem();
          ii.setId(i);
          ii.setInformID(rs.getInt("InformID"));
          ii.setInformT(rs.getString("InformT"));
          ii.setPromulgator(rs.getString("Promulgator"));
          ii.setAddT(rs.getString("AddT").trim());
          ii.setEndT(rs.getString("EndT").trim());
          ii.setIfreand(rs.getString("Ifreand"));
          v.add(ii);
          i++;
        }
        return v;
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return null;
      }//end block catch
    }//end method getInform()
    
    
    public Vector selectInform(String PeopleName)
    {
      try
      {
        Vector v=new Vector();
        con=db.getConnection();
        ps=con.prepareStatement("select kjc_TempInform.InformID,kjc_TempInform.InformT,Embracer,kjc_TempInform.AddT,kjc_TempInform.EndT from kjc_TempInform where kjc_TempInform.Promulgator=?");
        ps.setString(1,PeopleName);
        rs=ps.executeQuery();
        int i=1;
        while(rs.next())
        {
          InformItem ii=new InformItem();
          ii.setId(i);
          ii.setInformID(rs.getInt("InformID"));
          ii.setInformT(rs.getString("InformT"));
          ii.setEmbracer(rs.getInt("Embracer"));
          ii.setAddT(rs.getString("AddT").trim());
          ii.setEndT(rs.getString("EndT").trim());
          v.add(ii);
          i++;
        }//end block while
         
        return v;
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return null;
      }//end block catch
    }//end selectInform()
    
    
    public InformItem getInformMessage(int id)
    {
      try
      {
        con=db.getConnection();
        ps=con.prepareStatement("select InformID,InformT,InformC,AddT,EndT,Promulgator,Embracer from kjc_Inform where InformID=?");
        ps.setInt(1,id);
        rs=ps.executeQuery();
        InformItem ii=new InformItem();
        while(rs.next())
        {
          this.editInfrom(id);
          ii.setInformID(rs.getInt("InformID"));
          ii.setInformT(rs.getString("InformT"));
          ii.setInformC(rs.getString("InformC"));
          ii.setAddT(rs.getString("AddT"));
          ii.setEndT(rs.getString("EndT"));
          ii.setPromulgator(rs.getString("Promulgator"));
          ii.setEmbracer(rs.getInt("Embracer"));
        }//end block while
        return ii;
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return null;
      }//end block catch
    }//end method getInformMessage()
    public InformItem getInformMessage1(int id)
    {
      try
      {
        con=db.getConnection();
        ps=con.prepareStatement("select InformID,InformT,InformC,AddT,EndT,Promulgator,Embracer from kjc_Inform where InformID=?");
        ps.setInt(1,id);
        rs=ps.executeQuery();
        InformItem ii=new InformItem();
        while(rs.next())
        {
          ii.setInformID(rs.getInt("InformID"));
          ii.setInformT(rs.getString("InformT"));
          ii.setInformC(rs.getString("InformC"));
          ii.setAddT(rs.getString("AddT"));
          ii.setEndT(rs.getString("EndT"));
          ii.setPromulgator(rs.getString("Promulgator"));
          ii.setEmbracer(rs.getInt("Embracer"));
        }//end block while
        return ii;
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return null;
      }//end block catch
    }//end method getInformMessage1()
    
    
    public void editInfrom(int id)
    {
      try
      {
        con=db.getConnection();
        ps=con.prepareStatement("update kjc_Inform set Ifreand=? where InformID=?");
        ps.setString(1,"已读");
        ps.setInt(2,id);
        ps.executeUpdate();
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
      }//end block catch
    }//end method editInform()
    
    
    
    public String insertBack(BackItem bi)
    {
      try
      {
        con=db.getConnection();
        ps=con.prepareStatement("insert into kjc_Back values(?,?,?,?,?)");
        ps.setInt(1,bi.getInformID());
        ps.setString(2,bi.getBacker());
        ps.setString(3,bi.getBackDate());
        ps.setString(4,bi.getBackC());
        ps.setString(5,bi.getIfread());
        ps.executeUpdate();
        return "添加成功";
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return "添加失败";
      }//end block catch
    }//end method insertBack
    
    
    public String DeleteInform(int id)
    {
      try
      {
        con=db.getConnection();
        ps=con.prepareStatement("Delete kjc_TempInform where InformID=?");
        ps.setInt(1,id);
        ps.executeUpdate();
        return "删除成功";
      }//end block try
      catch(Exception e)
      {
         e.printStackTrace();
         return "删除失败";
      }//end block catch
    }//end method DeleteInform()
    
    
    public ResultSet getIfreand(InformItem bi)
    {
      try
      {
        con=db.getConnection();
        ps=con.prepareStatement("select Ifreand from kjc_inform where InformID=?");
        ps.setInt(1,bi.getInformID());
        rs=ps.executeQuery();
        return rs;
      }
      catch(Exception e)
      {
        e.printStackTrace();
        return null;
      }
    }
    public String updateInform(InformItem bi)
    {
      try
      {
        con=db.getConnection();
        ps=con.prepareStatement("update kjc_Inform set InformT=?,EndT=?,InformC=? where InformID=?");
        ps.setString(1,bi.getInformT());
        ps.setString(2,bi.getEndT());
        ps.setString(3,bi.getInformC());
        ps.setInt(4,bi.getInformID());
        ps.executeUpdate();
        return "修改成功";
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return "修改失败";
      }//end block catch
    }//end method updateBack()
    
    
    public Collection selectBack(int id)
    {
      try
      {
        Vector v=new Vector();
        con=db.getConnection();
        ps=con.prepareStatement("select BackID,Backer,BackC,BackDate,Ifread from kjc_Back where InformID=?");
        ps.setInt(1,id);
        rs=ps.executeQuery();
        int i=1;
        while(rs.next())
        {
          BackItem bi=new BackItem();
          bi.setId(i);
          bi.setBackID(rs.getInt("BackID"));
          bi.setBacker(rs.getString("Backer"));
          bi.setBackC(rs.getString("BackC"));
          bi.setBackDate(rs.getString("BackDate"));
          bi.setIfread(rs.getString("Ifread"));
          v.add(bi);
          i++;
        }//end block while
        return v;
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return null;
      }//end block catch
    }//end selectInform()
    
    
    public String deleteBack(int id)
    {
      try
      {
        con=db.getConnection();
        ps=con.prepareStatement("delete kjc_Back where BackID=?");
        ps.setInt(1,id);
        ps.executeUpdate();
        return "删除成功";
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return "删除失败";
      }//end block catch
    }//end method deleteBack
    
    
    public Collection getInformWeiDu(int id)
    {
      try
      {
        Vector v=new Vector();
        con=db.getConnection();
        ps=con.prepareStatement("select InformID,InformT,Promulgator,AddT,EndT,Ifreand from kjc_Inform where Embracer=? and Ifreand='未读' or Embracer='0'");
        ps.setInt(1,id);
        rs=ps.executeQuery();
        int i=1;
        while(rs.next())
        {
          InformItem iii=new InformItem();
          iii.setId(i);
          iii.setInformID(rs.getInt("InformID"));
          iii.setInformT(rs.getString("InformT"));
          iii.setPromulgator(rs.getString("Promulgator"));
          iii.setAddT(rs.getString("AddT").trim());
          iii.setEndT(rs.getString("EndT").trim());
          iii.setIfreand(rs.getString("Ifreand"));
          v.add(iii);
          i++;
        }
        return v;
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return null;
      }//end block catch
    }//end method getInform()
}//end class InformBean