receivemesbean.java

oa源码哈

package edu.scfc;

import java.sql.*;
import java.util.*;

public class ReceiveMesBean {

    private String title;
    private String content;
    private String receiveUName;
    private String receiveTime;
    private String readOnly;
    private String sendDept;
    private String sendUName;
    int count = 0;
    Connection con = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    ConnDB objConnDB = new ConnDB();

    public ReceiveMesBean() {
    }

    public void setTitle(String title){
        this.title=title;
    }

    public String getTitle(){
        return this.title;
    }

    public void setContent(String content){
        this.content=content;
    }

    public String getContent(){
        return this.content;
    }

    public void setReceiveUName(String receiveuname){
        this.receiveUName=receiveuname;
    }

    public String getReceiveUName(){
        return this.receiveUName;
    }

    public void setReceiveTime(String receivetime){
        this.receiveTime=receivetime;
    }

    public String getReceiveTime(){
        return this.receiveTime;
    }

    public void setReadOnly(String readonly){
        this.readOnly=readonly;
    }

    public String getReadOnly(){
        return this.readOnly;
    }

    public void setSendDept(String senddept){
        this.sendDept=senddept;
    }

    public String getSendDept(){
        return this.sendDept;
    }

    public void setSendUName(String senduname){
        this.sendUName=senduname;
    }

    public String getSendUName(){
        return this.sendUName;
    }

    public int selecuNoReadMes(String realName){
        try{
            con = objConnDB.getConnection();
            pstmt = con.prepareStatement("Select count(*) from TB_ReceiveMes where ReceiveUName = ? and ReadOnly = ?");
            pstmt.setString(1,realName);
            pstmt.setString(2,"未读");
            rs = pstmt.executeQuery();
            if(rs.next()){count = rs.getInt(1);}
        }catch(SQLException ex){System.out.println(""+ex.getMessage());}
        return count;
    }

    public Vector selectReceiveMesTop6(String realName) {
       try{
           Vector vc = new Vector();
           con = objConnDB.getConnection();
           pstmt = con.prepareStatement("Select Top 6 * from TB_ReceiveMes where ReceiveUName = ? order by ReceiveTime DESC");
           pstmt.setString(1,realName);
           rs = pstmt.executeQuery();
           while(rs.next()){
               ReceiveMesBean objReceiveMesBean = new ReceiveMesBean();
               objReceiveMesBean.setTitle(rs.getString("Title").trim());
               objReceiveMesBean.setContent(rs.getString("Content").trim());
               objReceiveMesBean.setReceiveTime(rs.getString("ReceiveTime").substring(0,11));
               objReceiveMesBean.setReadOnly(rs.getString("ReadOnly").trim());
               objReceiveMesBean.setSendDept(rs.getString("SendDept").trim());
               objReceiveMesBean.setSendUName(rs.getString("SendUName").trim());
               vc.addElement(objReceiveMesBean);
           }
           return vc;
       }catch(SQLException ex)
       {}
        return null;
    }
    public void UpdateReceiveMesReadOnly(String title,String receiveuname,String senddept,String senduname){
        try{
            String read = "已读";
            con = objConnDB.getConnection();
            pstmt = con.prepareStatement("update TB_ReceiveMes set ReadOnly=? where Title=? and ReceiveUName=? and SendDept=? and SendUName=?");
            pstmt.setString(1,read);
            pstmt.setString(2,title);
            pstmt.setString(3,receiveuname);
            pstmt.setString(4,senddept);
            pstmt.setString(5,senduname);
            pstmt.executeUpdate();
        }catch(SQLException ex){ex.printStackTrace();}
    }
}