select username,password,age from userinfo;public ArrayList getAllUser()
{
ArrayList alRS=new userInfoDAO().getAllUser();//这个ArrayList中存放的是所有从数据库中取出来的结果,sql语句在上面ArrayList alUser=new ArrayList();for(ArrayList alRow:alRS)
{
String userName=alRow.get(1);
String password=alRow.get(2);
String age=alRow.get(3);
alUser.add(new userInfoDTO(userName,password,age));//userInfoDTO是JavaBean
}
return alUser;
}//getAllUser
{
ArrayList alRS=new userInfoDAO().getAllUser();//这个ArrayList中存放的是所有从数据库中取出来的结果,sql语句在上面ArrayList alUser=new ArrayList();for(ArrayList alRow:alRS)
{
String userName=alRow.get(1);
String password=alRow.get(2);
String age=alRow.get(3);
alUser.add(new userInfoDTO(userName,password,age));//userInfoDTO是JavaBean
}
return alUser;
}//getAllUser
{
ArrayList alRS=new userInfoDAO().getAllUser();//这个ArrayList中存放的是所有从数据库中取出来的结果,sql语句在上面ArrayList alUser=new ArrayList();for(int i = 0; i < alRS.size(); i++)
{
ArrayList alRow = alRS.get(i);
String userName=alRow.get(1);
String password=alRow.get(2);
String age=alRow.get(3);
alUser.add(new userInfoDTO(userName,password,age));//userInfoDTO是JavaBean
}
return alUser;
}//getAllUser
public ArrayList getAllUser()
{
ArrayList alRS=new userInfoDAO().getAllUser();//这个ArrayList中存放的是所有从数据库中取出来的结果,sql语句在上面ArrayList alUser=new ArrayList();
ArrayList alRow ;
for(int i = 0; i < alRS.size(); i++)
{
alRow = (ArrayList) alRS.get(i) ; //需要造型一下
String userName=alRow.get(1);
String password=alRow.get(2);
String age=alRow.get(3);
alUser.add(new userInfoDTO(userName,password,age));//userInfoDTO是JavaBean
}
return alUser;
}//getAllUser