Arraylist的一个问题从数据库拿到多组数据但是只能读出一组
这是数据库select方法public List getgameperson() {
List<Gameperson> list = new ArrayList<Gameperson>();
Connection conn = null;
Statement st = null;
ResultSet rs = null;
try {
conn = DBO.getconnection();
st =(Statement) conn.createStatement();
String sql = "select * from gameperson";
rs = (ResultSet) st.executeQuery(sql);
if(rs.next()){
Gameperson gp = new Gameperson();
gp.setId(rs.getInt("id"));
gp.setCompetitorId(rs.getInt("competitorId"));
gp.setGameId(rs.getInt("gameId"));
list.add(gp);
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}finally{
DBO.close(st, rs, conn);
}
return list;
}这是拿出方法：
<%
List list = new ArrayList();
GamepersonDao gpo = new GamepersonDaoImpl();
list = gpo.getgameperson();
if(list!=null){
for (int i=0;i<list.size();i++){
Gameperson gp = list.get(i);
%>
<%=gp.getId()%>
<%=gp.getGameId() %>
<%=gp.getCompetitorId()%>
<%
}
} %>现在数据库有很多组数据，但是为什么页面只能显示遍历一组？
展开
收起
1
条回答
写回答
写回答
-
我说我不帅他们就打我，还说我虚伪public List getgameperson() { // TODO Auto-generated method stub List<Gameperson> list = new ArrayList<Gameperson>(); Connection conn = null; Statement st = null; ResultSet rs = null; try { conn = DBO.getconnection(); st =(Statement) conn.createStatement(); String sql = "select * from gameperson"; rs = (ResultSet) st.executeQuery(sql); while(rs.next()){ Gameperson gp = new Gameperson(); gp.setId(rs.getInt("id")); gp.setCompetitorId(rs.getInt("competitorId")); gp.setGameId(rs.getInt("gameId")); list.add(gp); } } catch (Exception e) { // TODO: handle exception e.printStackTrace(); }finally{ DBO.close(st, rs, conn); } return list; }2019-07-17 19:03:03赞同 展开评论 打赏
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
相关问答
