＋设为首页 ＋添加到收藏夹
如果去掉66的注视就会报错(ResultSet用尽)！在一行里面调用多个rset.getString就可以，一旦在多行就不行：）谢谢！！
try{
String sql="SELECT pageid, fromid, pagename, pagecontent, about, timewrite, packupone, packuptwo FROM WORKPAGE";
//String sql="SELECT ID,NAME,PASSWORD,ABOUT FROM WUSER";
System.out.println(sql);
con=ds.getConnection();
PreparedStatement stmt =con.prepareStatement(sql);
//stmt.setBigDecimal(1,pageid);
ResultSet rset=stmt.executeQuery();
ArrayList NAMElist=new ArrayList();
int i=0;
while(rset.next())
NAMElist.add(rset.getString("PAGEID")+rset.getString("FROMID"));
66 // NAMElist.add;
//NAMElist.add(rset.getString("PAGENAME"));
// NAMElist.add(rset.getString("ABOUT"));
stmt.close();
return NAMElist;
}catch (SQLException se){
throw new EJBException(se);
}finally{
try{
if(con!=null)
con.close();
}catch(SQLException se){}
}
while(rset.next())
NAMElist.add(rset.getString("PAGEID")+rset.getString("FROMID"));
66 // NAMElist.add;
//NAMElist.add(rset.getString("PAGENAME"));
// NAMElist.add(rset.getString("ABOUT"));
=>
while(rset.next()){
NAMElist.add(rset.getString("PAGEID")+rset.getString("FROMID"));
NAMElist.add;
NAMElist.add(rset.getString("PAGENAME"));
NAMElist.add(rset.getString("ABOUT"));
}
