sendmesbean.java

oa源码哈

package edu.scfc;

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

public class SendMesBean {

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

    public SendMesBean() {
    }

    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 setSendUName(String senduname){
        this.sendUName=senduname;
    }

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

    public void setSendTime(String sendtime){
        this.sendTime=sendtime;
    }

    public String getSendTime(){
        return this.sendTime;
    }

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

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

    public void setReceiveDept(String receivedept){
        this.receiveDept=receivedept;
    }

    public String getReceiveDept(){
        return this.receiveDept;
    }

    public void setReciveUName(String reciveuname){
        this.receiveUName=reciveuname;
    }

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

    public Vector selectSendMesTop6(String realName) {
        try{
            Vector vc = new Vector();
            con = objConnDB.getConnection();
            pstmt = con.prepareStatement("Select Top 6 * from TB_SendMes where SendUName = ? order by SendTime DESC");
            pstmt.setString(1,realName);
            rs = pstmt.executeQuery();
            while(rs.next()){
                SendMesBean objSendMesBean = new SendMesBean();
                objSendMesBean.setTitle(rs.getString("Title").trim());
                objSendMesBean.setContent(rs.getString("Content").trim());
                objSendMesBean.setSendUName(rs.getString("SendUName").trim());
                objSendMesBean.setSendTime(rs.getString("SendTime").substring(0,11));
                objSendMesBean.setReadOnly(rs.getString("ReadOnly").trim());
                objSendMesBean.setReceiveDept(rs.getString("ReceiveDept").trim());
                objSendMesBean.setReciveUName(rs.getString("ReceiveUName").trim());
                vc.addElement(objSendMesBean);
            }
            return vc;
        }catch(SQLException ex)
        {}
        return null;
    }
    public void UpdateSendMesReadOnly(String title,String senduname,String receivedept,String receiveuname){
        try{
            String read = "已读";
            con = objConnDB.getConnection();
            pstmt = con.prepareStatement("update TB_SendMes set ReadOnly=? where Title=? and SendUName=? and ReceiveDept=? and ReceiveUName=?");
            pstmt.setString(1,read);
            pstmt.setString(2,title);
            pstmt.setString(3,senduname);
            pstmt.setString(4,receivedept);
            pstmt.setString(5,receiveuname);
            pstmt.executeUpdate();
        }catch(SQLException ex){ex.printStackTrace();}
    }
    public void DeleteSendMesServelt(int id){
        try{
            con = objConnDB.getConnection();
            pstmt = con.prepareStatement("delete from TB_SendMes where ID=?");
            pstmt.setInt(1,id);
            pstmt.executeUpdate();
        }catch(SQLException ex){ex.printStackTrace();}
    }
}