📄 mailbean.java
字号:
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
if(rs1!=null)try{ stmt = rs1.getStatement(); rs1.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
if(doc!=null)
doc.closeConn();
}
}
public void DeleteFJInC(String yjfjid) {
DealString ds = new DealString();
DocBean doc = null;
// ResultSet rs = null;
//当有其他人使用该附件时，将邮件附件的状态值变成1,改变邮件状态,readmail_caogao.jsp中的邮件处理
//即从草稿箱中发邮件时，上传附件后对附件的删除
String fid = yjfjid;
int sjnum = CheckS(fid);
int fjnum = CheckF(fid);
if (sjnum==0 && fjnum==1)
DeleteFJ(yjfjid);
else {
try{
doc = new DocBean();
String str = "update zz_yjfjb set fujianzt='1' where yjfjid='"+yjfjid+"'";
doc.ExecuteSQL(str);
}catch(Exception e){System.out.println("运行时出错："+e);}
finally{ if(doc!=null) doc.closeConn();}
}
}
public String getmyTime(){
GregorianCalendar sdate=new GregorianCalendar();
int year=sdate.get(Calendar.YEAR);
int month=sdate.get(Calendar.MONTH)+1;
int date=sdate.get(Calendar.DATE);
int hour=sdate.get(Calendar.HOUR_OF_DAY);
int minute=sdate.get(Calendar.MINUTE);
int second=sdate.get(Calendar.SECOND);
int millisecond=sdate.get(Calendar.MILLISECOND);
StringBuffer sResult=new StringBuffer();
//get year
sResult.append(year);
//get month
if (month<10){
sResult.append(0);
sResult.append(month);
}
else {sResult.append(month);}
//get date
if (date < 10) {
sResult.append(0);
sResult.append(date);
}
else {
sResult.append(date);
}
//get hour
if (hour < 10) {
sResult.append(0);
sResult.append(hour);
}
else {
sResult.append(hour);
}
//get minite
if (second < 10) {
sResult.append(0);
sResult.append(second);
}
else {
sResult.append(second);
}
//get millisecond
if (millisecond < 10) {
sResult.append(0);
sResult.append(millisecond);
}
else {
sResult.append(millisecond);
}
return sResult.toString();
}
/** 取得职工编号和fjid，对职工编号进行重组，排序
*
*
**/
public Vector sort(Vector vec)
{
String[] s = {};
String[] s1 = {};
Hashtable temp;
//正序
int v1 = 0;
int v2 = 0;
Hashtable hash,hash1;
String zgbh = "";
String zgbh1 = "";
for (int i=0;i<vec.size() ;i++ )
{
//v.add(s[0]);
//1.取出key和value:
hash = new Hashtable();
hash = (Hashtable)vec.get(i);
Enumeration en = hash.keys();
while (en.hasMoreElements())
{
zgbh = (String)en.nextElement();
String value1 = (String)hash.get(zgbh);
}
s = zgbh.split(",");
v1 = Integer.parseInt(s[0]);
for (int j=i;j<vec.size() ;j++ )
{
hash1 = (Hashtable)vec.get(j);
Enumeration en1 = hash1.keys();
while (en1.hasMoreElements())
{
zgbh1 = (String)en1.nextElement();
String value2 = (String)hash1.get(zgbh1);
}
s1 = zgbh1.split(",");
v2 = Integer.parseInt(s1[0]);
if (v1>v2)
{
temp = hash1;
hash1 = hash;
hash = temp;
}
vec.set(i,hash);
vec.set(j,hash1);
}
}
/*
for (int i=0;i<vec.size() ;i++ )
{
//System.out.println("vv["+i+"]="+vec.get(i));
Hashtable h1 = new Hashtable();
h1 = (Hashtable)vec.get(i);
Enumeration e = h1.keys();
while (e.hasMoreElements())
{
Object keys = e.nextElement();
Object value = h1.get(keys);
System.out.println("$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$");
System.out.println("keys["+i+"]="+keys+" "+"value["+i+"]="+value);
}
}
*/
return vec;
}
/** 倒序
*
*
**/
public Vector descsort(Vector vec)
{
String[] s = {};
String[] s1 = {};
Hashtable temp;
//倒序
int v1 = 0;
int v2 = 0;
Hashtable hash,hash1;
String zgbh = "";
String zgbh1 = "";
for (int i=vec.size()-1;i>=0 ;i-- )
{
//v.add(s[0]);
//1.取出key和value:
hash = new Hashtable();
hash = (Hashtable)vec.get(i);
Enumeration en = hash.keys();
while (en.hasMoreElements())
{
zgbh = (String)en.nextElement();
String value1 = (String)hash.get(zgbh);
}
s = zgbh.split(",");
v1 = Integer.parseInt(s[0]);
for (int j=i-1;j>=0 ;j-- )
{
hash1 = (Hashtable)vec.get(j);
Enumeration en1 = hash1.keys();
while (en1.hasMoreElements())
{
zgbh1 = (String)en1.nextElement();
String value2 = (String)hash1.get(zgbh1);
}
s1 = zgbh1.split(",");
v2 = Integer.parseInt(s1[0]);
if (v1>v2)
{
temp = hash1;
hash1 = hash;
hash = temp;
}
vec.set(i,hash);
vec.set(j,hash1);
}
}
return vec;
}
/** 对用逗号隔开的zgbh进行重新排列，保障小的在前面
*
*
**/
public String ResortArray (String s)
{
String[] s1 = {};
s1 = s.split(",");
String temp = "";
String s2 = "";
for (int i=0;i<s1.length ;i++ )
{
int a = Integer.parseInt(s1[i]);
for (int j=i+1;j<s1.length ;j++ )
{
int b = Integer.parseInt(s1[j]);
if (a>b)
{
temp = s1[i];
s1[i] = s1[j];
s1[j] = temp;
}
}
}
for (int i=0;i<s1.length ;i++ )
{
s2 += s1[i] + ",";
}
return s2;
}
/** 取得目录名称:年份
*
*
*/
public String getDirYear (String s)
{
return s.substring(0,4);
}
/** 取得目录名称:月份
*
*
**/
public String getDirMonth (String s)
{
return s.substring(4,6);
}
/** 对Vector进行重组，将FJID相同的姓名和在一起
*
*
**/
public Vector Resort (Vector v)
{
if (v.isEmpty())
{
return v;
}
Vector v1 = new Vector();
MailElementBean meb,meb1,meb2;
String fjid = "",xm = "",fjid1 = "",xm1 = "";
meb = new MailElementBean();
meb = (MailElementBean)v.get(0);
v1.add(meb);
for (int i=1;i<v.size() ;i++ )
{
boolean flag = true;
meb = new MailElementBean();
meb = (MailElementBean)v.get(i);
fjid = Long.toString(meb.getFJID());
xm = meb.getXM();
for (int j=0;j<v1.size() ;j++ )
{
meb1 = new MailElementBean();
meb1 = (MailElementBean)v1.get(j);
fjid1 = Long.toString(meb1.getFJID());
xm1 = meb1.getXM();
if (fjid.equals(fjid1))
{
xm1 += ","+xm;
meb1.setXM(xm1);
flag = false;
}
}
if (flag)
{
v1.add(meb);
}
}
return v1;
}
/** 对Vector进行重组，将SJID相同的姓名和在一起
*
*
**/
public Vector Resort1 (Vector v)
{
if (v.isEmpty())
{
return v;
}
Vector v1 = new Vector();
MailElementBean meb,meb1,meb2;
String sjid = "",xm = "",sjid1 = "",xm1 = "";
meb = new MailElementBean();
meb = (MailElementBean)v.get(0);
v1.add(meb);
for (int i=1;i<v.size() ;i++ )
{
boolean flag = true;
meb = new MailElementBean();
meb = (MailElementBean)v.get(i);
sjid = Long.toString(meb.getSJID());
xm = meb.getXM();
for (int j=0;j<v1.size() ;j++ )
{
meb1 = new MailElementBean();
meb1 = (MailElementBean)v1.get(j);
sjid1 = Long.toString(meb1.getSJID());
xm1 = meb1.getXM();
if (sjid.equals(sjid1))
{
xm1 += ","+xm;
meb1.setXM(xm1);
flag = false;
}
}
if (flag)
{
v1.add(meb);
}
}
return v1;
}
/** 垃圾箱
*
*
**/
public Vector Recycle (String strSQL,String searchType,String sort)
{
Vector vec = new Vector();
//DocBean doc = new DocBean();
String w = "";
if (searchType.equals("1"))
{
w = " order by xm";
}
else if (searchType.equals("2"))
{
w = " order by zt";
}
else if (searchType.equals("3"))
{
w = " order by fssj";
}
else if (searchType.equals("4") || searchType.equals("5"))
{
w = " order by fjdx";
}
else if (searchType.equals("6"))
{
w = " order by read";
}
strSQL += w;
if (sort.equals("1"))
{
strSQL += " desc";
}
ResultSet rs = db.QuerySQL(strSQL);
Statement stmt = null;
try
{
MailElementBean meb;
while(rs.next())
{
meb= new MailElementBean();
meb.setSJID(rs.getLong("SJID"));
//meb.setFJRZGBH(rs.getString("FJRZGBH"));
//meb.setSJRZGBH(rs.getString("SJRZGBH"));
meb.setXM(rs.getString("XM"));
meb.setZT(rs.getString("ZT"));
meb.setNR(rs.getString("NR"));
meb.setFSSJ(rs.getString("FSSJ"));
meb.setFJDX(rs.getInt("FJDX"));
meb.setYJZT(rs.getInt("YJZT"));
meb.setREAD(rs.getString("READ"));
vec.add(meb);
}
}catch(Exception e){System.out.println("MailBean运行时出错："+e);}
finally{
if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}
if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}
//doc.closeConn();
}
return vec;
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -