数据库查询问题！！

zhangyunpo

sql="select * from CustomerAnnounceTable where username='"+username+"'";
rs=sqlStatement.executeQuery(sql);
while(rs.next())
   {
   headline=rs.getString("headline";
   out.println(headline);
   sql1="select * from AnnounceTable where headline='"+headline+"'";
   rs1=sqlStatement.executeQuery(sql1);
   while(rs1.next())
     {
   out.println(rs1.getString("headline");
   out.println(rs1.getString("content");
   out.println(rs1.getString("person");
     }
        rs1.close();//关闭结果集
        }
rs.close();//关闭结果集

为什么只能输出第一条记录，然后就显示ResultSet is closed ，，
请高手解答

echoguo

你联的是什么数据库？