📄 newcar.jsp

📁 汽车展销的网站开发
💻 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="market" 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">
A:LINK{color:red;font:9pt;text-decoration:none}
A:visited{color:black;font:9pt;text-decoration:none}
A:hover{color:green;font:9pt;text-decoration:underline}
</style>
</head>

<body>
<%
	ResultSet rs=null;
	String strSql="select car_id,bname,type,price,prodtime,browse_num,cover,manufacturer from car,category where car.brand_id=category.brand_id order by prodtime desc"; 
	int i=0;//用于设置每行显示两条数据
	market.open();
	rs=market.executeQuery(strSql);
	out.println("<table border='1' bordercolor='#cccccc' width='300' height='25'><tr><td><img src='C:\\Program Files\\Tomcat 5.5\\webapps\\ROOT\\car\\images\\新车图库.jpg'></td></tr></table>");
	while(rs.next()&&i<6)
	{
		int car_id=rs.getInt("car_id");
		String bname=rs.getString("bname");
		String type=rs.getString("type");
		String price=rs.getString("price");
		String p=rs.getString("prodtime");
		String prodtime=p.substring(0,10);
		String browse_num=rs.getString("browse_num");
		String cover="<img src='C:\\Program Files\\Tomcat 5.5\\webapps\\ROOT\\car\\images\\"+rs.getString("cover")+"'>";
		String manufacturer=rs.getString("manufacturer");
		
		out.println("<table border='1' bordercolor='#cccccc' width='500' height='100'>");
		out.print("<tr><td rowspan='4' width='130' height='100'><a href='CarInfo.jsp?car_id="+car_id+"'>"+cover+"</a></td>");
		out.print("<td>汽车名称："+bname+type+"</td></tr>");
		out.print("<tr><td>生产厂家："+manufacturer+"</td></tr>");
		out.print("<tr><td>上市时间："+prodtime+"&nbsp;&nbsp;&nbsp;浏览次数："+browse_num+"</td></tr>");
		out.print("<tr><td>价格："+price+"元&nbsp;&nbsp;&nbsp;<a href='CarInfo.jsp?car_id="+car_id+"'><font color='red'>查看更多>></font></a></td></tr>");
		out.print("</table>");
		i++;
		if(i%2==0)
		{out.print("<br>");
%>
		<img src="C:\\Program Files\\Tomcat 5.5\\webapps\\ROOT\\car\\images\\newCarLine.gif">
		
<%	
		}
		}
%>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -