mailboxdaoimpl.java

该系统可以实现邮件的收发

package mail.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.domain.Position;
import com.util.JdbcUtil;

import mail.dao.MailBoxDao;
import mail.domain.Accessory;
import mail.domain.MailBox;

public class MailBoxDaoImpl implements MailBoxDao {

	public List searchMail() {
		
		String info = "select * from mailbox m,accessory a where a.mailid = m.mailid";
		Connection conn = JdbcUtil.getConnection();
		Position position = null;
		List<MailBox> list = new ArrayList<MailBox>();
		try {
			PreparedStatement ps = conn.prepareStatement(info);
			ResultSet rs = ps.executeQuery();
					
			while(rs.next()){
				MailBox mail = new MailBox();
				mail.setMailId(rs.getString("mailid"));
				mail.setTitle(rs.getString("title"));
				mail.setContent(rs.getString("content"));
				mail.setSenter(rs.getString("senter"));
				mail.setAddressee(rs.getString("addressee"));
				mail.setSentLogo(rs.getString("sentlogo"));
				mail.setType(rs.getString("type"));
				mail.setDeleteLogo(rs.getString("deletelogo"));
				mail.setSentTime(rs.getString("senttime"));
				mail.setIsRead(rs.getString("isread"));
				mail.setHasAccessory(rs.getString("hasaccessory"));
				mail.setMailLogo(rs.getString("maillogo"));
				Accessory accessory = new Accessory();
				accessory.setMailId(rs.getString("mailid"));
				accessory.setAccessSize(rs.getInt("accesssize"));
				accessory.setCreateDate(rs.getString("createdate"));
				accessory.setAccessName(rs.getString("accessname"));
				accessory.setSavePath(rs.getString("savepath"));
				mail.setAccessory(accessory);
				list.add(mail);
			}
			rs.close();
			ps.close();			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return list;
	}

	public List searchAccessoryById(String mailId) {
		String info = "select * from mail where mailid = '"+mailId+"'";
		Connection conn = JdbcUtil.getConnection();
		Position position = null;
		List<Accessory> list = new ArrayList<Accessory>();
		try {
			PreparedStatement ps = conn.prepareStatement(info);
			ResultSet rs = ps.executeQuery();
					
			while(rs.next()){
				Accessory accessory = new Accessory();
				accessory.setMailId(mailId);
				accessory.setAccessSize(rs.getInt("accesssize"));
				accessory.setCreateDate(rs.getString("createDate"));
				accessory.setAccessName(rs.getString("accessname"));
				accessory.setSavePath(rs.getString("savepath"));
				list.add(accessory);
			}
			rs.close();
			ps.close();			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return list;
	}
}