public Vector allNews() {
DBConnect dbc = null;
Vector allNewsVector = new Vector();

try{
dbc  = new DBConnect();
dbc.prepareStatement("SELECT * FROM news order by hits desc");
rs = dbc.executeQuery();
while(rs.next()){
News news = new News();
news.setID(rs.getInt("id"));
news.setTopic(rs.getString("topic"));
news.setBody(rs.getString("body"));
news.setHits(rs.getInt("hits"));
news.setAdddate(rs.getString("adddate"));
news.setAdduser(rs.getString("adduser"));
news.setRootID(rs.getInt("rootid"));
news.setPic(rs.getString("pic"));
allNewsVector.add(news);
}
}catch(Exception e){
System.err.println("error:"+e);
}finally{
try{
dbc.close();
}catch(Exception e){
e.printStackTrace();
}
}
return allNewsVector;
}
如果新闻的条数很多呢?