maildaoimpl.java

Java协同办公系统。实现公司内部的人事

package com.icss.oa.dao.impl;

import java.util.List;
import java.util.Properties;

import com.icss.oa.base.*;
import com.icss.oa.base.impl.BaseDAOImpl;

import com.icss.oa.dao.MailDAO;

public class MailDAOImpl implements MailDAO {

	public StringBuffer getPersonByDeptNO(String deptNO) {
		String sqlStr="select * from person where deptno=?";
		BaseDAO baseDAO=new BaseDAOImpl();
		String dept[]={deptNO};
		List personsList=baseDAO.queryAllObject(sqlStr,dept);
		StringBuffer buf = new StringBuffer();
		buf.append("document.form1.persons.length = " + (personsList.size()) + ";\n");
		for(int i=0;i<personsList.size();i++){
			Properties prop=(Properties)personsList.get(i);
			String deptNO1=prop.getProperty("PERSONID");
			String deptName=prop.getProperty("NAME");
			buf.append("document.form1.persons.options[" + (i) + "].value = '" +deptNO1+ "';\n");
			buf.append("document.form1.persons.options[" + (i) + "].text = '" +deptName+ "';\n");
		}
		return buf;
	}

	public List getAllDept() {
		String sqlStr="select * from dept";
		return FileBase.queryAllObject(sqlStr);
	}

	public void send(String[] receiver, String title, String content, int senderId) {
		for(int i=0;i<receiver.length;i++){
			String receiverId=receiver[i].substring(0,receiver[i].indexOf("|"));
			System.out.println(receiver[i]+"  "+receiverId);

			String sqlStr="insert into message values(mailid_seq.nextval,"+receiverId+","+senderId+",'"+title+"','"+content+"',1,sysdate)";
			FileBase.fileUpdate(sqlStr);
		}
		return;
	}

}