emailbean.java

教师办公管理系统

package to.model.Email;


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.*;
import to.model.People.PeopleItem;

public class EmailBean 
{
    
    Connection con=null;
    PreparedStatement ps=null;
    ResultSet rs=null;
    CallableStatement cs=null;
    DBConnection db=new DBConnection("CollegePool",500);
    
    
    public String insertEmail(EmailItem ei)
    {
       try
      {
        con=db.getConnection();
        ps=con.prepareStatement("insert into kjc_Email values(?,?,?,?,?,?)");
        ps.setString(1,ei.getEmailT());
        ps.setString(2,ei.getEmailC());
        ps.setString(3,ei.getAddD());
        ps.setString(4,ei.getPromulgator());
        ps.setInt(5,ei.getEmbracer());
        ps.setString(6,"未读");
        ps.executeUpdate();
        return "添加成功";
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return "添加失败";
      }//end block catch
    }//end method insertEmail()
    
    
     public void insertTempEmail(EmailItem ei)
    {
       try
      {
        con=db.getConnection();
        ps=con.prepareStatement("insert into kjc_TempEmail values(?,?,?,?,?,?)");
        ps.setString(1,ei.getEmailT());
        ps.setString(2,ei.getEmailC());
        ps.setString(3,ei.getAddD());
        ps.setString(4,ei.getPromulgator());
        ps.setInt(5,ei.getEmbracer());
        ps.setString(6,"未读");
        ps.executeUpdate();
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
      }//end block catch
    }//end method insertEmail()
    
    
    public Collection getEmail(int id)
    { 
      try
      {
        Vector v=new Vector();
        con=db.getConnection();
        ps=con.prepareStatement("select EmailID,EmailT,Promulgator,AddD,Ifreand from kjc_Email where Embracer=?");
        ps.setInt(1,id);
        rs=ps.executeQuery();
        while(rs.next())
        {
          EmailItem ei=new EmailItem();
          ei.setEmailID(rs.getInt("EmailID"));
          ei.setEmailT(rs.getString("EmailT"));
          ei.setPromulgator(rs.getString("Promulgator"));
          ei.setAddD(rs.getString("AddD"));
          ei.setIfreand(rs.getString("Ifreand"));
          v.add(ei);
        }
        return v;
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return null;
      }//end block catch
    }//end method getEmail()
    
    
    
    public String deleteEmail(int id)
    {
       try
      {
        con=db.getConnection();
        ps=con.prepareStatement("delete kjc_TempEmail where EmailID=?");
        ps.setInt(1,id);
        ps.executeUpdate();
        return "删除成功";
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return "删除失败";
      }//end block catch
    }//end method deleteEmail()
    
     public String deleteEmailshou(int id)
    {
       try
      {
        con=db.getConnection();
        ps=con.prepareStatement("delete kjc_Email where EmailID=?");
        ps.setInt(1,id);
        ps.executeUpdate();
        return "删除成功";
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return "删除失败";
      }//end block catch
    }//end method deleteEmailshou()
    
    
    public EmailItem getEmailMessage(int id)
    {
      try
      {
        con=db.getConnection();
        ps=con.prepareStatement("select EmailID,EmailT,Promulgator,AddD,EmailC from kjc_TempEmail where EmailID=?");
        ps.setInt(1,id);
        rs=ps.executeQuery();
        EmailItem ei=new EmailItem();
        while(rs.next())
        {
          this.editEmail(id);
          ei.setEmailID(rs.getInt("EmailID"));
          ei.setEmailT(rs.getString("EmailT"));
          ei.setPromulgator(rs.getString("Promulgator"));
          ei.setAddD(rs.getString("AddD"));
          ei.setEmailC(rs.getString("EmailC"));
        }
        return ei;
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return null;
      }//end block catch
    }//end method getEmailMessage()
    
    
    public PeopleItem getPeopleID(String name)
    {
      try
      {
        con=db.getConnection();
        ps=con.prepareStatement("select PeopleID from kjc_People where PeopleName=?");
        ps.setString(1,name);
        rs=ps.executeQuery();
        PeopleItem pi=new PeopleItem();
        while(rs.next())
        {
          pi.setPeopleID(rs.getInt("PeopleID"));
        }
        return pi;
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return null;
      }//end block catch
    }//end method getPeopleID()
    
    
    public void editEmail(int id)
    {
      try
      {
        con=db.getConnection();
        ps=con.prepareStatement("update kjc_Email set Ifreand=? where EmailID=?");
        ps.setString(1,"已读");
        ps.setInt(2,id);
        ps.executeUpdate();
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
      }//end block catch
    }//end method editInform()
    
    
    public Collection getFaJianXiang(String name)
    {
      try
      {
        Vector v=new Vector();
        con=db.getConnection();
        ps=con.prepareStatement("select kjc_TempEmail.EmailID,kjc_TempEmail.EmailT,kjc_People.PeopleName,kjc_TempEmail.AddD from kjc_TempEmail,kjc_People where kjc_TempEmail.Embracer=kjc_People.PeopleID and kjc_TempEmail.Promulgator=?");
        ps.setString(1,name);
        rs=ps.executeQuery();
        while(rs.next())
        {
          EmailItem ei=new EmailItem();
          ei.setEmailID(rs.getInt("EmailID"));
          ei.setEmailT(rs.getString("EmailT"));
          ei.setPeopleName(rs.getString("PeopleName"));
          ei.setAddD(rs.getString("AddD"));
          v.add(ei);
        }
        return v;
      }//end block try
      catch(Exception e)
      {
        e.printStackTrace();
        return null;
      }//end block catch
    }//end method getFaJianXiang()
    
    
}//end class EmailBean