java生产者消费者问题:ASP高手请来帮忙

来源:百度文库 编辑:高考问答 时间:2024/04/19 12:16:35
<%
Set rs=server.CreateObject("ADODB.Recordset")
sql="select * from book order by id desc"
rs.CursorLocation=3
rs.open sql,conn,3,3
DIM Pages,PageNum
rs.PageSize=5
Pages=rs.PageCount
if request("page")="" OR int(request("page"))>int(Pages) then
rs.AbsolutePage=1
PageNo=1
else
rs.AbsolutePage=request("page")
PageNo=request("page")
end if
do while not rs.eof
<link href="style.css" rel="stylesheet" type="text/css">
<table width="620" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><TABLE id=Table40 cellSpacing=1 cellPadding=3 width=620
bgColor=#c6d7c6 border=0>
<TBODY>
<TR>
<TD colspan="2" bgColor=#f5faf5><TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD width="65%"><P style="MARGIN-TOP: 3px; MARGIN-LEFT: 10px"><span class="text1" style="font-weight: bold"><%=rs(0)%> <%=rs(1)%></span> </P></TD>
<TD width="20%"><P style="MARGIN-TOP: 3px; MARGIN-LEFT: 10px">留言于 <%=rs(4)%></P></TD>
<TD width="15%" align=left>作者:<%=rs(1)%></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD width=50 bgColor=white><P class="text2" style="MARGIN-TOP: 3px; MARGIN-LEFT: 10px">内容:</p></TD>
<TD width=550 bgColor=white><P style="MARGIN-TOP: 3px; MARGIN-LEFT: 10px"><%=rs(3)%></p></TD>
</TR>
</TBODY>
</TABLE></td>
</tr>
</table>
<%
Set rs1=server.CreateObject("ADODB.Recordset")
sql="select * from reply where replyid= "这里该如何赋值?
rs1.CursorLocation=3
rs1.open sql,conn,3,3
do while not rs.eof
%>
<table width="620" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><TABLE id=Table40 cellSpacing=1 cellPadding=3 width=620
bgColor=#c6d7c6 border=0>
<TBODY>
<TR>
<TD colspan="2" bgColor=#f5faf5><TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD width="65%"><P style="MARGIN-TOP: 3px; MARGIN-LEFT: 10px"><span class="text1" style="font-weight: bold">Re <%=rs1(2)%></span> </P></TD>
<TD width="20%"><P style="MARGIN-TOP: 3px; MARGIN-LEFT: 10px">回复于 <%=rs1(4)%></P></TD>
<TD width="15%" align=left>作者:<%=rs1(1)%></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD width=50 bgColor=white><P class="text2" style="MARGIN-TOP: 3px; MARGIN-LEFT: 10px">内容:</p></TD>
<TD width=550 bgColor=white><P style="MARGIN-TOP: 3px; MARGIN-LEFT: 10px"><%=rs(3)%></p></TD>
</TR>
</TBODY>
</TABLE></td>
</tr>
</table>
<%
rs.movenext
loop
%>