<%
set rsa= Server.CreateObject("adodb.recordset")
sql="select top 6 * from n_class "
rsa.open sql,conn,1,1
while not rsa.eof
newsclass=rsa("cname_en")
%>
 |
"><%= newsclass %> |
<%
rsa.movenext()
wend
set rsa=nothing
%>
|
|
<% set rsc= Server.CreateObject("adodb.recordset")
sql="select top 8 * from pro_class "
rsc.open sql,conn,1,1
while not rsc.eof
%>
|
"><%= rsc("pname_en") %> |
<%
rsc.movenext()
wend
%>
|
|
|
|
<%
set rs= Server.CreateObject("adodb.recordset")
sql="select top 6 * from product where tj1=0 order by id desc"
rs.open sql,conn,1,1
%>
<%
i=0
do while not rs.eof
%>
<%
if i <> 0 then
if i mod 3=0 then
Response.Write(" ")
end if
end if
%>
|
<%
i=i+1
rs.movenext
loop
set rs=nothing
%>
|
| <%
set rs1= Server.CreateObject("adodb.recordset")
sql="select * from xxdq_en where id=18"
rs1.open sql,conn,1,1
%>
<%= rs1("diqu") %>
<% set rs1=nothing %> |
<%
set rs1= Server.CreateObject("adodb.recordset")
sql="select * from n_class where id=1"
rs1.open sql,conn,1,1
%>
<%= rs1("cname_en") %>
<% set rs1=nothing %> |
<%
set rs1= Server.CreateObject("adodb.recordset")
sql="select * from n_class where id=5"
rs1.open sql,conn,1,1
%>
<%= rs1("cname_en") %>
<% set rs1=nothing %> |
<%
set rs1= Server.CreateObject("adodb.recordset")
sql="select * from n_class where id=6"
rs1.open sql,conn,1,1
%>
<%= rs1("cname_en") %>
<% set rs1=nothing %> |
| <%
set rs2= Server.CreateObject("adodb.recordset")
sql="select * from about where id=1"
rs2.open sql,conn,1,1
%>
<%= rs2("jj_en") %>
<%
set rs2=nothing
%> |
|
|
|
|
<%
set rs= Server.CreateObject("adodb.recordset")
sql="select top 5 * from gonggao order by id desc"
rs.open sql,conn,1,1
while not rs.eof
%>
|
"><%= cutstr(rs("nname_en"),26) %> |
<%
rs.movenext()
wend
set rs=nothing
%>
|
|
| <%
set rs1= Server.CreateObject("adodb.recordset")
sql="select * from n_class where id=7"
rs1.open sql,conn,1,1
%>
<%= rs1("cname_en") %>
|
">more>> |
<% set rs1=nothing %>
|
|
