list集合，在三层应用的时候

list<t>集合，在三层应用的时候
public class RoomTypeService
    {
        //得到全部客房类型信息
        public IList<RoomType> GetAllRoomTypes()
        {
            IList<RoomType> RoomTypes = new List<RoomType>();
            using (SqlCommand command = new SqlCommand("usp_GetAllRoomTypes", DBHelper.conn))
            {
                command.CommandType = CommandType.StoredProcedure;
                DBHelper.conn.Open();
                using (SqlDataReader sdr = command.EndExecuteReader())
                {
                    while (sdr.Read())
                    {
                        RoomType rt = new RoomType();
                        rt.TypeId = Convert.ToString(rt["TypeId"]);
                        rt.TypeName = Convert.ToString(rt["TypeName"]);
                        rt.TypePrice = Convert.ToString(rt["TypePrice"]);
                        rt.IsAddBed = Convert.ToString(rt["IsAddBed"]);
                        rt.AddBedPrice = Convert.ToString(rt["AddBedPrice"]);
                        rt.Remark = Convert.ToString(rt["Remark"]);
                    }
                }
            }
            return RoomTypes;
        }

    }

 

 

-------------------------------------------------------

java:

 Admin admin;
        Iterator it=DAOFactory.getAdminDAOInstance().getAllAdmin().iterator();
        int i=1;
     while(it.hasNext())
       {
        admin=(Admin)it.next();//如果迭代器中有对象，则赋给provider
      
              String id=admin.getAdminId();
              String name=admin.getName();
     String IDCard=admin.getIdcard();
     String address=admin.getAddress();
     String telNo=admin.getTelNo();
     String adminpopedom=admin.getPopedom();

 

-------------------------------------------------------------------------------------------------

 

SqlConnection con =new SqlConnection("server=.;database=tempdb;uid=sa;pwd=");
   SqlDataAdapter da =new SqlDataAdapter("select * from users",con);
   DataSet ds =new DataSet();
   da.Fill(ds,"users");
            DataTable dt = ds.Tables["users"];

   ArrayList list =new ArrayList();
   //往集合中添加实体对象
   foreach(DataRow dr in dt.Rows)
   {
    Users user =new Users();
   
    user.Username =dr["Username"].ToString();
                user.Id = int.Parse(dr["id"].ToString());
                user.Pwd = dr["Pwd"].ToString();
    list.Add(user);
   }
   return list;//返回集合


SqlConnection con = new SqlConnection("server=.;database=tempdb;uid=sa;pwd=");
            SqlDataAdapter da = new SqlDataAdapter("select *from [user]",con);
            DataSet ds = new DataSet();
            da.Fill(ds);
            return ds.Tables[0];