明明查的全表的信息，为什么只重复显示一行

求知若渴CC 2014-09-22 07:56:05

数据库里有三行不一样信息，查出来是三行但是每行都是重复的，我就纳闷了，代码查了几遍也没看出问题，自学真是伤不起啊
重复的错误内容！

struts.xml

<action name="findalluser" class="com.lkx.action.FindAllUsersAction" method="findAllUsers">

			<result name="success">/allusers.jsp</result>

			<result name="input">/admin/allusers.jsp</result>

</action>

public class FindAllUsersAction extends ActionSupport {

	private Users user = new Users();



	public Users getModel() {

		return user;

	}

	private String type;

	public String findAllUsers()throws Exception{

		UsersDAO dao = new UsersDAO();

		List list = dao.findAllUses(user);

		ActionContext.getContext().put("list", list); 

		if("admin".equals(type)){  

			return INPUT;  //管理员查询

		}else{ return SUCCESS ;}//用户查询

	}

	public String getType() {

		return type;

	}

	public void setType(String type) {

		this.type = type;

	}

}

DAO

//查看所有用户

	public List findAllUses(Users users) {

		List list = new ArrayList();

		con = DatabaseDAO.getConnection();

		try{

			pt = con.prepareStatement("SELECT * FROM users");

			rs = pt.executeQuery();

			while(rs.next()){

				users.setId(rs.getInt(1));  

				users.setUsername(rs.getString(2));

				users.setPassword(rs.getString(3));

				users.setName(rs.getString(4));

				users.setNic(rs.getString(5));

				users.setEmail(rs.getString(6));

				users.setPhone(rs.getString(7));

				users.setSelfshow(rs.getString(8));

				list.add(users);

			}

		}catch (Exception e) {

			// TODO: handle exception

		}

		return list;

	}

jsp页面迭代

<s:iterator value="list">



				<tr>

					<td>

						<s:property value="username" />

					</td>

					<td>

						<s:property value="nic" />

					</td>

					<td>

						<s:property value="name" />

					</td>

					<td>

						<s:property value="email" />

					</td>

					<td>

						<s:property value="phone" />

					</td>

					<td>

						<s:property value="selfshow" />

					</td>

				</tr>

			</s:iterator>

...全文

94 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

求知若渴CC 2014-09-22

打赏
举报

引用 6 楼 XUECHANG1 的回复:

[quote=引用 5 楼 u010449017 的回复:] [quote=引用 4 楼 XUECHANG1 的回复:]


public List findAllUses() {
        List list = new ArrayList();
        con = DatabaseDAO.getConnection();
        try{
            pt = con.prepareStatement("SELECT * FROM users");
            rs = pt.executeQuery();
            while(rs.next()){
                User users=new User();
                users.setId(rs.getInt(1));  
                users.setUsername(rs.getString(2));
                users.setPassword(rs.getString(3));
                users.setName(rs.getString(4));
                users.setNic(rs.getString(5));
                users.setEmail(rs.getString(6));
                users.setPhone(rs.getString(7));
                users.setSelfshow(rs.getString(8));
                list.add(users);
            }
        }catch (Exception e) {
            // TODO: handle exception
        }
        return list;
    }

我在Action里用了模型驱动了啊，并且把user对象传给DAO了，就不用new了吧[/quote] 可是你这样做只有一个User对象，都被覆盖了，值都是一样的[/quote] 好的，明白了搞定，谢谢

求个名字起 2014-09-22

打赏
举报

引用 5 楼 u010449017 的回复:

[quote=引用 4 楼 XUECHANG1 的回复:]


public List findAllUses() {
        List list = new ArrayList();
        con = DatabaseDAO.getConnection();
        try{
            pt = con.prepareStatement("SELECT * FROM users");
            rs = pt.executeQuery();
            while(rs.next()){
                User users=new User();
                users.setId(rs.getInt(1));  
                users.setUsername(rs.getString(2));
                users.setPassword(rs.getString(3));
                users.setName(rs.getString(4));
                users.setNic(rs.getString(5));
                users.setEmail(rs.getString(6));
                users.setPhone(rs.getString(7));
                users.setSelfshow(rs.getString(8));
                list.add(users);
            }
        }catch (Exception e) {
            // TODO: handle exception
        }
        return list;
    }

我在Action里用了模型驱动了啊，并且把user对象传给DAO了，就不用new了吧[/quote] 可是你这样做只有一个User对象，都被覆盖了，值都是一样的

求知若渴CC 2014-09-22

打赏
举报

引用 4 楼 XUECHANG1 的回复:


public List findAllUses() {
        List list = new ArrayList();
        con = DatabaseDAO.getConnection();
        try{
            pt = con.prepareStatement("SELECT * FROM users");
            rs = pt.executeQuery();
            while(rs.next()){
                User users=new User();
                users.setId(rs.getInt(1));  
                users.setUsername(rs.getString(2));
                users.setPassword(rs.getString(3));
                users.setName(rs.getString(4));
                users.setNic(rs.getString(5));
                users.setEmail(rs.getString(6));
                users.setPhone(rs.getString(7));
                users.setSelfshow(rs.getString(8));
                list.add(users);
            }
        }catch (Exception e) {
            // TODO: handle exception
        }
        return list;
    }

我在Action里用了模型驱动了啊，并且把user对象传给DAO了，就不用new了吧

求个名字起 2014-09-22

打赏
举报


public List findAllUses() {
        List list = new ArrayList();
        con = DatabaseDAO.getConnection();
        try{
            pt = con.prepareStatement("SELECT * FROM users");
            rs = pt.executeQuery();
            while(rs.next()){
                User users=new User();
                users.setId(rs.getInt(1));  
                users.setUsername(rs.getString(2));
                users.setPassword(rs.getString(3));
                users.setName(rs.getString(4));
                users.setNic(rs.getString(5));
                users.setEmail(rs.getString(6));
                users.setPhone(rs.getString(7));
                users.setSelfshow(rs.getString(8));
                list.add(users);
            }
        }catch (Exception e) {
            // TODO: handle exception
        }
        return list;
    }

求知若渴CC 2014-09-22