📄 carhots.jsp
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312" import="java.sql.*"%>
<jsp:useBean id="hot" class="Bean.DbConn" scope="page"/>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
.STYLE2 {
font-size: 16px;
color: #00FF00;
}
.STYLE5 {
font-size: 18px;
color: #000000;
font-weight: bold;
}
.STYLE6 {color: #FF0000}
-->
</style>
</head>
<body>
<table width="200" border="o" bordercolor="#FFFFFF" bgcolor="#CCCCCC">
<tr bgcolor="#999999">
<td height="31"><div align="center"><span class="STYLE2"><span class="STYLE5">热点排行榜</span> <span class="STYLE6">HOTS</span></span></div></td>
</tr>
<tr>
<td align="center"><hr width="200" size="3" noshade="noshade" color="#ffffff"></td>
</tr>
<%
ResultSet r=null;
String s="select top 6 * from car,category where car.brand_id=category.brand_id order by browse_num desc";
hot.open();
r=hot.executeQuery(s);
while(r.next()){
int car_id=r.getInt(1);
String type=r.getString(3);
String bname=r.getString("bname");
%>
<!--marquee direction="down" behavior="scroll" loop="-1"-->
<tr>
<td width="124">.<a href="CarInfo.jsp?car_id=<%=car_id%>"><%=bname%><%=type%></a> </td>
</tr>
<%}%>
<!--/marquee-->
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -