contactdao.java

来自「用java编的用到」· Java 代码 · 共 47 行

package djr.dao;

import java.sql.*;
import java.util.*;
import djr.dto.*;

public class ContactDAO extends CommonDAO
{
	/** 取得联系人列表*/
	public List<ContactDTO> getContactList(ContactDTO contactDTO, Connection conn)
	{

		String sql = "select contactID,contactName," + "email,mobile,userid "
				+ "from contactinfo" + " where userid='"
				+ contactDTO.getUserID() + "'";

		List<ContactDTO> contactList = new ArrayList<ContactDTO>();
		ResultSet rs = null;
		try
		{
			rs = execSelect(sql, conn);

			while (rs.next())
			{
				contactDTO = new ContactDTO();
				contactDTO.setContactID(rs.getString("contactID"));
				contactDTO.setContactName(rs.getString("contactName"));
				contactDTO.setEmail(rs.getString("email"));
				contactDTO.setMobile(rs.getString("mobile"));
				contactDTO.setUserID(rs.getString("userid"));
				contactList.add(contactDTO);
			}

			return contactList;
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
			close(null, rs);
		}

		return null;
	}
}