mailbean.java

这是一个很好用的软件

					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 (doc != null)
				doc.closeConn();
		}
		return count;
	}

	public void DeleteFJInS(String yjfjid, String sjid, String value) {
		DocBean doc = null;
		try {
			doc = new DocBean();
			String fid = yjfjid;
			int sjnum = CheckS(fid);
			int fjnum = CheckF(fid);
			String str = "";
			if (value == null) {
				//删除sjfjgxb
				str = "delete from zz_sjfjgxb where yjfjid='" + yjfjid
						+ "' and sjid='" + sjid + "'";
			} else {
				str = "delete from zz_sjfjgxb" + " where yjfjid='" + yjfjid
						+ "' and sjid in"
						+ " (select sjid from zz_syjb where sjid='" + sjid
						+ "' and yjzt='" + value + "')";
			}
			doc.ExecuteSQL(str);
			//当收件箱（或垃圾箱）只有1条记录且发件箱，草稿箱没有记录，即系统中没有其他人使用该记录时
			if (sjnum == 1 && fjnum == 0) {
				DeleteFJ(yjfjid);
			}
		} catch (Exception e) {
			System.out.println("运行时出错：" + e);
		} finally {
			if (doc != null)
				doc.closeConn();
		}
	}

	public void DeleteFJInF(String yjfjid, String fjid) {
		DealString ds = new DealString();
		DocBean doc = null;
		ResultSet rs = null, rs1 = null;
		Statement stmt = null;
		String fid = yjfjid;
		int sjnum = CheckS(fid);
		int fjnum = CheckF(fid);

		int count = 0;
		try {
			doc = new DocBean();
			if (sjnum == 0 && fjnum == 1) {
				String str1 = "select fjid from zz_yjfjb where fjid='" + fjid
						+ "'";
				rs1 = doc.QuerySQL(str1);
				while (rs1.next()) {
					if (fjid.equals(rs1.getString("fjid")))
						count++;
				}
				if (count == 1) {
					long fjid1 = Long.parseLong(fjid);
					delSJR(fjid1);
					delFMail(fjid);
				}
				DeleteFJ(yjfjid);
			}
			//对发件箱或者草稿箱：当有其他人使用该附件时，将该邮件的状态值改为2
			else {
				long fjid1 = Long.parseLong(fjid);
				modifyFMail(2, fjid1);
			}
		} catch (Exception e) {
			System.out.println("运行时出错：" + 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);
				}
			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;
	}

}