accessorydaoimpl.java

来自「该系统可以实现邮件的收发」· Java 代码 · 共 51 行

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.AccessoryDao;
import mail.domain.Accessory;
import mail.domain.MailBox;

public class AccessoryDaoImpl implements AccessoryDao {

	public List searchAccessoryById(String mailId) {
		String info = "select * from accessory 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;
	}
}