jjsp.asp
来自「房地产管理系统 vb写的,很不错!!!!!!!!!!!」· ASP 代码 · 共 414 行 · 第 1/2 页
ASP
414 行
<p align="right">
<a href="jiaju_more.asp?sort=2"><font color=#ffffff>更多</font></a> </td>
</tr>
</table>
</TD></TR>
<TR>
<TD background="../img/36.gif" height="39"> <b>
<font color=#ffffff>装 修 流 行 线</font></b></TD></TR>
<TR>
<TD>
<table width="255" border="0" cellpadding="0" cellspacing="0" bgcolor="#7CB721" class="main">
<tr class="black" height="7">
<td height="7" colspan="3"></td>
</tr>
<%
set rs=server.CreateObject("adodb.recordset")
sql="select top 6 * from news where sort=3 order by dnt desc"
rs.open sql,conn,1,1
do while not rs.eof
%>
<tr class="black">
<td width="10"> </td>
<td width="12" height="19"> <div align="center">
<img border="0" src="../img/arr_w1.gif" width="9" height="9"></div></td>
<td height="19"><a href=jiaju_detail.asp?newsid=<%=trim(rs("newsid"))%>&sort=3>
<font color=#ffffff><%=left(trim(rs("topic")),14)%></font></a></td>
</tr>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</table>
</TD></TR>
<TR>
<TD>
<p align="right"><a href="jiaju_more.asp?sort=3">
<font color="#FFFFFF">更多</font></a> </TD></TR>
<TR>
<TD> </TD></TR>
<TR>
<TD> </TD></TR>
<TR>
<TD> </TD></TR>
<TR>
<TD> </TD></TR>
</TBODY></TABLE></TD></TR></TBODY></TABLE></TD>
<TD vAlign=top>
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD height=5></TD></TR></TBODY></TABLE>
<div align="right">
<TABLE height=30 cellSpacing=0 cellPadding=0 width=710 border=0 id="table7">
<TBODY>
<TR>
<TD width=5><IMG height=30 src="../img/news1a.gif" width=5></TD>
<TD width=150 background=../img/news4a.gif>
<IMG height=9
src="../img/arr_w2.gif" width=9> <b><font color=#ffffff>家 具 饰 品</font></b></TD>
<TD width=5><IMG height=30 src="../img/news2a.gif" width=5></TD>
<TD background=../img/news5a.gif> </TD>
<TD width=5><IMG height=30 src="../img/news3a.gif"
width=5></TD></TR></TBODY></TABLE>
</div>
<TABLE height=3 cellSpacing=0 cellPadding=0 width=75 border=0>
<TBODY>
<TR>
<TD></TD></TR></TBODY></TABLE>
<div align="right">
<TABLE class=out4s_green cellSpacing=0 cellPadding=0 width=705 border=0>
<TBODY>
<TR>
<TD vAlign=top>
<td width="705" valign="top"> <%
Sql = "Select * From Jj_Type"
Set RsJj = Server.CreateObject("Adodb.Recordset")
RsJj.Open Sql,conn,1,1
%> <table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<%
Dim a
a = 1
While not RsJj.Eof
%>
<td height="25"><a href="Photo.Asp?Type=<%=Trim(RsJj("Jj_Type"))%>&class=Jj" class="linkone"><%=RsJj("Jj_Type")%></a></td>
<%
IF a mod 8 = 0 Then
Response.write"</tr><tr>"
End if
RsJj.Movenext
a = a + 1
Wend
RsJj.close
Set RsJj = Nothing
%>
</tr>
</table>
<%
SqlT = "Select * From Jj_Type"
Set RsT = Server.CreateObject("Adodb.Recordset")
RsT.Open SqlT,conn,1,1
%> <%Do while Not RsT.Eof%> <table width="705" border="0" cellpadding="0" cellspacing="0" class="main">
<tr>
<td width="496" height="29" background="../images/user_02.jpg"> <IMG height=9
src="../images/Frams_nav.gif" width=9> <B><FONT
color=#fc6808><%=Trim(RsT("Jj_Type"))%></FONT></B></td>
<td width="82" background="../images/user_02.jpg"><div align="center"><a href="Photo.Asp?Type=<%=Trim(RsT("Jj_Type"))%>&class=jj" class="linkone">更多...</a></div></td>
</tr>
<tr height="1">
<td height="1" colspan="2" background="../ima/back.gif"></td>
</tr>
</table>
<%
SqlJ = "Select top 3 * from Jj where Jj_Type='"&Trim(RsT("Jj_Type"))&"' Order by id desc"
Set Rsj = server.CreateObject("adodb.Recordset")
Rsj.Open Sqlj,conn,1,1
IF Rsj.Eof then
Response.write"<br><div align='center'>还没有此类商品</div>"
End if
%> <TABLE id=table523 style="BORDER-COLLAPSE: collapse"
cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<%
Dim d
d = 1
While NOt Rsj.Eof
%>
<TD vAlign=top align=left height=137> <DIV align=center>
<TABLE width=171
height=137
border=0 cellPadding=0 cellspacing="0"
background="../images/housebk.gif" id=table524 style="BORDER-COLLAPSE: collapse">
<TBODY>
<TR>
<TD align=middle height=49> <DIV align=center>
<TABLE
width="100%" border=0 cellPadding=0 cellspacing="0" id=table525
style="BORDER-COLLAPSE: collapse">
<TBODY>
<TR>
<TD height=100> <P align=center><a href="../fyfile/<%=Trim(Rsj("pic"))%>" target="_blank"><img src="../fyfile/<%=Trim(Rsj("pic"))%>" alt="" name="<%=Trim(Rsj("Jj_mc"))%>" width="130" height="90" border="0"></a></P></TD>
</TR>
<TR>
<TD height=20> <P align=center>[<a href="javascript:;" class="linkone" onClick="javascript:window.open('Jj_Show.Asp?ID=<%=Trim(Rsj("ID"))%>','newhouse','width=600,height=550,top=50,left=200,scrollbars=yes');"><%=Trim(Rsj("Jj_mc"))%></A>]</P></TD>
</TR>
</TBODY>
</TABLE>
</DIV></TD>
</TR>
</TBODY>
</TABLE>
</DIV></TD>
<%
IF d mod 3 = 0 then
Response.write"</tr><tr>"
end if
rSJ.movenext
d = d + 1
Wend
Rsj.close
Set Rsj = Nothing
%>
</TR>
</TBODY>
</TABLE>
<%
RsT.movenext
Loop
%> </td>
</div>
<TABLE height=5 cellSpacing=0 cellPadding=0 width=75 border=0>
<TBODY>
<TR>
<TD></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=708
background=../img/bomgreen2.gif border=0>
<TBODY>
<TR>
<TD width=20>
<IMG height=27 src="../img/bomgreen1.gif"
width=13></TD>
<TD align=right>
</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
</div>
<TABLE height=5 cellSpacing=0 cellPadding=0 width=75 border=0>
<TBODY>
<TR>
<TD></TD></TR></TBODY></TABLE>
<TABLE height=3 cellSpacing=0 cellPadding=0 width=75 border=0>
<TBODY>
<TR>
<TD></TD></TR></TBODY></TABLE>
<TABLE height=5 cellSpacing=0 cellPadding=0 width=75 border=0>
<TBODY>
<TR>
<TD></TD></TR></TBODY></TABLE>
<TABLE height=3 cellSpacing=0 cellPadding=0 width=75 border=0>
<TBODY>
<TR>
<TD></TD></TR></TBODY></TABLE>
</TD></TR></TBODY></TABLE>
<!--#include file="../end.asp"-->
</BODY></HTML>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?