<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<jsp:useBean id="li" scope="page" class="yy.bbcode"/>
<%! String Time_Str, Man_Str,Forum_Mastor,Forum_id,sql;%>
<%
Connection con=yy.getConn();
Statement stmt=con.createStatement();
ResultSet rs=null;
sql="SELECT * FROM qita";
rs=stmt.executeQuery(sql);
while (rs.next())
{
Time_Str=rs.getString("title");
Man_Str=rs.getString("content");
Forum_id=rs.getString("qitaid");
Forum_Mastor=rs.getString("author");
int ab=Integer.parseInt(Forum_Mastor);
sql="select * from User where userid="+ab;
rs=stmt.executeQuery(sql);
String Author=rs.getString("username");
out.println();
%>
<tr>
<td><%=Time_Str%></td>
<td height="25"><%=Man_Str%></td>
<td><%=Author%></td>
</tr>
<%
if (!rs.next())
break;
}
%>
只能显示一条记录,我改了一下好像有错误了,帮忙改一下