这是数据库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()%>
<%
}
} %>
现在数据库有很多组数据,但是为什么页面只能显示遍历一组?
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;
}
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。